What operations does MySQL Database Access MCP Server support?
It supports listing databases, listing tables, describing table schemas, and executing read‑only SQL queries (SELECT, SHOW, DESCRIBE, EXPLAIN).
@allizwellai
基本信息
暂无概览
使用下面的配置,将此服务器添加到你的 MCP 客户端。
{
"mcpServers": {
"mysql": {
"command": "npx",
"args": [
"mysql-mcp-server"
],
"env": {
"MYSQL_HOST": "",
"MYSQL_PORT": "",
"MYSQL_USER": "",
"MYSQL_PASSWORD": "",
"MYSQL_DATABASE": ""
}
}
}
}工具列表暂未提供
当前收录暂时没有可展示的工具列表,不代表服务没有工具。请查阅项目文档了解支持的能力。
点击上方按钮,在临时沙箱中运行此服务器并实时获取工具列表。
MySQL Database Access MCP Server provides read-only access to MySQL databases via the Model Context Protocol. It lets you list databases, list tables, describe table schemas, and execute read-only SQL queries. This server is designed for developers and AI agents who need to inspect MySQL schemas and query data without risk of modification.
Install globally via npm (npm install -g mysql-mcp-server) or build from source, then configure environment variables (MYSQL_HOST, MYSQL_PORT, MYSQL_USER, MYSQL_PASSWORD, MYSQL_DATABASE) and add the server configuration to your MCP settings file. Use the provided tools: list_databases, list_tables, describe_table, and execute_query.
It supports listing databases, listing tables, describing table schemas, and executing read‑only SQL queries (SELECT, SHOW, DESCRIBE, EXPLAIN).
Install from npm (`npm install -g mysql-mcp-server`) or build from source. Set environment variables for your MySQL connection (host, port, user, password, database) and add the server to your MCP settings file.
No. The server enforces read‑only access; only SELECT, SHOW, DESCRIBE, and EXPLAIN statements are allowed. Data modification attempts are blocked.
`MYSQL_HOST`, `MYSQL_PORT`, and `MYSQL_USER` are required. `MYSQL_PASSWORD` is optional but recommended. `MYSQL_DATABASE` is optional.
The server has a query timeout to prevent long‑running queries from consuming resources and a row limit to prevent excessive data return.
Postgres MCP Pro provides configurable read/write access and performance analysis for you and your AI agents.
A Model Context Protocol server to connect to MongoDB databases and MongoDB Atlas Clusters.
EnvKit — free local development environment for Windows & macOS: nginx/Apache, multiple PHP versions, MySQL/MariaDB, PostgreSQL, Redis, MongoDB, Mailpit, Node.js, trusted .test HTTPS, and a built-in MCP server for AI-assistant control. A Laragon/XAMPP/Herd alternative.

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

Safety-first stdio MCP server with 38 tools for operating Docker-based local-ydb environments locally or over SSH.
评论