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: ```json { "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: ```bash docker build -t mysql-mcp-server . ```