Mysql

About

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

• Performs test executions of write queries with rollback
• Runs as a Docker container
• Lists tables in the database
• Executes read-only SQL queries
• Describes table schema

Use Cases

• Testing SQL queries before implementation
• Retrieving data from a MySQL database within an MCP environment
• Inspecting database schema programmatically