.env.example

# PostgreSQL Connection Configuration
# These environment variables are automatically used by pgschema commands
# when the corresponding CLI flags are not provided

# Target Database Connection (for plan and apply commands)
# Database server host (default: localhost)
PGHOST=localhost

# Database server port (default: 5432)
PGPORT=5432

# Database name
PGDATABASE=your_database_name

# Database user name
PGUSER=your_username

# Database password
PGPASSWORD=your_password_here

# Application name for database connection (default: pgschema)
# This appears in pg_stat_activity and can help identify connections
PGAPPNAME=pgschema

# Plan Database Connection (optional - for using external database instead of embedded postgres)
# If PGSCHEMA_PLAN_HOST is provided, the plan command will use an external database
# to validate the desired state instead of spinning up an embedded PostgreSQL instance.
# This is useful for environments where embedded postgres has limitations.

# Plan database host (if not provided, uses embedded postgres)
#PGSCHEMA_PLAN_HOST=localhost

# Plan database port (default: 5432)
#PGSCHEMA_PLAN_PORT=5432

# Plan database name (required if PGSCHEMA_PLAN_HOST is set)
#PGSCHEMA_PLAN_DB=pgschema_plan

# Plan database user (required if PGSCHEMA_PLAN_HOST is set)
#PGSCHEMA_PLAN_USER=postgres

# Plan database password
#PGSCHEMA_PLAN_PASSWORD=your_plan_db_password