v1.1.0

Highlights

• add multi-org support with one Postgres schema per registered Salesforce org
• add org switching and org registry flows in the UI
• scope API, sync, DDL, and scheduler behavior by org id
• add runtime migration for existing single-org databases
• add startup repair for migrated object tables missing primary keys
• harden local connection details handling and first-run setup docs

Notes

• this release introduces per-org schemas named org_<orgid>
• local users should run npm run export-tokens before first start so Docker can access Salesforce tokens
• version bumped to 1.1.0

v1.0.0 — Initial release

First public release of sfetch.

What it does

Self-hosted Salesforce-to-PostgreSQL sync pipeline. Run docker compose up, configure which objects and fields to sync from the web UI, and connect any BI tool or SQL client directly to Postgres.

Features

• Web UI for configuring sync — no config files to edit
• Delta sync (hourly by default) + full ID reconciliation (nightly)
• Soft deletes: sf_deleted_at set on records deleted in Salesforce
• Salesforce Bulk API 2.0 for large volumes; REST fallback for small objects
• Auth via ~/.sfdx files — no SF credentials stored in the project
• Read-only Postgres role for BI tools
• Sync logs with per-object record counts and errors

Getting started

See the README and first-run guide.