MySQL MCP Server

# MySQL Database Configurations (JSON format) # Each database can have its own host, user, password, and database # The first database in the array is considered the default MYSQL_DATABASES='[ { "name": "primary_db", "host": "localhost", "user": "primary_user", "password": "primary_password", "database": "primary_database" }, { "name": "analytics_db", "host": "analytics.example.com", "user": "analytics_user", "password": "analytics_password", "database": "analytics" }, { "name": "legacy_db", "host": "legacy.example.com", "user": "legacy_user", "password": "legacy_password", "database": "legacy_system" } ]' # Connection Pool Settings MYSQL_CONNECTION_LIMIT=4 MYSQL_WAIT_FOR_CONNECTIONS=true # SQL Command Security Settings # Options: # (default) - Safe read-only commands: SELECT, SHOW, DESCRIBE, DESC, EXPLAIN, ANALYZE # extended - Includes schema and data modification: CREATE, ALTER, DROP, INSERT, UPDATE, DELETE # all - All SQL commands allowed (USE WITH EXTREME CAUTION!) # custom - Comma-separated list: "SELECT,INSERT,UPDATE,CREATE TABLE" # MYSQL_ALLOWED_COMMANDS=extended # Connection Pool Settings MYSQL_CONNECTION_LIMIT=4 MYSQL_WAIT_FOR_CONNECTIONS=true # MCP Server Settings MCP_SERVER_NAME=mysql-mcp-server MCP_SERVER_VERSION=1.0.0