MySQL Database Access MCP Server
@shensiqi0701
About MySQL Database Access MCP Server
No overview available yet
Config
Add this server to your MCP-compatible client using the configuration below.
{
"mcpServers": {
"mysql-mcp-server-modification": {
"command": "npx",
"args": [
"-y",
"@smithery/cli",
"install",
"@dpflucas/mysql-mcp-server",
"--client",
"claude"
]
}
}
}Tools
No tools detected
Fetch the live tool list by running this server in a temporary sandbox using the button above.
Overview
What is MySQL Database Access MCP Server?
A read-only MCP server that provides tools to interact with MySQL databases, including listing databases, listing tables, describing table structures, and executing read-only SQL queries.
How to use MySQL Database Access MCP Server?
Install via npm (npm install -g @valuprosys/mysql-mcp-server), set the required environment variables (MYSQL_HOST, MYSQL_PORT, MYSQL_USER, MYSQL_PASSWORD, and optionally MYSQL_DATABASE), then add the server configuration to your MCP client config under mcpServers.mysql.
Key features of MySQL Database Access MCP Server
- List all accessible databases on the MySQL server
- List tables within a specified database
- Describe table structure including column comments
- Execute read-only SQL queries (SELECT, SHOW, DESCRIBE, EXPLAIN)
Use cases of MySQL Database Access MCP Server
- Querying database metadata without writing full SQL
- Exploring table schemas during development or debugging
- Performing safe, read-only data lookups from an AI assistant
FAQ from MySQL Database Access MCP Server
What queries are allowed?
Only SELECT, SHOW, DESCRIBE, and EXPLAIN statements are permitted. Other SQL statements will be rejected.
What environment variables are required?
MYSQL_HOST, MYSQL_PORT (default 3306), MYSQL_USER, and MYSQL_PASSWORD must be set. MYSQL_DATABASE (default database name) is optional.
How do I configure the server with my MCP client?
Add the following to your MCP configuration under mcpServers.mysql: command npx, args ["@valuprosys/mysql-mcp-server"], and the necessary environment variables.
Does the server modify data?
No. The server is strictly read-only and only accepts SELECT, SHOW, DESCRIBE, and EXPLAIN queries.
Frequently asked questions
What queries are allowed?
Only SELECT, SHOW, DESCRIBE, and EXPLAIN statements are permitted. Other SQL statements will be rejected.
What environment variables are required?
`MYSQL_HOST`, `MYSQL_PORT` (default 3306), `MYSQL_USER`, and `MYSQL_PASSWORD` must be set. `MYSQL_DATABASE` (default database name) is optional.
How do I configure the server with my MCP client?
Add the following to your MCP configuration under `mcpServers.mysql`: command `npx`, args `["@valuprosys/mysql-mcp-server"]`, and the necessary environment variables.
Does the server modify data?
No. The server is strictly read-only and only accepts SELECT, SHOW, DESCRIBE, and EXPLAIN queries.
Basic information
More Databases MCP servers
Elasticsearch/OpenSearch MCP Server
cr7258A Model Context Protocol (MCP) server implementation that provides Elasticsearch and OpenSearch interaction.
Neon MCP Server
neondatabase-labsMCP server for interacting with Neon Management API and databases
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
mcp_mysql_server
wenb1n-devModel Context Protocol (MCP) server that supports secure interaction with MySQL databases and has anomaly analysis capabilities.更加牛逼！更加好用！不仅止于mysql的增删改查功能； 还包含了数据库异常分析能力；且便于开发者们进行个性化的工具扩展
MotherDuck's DuckDB MCP Server
motherduckdbLocal MCP server for DuckDB and MotherDuck
Comments