.env.example

# 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