Advertise
MCP.so
Sign In

MCP Mysql Server

@MCP-Mirror

Repository

Basic information

Category

Databases

License

MIT license

Transports

stdio

Author

MCP-Mirror

About MCP Mysql Server

Mirror of

#mysql#database#mcp-server

MCP Mysql Server config

No standard config provided

This server doesn't expose a parseable MCP config block in its README. See the repository for install instructions.

Repository

MCP Mysql Server tools

Tool list not available yet

This listing does not currently have a tool list to display. This does not mean the server has no tools; check its documentation for supported capabilities.

We auto-extract tools from the README. The maintainer can list them under a ## Tools heading to populate this section.

Overview

What is mcp_mysql_server?

mcp_mysql_server is a MySQL database MCP server that supports CRUD operations, database anomaly analysis, and custom tool extensions. It is intended for developers who need to interact with MySQL databases through an MCP client with role‑based permissions and built-in diagnostics.

How to use mcp_mysql_server?

Install the package with pip install mysql_mcp_server_pro, create a .env file with MySQL connection details and the desired role (readonly, writer, or admin), then start the server via mysql_mcp_server_sse for SSE mode or using uvx/uv for STDIO mode. Configure your MCP client with the appropriate JSON settings.

Key features of mcp_mysql_server

  • Execute multiple SQL statements separated by ";"
  • Query table names and fields using table comments
  • Analyze SQL execution plans
  • Convert Chinese field names to pinyin initials
  • Detect row-level and table-level locks
  • Assess MySQL health status (connections, transactions, locks)
  • Permission control with three roles (readonly, writer, admin)
  • Supports both STDIO and SSE transport modes

Use cases of mcp_mysql_server

  • Perform database CRUD operations with configurable permissions
  • Diagnose slow SQL queries and deadlock issues
  • Monitor overall MySQL health and index usage
  • Automate table creation and data insertion via natural-language prompts
  • Extend with custom tools for additional database analysis

Frequently asked questions

1

What permission roles are available?

Three roles: **readonly** (SELECT, SHOW, DESCRIBE, EXPLAIN), **writer** (adds INSERT, UPDATE, DELETE), and **admin** (adds CREATE, ALTER, DROP, TRUNCATE). Role is set via the `MYSQL_ROLE` environment variable.

2

How do I install and configure mcp_mysql_server?

Install with `pip install mysql_mcp_server_pro`, then set the environment variables `MYSQL_HOST`, `MYSQL_PORT`, `MYSQL_USER`, `MYSQL_PASSWORD`, `MYSQL_DATABASE`, and optionally `MYSQL_ROLE` in a `.env` file or in your shell.

3

What tools does mcp_mysql_server provide?

It provides eight tools: `execute_sql`, `get_chinese_initials`, `get_db_health_running`, `get_table_desc`, `get_table_index`, `get_table_lock`, `get_table_name`, and `get_db_health_index_usage`.

4

Can I add custom tools to mcp_mysql_server?

Yes. Create a new tool class in the `handles` package that inherits from `BaseHandler`, implement `get_tool_description` and `run_tool`, then import it in `__init__.py`.

5

What transport modes are supported?

Both STDIO and SSE modes are supported. Use `mysql_mcp_server_sse` for SSE or configure a `uv` command with `--stdio` for STDIO.

Comments

More Databases MCP servers

Multi Database MCP Server

FreePeak

A powerful multi-database server implementing the Model Context Protocol (MCP) to provide AI assistants with structured access to databases.

397

Expired Domains MCP | Karma.Domains

karma-domains

Connect Karma.Domains to ChatGPT, Claude, Cursor, VS Code, or another MCP client — and find a domain in plain language. The same auctions, expired, backorder, and buy-now data you use in the app, plus saved filters, note

MCP Alchemy

runekaagaard

A MCP (model context protocol) server that gives the LLM access to and knowledge about relational databases like SQLite, Postgresql, MySQL & MariaDB, Oracle, and MS-SQL.

412

mcp-server-qdrant: A Qdrant MCP server

qdrant

An official Qdrant Model Context Protocol (MCP) server implementation

637

Chroma MCP Server

chroma-core

A Model Context Protocol (MCP) server implementation that provides database capabilities for Chroma

569
Advertise