mysqldb-mcp-server MCP server
@MCP-Mirror
About mysqldb-mcp-server MCP server
Mirror of
Config
Add this server to your MCP-compatible client using the configuration below.
{
"mcpServers": {
"burakdirin_mysqldb-mcp-server": {
"command": "uv",
"args": [
"pip",
"install",
"mysqldb-mcp-server"
]
}
}
}Tools
2Connects to a specific MySQL database
Executes MySQL queries
Overview
What is mysqldb-mcp-server?
mysqldb-mcp-server is a MySQL database MCP server that provides tools to connect to MySQL databases and execute SQL queries via the Model Context Protocol. It is designed for developers who want to interact with MySQL databases through AI assistants that support MCP.
How to use mysqldb-mcp-server?
Install the package using pip or uv, then configure environment variables (MYSQL_HOST, MYSQL_USER, MYSQL_PASSWORD, MYSQL_DATABASE, MYSQL_READONLY). Add the server configuration to Claude Desktop’s claude_desktop_config.json. Use the connect_database tool to connect to a specific database and execute_query to run SQL queries.
Key features of mysqldb-mcp-server
- Provides two tools:
connect_databaseandexecute_query - Supports multiple SQL queries separated by semicolons
- Returns query results in JSON format
- Enables read‑only mode via the MYSQL_READONLY environment variable
- Can be installed via Smithery for automated Claude Desktop setup
Use cases of mysqldb-mcp-server
- Querying MySQL databases directly from an AI assistant conversation
- Executing database migrations or updates through natural language commands
- Reading and analyzing data from a MySQL database without leaving the chat interface
FAQ from mysqldb-mcp-server
What tools does the server provide?
Two tools: connect_database (connects to a specific database) and execute_query (runs SQL queries and returns results in JSON).
How do I configure the server?
Set environment variables MYSQL_HOST, MYSQL_USER, MYSQL_PASSWORD, optionally MYSQL_DATABASE, and MYSQL_READONLY for read‑only mode.
Can I run queries in read‑only mode?
Yes, by setting MYSQL_READONLY to 1 or true.
How do I install the server?
Using pip install mysqldb-mcp-server or uv pip install mysqldb-mcp-server. A published version can also be run via uvx.
What are the runtime requirements?
The server runs on Python and requires a MySQL connection. No additional runtime dependencies beyond the package are mentioned in the README.
Frequently asked questions
What tools does the server provide?
Two tools: `connect_database` (connects to a specific database) and `execute_query` (runs SQL queries and returns results in JSON).
How do I configure the server?
Set environment variables `MYSQL_HOST`, `MYSQL_USER`, `MYSQL_PASSWORD`, optionally `MYSQL_DATABASE`, and `MYSQL_READONLY` for read‑only mode.
Can I run queries in read‑only mode?
Yes, by setting `MYSQL_READONLY` to `1` or `true`.
How do I install the server?
Using `pip install mysqldb-mcp-server` or `uv pip install mysqldb-mcp-server`. A published version can also be run via `uvx`.
What are the runtime requirements?
The server runs on Python and requires a MySQL connection. No additional runtime dependencies beyond the package are mentioned in the README.
Basic information
More Other MCP servers
Reactive Resume
amruthpillaiA one-of-a-kind resume builder that keeps your privacy in mind. Completely secure, customizable, portable, open-source and free forever. Try it out today!
🚀 Model Context Protocol (MCP) Curriculum for Beginners
microsoftThis open-source curriculum introduces the fundamentals of Model Context Protocol (MCP) through real-world, cross-language examples in .NET, Java, TypeScript, JavaScript, Rust and Python. Designed for developers, it focuses on practical techniques for building modular, scalable,
🪟 Windows-MCP
CursorTouchMCP Server for Computer Use in Windows
Peekaboo MCP – lightning-fast macOS screenshots for AI agents
steipetePeekaboo is a macOS CLI & optional MCP server that enables AI agents to capture screenshots of applications, or the entire system, with optional visual question answering through local or remote AI models.
DeepMark
DeepMark helps teachers deliver rapid, consistent marking with meaningful feedback for every student — in a fraction of the time. What once took a week, now takes one free period.
Comments