投稿ログイン

MySQL MCP Server

@gopikapeenikkal

リポジトリ

MySQL MCP Server について

Custom MCP Server for MySQL

基本情報

カテゴリ

データベース

ライセンス

MIT license

ランタイム

python

トランスポート

stdio

公開者

gopikapeenikkal

設定

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

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

ツール

ツールは検出されませんでした

ツールは 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

FAQ from MySQL MCP Server

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.

コメント

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

mcp-server-duckdb

A Model Context Protocol (MCP) server implementation for DuckDB, providing database interaction capabilities

MongoDB Lens

🍃🔎 MongoDB Lens: Full Featured MCP Server for MongoDB Databases

Neon MCP Server

MCP server for interacting with Neon Management API and databases

Multi Database MCP Server

A powerful multi-database server implementing the Model Context Protocol (MCP) to provide AI assistants with structured access to databases.

Chroma MCP Server

A Model Context Protocol (MCP) server implementation that provides database capabilities for Chroma