广告合作
MCP.so
登录

MCP Server Mysql

@yuru-sha

代码仓库

基本信息

分类

数据库

许可证

MIT

传输方式

stdio

作者

yuru-sha

关于 MCP Server Mysql

MCP Server for MySQL databases

MCP Server Mysql 配置

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

{
  "mcpServers": {
    "mcp-server-mysql-yuru-sha": {
      "command": "docker",
      "args": [
        "run",
        "-i",
        "--rm",
        "mcp/mysql",
        "mysql://host:port/dbname"
      ]
    }
  }
}

MCP Server Mysql 工具

工具列表暂未提供

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

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

概览

What is mcp-server-mysql?

Model Context Protocol Server for MySQL databases. It enables LLMs to inspect database schemas and execute read-only queries in a safe, read‑only transaction.

How to use mcp-server-mysql?

Install via Docker (build the image then run with a connection URL) or via the Smithery CLI. Configure the server in Claude Desktop by adding a “mysql” entry to claude_desktop_config.json that points to a Docker run command with the mysql://host:port/dbname connection string.

Key features of mcp-server-mysql

  • Read-only access to MySQL databases
  • Schema inspection for LLM‑driven analysis
  • All queries executed inside READ ONLY transactions
  • Docker image available for easy deployment
  • Published as an npm package

Use cases of mcp-server-mysql

  • Allow an LLM to examine table structures and relationships
  • Let an LLM answer questions about database content with safe, read‑only queries
  • Provide live schema details to AI agents during data exploration

常见问题

1

What does mcp-server-mysql do?

It acts as a bridge between LLMs and a MySQL database, allowing schema inspection and read‑only query execution while enforcing READ ONLY transactions.

2

What are the runtime requirements?

You can run it via Docker (using the built image) or install it as an npm package. The README does not specify a minimum Node.js version.

3

How is data protected?

All queries are wrapped in READ ONLY transactions, preventing any writes to the database. For extra security, creating a dedicated read‑only database user is recommended.

4

What connection URL format does it expect?

The server accepts a connection string in the form `mysql://[user][:password]@host[:port]/database`.

5

Is there a known limitation?

The server intentionally restricts all operations to read‑only; no insert, update, or delete actions are permitted.

评论

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

Neon MCP Server

neondatabase

MCP server for interacting with Neon Management API and databases

617

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

modelcontextprotocol

Model Context Protocol Servers

88.1K

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.

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

广告合作