mysql-mcp

An MCP server that gives AI agents MySQL tools for CRUD, JSON, spatial, and document-store operations, plus a token-saving "Code Mode" that runs agent-written JavaScript in a sandboxed V8 isolate instead of chaining dozens of narrow tool calls.


About

mysql-mcp exposes MySQL databases to AI coding assistants over the Model Context Protocol, with specialized tools for CRUD, JSON, spatial, and MySQL Document Store operations, and resources for monitoring schema, performance, replication, and InnoDB diagnostics. Its “Code Mode” lets an agent write JavaScript that runs in a sandboxed V8 isolate against the available tools in one call, which the project reports as a large reduction in token usage compared to calling each tool individually.

It supports stdio and HTTP transports (including stateless HTTP and SSE), bearer-token or OAuth 2.1 authentication, per-client tool filtering, and Prometheus metrics. Beyond a local MySQL server, it documents connecting to MySQL on Docker and on cloud services such as AWS RDS, Google Cloud SQL, Azure Database for MySQL, PlanetScale, and DigitalOcean, as well as ecosystem components including InnoDB Cluster, Group Replication, MySQL Router, ProxySQL, and MySQL Shell. The project is MIT-licensed, requires Node.js 24+, and can be installed via npm/pnpm, run with npx, or used through Docker.

Category Software & Tools
Subcategory Database Management & GUI, AI & Ecosystem Skills
✎ Suggest an update

Community feedback

This space is for grounded, evaluable experience — versions used, environments, what you measured or observed, and how it behaves alongside other software. General impressions without supporting detail may be removed. Sign in to write one; posts are tied to a verified identity, not anonymous.