mysql-mcp
2
This project is a Model Context Protocol (MCP) server designed for interacting with MySQL and PostgreSQL databases in a read-only manner. It provides various tools for schema inspection, metadata retrieval, and execution of SQL queries, focusing on safety and extensibility.
Overview
This project provides a read-only Model Context Protocol (MCP) server for interacting with MySQL & PostgreSQL databases. It allows MCP-compatible clients to inspect database schemas, retrieve metadata, and execute read-only SQL queries. Key features include schema and metadata tools, query execution tools, visualization, and performance tools. The server emphasizes extensibility and read-only operations for safety.
Features & Implemented Tools
- Schema & Metadata Tools: Retrieve table columns, fetch schema details, get indexes and constraints, compare schemas, explain schema, detect schema changes, find relationships and navigation paths.
- Query Execution Tools: Execute read-only queries, batch queries, prepare and execute statements, explain queries, and query history (placeholder).
- Visualization Tools: Visualize schemas in various formats.
- Performance Tools: Retrieve performance metrics.