PostgreSQL MCP AllAccess

# PostgreSQL MCP Server Configuration Example # Copy this file to postgres_config.ini and update with your settings # Connection pool settings (for global pool) [connection] max_connections = 15 min_connections = 2 pool_timeout_seconds = 30 idle_timeout_seconds = 300 # Query timeout and other defaults [defaults] # Increased from 30s to 900s (15 minutes) for long-running queries timeout_seconds = 900 # Option 1: Direct PostgreSQL connection (for local/development) [postgresql] host = localhost port = 5432 database = your_database_name user = your_username password = your_password # Optional connection parameters # connect_timeout = 10 # options = -c search_path=public # sslmode = prefer # Option 2: AWS Secrets Manager (for production) # Uncomment and configure if using AWS Secrets Manager for credentials [aws] # AWS Secrets Manager configuration for dynamic password fetching # secret_name = postgres/prod/db_credentials # region = us-west-2 # password_secret_name = rds!db-xxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx # Cache configuration # Time in seconds to cache the password (default: 3600 = 1 hour) # cache_ttl_seconds = 3600 # Advanced options [advanced] # SSL mode for connection (prefer, require, disable) sslmode = prefer # Connection timeout in seconds connect_timeout = 10 # Application name for connection identification application_name = yt_postgres_mcp # Maximum number of retries for authentication failures max_auth_retries = 3