sqliac-postgres

PostgreSQL adapter for SQLIaC — a Terraform alternative for SQL databases that uses no state file.

This package provides the PostgreSQL database connector and credential handling so SQLIaC can query Postgres's live state and execute DDL to reconcile your declared resource definitions.

Installation

pip install sqliac-postgres

This also installs sqliac (the CLI and core engine) and pg8000 (a pure-Python PostgreSQL driver).

Quick Start

Credentials

SQLIaC looks for Postgres credentials in two places, in order of precedence:

1. Environment variables (recommended)

export POSTGRES_HOST="localhost"
export POSTGRES_USER="my_user"
export POSTGRES_PASSWORD="my_password"
export POSTGRES_DATABASE="my_db"
# Optional:
export POSTGRES_PORT="5432"
export POSTGRES_SSLMODE="require"

2. Configuration file .sqliac/provider/credentials.toml

[postgres]
host = "localhost"
user = "my_user"
password = "my_password"
database = "my_db"

Environment variables take precedence. Run sqliac init to scaffold this file.

Using SQLIaC with Postgres

# Scaffold a project
sqliac init

# Configure your credentials and edit definitions/
# then preview and apply:

sqliac apply --dry-run
sqliac apply

Provider config

The adapter is registered via the sqliac.adapters entry point group. Your .sqliac/provider/config.toml should start with a top-level [postgres] section:

[postgres.schema.ddl_command]
create = "CREATE"
alter  = "ALTER"
drop   = "DROP"

[postgres.schema.ddl_context]
object_name = "analytics"
owner = "analytics_owner"
wait_time = 0

[postgres.schema.ddl_context.depends_on]

API

The adapter exposes three classes, all available from the top-level package:

from sqliac_postgres import PostgresAdapter, PostgresCredentials, PostgresConnectionManager

All three are registered via the entry point sqliac.adapters / postgres and resolved automatically by the SQLIaC CLI. You don't need to import them directly unless building custom tooling.

Supported credential fields

License

MIT — see the sqliac package for details.