mysql-mcp-server

mysql-mcp-server

3.3

If you are the rightful owner of mysql-mcp-server and would like to certify it and/or have it hosted online, please leave a comment on the right or send an email to henry@mcphub.com.

An MCP server for interacting with MySQL databases, supporting read-only and test write queries.

The MySQL MCP Server is designed to facilitate interaction with MySQL databases through a Model Context Protocol (MCP) server. It allows users to execute read-only queries and test write queries that are rolled back, ensuring no permanent changes are made to the database. The server is implemented in TypeScript and utilizes the mysql2 package, running as a Docker container. It accepts JSON commands via standard input and returns JSON responses through standard output. The server is configured to connect to a MySQL database running on the host machine using 'host.docker.internal', which is compatible with both OrbStack and Docker Desktop. Security is managed through environment variables, and users are responsible for implementing SQL injection prevention measures.

Features

  • Supports read-only and test write queries
  • Implemented in TypeScript using mysql2 package
  • Runs as a Docker container
  • Uses JSON for command input and output
  • Connects to host MySQL using 'host.docker.internal'