MySQL MCP Server

Example Use Cases

• 1

  Inspect database schemas, table definitions, indexes, and foreign key relationships to understand a MySQL database before generating queries.

• 2

  Run read-only or tightly controlled write SQL queries against local or remote MySQL instances (via SSH tunnels) with transaction handling, timeouts, and rate limiting.

• 3

  Multi-database access, schema-specific permission control, and remote MCP hosting to allow LLMs to query different databases securely from within agent workflows.

Description

This project provides a Model Context Protocol (MCP) server that allows LLM agents to inspect MySQL schemas and execute SQL queries securely, with built‑in SSH tunnel support. It is optimized for integration with Claude Code and supports local, remote, and multi-database modes, plus automatic tunnel lifecycle hooks. By default it enforces read-only transactions and includes configurable flags for INSERT/UPDATE/DELETE/DDL, rate limiting, logging, and query timeouts to reduce risk. Additional features include connection pooling, caching, schema-specific permissions, and monitoring hooks.

Capabilities(1 total)