MySQL MCP Server Pro

You can run and use mcp_mysql_server_pro to manage MySQL databases through MCP with multiple transfer modes, perform SQL operations, analyze health and performance, and extend with custom tools. It supports role-based permissions, OAuth2.0, prompt templates, and convenient local development workflows.

How to use

You run a local MCP server that connects to your MySQL database and then interact with it through an MCP client. You can choose between a streamable HTTP endpoint, SSE, or a local stdio-based workflow. Practical usage patterns include executing SQL commands, querying table metadata, analyzing health and performance, and applying optimization suggestions. Enable OAuth2.0 for secure access and use role-based permissions to control what each client can do.

Typical end-to-end usage flows you can perform:

• Start the server in one of the development modes (streamable HTTP, SSE, or STDIO).
• Connect with an MCP client by pointing to the appropriate endpoint or by launching the local stdio service with the provided command.
• Use the available tools to run SQL statements, inspect table structures, check health, and optimize queries.
• If needed, enable OAuth2.0 authentication to protect access to the MCP service.

How to install

Prerequisites: you need Python and/or Node tooling depending on how you want to run the MCP server. You will also need access to a MySQL database you can reach from the server.

pip install mysql_mcp_server_pro

Additional configuration and usage notes

Environment variables you may need to configure for the server to connect to MySQL:

• MYSQL_HOST: the host name or IP of your MySQL server
• MYSQL_PORT: the port number (default 3306)
• MYSQL_USER: your MySQL user name
• MYSQL_PASSWORD: the MySQL password
• MYSQL_DATABASE: the database you want to access
• MYSQL_ROLE: access role to assign (readonly, writer, admin) with corresponding permissions These variables can be placed in a .env file in your working directory or provided directly in your environment.

To run in Streamable Http mode (default): start the service with your environment file, for example: mysql_mcp_server_pro --envfile /path/to/.env

To run in SSE mode: mysql_mcp_server_pro --mode sse --envfile /path/to/.env

To enable OAuth2.0 authentication, start the service with the oauth flag: uv run -m mysql_mcp_server_pro.server --oauth true Then visit the authentication service at http://localhost:3000/login to obtain a token and add it to your request headers.

Example configurations and usage patterns

HTTP/Streamable Http example (remote client access): you expose an HTTP endpoint for MCP clients to connect. The endpoint is configured with a URL and optional authentication headers as needed.

STDIO example (local development): you can run the server directly and connect via a local driver or MCP client that supports stdio. The following snippet shows a complete stdio configuration that you can adapt to your environment.

Available tools

execute_sql

Execute SQL statements with permission-based command support across SELECT, INSERT, UPDATE, DELETE, CREATE, ALTER, DROP, TRUNCATE as configured.

get_chinese_initials

Convert Chinese field names to pinyin initials for easier indexing and display.

get_db_health_running

Analyze MySQL health status including connection, transaction, running, and lock status.

get_table_desc

Query table structures by name and support multi-table queries.

get_table_index

Query table indexes by table name and support multi-table queries.

get_table_lock

Check for row-level or table-level locks on the current MySQL server.

get_table_name

Search for table names based on table comments and descriptions.

get_db_health_index_usage

Identify index usage patterns, including redundant or poorly performing indexes and top unused indexes with long query times.

optimize_sql

Provide expert SQL optimization suggestions based on execution plans and schema information.

use_prompt_queryTableData

Use built-in prompts to construct a chain of tool calls for querying table data in MCP.