Skip to content

PostgreSQL Data Extraction and Replication

Use Skippr as a Postgres-to-warehouse pipeline without maintaining custom replication code. Connect with host credentials, sync selected schemas, and let Skippr handle discovery, cleansing, and load.

Capabilities

  • Extraction from Postgres schemas, tables, and nominated relations
  • Deterministic schema discovery from PostgreSQL catalogs and samples
  • Incremental and full-refresh sync modes
  • Automatic data cleansing and dead letter handling
  • Load into 9 supported data warehouses

CLI

bash
skippr connect source postgres-source \
  --host localhost --port 5432 \
  --user myuser --password mypass \
  --database mydb \
  --tables public.customers,public.orders

Sample config

yaml
data_sources:
  source:
    Postgres:
      host: localhost
      port: 5432
      user: myuser
      password: mypass
      database: mydb

Full connector reference: postgres.