mysql-schema-explorer-mcp
If you are the rightful owner of mysql-schema-explorer-mcp and would like to certify it and/or have it hosted online, please leave a comment on the right or send an email to henry@mcphub.com.
This is a Model Context Protocol (MCP) server that provides compressed schema information for MySQL databases.
The MySQL Schema MCP Server is designed to efficiently handle large database schemas by providing compressed schema information. This is particularly useful when the schema dump file exceeds the context size limitations due to the large size of the database schema. The server offers tools to list and describe tables within a specified database, making it easier to manage and understand complex database structures. By leveraging the Model Context Protocol, this server ensures that users can access detailed schema information without overwhelming their system's resources.
Features
- Efficiently handles large database schemas by providing compressed schema information.
- Lists all table information in the specified database, including table name, comment, primary key, unique key, and foreign key information.
- Displays detailed information for specific tables, including column definitions, key constraints, and indexes.
- Supports parameterized queries to retrieve specific schema details.
- Integrates with existing systems using the Model Context Protocol.
Tools
List Tables
Lists all table information in the specified database. Includes table name, comment, primary key, unique key, and foreign key information.
Describe Tables
Displays detailed information for specific tables in the specified database. Provides formatted information such as column definitions, key constraints, and indexes.
