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

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.

「その他」の他のコンテンツ

🪟 Windows-MCP

CursorTouch

MCP Server for Computer Use in Windows

6.3K

MCP Go 🚀

mark3labs

A Go implementation of the Model Context Protocol (MCP), enabling seamless integration between LLM applications and external data sources and tools.

8.9K

Activepieces

activepieces

AI Agents & MCPs & AI Workflow Automation • (~400 MCP servers for AI agents) • AI Automation / AI Agent with MCPs • AI Workflows & AI Agents • MCPs for AI Agents

23.2K