MySQL MCP Server
About
# 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…
Explore
- Execute SQL queries via MCP functions
- Get database schema information
- Fully containerized with Docker and docker-compose
- Packaged with Poetry for dependency management
Setting up with Highlight
This MCP is not yet compatible with Highlight’s one-click setup. However, you can still use it with Highlight by following these steps:
- Download and install Highlight from highlightai.com/download
- Navigate to the plugins tab and select "Add Custom Plugin"
-
Configure the plugin with the settings below
Plugin Name
MySQL MCP ServerCommand (node, npx, python, etc.)Please refer to the README for specific instructions on how to obtain API keys or other required environment variables.
- Enable "Start Automatically" if you want the plugin to start when Highlight launches
From the repository
Deploy using Docker (recommended) or run locally with Poetry. Set environment variables (MYSQL_HOST, MYSQL_PORT, MYSQL_USER, MYSQL_PASSWORD, MYSQL_DATABASE) to connect to a MySQL instance. For Cursor integration, add the provided configuration to ~/.cursor/mcp.json. The server exposes five MCP tools: execute_query, execute_update, get_tables, get_table_schema, and describe_database.
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
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
Claude Desktop / Cursor
Paste into your MCP client config file to install this server.
{
"mcpServers": {
"mysql mcp server": {
"mysql-mcp-server-ganganbiz1": {
"command": "docker",
"args": [
"build",
"-t",
"mysql-mcp-server",
"."
]
}
}
}
}McpServers
{
"mysql-mcp-server-ganganbiz1": {
"command": "docker",
"args": [
"build",
"-t",
"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 .
Sign in to leave a review
Use Google, GitHub, or an email account so ratings stay tied to real people.
No reviews posted yet.
