About
MySQL empowers interaction with MySQL databases by implementing a Model Context Protocol (MCP) server. This allows execution of SQL queries (SELECT, SHOW, EXPLAIN, DESCRIBE), retrieval of table schemas, listing of database tables, and fetching data from specified tables, all through the MCP interface.
Key Features
- Lists all tables in a database.
- Executes SQL queries (SELECT, SHOW, EXPLAIN, DESCRIBE).
- Uses environment variables for MySQL connection configuration.
- Retrieves table schemas.
- 2 GitHub stars
- Fetches data from specified tables (up to 100 rows).
Use Cases
- Providing a read-only interface to a MySQL database.
- Automating database querying and schema inspection tasks.
- Integrating MySQL data into MCP-based applications.
