广告合作
MCP.so
登录

MySQL MCP Server

@actstorms

代码仓库

基本信息

分类

数据库

传输方式

stdio

作者

actstorms

关于 MySQL MCP Server

暂无概览

#mcp-mysql-server#database#mcp

MySQL MCP Server 配置

使用下面的配置,将此服务器添加到你的 MCP 客户端。

{
  "mcpServers": {
    "mcp-mysql-server-actstorms": {
      "command": "node",
      "args": [
        "build/index.js"
      ]
    }
  }
}

MySQL MCP Server 工具

工具列表暂未提供

当前收录暂时没有可展示的工具列表，不代表服务没有工具。请查阅项目文档了解支持的能力。

工具是从 README 中自动提取的。维护者可以在 ## Tools 标题下列出工具,即可填充这部分内容。

概览

What is MySQL MCP Server?

MySQL MCP Server is a Model Context Protocol (MCP) server that enables MCP clients (such as AI assistants) to query and modify data in a MySQL database. It connects to a user-configured MySQL instance and exposes tools for executing SQL statements over standard input/output (stdio).

How to use MySQL MCP Server?

Install dependencies with npm install, build the TypeScript code with npm run build, then run mysql-server (if linked globally) or node build/index.js. Configure connection via environment variables: MYSQL_HOST, MYSQL_USER, MYSQL_PASSWORD, MYSQL_DATABASE (required), and optionally MYSQL_PORT (default 3306). Set MYSQL_ALLOW_WRITE_OPS=true to enable write tools (insert, update, delete); otherwise only read-only queries are allowed.

Key features of MySQL MCP Server

  • Connects to MySQL using standard connection parameters.
  • Provides MCP tools for executing SQL queries and statements.
  • Read-only queries (SELECT, SHOW, DESCRIBE) via the query tool.
  • Write operations (INSERT, UPDATE, DELETE) via separate tools.
  • Write tools are gated by the MYSQL_ALLOW_WRITE_OPS environment variable.
  • Communicates over standard input/output (stdio).

Use cases of MySQL MCP Server

  • AI assistants executing read-only reports or analytics on a MySQL database.
  • Automating data entry with INSERT statements through a chat interface.
  • Managing small-scale updates or deletions in a database via natural language.

常见问题

1

What does MySQL MCP Server do?

It acts as a bridge between MCP clients and a MySQL database, allowing AI assistants to run SQL queries and optionally modify data.

2

What are the dependencies for running MySQL MCP Server?

Node.js and npm are required to install and build the server. It also needs access to a running MySQL server and the corresponding connection credentials.

3

Where does the data reside?

All data stays in the user’s configured MySQL database. The server does not store or cache data externally.

4

What transport does MySQL MCP Server use?

It uses standard input/output (stdio) for communication with MCP clients.

5

How is authentication handled for MySQL?

Authentication is provided via the required environment variables `MYSQL_USER` and `MYSQL_PASSWORD`. Write operations can be further restricted by the optional `MYSQL_ALLOW_WRITE_OPS` variable, which defaults to `false`.

评论

数据库 分类下的更多 MCP 服务器

Dbhub

bytebase

Zero-dependency, token-efficient database MCP server for Postgres, MySQL, SQL Server, MariaDB, SQLite.

3.1K

MotherDuck's DuckDB MCP Server

motherduckdb

Local MCP server for DuckDB and MotherDuck

498

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

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.

广告合作