広告掲載
MCP.so
ログイン

MySQL MCP Server

@blanplan-ai

リポジトリ

基本情報

カテゴリ

データベース

ライセンス

Apache-2.0 license

トランスポート

stdio

作者

blanplan-ai

MySQL MCP Server について

概要はまだありません

MySQL MCP Server の設定

標準の設定はありません

このサーバーの README には解析可能な MCP 設定ブロックが含まれていません。インストール手順はリポジトリをご確認ください。

リポジトリ

MySQL MCP Server のツール

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

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

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

概要

What is MySQL MCP Server?

A MySQL database connection server built on go-mcp, supporting communication with clients via stdio for executing SQL queries and data manipulation operations. It is designed for developers and AI assistants that need to interact with MySQL databases through the Model Context Protocol.

How to use MySQL MCP Server?

Install via go install github.com/blanplan-ai/ai2mysql-mcp-server/cmd/ai2mysql-mcp-server@latest or build from source. Configure using environment variables (e.g., MYSQL_HOST, MYSQL_USER, MYSQL_PASS) and run the server binary. In clients like Cursor, add a JSON configuration to the MCP servers list.

Key features of MySQL MCP Server

  • Communicates with clients through the MCP protocol
  • Supports SELECT, SHOW, DESCRIBE queries
  • Supports INSERT, UPDATE, DELETE with permission control
  • Flexible configuration via environment variables
  • Debug mode with detailed logging to file
  • Provides mysql_query and mysql_execute tools

Use cases of MySQL MCP Server

  • AI-powered database assistants executing read queries
  • Automated data reporting and analysis workflows
  • Controlled data modification with insert/update/delete permissions
  • Integration with MCP-compatible IDEs like Cursor

よくある質問

1

What SQL operations are supported?

Query operations (SELECT, SHOW, DESCRIBE) and data manipulation (INSERT, UPDATE, DELETE). Permission to manipulate data must be explicitly enabled via `ALLOW_INSERT`, `ALLOW_UPDATE`, and `ALLOW_DELETE` environment variables.

2

How do I enable write operations?

Set `ALLOW_INSERT=true`, `ALLOW_UPDATE=true`, or `ALLOW_DELETE=true` in the environment configuration. By default, only read queries are allowed.

3

How does the server communicate with clients?

The server uses stdio transport and conforms to the MCP protocol, making it compatible with clients that support MCP, such as Cursor.

4

What are the runtime dependencies?

The server is written in Go and uses the MySQL driver (go-sql-driver/mysql). No external runtime beyond the compiled binary is required.

5

How can I troubleshoot connection issues?

Enable development mode by setting `IS_DEV=true`. This outputs detailed logs to the configured log file (default `/tmp/ai2mysql.log`) showing requests, responses, errors, and query execution time.

コメント

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

Database Gateway

centralmind

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

531

MotherDuck's DuckDB MCP Server

motherduckdb

Local MCP server for DuckDB and MotherDuck

498

Neon MCP Server

neondatabase

MCP server for interacting with Neon Management API and databases

617

PostgreSQL Model Context Protocol (PG-MCP) Server

stuzero

540

Schemity

tbson

Local database MCP server: your agent sees a migration's impact before it runs, for PostgreSQL, MySQL, SQL Server and SQLite, with no database credentials.

広告掲載