Schema changes handled
New tables, columns, and schema changes are discovered automatically, so your sync keeps up with PlanetScale Postgres without manual remapping.
PlanetScale Postgres
Polytomic connects PlanetScale Postgres to your data warehouse, databases, and SaaS tools for ETL and reverse ETL, without writing code. Replicate tables with log based change data capture, or write data back into PlanetScale Postgres for your application to use.
Failover safe replication
The replication slot Polytomic manages keeps streaming through a PlanetScale primary failover, instead of needing a resync.
No primary key needed
Tables without a primary key still sync incrementally, tracked by internal transaction order instead of a tracking column.
Example workflows
Replicate PlanetScale tables into your data warehouse for analytics
What you can sync
Move data between PlanetScale Postgres and your data warehouse, databases, and SaaS tools, in both directions.
From PlanetScale Postgres
Tables and views in your database
Change data capture through logical replication
Incremental reads with or without a primary key
Every schema you grant access to
To PlanetScale Postgres
Tables you create, or your own existing tables
Create, update, create or update, and replace
Upsert matched on a primary key or unique index
Columns added automatically as fields change
How it works
Polytomic connects to PlanetScale Postgres over the standard Postgres wire protocol. It discovers your tables and views automatically. Turning on logical replication streams inserts, updates, and deletes continuously, instead of rereading full tables on every run.
A replication slot that Polytomic manages keeps streaming through a PlanetScale primary failover. Tables without a primary key still sync incrementally, tracked by internal transaction order rather than a tracking column.
- Tables and views discovered automatically across your database
- Turn on logical replication for continuous change capture
- Replication slot keeps streaming through a PlanetScale failover
- Tables without a primary key sync incrementally by transaction order
- Create, update, upsert, or replace tables as a destination
- Monitor sync health and failures from one interface
How to set up
Connect to PlanetScale Postgres with a hostname, database name, and the credentials for a Postgres user. SSL is on by default, with the certificate chain and hostname verified against trusted roots.
How to get connected
- 1In PlanetScale, create the Postgres credential that the connection form requires
- 2In Polytomic, go to Connections, click Add connection, and select PlanetScale Postgres
- 3Enter the hostname, database, credential, and SSL settings, then click Save
Frequently asked questions
Why teams choose Polytomic
No engineering required
Set up and manage syncs without writing code.
Flexible data modeling
Use SQL to define exactly what data gets synced.
Handles scale automatically
Supports large datasets with incremental syncs and bulk APIs.
Start syncing your data with PlanetScale Postgres in minutes
No credit card required. Free trial available.