広告掲載
MCP.so
ログイン

MySQL MCP Server

@yuki777

リポジトリ

基本情報

カテゴリ

データベース

ライセンス

NOASSERTION

トランスポート

stdio

作者

yuki777

MySQL MCP Server について

概要はまだありません

MySQL MCP Server の設定

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

{
  "mcpServers": {
    "mysql-mcp-server-yuki777": {
      "command": "npx",
      "args": [
        "-y",
        "https://github.com/yuki777/mysql-mcp-server",
        "--host",
        "127.0.0.1",
        "--port",
        "13306",
        "--user",
        "root"
      ]
    }
  }
}

MySQL MCP Server のツール

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

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

上のボタンで一時的なサンドボックスでこのサーバーを実行し、ツール一覧を取得できます。

概要

What is MySQL MCP Server?

MySQL MCP Server enables large language models (LLMs) to directly execute SQL queries on a local MySQL or MariaDB database by implementing the Model Context Protocol (MCP). It is built for developers and AI applications that need LLMs to safely interact with relational databases.

How to use MySQL MCP Server?

Run it via npx with database connection options, or use a JSON config file. The server starts in stdio mode and accepts tool calls for connecting, querying, and managing connections. Example: npx -y https://github.com/yuki777/mysql-mcp-server --host 127.0.0.1 --port 13306 --user root. After starting, LLMs invoke MCP tools like execute_query and connect_database.

Key features of MySQL MCP Server

  • Executes SQL queries directly from LLM tool calls
  • Lists databases, tables, and table structures
  • M‑CP compliant, integrates with any MCP‑capable LLM
  • Uses stdio communication, no network port binding
  • Saves connection profiles locally for reuse
  • Manages multiple profiles and switches between them

Use cases of MySQL MCP Server

  • Allow an LLM to explore and query a local database for data analysis
  • Let an LLM manage database schemas by running DDL statements
  • Switch between development and production databases using saved profiles
  • Securely connect an LLM to a database without exposing network ports

よくある質問

1

What are the runtime requirements?

Node.js 20.0.0 or higher and MySQL 5.7+ or MariaDB server are required.

2

Where are saved connection profiles stored?

Profiles are stored locally in `~/.mysql-mcp-connections.json` in the user’s home directory.

3

Does this server expose a network port?

No, it uses stdio communication by default, avoiding port conflicts and improving security. An optional HTTP server port can be configured but is not used in stdio mode.

4

Can I connect to multiple databases without restarting?

Yes, the server separates startup from database connection. You can use `connect_database` or `connect_by_profile` tools to switch between databases at runtime.

5

How do I configure a custom query timeout and result limit?

Use the `--query-timeout` (default 30000 ms) and `--max-results` (default 1000 rows) command‑line options or set them in the JSON config file.

コメント

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

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

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

PostgreSQL Model Context Protocol (PG-MCP) Server

stuzero

540

Local YDB MCP

astandrik

Safety-first stdio MCP server with 38 tools for operating Docker-based local-ydb environments locally or over SSH.

4

golfdata.online - Verified Golf Clubs

golfdata.online

Verified golf club data for AI agents: holes, par, address, phone, booking links, facilities, visitor rules and green fees for golf clubs in Spain (Canary Islands and mainland), expanding across Europe. Every fact comes

広告掲載