Live CDC replication

Migrate Couchbase to
PostgreSQL

Migrate Couchbase to PostgreSQL with live CDC replication, automatic schema mapping, and zero downtime. Production-ready in minutes, not weeks.

Start migrating free →Read the docs

Real Bucket & Scope Hierarchy

Couchbase has real buckets, scopes, and collections. NoSQLSync lists your actual buckets and collections (including non-default scopes) instead of a placeholder.

No guesswork

Schema Discovery

Documents within a collection can carry different fields. NoSQLSync samples documents via N1QL to build a complete schema covering every observed field.

Union schema

Type Coercion Engine

Couchbase JSON types map cleanly to SQL: string → TEXT, number → INTEGER/DOUBLE, boolean → BOOLEAN, array/object → JSONB.

Auto type mapping

Offset-Paginated Bulk Load

Full-collection scans page through N1QL LIMIT/OFFSET, creating a primary index automatically if one doesn't already exist — the same 'ensure what's needed' approach used for SQL targets.

Auto-indexing

One-time Migration Only

Couchbase's native change protocol (DCP) isn't exposed by the official Node SDK at all — Couchbase's own docs point teams at a Kafka connector instead. Rather than build an unverified low-level DCP client, live sync isn't offered for this source yet.

Honest scope, no dual-write
How it works

Three steps to PostgreSQL

1
Connect your Couchbase
Paste your Couchbase connection string. NoSQLSync detects all collections/tables and samples documents/items to infer the full schema — including nested structures.
2
Review the schema & map columns
Our auto-mapper converts Couchbase types to PostgreSQL types. Review and adjust: rename columns, change types, flatten nested structures, or use JSON/JSONB for flexible fields.
3
Launch migration & monitor
Click launch. Watch records flow in real time with throughput charts, latency metrics, and error alerts. Enable live CDC to keep your SQL target in sync until cutover.

Type mapping: Couchbase → PostgreSQL

ObjectId / String IDVARCHAR(24)Stored as the 24-character hex string; _id becomes the primary key
StringTEXT / VARCHAR(n)Configurable max length or unlimited TEXT
Number / IntegerINTEGER / BIGINTNumeric types mapped to appropriate integer types
Double / DecimalDOUBLE PRECISION / NUMERICFloating point or arbitrary-precision
Date / TimestampTIMESTAMP WITH TIME ZONEFull timezone-aware timestamps
BooleanBOOLEANStandard true/false
Array / ListJSONB / ARRAYNested arrays as JSONB or typed PostgreSQL arrays
Object / Map / Nested docJSONBFlexible schema fields with indexing support
Binary / BytesBYTEABinary data support
Null / MissingNULL (nullable column)Schema-less nulls become SQL-compliant NULL

Frequently asked questions

Does this support live sync (CDC) for Couchbase?

Not yet. Couchbase's native change protocol (DCP) isn't exposed by the official Node SDK — Couchbase's own documentation points teams at a Kafka connector for that instead. One-time (bulk) migration is fully supported; live sync isn't offered rather than shipped as something shakier.

Does this work with non-default scopes and collections?

Yes. NoSQLSync lists collections across every scope in the bucket, not just the default one.

Does my bucket need a primary index?

No — NoSQLSync creates one (CREATE PRIMARY INDEX IF NOT EXISTS) if the collection doesn't already have one, the same way it creates tables on SQL targets that don't exist yet.

How long does a migration take?

A typical 100 GB dataset migrates in under 2 hours with bulk mode. With CDC enabled, ongoing writes sync in real time. Total time depends on data volume and network throughput.

Is my data secure during migration?

Yes. All data is encrypted in transit (TLS 1.3) and at rest (AES-256). Database credentials use short-lived tokens. Migration workers run in an isolated environment and never store data after the job completes.

Can I roll back if something goes wrong?

Yes. NoSQLSync only reads from your source — it is never modified, and CDC keeps running until you stop it. If you hit a problem after cutover, point your application's connection string back at the source.

Other migration paths from Couchbase

See the full Couchbase migration guide →

Couchbase → MySQLCouchbase → BigQueryCouchbase → SnowflakeCouchbase → RedshiftCouchbase → ClickHouseCouchbase → SQL ServerCouchbase → MariaDBCouchbase → SupabaseCouchbase → NeonCouchbase → PlanetScale

Ready to migrate to PostgreSQL?

Connect your Couchbase and PostgreSQL instances. No credit card required.

Start free migration →View pricing