kimo
Open demo
DatabasesPopular

PostgreSQL + Kimo

Read-only replication of your Postgres tables every 15 minutes. Join users, orders and events with every other source.

Auth
Read-only credentials
Sync
Every 15 min
Setup
≈ 10 min
Request access

Live demo workspace with fictional data · no signup, no credentials needed

kimo / connectors / postgresSyncing
Sync logevery 15 min
  • Succeeded:public.orders+61 rowsnow
  • Succeeded:public.events+842 rows2m ago
  • Succeeded:public.subscriptions+1,623 rows4m ago
  • Succeeded:public.users+2,404 rows6m ago
Rows synced · 30 days
114.3M
Workspaces
43%
Simulated demo data
What you can do

What teams build with PostgreSQL

PostgreSQL on its own answers half the question. Joined with the rest of your stack in Kimo, it answers the other half.

01

Activation from your own tables

Define “activated” once in SQL or the visual modeler, then reuse it everywhere.

Certified metric
02

Join users to revenue

Link public.users to Stripe customers and HubSpot contacts through email or external ids.

users ⋈ stripe
03

Feature adoption

Track which features new accounts adopt in their first week, by plan and acquisition channel.

Week-1 adoption
04

Ask your database

“Which plans had the most upgrades last month?” Kimo writes the SQL and shows its work.

Ask Kimo
Objects & tables

Exactly what gets synced

Kimo maps PostgreSQL into clean, typed tables with primary keys and incremental cursors, so syncs stay fast and joins just work.

4 tables · 20 fields

public.users

Incremental (CDC)≈ 29,100 rows
FieldTypeNotes
ididPrimary key
emailstring
planenumLow-cardinality dimension
created_attimestampIncremental cursor
utm_sourceenumLow-cardinality dimension
Custom fields and extra objects are discovered automatically on each sync. Row counts are illustrative.
Sample model

From raw PostgreSQL tables to a certified metric

This model ships with the Business Intelligence demo. Open it to see every join and measure.

Recurring revenue

MRR, new customers, expansion and churn from Stripe + product DB.

In the demo
  • Stripe
    subscriptions
  • PostgreSQL
    accounts
  • HubSpot
    deals
Model
customer_id = stripe_id
Measuresmrrnew_customerschurned
MRR · last 30 days
$4.9K-1.7% wk/wk

Fictional data · hover the chart for daily values

Setup

Connect PostgreSQL in 10 min

No engineers, no pipelines to maintain. Kimo asks for the minimum access it needs and tells you exactly what it will read.

  1. 1

    Create a read-only user

    Grant SELECT only. Kimo never writes to your database.

  2. 2

    Open network access

    Allow Kimo’s static egress IPs, use an SSH tunnel, or run the on-prem agent inside your network.

  3. 3

    Enter connection details

    Credentials are encrypted at rest with a per-workspace key and tested before saving.

  4. 4

    Select tables

    Choose what to sync, starting with public.users. Kimo backfills, then keeps it fresh.

Create a read-only user
CREATE USER kimo_reader WITH PASSWORD '<generated>';
GRANT USAGE ON SCHEMA public TO kimo_reader;
GRANT SELECT ON ALL TABLES IN SCHEMA public TO kimo_reader;
ALTER DEFAULT PRIVILEGES IN SCHEMA public
  GRANT SELECT ON TABLES TO kimo_reader;

Read-only, encrypted, revocable. Credentials are encrypted with a per-workspace key, never logged, and can be rotated without breaking your models.

Connect PostgreSQL
Step 2 of 3 · Kimo demo workspace
  • Reaching host
  • Authenticating
  • Reading schema
Read-only access
Illustration only · placeholder values, never real secrets
FAQ

PostgreSQL questions, answered

By default Kimo syncs PostgreSQL every 15 min. You can change the schedule per table, or trigger a sync manually from the connector page.

PostgreSQL · Read-only credentials · Every 15 min

See your PostgreSQL data in Kimo in 10 min.

Try it on the live demo workspace first, then connect your own account when you are ready.

Request access