env.example

# PostgreSQL MCP Server Configuration
# Copy this file to .env and fill in your values

# ============================================================================
# Database Configuration
# ============================================================================
# Option 1: Use individual connection parameters
DB_USER_NAME=your_db_user
DB_PASSWORD=your_db_password
DB_HOST=localhost
DB_PORT=5432
DB_NAME=your_database

# Option 2: Use a full connection string (takes precedence over individual params)
# POSTGRES_CONNECTION_STRING=postgresql://user:password@host:port/database

# Option 3: DATABASE_URL (common in cloud platforms like Railway, Heroku)
# DATABASE_URL=postgresql://user:password@host:port/database

# ============================================================================
# Server Configuration
# ============================================================================
# MCP Server Host and Port (default: 0.0.0.0:8000)
MCP_SERVER_HOST=0.0.0.0
MCP_SERVER_PORT=8000