广告合作
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 服务器

MCP Server for MySQL based on NodeJS

benborla

A Model Context Protocol server that provides read-only access to MySQL databases. This server enables LLMs to inspect database schemas and execute read-only queries.

1.9K

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.

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

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.

Neon MCP Server

neondatabase

MCP server for interacting with Neon Management API and databases

617
广告合作