Skip to main content
The most powerful way to feed the Organization Brain is by syncing your operational data. For internal tools (e.g., Metabase replicas, customer record databases) backed by relational databases like PostgreSQL, Corgtex can automatically ingest and update knowledge over time.

​
Setting up a PostgreSQL sync

Follow these steps to connect a read-only PostgreSQL instance.
1

Provision a Read-Only User

Provide explicit instructions to your DevOps team to generate a read-only Postgres user pointing to a securely accessible IP or Bastion host.
CREATE USER corgtex_readonly WITH PASSWORD 'SecurePass!';
GRANT CONNECT ON DATABASE production TO corgtex_readonly;
GRANT USAGE ON SCHEMA public TO corgtex_readonly;
GRANT SELECT ON ALL TABLES IN SCHEMA public TO corgtex_readonly;
2

Create the Data Source

  1. Navigate to Workspace Settings → Data Sources.
  2. Click New Database.
  3. Input the connection string (postgres://...) provided by your database administrator.
3

Configure Sync Preferences

  • Select the standard public tables you wish to index.
  • Set the sync cadence (e.g., every 60 minutes, daily, etc.).
4

Sync and Verify

Click Sync Now to schedule the first ingestion job. Keep an eye on the Dashboard UI—you should see chunk counts incrementing securely under byodb:XXX references.

​
How external syncs work

During a sync event, the background worker fetches the selected rows, serializes them into text representations, and runs them through the same ingestion pipeline as static files (Chunking → PII Classification → Embedding). Because this happens incrementally on a schedule, your agents always have access to near real-time operational data without needing to query your production database live.