MySQL MCP Server

MCPOpen SourceMIT32.0

by xiangma9712 • Data & Databases

A lightweight MCP server for interacting with MySQL databases, supporting read-only queries, schema inspection, and safe test execution of write queries.

Example Use Cases

1
Run read-only SQL queries against a MySQL instance and receive structured JSON results.
2
Validate or test the effect of update/insert/delete SQL statements without persisting changes (execution rolled back).
3
Discover database structure by listing tables and describing table schemas programmatically.

Description

This MCP server runs in a Docker container and connects to a MySQL instance using environment variables. It accepts JSON commands on stdin and returns JSON responses on stdout, supporting read-only queries, listing tables, and describing table schemas. It also supports executing write queries in a way that is rolled back for testing purposes. Implemented in TypeScript using the mysql2 package, it is convenient for automated agents and tooling that need programmatic database access.

Quick Actions

View on GitHub

Security

Scanned 3 month(s) ago

Risk Level

MINIMAL

Read-only data retrieval, no side effects

Trust Score

C51/100

9/17 checks passed

Scores are informational only and provided “as is” without warranty. AgentHotspot assumes no liability for actions taken based on these ratings.

Quick Stats

Service TypeMCP

Pricing ModelFree

Capabilities0 Tools / 0 Prompts / 0 Resources

Ownerxiangma9712

CategoryData & Databases

DependenciesStandalone