mysql-mcp-server

mysql-mcp-server

1
databases

The MySQL MCP Server is a containerized server using FastMCP 2.0 and Python to provide database interaction tools via the Model Context Protocol. It supports SQL query execution and schema retrieval, packaged with Docker and Poetry for streamlined deployment.

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 .