MySQL MCP Server

MySQL MCP Server

A MySQL Model Context Protocol (MCP) server implemented with FastMCP 2.0 and Python.

Features

• Execute SQL queries via MCP functions
• Get database schema information
• Fully containerized with Docker and docker-compose
• Packaged with Poetry for dependency management

MCP Tools

The server provides the following MCP tools:

• execute_query: Execute a SQL query and return results
• execute_update: Execute an update/insert SQL query
• get_tables: Get a list of tables in the database
• get_table_schema: Get schema information for a specific table
• describe_database: Get comprehensive database structure information

Setup

Prerequisites

• Docker and docker-compose
• Poetry (for local development)
• Python 3.13+

Cursor Integration

To integrate with Cursor, add the following to your ~/.cursor/mcp.json file:

{
  "mcpServers": {
    "mysqlMcp": {
      "command": "docker",
      "args": [
        "run",
        "-i",
        "--rm",
        "-e",
        "MYSQL_HOST",
        "-e",
        "MYSQL_PORT",
        "-e",
        "MYSQL_USER",
        "-e",
        "MYSQL_PASSWORD",
        "-e",
        "MYSQL_DATABASE",
        "mysql-mcp-server"
      ],
      "env": {
        "MYSQL_HOST": "host.docker.internal",
        "MYSQL_PORT": "3306",
        "MYSQL_USER": "root",
        "MYSQL_PASSWORD": "password",
        "MYSQL_DATABASE": "mcpdb"
      }
    }
  }
}

Docker Build

To build the Docker image separately:

docker build -t mysql-mcp-server .