mysql-schema-explorer-mcp

mysql-schema-explorer-mcp

15
databases

The MySQL Schema MCP Server is designed to provide compressed schema details for MySQL databases, facilitating operations with large schema dumps. It includes tools for listing and describing table information.

MySQL Schema MCP Server

This is a Model Context Protocol (MCP) server that provides compressed schema information for MySQL databases. It helps when the schema dump file does not fit in the context size due to large database schema size.

Provided Tools

  • List Tables: Lists all table information such as table name, comment, primary key, unique key, and foreign key information.
  • Describe Tables: Displays detailed information including column definitions, key constraints, and indexes for specific tables.

Quick Start

  1. Install the command.
  2. Configure mcp.json with database details.
  3. Execute SQL generation using the agent.