MySQL MCP Server

@gopikapeenikkal

リポジトリ

基本情報

カテゴリ

データベース

ライセンス

MIT license

トランスポート

stdio

作者

gopikapeenikkal

MySQL MCP Server について

Custom MCP Server for MySQL

MySQL MCP Server の設定

以下の設定を使って、このサーバーを MCP 対応クライアントに追加してください。

{
  "mcpServers": {
    "mysql-mcp-server-gopikapeenikkal": {
      "command": "uv",
      "args": [
        "pip",
        "install",
        "mcp_mysql_connect"
      ]
    }
  }
}

MySQL MCP Server のツール

ツール一覧はまだありません

この掲載には表示できるツール一覧がまだありません。サーバーにツールがないという意味ではありません。対応機能はプロジェクトのドキュメントをご確認ください。

ツールは README から自動的に抽出されます。メンテナーは ## Tools という見出しの下に記載することで、このタブに反映できます。

概要

What is MySQL MCP Server?

A Model Context Protocol (MCP) server that connects to a MySQL database and exposes a tool for AI models to execute SQL queries via natural language, without direct database access.

How to use MySQL MCP Server?

Install with pip install mcp_mysql_connect or uv pip install mcp_mysql_connect. Set environment variables DB_HOST, DB_USER, DB_PASSWORD, and DB_NAME. Then configure in Cursor's mcp.json, use the Python client, or run manually with python -m mcp_mysql_connect.

Key features of MySQL MCP Server

Provides a single read_query tool for executing SELECT queries
Allows natural language querying through AI models like Claude
Integrates with Cursor via mcp.json configuration
Supports manual execution and Python client usage
Requires Python 3.11+ and a MySQL database

Use cases of MySQL MCP Server

Ask an AI model to list users registered in the last week
Retrieve top 5 selling products via plain English
Count orders per customer without writing SQL manually
Explore database content through conversational chat interfaces

よくある質問

What are the prerequisites for MySQL MCP Server?

Python 3.11 or above and a running MySQL database.

How do I install MySQL MCP Server?

Install via pip: `pip install mcp_mysql_connect`, or with UV: `uv pip install mcp_mysql_connect`.

What environment variables are required?

The server needs `DB_HOST`, `DB_USER`, `DB_PASSWORD`, and `DB_NAME`.

How can I use MySQL MCP Server with Cursor?

Add a `"mysql-mcp-server"` entry to `~/.cursor/mcp.json` using either `uvx` or `uv` commands, including the four database environment variables.

What SQL operations does MySQL MCP Server support?

Currently only `read_query` for SELECT queries; write operations are not mentioned.

「データベース」の他のコンテンツ

nuzur

nuzur is a model-first database platform for MySQL and PostgreSQL. The MCP server lets any AI assistant or agent (Claude, Cursor, Gemini, or anything else that speaks MCP) design your schema, query your data, generate mi

Expired Domains MCP | Karma.Domains

karma-domains

Connect Karma.Domains to ChatGPT, Claude, Cursor, VS Code, or another MCP client — and find a domain in plain language. The same auctions, expired, backorder, and buy-now data you use in the app, plus saved filters, note