mcp-server-mysql
@yuru-sha
About mcp-server-mysql
MCP Server for MySQL databases
Config
Add this server to your MCP-compatible client using the configuration below.
{
"mcpServers": {
"mcp-server-mysql-yuru-sha": {
"command": "docker",
"args": [
"run",
"-i",
"--rm",
"mcp/mysql",
"mysql://host:port/dbname"
]
}
}
}Tools
No tools detected
We auto-extract tools from the README. The maintainer can list them under a ## Tools heading to populate this section.
Overview
What is mcp-server-mysql?
Model Context Protocol Server for MySQL databases. It enables LLMs to inspect database schemas and execute read-only queries in a safe, read‑only transaction.
How to use mcp-server-mysql?
Install via Docker (build the image then run with a connection URL) or via the Smithery CLI. Configure the server in Claude Desktop by adding a “mysql” entry to claude_desktop_config.json that points to a Docker run command with the mysql://host:port/dbname connection string.
Key features of mcp-server-mysql
- Read-only access to MySQL databases
- Schema inspection for LLM‑driven analysis
- All queries executed inside READ ONLY transactions
- Docker image available for easy deployment
- Published as an npm package
Use cases of mcp-server-mysql
- Allow an LLM to examine table structures and relationships
- Let an LLM answer questions about database content with safe, read‑only queries
- Provide live schema details to AI agents during data exploration
FAQ from mcp-server-mysql
What does mcp-server-mysql do?
It acts as a bridge between LLMs and a MySQL database, allowing schema inspection and read‑only query execution while enforcing READ ONLY transactions.
What are the runtime requirements?
You can run it via Docker (using the built image) or install it as an npm package. The README does not specify a minimum Node.js version.
How is data protected?
All queries are wrapped in READ ONLY transactions, preventing any writes to the database. For extra security, creating a dedicated read‑only database user is recommended.
What connection URL format does it expect?
The server accepts a connection string in the form mysql://[user][:password]@host[:port]/database.
Is there a known limitation?
The server intentionally restricts all operations to read‑only; no insert, update, or delete actions are permitted.
Frequently asked questions
What does mcp-server-mysql do?
It acts as a bridge between LLMs and a MySQL database, allowing schema inspection and read‑only query execution while enforcing READ ONLY transactions.
What are the runtime requirements?
You can run it via Docker (using the built image) or install it as an npm package. The README does not specify a minimum Node.js version.
How is data protected?
All queries are wrapped in READ ONLY transactions, preventing any writes to the database. For extra security, creating a dedicated read‑only database user is recommended.
What connection URL format does it expect?
The server accepts a connection string in the form `mysql://[user][:password]@host[:port]/database`.
Is there a known limitation?
The server intentionally restricts all operations to read‑only; no insert, update, or delete actions are permitted.
Basic information
More Databases MCP servers
PostgreSQL
modelcontextprotocolModel Context Protocol Servers
Elasticsearch/OpenSearch MCP Server
cr7258A Model Context Protocol (MCP) server implementation that provides Elasticsearch and OpenSearch interaction.
MCP Alchemy
runekaagaardA 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.
mcp_mysql_server
wenb1n-devModel Context Protocol (MCP) server that supports secure interaction with MySQL databases and has anomaly analysis capabilities.更加牛逼！更加好用！不仅止于mysql的增删改查功能； 还包含了数据库异常分析能力；且便于开发者们进行个性化的工具扩展
nuzur
nuzur is a model-first database platform for MySQL and PostgreSQL. The MCP server lets any AI assistant or agent (Claude, Cursor, Gemini, or anything else that speaks MCP) design your schema, query your data, generate mi
Comments