MySQL Query MCP Server
@devakone
About MySQL Query MCP Server
MySQL Query MCP server for AI assistants - execute read-only MySQL queries
Config
Add this server to your MCP-compatible client using the configuration below.
{
"mcpServers": {
"mysql-query-mcp-server": {
"command": "npx",
"args": [
"mysql-query-mcp-server"
]
}
}
}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 Query MCP Server?
A Model Context Protocol (MCP) server that provides read-only MySQL database queries for AI assistants. It enables AI-powered tools like Cursor IDE and Anthropic Claude to execute queries, explore database structures, and investigate data directly.
How to use MySQL Query MCP Server?
Install globally with npm install -g mysql-query-mcp-server or run instantly with npx mysql-query-mcp-server. Configure your AI tool’s MCP settings (e.g., .cursor/mcp.json) with environment variables for database credentials (LOCAL_DB_HOST, LOCAL_DB_USER, etc.). The server exposes three tools: query (read-only SQL), info (database metadata), and environments (list configured environments).
Key features of MySQL Query MCP Server
- Read-only MySQL queries (SELECT, SHOW, DESCRIBE)
- Predefined environments: local, development, staging, production
- SSL support for secure database connections
- Query timeout to prevent long-running operations
- Database information and metadata retrieval
- Lists available database environments
Use cases of MySQL Query MCP Server
- Investigate database structure and table schemas via AI assistants
- Run read-only analytical queries on production data without risk
- Explore development and staging databases for debugging
- List available database environments from configuration
- Retrieve database metadata such as version and connection status
FAQ from MySQL Query MCP Server
What types of queries can I execute?
Only read‑only SQL statements: SELECT, SHOW
Frequently asked questions
What types of queries can I execute?
Only read‑only SQL statements: SELECT, SHOW
Basic information
More Databases MCP servers
MCP Server for MySQL based on NodeJS
benborlaA Model Context Protocol server that provides read-only access to MySQL databases. This server enables LLMs to inspect database schemas and execute read-only queries.
ClickHouse MCP Server
ClickHouseConnect ClickHouse to your AI assistants.
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
xwb602625136Model Context Protocol (MCP) server that supports secure interaction with MySQL databases and has anomaly analysis capabilities.更加牛逼！更加好用！不仅止于mysql的增删改查功能； 还包含了数据库异常分析能力；且便于开发者们进行个性化的工具扩展
Xata MCP Server
The Xata MCP server lets AI assistants and agents interact with your Xata organizations, projects, and Postgres database branches.
Comments