MySQL Schema Explorer
Provides compressed MySQL database schema information via a Model Context Protocol (MCP) server.
About
MySQL Schema Explorer is an MCP server designed to efficiently deliver compressed schema information for MySQL databases, especially when dealing with large schemas that exceed typical context size limits. It offers functionalities to list table information, including names, comments, primary keys, unique keys, and foreign keys, as well as provide detailed descriptions of specific tables, covering column definitions, key constraints, and indexes. This allows you to explore and understand your database structure more effectively.
Key Features
- Provides detailed descriptions of tables, including column definitions and indexes.
- 15 GitHub stars
- Uses Model Context Protocol (MCP) for efficient schema delivery.
- Lists table information including names, comments, and key constraints.
- Supports retrieval of schema information for large databases.
Use Cases
- Integrating schema information into automated database management workflows.
- Analyzing and understanding complex MySQL database schemas.
- Generating SQL queries based on database schema structure.