MCP.so
Sign In

mysqldb-mcp-server MCP server

@MCP-Mirror

Repository

About mysqldb-mcp-server MCP server

Mirror of

#mysqldb#mcp-server#database

Basic information

Category

Other

License

MIT license

Runtime

python

Transports

stdio

Publisher

MCP-Mirror

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

2

Connects 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_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

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.

Comments

More Other MCP servers

Website

FunnyWolf

Adversary simulation and Red teaming platform with AI

5.1K

MCP Toolbox for Databases

googleapis

MCP Toolbox for Databases is an open source MCP server for databases.

15.9K

ACI: Open-Source Infra to Power Unified MCP Servers

aipotheosis-labs

ACI.dev is the open source tool-calling platform that hooks up 600+ tools into any agentic IDE or custom AI agent through direct function calling or a unified MCP server. The birthplace of VibeOps.

4.8K

Production-ready MCP integrations for AI applications

Klavis-AI

Klavis AI: MCP integration platforms that let AI agents use tools reliably at any scale

5.8K

Sequential Thinking

modelcontextprotocol

Model Context Protocol Servers

88.2K