LightningSyncLightningSync

Feature

Automatic tables and schema.

LightningSync creates the tables and keeps schema aligned with each integration.

LightningSync creates and updates Supabase tables for you.

Start syncing freeView integrations

Automatic table creation

Missing tables are detected and created during setup.

Schema evolution

Schema updates are handled so your data stays consistent.

Normalized columns

Typed columns make SQL queries and joins predictable.

Preview

Tables created automatically

LightningSync creates and updates tables so your schema stays consistent.

Tables created

facebook_ads_dailycreated
facebook_campaignscreated
ig_insights_dailyexists

Schema preview

columntype
ad_idtext
spendnumeric
impressionsinteger
datedate

How it works

1

Connect Supabase

Connect Supabase via official OAuth so LightningSync can create tables automatically.

2

We check tables

LightningSync verifies existing tables and creates any missing ones.

3

Sync with upserts

Data lands in normalized tables with idempotent upserts.

Use cases

  • Launch fast without manual schema work.
  • Keep dashboards stable as API schemas evolve.
  • Onboard new data sources with confidence.

FAQ

Where are tables created?

Tables are created in your Supabase public schema by default.

Can I inspect or modify the schema?

Yes. The tables are standard Postgres tables.

Ready to start syncing?

Connect your first data source and see your tables populate.

Start syncing freeView all features