Mysql Schema Explorer Mcp
What is Mysql Schema Explorer Mcp
mysql-schema-explorer-mcp is a Model Context Protocol (MCP) server that provides schema information for MySQL databases, allowing LLM clients to easily retrieve database schema details.
Use cases
Use cases include generating a list of tables in a database, retrieving detailed schema information for specific tables, and integrating with LLM clients for enhanced data interaction.
How to use
To use mysql-schema-explorer-mcp, set the environment variables for database connection (DB_HOST, DB_PORT, DB_USER, DB_PASSWORD), then start the server with the command ‘go run main.go’.
Key features
Key features include retrieving a list of tables in a specified database and obtaining detailed information about specific tables, such as column definitions, key constraints, and indexes.
Where to use
mysql-schema-explorer-mcp can be used in various fields that require database management and schema exploration, such as software development, data analysis, and database administration.
Clients Supporting MCP
The following are the main client software that supports the Model Context Protocol. Click the link to visit the official website for more information.
Overview
What is Mysql Schema Explorer Mcp
mysql-schema-explorer-mcp is a Model Context Protocol (MCP) server that provides schema information for MySQL databases, allowing LLM clients to easily retrieve database schema details.
Use cases
Use cases include generating a list of tables in a database, retrieving detailed schema information for specific tables, and integrating with LLM clients for enhanced data interaction.
How to use
To use mysql-schema-explorer-mcp, set the environment variables for database connection (DB_HOST, DB_PORT, DB_USER, DB_PASSWORD), then start the server with the command ‘go run main.go’.
Key features
Key features include retrieving a list of tables in a specified database and obtaining detailed information about specific tables, such as column definitions, key constraints, and indexes.
Where to use
mysql-schema-explorer-mcp can be used in various fields that require database management and schema exploration, such as software development, data analysis, and database administration.
Clients Supporting MCP
The following are the main client software that supports the Model Context Protocol. Click the link to visit the official website for more information.
Content
MySQL Schema MCP Server
This is a Model Context Protocol (MCP) server that provides compressed schema information for MySQL databases.
This MCP server is useful when the schema dump file does not fit in the context size because you are using a large database schema.
https://github.com/user-attachments/assets/0cecef84-cd70-4f84-95cb-01c6ec7c9ac7
Provided Tools
- List Tables (
list_tables)- Lists all table information in the specified database. Includes table name, comment, primary key, unique key, and foreign key information.
- Parameters
dbName: The name of the database to retrieve information from (not required when DB_NAME environment variable is set)
- Describe Tables (
describe_tables)- Displays detailed information for specific tables in the specified database. Provides formatted information such as column definitions, key constraints, and indexes.
- Parameters
dbName: The name of the database to retrieve information from (not required when DB_NAME environment variable is set)tableNames: An array of table names to retrieve detailed information for
Quick Start
-
Install the command
go install github.com/shibayu36/mysql-schema-explorer-mcp@latest -
Configure mcp.json
-
Execute SQL generation using the agent
Example: Using the structure of the ecshop database, list the names of the 3 most recently ordered products by the user shibayu36.
Usage
Fixing to a Specific Database
When accessing only one database, you can set the DB_NAME environment variable to avoid specifying the database name each time.
Dev Tools Supporting MCP
The following are the main code editors that support the Model Context Protocol. Click the link to visit the official website for more information.
