MySQL MCP Server

Example Use Cases

• 1

  Inspect database schemas, columns, indexes, and foreign key relationships before generating queries.

• 2

  Execute read-only SQL queries against a MySQL instance with injection protection and query timeouts.

• 3

  Integrate database introspection and safe query execution into LLM workflows (e.g., Claude Desktop integration).

Description

This MCP server exposes MySQL database metadata and provides a tool to run read-only SQL queries (with prepared statements and read-only transactions). It automatically discovers table schemas, indexes, foreign keys, and provides query execution statistics, caching, and performance options. Security features include prepared statements to prevent SQL injection, rate limiting, query whitelisting/blacklisting, and optional SSL/TLS. It is intended to integrate with LLM applications (e.g., Claude) to let agents reason about and query databases safely.

Capabilities(1 total)