MySQL Query MCP Server
@devakone
关于 MySQL Query MCP Server
MySQL Query MCP server for AI assistants - execute read-only MySQL queries
基本信息
配置
使用下面的配置,将此服务器添加到你的 MCP 客户端。
{
"mcpServers": {
"mysql-query-mcp-server": {
"command": "npx",
"args": [
"mysql-query-mcp-server"
]
}
}
}工具
未检测到工具
工具是从 README 中自动提取的。维护者可以在 ## Tools 标题下列出工具,即可填充这部分内容。
概览
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
数据库 分类下的更多 MCP 服务器
MCP MongoDB Server
kiliczshA Model Context Protocol Server for MongoDB
MongoDB MCP Server
mongodb-jsA Model Context Protocol server to connect to MongoDB databases and MongoDB Atlas Clusters.
Multi Database MCP Server
FreePeakA powerful multi-database server implementing the Model Context Protocol (MCP) to provide AI assistants with structured access to databases.

Sqlite
modelcontextprotocolModel Context Protocol Servers
MotherDuck's DuckDB MCP Server
motherduckdbLocal MCP server for DuckDB and MotherDuck
评论