mcp-server-mysql

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

FAQ from mcp-server-mysql

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.

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.

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.

What connection URL format does it expect?

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

Is there a known limitation?

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