Mysql icon

Mysql

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.

주요 기능

  • 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

사용 사례

  • Testing SQL queries before implementation
  • Retrieving data from a MySQL database within an MCP environment
  • Inspecting database schema programmatically
Craft Better Prompts with AnyPrompt
Sponsored
MySQL MCP Server: Secure Database Query Tool