mysqldb-mcp-server MCP server

Name: mysqldb-mcp-server MCP server
Author: MCP-Mirror

@MCP-Mirror

代码仓库

关于 mysqldb-mcp-server MCP server

Mirror of

#mysqldb #mcp-server #database

基本信息

分类

其他

许可证

MIT license

运行时

python

传输方式

stdio

发布者

MCP-Mirror

配置

使用下面的配置,将此服务器添加到你的 MCP 客户端。

{
  "mcpServers": {
    "burakdirin_mysqldb-mcp-server": {
      "command": "uv",
      "args": [
        "pip",
        "install",
        "mysqldb-mcp-server"
      ]
    }
  }
}

工具

Connects to a specific MySQL database

Executes MySQL queries

概览

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_database and execute_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