MySQL MCP Server

# MySQL Connection MYSQL_HOST=localhost MYSQL_PORT=3306 MYSQL_USER=root MYSQL_PASSWORD=your_password_here MYSQL_DATABASE=your_database # Connection Pool MYSQL_POOL_SIZE=10 MYSQL_POOL_TIMEOUT=10000 # MySQL Router REST API (optional - for router tools) # For InnoDB Cluster mode (metadata_cache auth): # - The user must exist in the MySQL cluster # - Cluster must be running for authentication to work # - Uses HTTPS with self-signed certificates by default MYSQL_ROUTER_URL=https://localhost:8443 MYSQL_ROUTER_USER=rest_api MYSQL_ROUTER_PASSWORD=your_router_password MYSQL_ROUTER_INSECURE=true # ProxySQL Admin Interface (optional - for proxysql tools) PROXYSQL_HOST=localhost PROXYSQL_PORT=6032 PROXYSQL_USER=radmin PROXYSQL_PASSWORD=radmin # MySQL Shell (optional - for mysqlsh tools) # Path to mysqlsh executable MYSQLSH_PATH=C:\Program Files\MySQL\MySQL Shell 9.5\bin\mysqlsh.exe # X Protocol port for mysqlsh_import_json (default: 33060, use 6448 with MySQL Router) # MYSQL_XPORT=33060 # OAuth 2.0 Authentication (optional - for enterprise deployments) # See https://github.com/neverinfamous/mysql-mcp/wiki/OAuth for setup guide OAUTH_ENABLED=false OAUTH_ISSUER=http://localhost:8080/realms/mysql-mcp OAUTH_AUDIENCE=mysql-mcp # OAUTH_JWKS_URI= # Optional: auto-discovered from issuer # OAUTH_CLOCK_TOLERANCE=60 # Optional: clock drift tolerance in seconds # Server MYSQLMCP_PORT=3001