MySQL MCP Server

A Model Context Protocol (MCP) server that provides MySQL database access through standardized tools.

- Query Execution: Execute arbitrary SQL queries
- Schema Inspection: View table schemas
- Table Listing: List all tables in the database
- Query Analysis: Analyze query execution plans with optimization suggestions

- Go 1.21+ (developed with Go 1.23.6)
- MySQL 5.7+ or MySQL 8.0+
- Make (for build commands)

Option 1: Download Pre-built Binary (Recommended)

Download the latest release for your platform:

curl -L https://github.com/koh/mysql-mcp-server/releases/latest/download/mysql-mcp-server-linux-amd64.tar.gz | tar xz chmod +x mysql-mcp-server sudo mv mysql-mcp-server /usr/local/bin/

curl -L https://github.com/koh/mysql-mcp-server/releases/latest/download/mysql-mcp-server-darwin-arm64.tar.gz | tar xz chmod +x mysql-mcp-server mv mysql-mcp-server /usr/local/bin/

curl -L https://github.com/koh/mysql-mcp-server/releases/latest/download/mysql-mcp-server-darwin-amd64.tar.gz | tar xz chmod +x mysql-mcp-server mv mysql-mcp-server /usr/local/bin/

# Download from https://github.com/koh/mysql-mcp-server/releases/latest # Extract mysql-mcp-server-windows-amd64.zip # Add to PATH or move mysql-mcp-server.exe to a directory in PATH

git clone https://github.com/koh/mysql-mcp-server.git cd mysql-mcp-server

make build # Or use make setup for full development setup

After installation, verify the server is accessible:

The server uses environment variables for MySQL connection configuration:

- MYSQL_HOST: MySQL server host (default: localhost)
- MYSQL_PORT: MySQL server port (default: 3306)
- MYSQL_USER: MySQL username
- MYSQL_PASSWORD: MySQL password
- MYSQL_DATABASE: Database name to connect to

You can copy.env.exampleto.envand modify it with your credentials:

Add the server to your Claude Desktop configuration file:

macOS:~/Library/Application Support/Claude/claude_desktop_config.jsonWindows:%APPDATA%\Claude\claude_desktop_config.json

{ "mcpServers": { "mysql": { "command": "mysql-mcp-server", "env": { "MYSQL_HOST": "localhost", "MYSQL_PORT": "3306", "MYSQL_USER": "your_user", "MYSQL_PASSWORD": "your_password", "MYSQL_DATABASE": "your_database" } } } }

export MYSQL_HOST=localhost export MYSQL_PORT=3306 export MYSQL_USER=root export MYSQL_PASSWORD=password export MYSQL_DATABASE=testdb ./mysql-mcp-server

Execute SELECT queries to retrieve data from MySQL database. This tool is restricted to SELECT statements only for safety. Use theexecutetool for data modification operations.

- query(required): SELECT statement only
- format(optional): Output format -json,table,csv, ormarkdown(default:table)

{ "name": "query", "arguments": { "query": "SELECT  FROM users WHERE status = 'active' LIMIT 10", "format": "csv" } }

{ "name": "execute", "arguments": { "sql": "UPDATE users SET status = 'inactive' WHERE last_login < '2024-01-01'", "dry_run": true } }

{ "content": [ {"type": "text", "text": "DRY RUN - Operation: UPDATE"}, {"type": "text", "text": "This operation will affect 42 rows"}, {"type": "text", "text": "To execute this query, run again with dry_run=false and the confirmation token below:"}, {"type": "text", "text": "confirm_token: abc123def456"} ], "affected_rows": 42, "operation": "UPDATE", "confirm_token": "abc123def456" }

{ "name": "execute", "arguments": { "sql": "UPDATE users SET status = 'inactive' WHERE last_login < '2024-01-01'", "dry_run": false, "confirm_token": "abc123def456" } }

{ "name": "schema", "arguments": { "table": "users" } }

{ "name": "tables", "arguments": {} }

{ "name": "explain", "arguments": { "query": "SELECT  FROM users WHERE email = 'test@example.com'" } }

{ "name": "explain", "arguments": { "query": "SELECT * FROM users WHERE age > 25", "analyze": true } }

Note:EXPLAIN ANALYZE actually executes the query to gather real execution statistics, including actual row counts and timing information. Use with caution on queries that modify data or take a long time to execute.

{ "mcp.servers": { "mysql": { "command": "/path/to/mysql-mcp-server", "env": { "MYSQL_HOST": "localhost", "MYSQL_USER": "root", "MYSQL_PASSWORD": "password", "MYSQL_DATABASE": "mydb" } } } }

Create a custom extension that spawns the MCP server. SeeINTEGRATION.mdfor implementation details.

{ "mysql": { "command": "/path/to/mysql-mcp-server", "env": { "MYSQL_HOST": "localhost", "MYSQL_USER": "root", "MYSQL_PASSWORD": "password", "MYSQL_DATABASE": "mydb" } } }

GitHub Copilot doesn't directly support MCP servers, but you can create a bridge through VSCode extensions. SeeINTEGRATION.mdfor detailed implementation.

const { spawn } = require('child_process'); class MCPClient { constructor(serverPath, env) { this.server = spawn(serverPath, [], { env }); // ... handle communication } async callTool(name, arguments) { return this.request('tools/call', { name, arguments }); } } // Usage const client = new MCPClient('/path/to/mysql-mcp-server', { MYSQL_HOST: 'localhost', MYSQL_USER: 'root', MYSQL_PASSWORD: 'password', MYSQL_DATABASE: 'mydb' });

For complete integration examples and troubleshooting, seeINTEGRATION.md.

For detailed testing instructions, seeTESTING.md.

# Setup and run interactive test client make setup make test-client

Access and manage MariaDB or MySQL databases using an MCP server.