mysql-mcp-server

mysql-mcp-server

5
databases

The MySQL MCP Server is designed to facilitate interaction with MySQL databases through a Docker-based MCP server. It supports executing various SQL commands through JSON inputs, catering to developers needing database query capabilities.

MySQL MCP Server

An MCP server for interacting with MySQL databases.

Features

  • Supports executing read-only queries and write queries that are rolled back
  • Implemented in TypeScript, using the mysql2 package
  • Runs as a Docker container and accepts JSON commands

Usage

  1. Starting the Server: Use Docker to run the server with predefined environment variables.
  2. Available Commands: Execute read-only queries, test query execution, list tables, and describe tables.

Security Considerations

  • Uses environment variables for managing sensitive information.
  • SQL injection prevention and proper network configuration are essential.