MCP Server MySQL Database Explorer
@eth-ts-x
关于 MCP Server MySQL Database Explorer
暂无概览
基本信息
配置
使用下面的配置,将此服务器添加到你的 MCP 客户端。
{
"mcpServers": {
"mcp-server-mysql-pool": {
"command": "uv",
"args": [
"run",
"mcp",
"dev",
"main.py"
]
}
}
}工具
未检测到工具
工具是从 README 中自动提取的。维护者可以在 ## Tools 标题下列出工具,即可填充这部分内容。
概览
What is MCP Server MySQL Database Explorer?
This MCP server connects to your MySQL database, providing seamless access to database schemas, tables, and query capabilities through LLMs.
How to use MCP Server MySQL Database Explorer?
Install dependencies with uv add "mcp[cli]" aiomysql, configure environment variables (MYSQL_HOST, MYSQL_PORT, MYSQL_USER, MYSQL_PASSWORD, MYSQL_DB, MYSQL_POOL_SIZE) in a .env file or directly in the environment, then run the server via uv run mcp dev main.py for testing or paste the JSON configuration into your MCP client (e.g., Cline, Cursor).
Key features of MCP Server MySQL Database Explorer
- Connect to your MySQL database
- Expose table schemas, CREATE statements, and sample data as resources
- Run read-only SQL queries with secure validation
Use cases of MCP Server MySQL Database Explorer
—
FAQ from MCP Server MySQL Database Explorer
What dependencies are required?
The project requires uv and the packages mcp[cli] and aiomysql to be installed.
How do I configure the database credentials?
Set environment variables via a .env file at the project root (e.g., MYSQL_HOST, MYSQL_USER, MYSQL_PASSWORD, MYSQL_DB) or define them directly in your environment.
Are write operations supported?
No, the server only runs read-only SQL queries with secure validation.
Which MCP clients can I use?
The server can be installed in MCP clients like Cline and Cursor by pasting the provided JSON configuration.
What is the default connection pool size?
The default MYSQL_POOL_SIZE is 10, configurable via environment variables.
数据库 分类下的更多 MCP 服务器
mcp_mysql_server
xwb602625136Model Context Protocol (MCP) server that supports secure interaction with MySQL databases and has anomaly analysis capabilities.更加牛逼！更加好用！不仅止于mysql的增删改查功能； 还包含了数据库异常分析能力；且便于开发者们进行个性化的工具扩展
Snowflake MCP Server
isaacwasserman
Meilisearch MCP Server
meilisearchA Model Context Protocol (MCP) server for interacting with Meilisearch through LLM interfaces.
Redis MCP Server
redisThe official Redis MCP Server is a natural language interface designed for agentic applications to manage and search data in Redis efficiently
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.
评论