# PostgreSQL MCP Server Configuration
#
# NOTE: This file is for local development/testing.
# For Claude Desktop/Cursor, configure env vars in your MCP client config instead.
# See .mcp.json.example for client configuration.
# Connection Settings
PG_HOST=localhost
PG_PORT=5432
PG_USER=your_postgres_user
PG_PASSWORD=your_postgres_password
PG_DATABASE=your_database_name
PG_SCHEMA=public
# SSL Configuration (Full)
# Modes: disable, require, verify-ca, verify-full
PG_SSL_MODE=disable
PG_SSL_REJECT_UNAUTHORIZED=true
PG_SSL_CA_PATH=/path/to/ca-certificate.crt
PG_SSL_CERT_PATH=/path/to/client-certificate.crt
PG_SSL_KEY_PATH=/path/to/client-key.pem
PG_SSL_MIN_VERSION=TLSv1.2
# Security Settings
ALLOW_WRITE_OPERATIONS=false
# Performance Settings
CONNECTION_LIMIT=10
QUERY_TIMEOUT=30000
MAX_RESULTS=1000
# Rate Limiting
RATE_LIMIT_PER_MINUTE=60
RATE_LIMIT_PER_HOUR=1000
RATE_LIMIT_CONCURRENT=10
# Debug Mode
MCP_DEBUG=false
