广告合作
MCP.so
登录

MySQL MCP Server

@vitalyDV

代码仓库

基本信息

分类

数据库

传输方式

stdio

作者

vitalyDV

关于 MySQL MCP Server

MySQL MCP server for cursor

#mysql#mcp#database#server

MySQL MCP Server 配置

暂无标准配置

该服务器的 README 中没有可解析的 MCP 配置块，请前往代码仓库查看安装说明。

代码仓库

MySQL MCP Server 工具

工具列表暂未提供

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

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

概览

What is MySQL MCP Server?

MySQL MCP Server is an MCP (Model Context Protocol) server that integrates with MySQL databases. It allows AI assistants and MCP-compatible clients to execute read-only SQL queries, explore database schemas, and retrieve table data. The server is intended for developers who want to connect an AI tool to a MySQL database safely using only query‑side operations.

How to use MySQL MCP Server?

Clone the repository from GitHub, install dependencies with npm install, and add the server configuration to your mcp.json file under mcpServers. The configuration requires setting environment variables for the MySQL connection (MYSQL_HOST, MYSQL_PORT, MYSQL_USER, MYSQL_PASS, MYSQL_DB). The server is started with the command node ./mysql-mcp/index.js.

Key features of MySQL MCP Server

  • Execute read‑only SQL queries (SELECT, SHOW, EXPLAIN, DESCRIBE)
  • Retrieve the structure (schema) of any table
  • List all tables in the connected database
  • Access table data via the resource table://{name} (up to 100 rows)
  • Simple environment‑variable based configuration

Use cases of MySQL MCP Server

  • Query a MySQL database using natural language through an MCP‑capable AI assistant
  • Inspect table schemas and list tables without writing raw SQL
  • Quickly fetch sample data from a table for preview or analysis
  • Enable read‑only database exploration for non‑technical users via an AI interface

常见问题

1

Which SQL statements are supported?

Only SELECT, SHOW, EXPLAIN, and DESCRIBE statements. The server enforces read‑only access, so INSERT, UPDATE, DELETE, and other write commands are not allowed.

2

How do I configure the MySQL connection?

Set the environment variables `MYSQL_HOST`, `MYSQL_PORT`, `MYSQL_USER`, `MYSQL_PASS`, and `MYSQL_DB` in the MCP server configuration. They specify the MySQL host, port, username, password, and database name.

3

Does the server allow write operations to the database?

No. The `query` tool only accepts read‑only SQL statements, and the other tools (table‑schema, list‑tables) are also read‑only. The server is designed for safe, query‑only access.

4

How many rows can I retrieve from a table resource?

The `table://{name}` resource returns up to 100 rows. There is no pagination or limit override described in the README.

5

What runtime does the server require?

The server runs on Node.js. You need to have Node.js and npm installed to clone the repository and install dependencies before launching the server.

评论

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

PostgreSQL

modelcontextprotocol

Model Context Protocol Servers

88.1K

Sqlite

modelcontextprotocol

Model Context Protocol Servers

88.1K

Redis MCP Server

redis

The official Redis MCP Server is a natural language interface designed for agentic applications to manage and search data in Redis efficiently

539

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

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.

广告合作