MySQL MCP Server

Name: MySQL MCP Server
Availability: InStock
Author: designcomputer

by designcomputer

Securely connect AI assistants to MySQL databases for structured exploration and SQL execution.

0 stars

0 views

Works in:VS Code Copilot

Exposes:ToolsResources

View on GitHub Docs

What it does

Connects AI assistants to MySQL databases, allowing them to explore schemas, read table contents, and execute SQL queries through a secure, controlled interface.

Tools

list_tables: Lists available MySQL tables as resources.
read_table: Reads the contents of a specific table.
execute_query: Executes custom SQL queries with structured error handling.

Installation

Add this to your claude_desktop_config.json:

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

Supported hosts

Claude Desktop
VS Code

Quick install

pip install mysql-mcp-server

Information

Pricing: free
Published: 4/12/2026
stars

Related Apps

Choose your AI client and follow the steps below.

Claude Desktop

Use uv to run mysql_mcp_server with MYSQL_HOST, MYSQL_USER, and MYSQL_PASSWORD env vars.

VS Code Copilot

Add to mcp.json using uvx --from mysql-mcp-server mysql_mcp_server