Advertise
MCP.so
Sign In

MCP Server Mysql

@yuru-sha

Repository

Basic information

Category

Databases

License

MIT

Transports

stdio

Author

yuru-sha

About MCP Server Mysql

MCP Server for MySQL databases

MCP Server Mysql config

Add this server to your MCP-compatible client using the configuration below.

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

MCP Server Mysql tools

Tool list not available yet

This listing does not currently have a tool list to display. This does not mean the server has no tools; check its documentation for supported capabilities.

We auto-extract tools from the README. The maintainer can list them under a ## Tools heading to populate this section.

Overview

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

Frequently asked questions

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.

Comments

More Databases MCP servers

Sqlite

modelcontextprotocol

Model Context Protocol Servers

88.1K

Elasticsearch MCP Server

elastic

685

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

ClickHouse MCP Server

ClickHouse

Connect ClickHouse to your AI assistants.

818

MySQL MCP Server

designcomputer

A Model Context Protocol (MCP) server that enables secure interaction with MySQL databases

1.3K
Advertise