MySQL MCP Server

Model Context Protocol server for MySQL database access.

Features

• Execute SQL queries with prepared statements
• List database tables
• Describe table schemas
• Get table statistics (row counts, sizes)
• Connection pooling for performance

Installation

npm install
npm run build

Configuration

Configure via environment variables:

• MYSQL_HOST - MySQL server hostname (default: localhost)
• MYSQL_PORT - MySQL server port (default: 3306)
• MYSQL_USER - MySQL username (default: root)
• MYSQL_PASS - MySQL password (default: empty)
• MYSQL_DB - MySQL database name (default: empty)

Usage with Claude Code

Add to .claude/.mcp.json:

{
  "mcpServers": {
    "mysql": {
      "command": "node",
      "args": [
        "/path/to/mysql-mcp-server/dist/server.js"
      ],
      "env": {
        "MYSQL_HOST": "your-host",
        "MYSQL_PORT": "3306",
        "MYSQL_USER": "your-user",
        "MYSQL_PASS": "your-password",
        "MYSQL_DB": "your-database"
      }
    }
  }
}

Available Tools

mysql_query

Execute any SQL query with optional prepared statement parameters.

Example:

SELECT * FROM users WHERE id = ?

mysql_show_tables

List all tables in the current database.

mysql_describe_table

Get the schema/structure of a specific table.

mysql_table_info

Get detailed table information including row counts and sizes.

License

MIT