Provides an MCP server for interacting with MySQL databases using read-only and test-execute queries.
This tool spins up an MCP server that facilitates interaction with MySQL databases. It allows for executing read-only SQL queries and performing test executions of write queries, which are subsequently rolled back. The server operates within a Docker container, accepts JSON commands via standard input, and returns JSON responses via standard output. Connection to the host MySQL server is achieved using `host.docker.internal`, ensuring compatibility with both OrbStack and Docker Desktop.
Key Features
01Performs test executions of write queries with rollback
02Runs as a Docker container
03Lists tables in the database
04Executes read-only SQL queries
05Describes table schema
Use Cases
01Testing SQL queries before implementation
02Retrieving data from a MySQL database within an MCP environment
