MCP.so
ログイン

mysql-mcp-server

@Mineru98

リポジトリ

mysql-mcp-server について

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

#mysql#mcp

基本情報

カテゴリ

データベース

ライセンス

MIT

ランタイム

python

トランスポート

stdio

公開者

Mineru98

設定

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

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

ツール

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

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

FAQ from mysql-mcp-server

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.

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.

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.

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.

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.

コメント

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

Multi Database MCP Server

FreePeak

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

397

Database Gateway

centralmind

Universal MCP-Server for your Databases optimized for LLMs and AI-Agents.

531

Sail MCP Server for Spark SQL

lakehq

Drop-in Apache Spark replacement written in Rust, unifying batch processing, stream processing, and compute-intensive AI workloads.

3.1K

MCP Alchemy

runekaagaard

A MCP (model context protocol) server that gives the LLM access to and knowledge about relational databases like SQLite, Postgresql, MySQL & MariaDB, Oracle, and MS-SQL.

412

Meilisearch MCP Server

meilisearch

A Model Context Protocol (MCP) server for interacting with Meilisearch through LLM interfaces.

193