広告掲載
MCP.so
ログイン

Mysql MCP Server

@Mineru98

リポジトリ

基本情報

カテゴリ

データベース

ライセンス

MIT

トランスポート

stdio

作者

Mineru98

Mysql MCP Server について

A server application designed on top of MCP to interact with Cursor and MySQL.

#mysql#mcp

Mysql MCP Server の設定

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

{
  "mcpServers": {
    "mysql-mcp-server-mineru98": {
      "command": "python",
      "args": [
        "mysql_mcp_server/main.py",
        "run"
      ]
    }
  }
}

Mysql MCP Server のツール

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

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

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

概要

What is mysql-mcp-server?

mysql-mcp-server is a server application for MySQL database operations built on the Model Context Protocol (MCP). It provides tools that allow AI models to interact with a MySQL database.

How to use mysql-mcp-server?

Deploy via Docker, Docker Compose, or run directly with Python. Set environment variables for MySQL connection (host, port, user, password, database). For Cursor IDE, version 0.46+ and a Pro account are required. Use python mysql_mcp_server/main.py run for local execution.

Key features of mysql-mcp-server

  • Docker and Docker Compose deployment
  • Python-based MCP server using FastMCP
  • Tools for CREATE, SELECT, INSERT, DESC, EXPLAIN, SHOW TABLES
  • Database connection management via singleton pattern
  • Environment variable configuration for credentials
  • Visualization chart recommendation tool

Use cases of mysql-mcp-server

  • AI models querying MySQL databases via natural language
  • Automated database schema exploration and reporting
  • Generating data analysis reports with chart recommendations
  • Executing safe SQL operations through tool-based access
  • Integrating MySQL into MCP-enabled workflows

よくある質問

1

What database tools does mysql-mcp-server provide?

It offers tools for creating tables, viewing schemas, executing SELECT and INSERT queries, retrieving table lists, explaining query plans, and generating insight reports.

2

What are the runtime requirements for mysql-mcp-server?

Python with dependencies (mcp, PyMySQL, pandas, python-dotenv, fire) and MySQL 8.0. Docker and Docker Compose are optional for containerized deployment.

3

How do I add a new tool to mysql-mcp-server?

Create an executor file in `mysql_mcp_server/executors`, then import it in `__init__.py` and add it to the `__all__` array. The `@tool` decorator registers it with MCP.

4

Are there any security considerations for mysql-mcp-server?

Database credentials are managed via environment variables. Use strong passwords in production and consider implementing SSL/TLS encryption for database connections.

5

Does mysql-mcp-server support Cursor IDE?

Yes, it works with Cursor version 0.46 and above, but only for Cursor Pro account users. Configuration requires adding the server in Cursor settings.

コメント

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

MongoDB MCP Server

mongodb-js

A Model Context Protocol server to connect to MongoDB databases and MongoDB Atlas Clusters.

1.1K

Fund Momentum MCP Server

schneidavie

Fund Momentum MCP Server — VC intelligence for AI assistants. 1000+ active VC funds, live investor signals, AI-powered startup matching.

MySQL MCP Server

designcomputer

A Model Context Protocol (MCP) server that enables secure interaction with MySQL databases

1.3K

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

ClickHouse MCP Server

ClickHouse

Connect ClickHouse to your AI assistants.

818
広告掲載