mysqldb-mcp-server MCP server

@MCP-Mirror

Repository

Basic information

About mysqldb-mcp-server MCP server

Mirror of

#mysqldb#mcp-server #database

mysqldb-mcp-server MCP server 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"
      ]
    }
  }
}

mysqldb-mcp-server MCP server tools

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

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.

Comments

More Other MCP servers

FastMCP v2 🚀

jlowin

🚀 The fast, Pythonic way to build MCP servers and clients.

26.0K

Klarix Intelligence Engine

Klarix

B2B competitive intelligence, live sales battlecards, 5-axis ICP prospect fit scoring, and tech stack teardowns over MCP and REST with cited public-web evidence.

Glasswarp

See and control a real Windows PC you own — from any MCP client, locally or remotely. Observe (UIA + screenshots), click/type/drag/scroll, launch apps, owner Live View. BYOH: your machine, your key.

EverArt

modelcontextprotocol

Model Context Protocol Servers

88.1K

ICSS

chokcoco

不止于 CSS

20.7K