MySQL

Provides secure MySQL access to list tables, read data, and run SQL queries via an MCP interface.

python

GitHub Stars

python

Language

4 months ago

First Indexed

3 weeks ago

Catalog Refreshed

Documentation & install

Readme and setup notes from the catalogue, plus a client-ready config you can copy for your MCP host.

Installation

Add the following to your MCP client configuration file.

Configuration

View docs

{
  "mcpServers": {
    "mcp-mirror-designcomputer_mysql_mcp_server": {
      "command": "uv",
      "args": [
        "--directory",
        "path/to/mysql_mcp_server",
        "run",
        "mysql_mcp_server"
      ],
      "env": {
        "MYSQL_HOST": "localhost",
        "MYSQL_USER": "your_username",
        "MYSQL_DATABASE": "your_database",
        "MYSQL_PASSWORD": "your_password"
      }
    }
  }
}

You can securely interact with a MySQL database through a dedicated MCP server that lets you list tables, read data, and execute SQL queries in a controlled, auditable way. This MCP server helps AI assistants explore and analyze MySQL data safely by exposing only designated operations with structured responses.

How to use

To use the server, start one of the provided MCP configurations and connect your MCP client to it. You can list available MySQL tables as resources, read table contents, and run SQL queries with built-in error handling. Ensure your client is configured to access the local MCP endpoint you started and that the required environment variables for database access are in place.

How to install

Prerequisites: Python should be installed on your system. You may also need to ensure network access to your MySQL instance.

Available tools

list_tables

List available MySQL tables as resources exposed by the MCP server.

read_table

Read and return rows from a specified table within the connected database.

execute_query

Execute a raw SQL query against the database and return results with proper error handling.

log_operations

Comprehensive logging of all database operations for audit and debugging.

Built by

VeilStrat

AI signals for GTM teams