MySQL MCP Server

Example Use Cases

• 1

  Inspect database schemas, table definitions, indexes and foreign keys to generate correct SQL or understand data structure.

• 2

  Run read-only analytical queries against MySQL databases and receive paginated, streamed or cached results with query timeouts.

• 3

  Controlled write access (INSERT/UPDATE/DELETE/DDL) with schema-specific permissions and transactional safety when such operations are explicitly enabled.

Description

This Node.js-based MCP server lets LLM agents inspect database schemas, run read queries by default, and optionally perform controlled write and DDL operations when enabled. It supports multi-db mode, schema-specific permissions, prepared statements, connection pooling, caching, query timeouts, and comprehensive logging/metrics. The server is easily configurable via environment variables and integrates with tools like Smithery, Cursor, Claude Desktop, and MCP Get for streamlined installation and setup.