FastPostgresMCP

# REQUIRED: Comma-separated list of unique DB aliases DB_ALIASES=main,reporting # REQUIRED: Default alias if 'dbAlias' is omitted in tool calls DEFAULT_DB_ALIAS=main # OPTIONAL: Enable API Key auth (primarily for network transports) ENABLE_AUTH=false MCP_API_KEY=your_super_secret_api_key_here # Define DB connection details for each alias (DB_MAIN_*, DB_REPORTING_*, etc.) # Example: DB_MAIN_HOST=localhost DB_MAIN_PORT=5432 DB_MAIN_NAME=app_prod_db DB_MAIN_USER=app_user # Needs permissions on information_schema DB_MAIN_PASSWORD=app_secret_password DB_MAIN_SSL=disable # Recommend 'require' or stricter for prod # Alternative: Use connection URLs # DB_MAIN_URL=postgres://user:password@localhost:5432/database?sslmode=require # Second database example DB_REPORTING_HOST=reporting-db.read-replica.internal DB_REPORTING_PORT=5432 DB_REPORTING_NAME=analytics DB_REPORTING_USER=readonly_reporter DB_REPORTING_PASSWORD=readonly_password DB_REPORTING_SSL=require # --- Optional: Server Logging Level --- # LOG_LEVEL=info # debug, info, warn, error (defaults to info)