Supabase Agent for Gluesync: Target Integration
Core principles
Supabase is PostgreSQL, and it speaks the PostgreSQL wire protocol. This agent is therefore the PostgreSQL target with Supabase’s connection defaults: it connects through the built-in PostgreSQL JDBC driver to database postgres as user postgres, with TLS on, and it uses the same type mapping, snapshot and CDC write paths and bulk COPY path as the PostgreSQL target.
Gluesync does not call the Supabase REST API or the Supabase management API. It needs only a database connection, so it works with Supabase projects hosted on supabase.com and with self-hosted Supabase.
The full-catalog walk of Core Hub (see PII discovery and masking) treats the schemas Supabase manages for itself (auth, storage, realtime, vault, extensions, graphql and the like) as system schemas: it does not walk or sample them, so auth.users and its password hashes are never read. Your own tables, in public or in schemas you created, are walked as usual.
Supported version
Supabase Postgres 15 or later, hosted or self-hosted, over the direct connection or the session pooler.
The integration test suite runs against Supabase Postgres 17.6 (the supabase/postgres image, version 17.6.1.054), with the postgres role (not a superuser, as on hosted Supabase), TLS only, row level security, the supabase_realtime publication and extensions installed in the extensions schema. This is not a certified compatibility matrix.
Platform supported features
| Feature | Support | Notes |
|---|---|---|
Target role |
✅ |
Writes Supabase Postgres tables through the bundled PostgreSQL JDBC driver, with TLS and pooling support. |
Source role |
❌ |
Current release supports Supabase only as a target. |
Snapshots |
✅ |
Snapshot batches are written to the target tables as the PostgreSQL target does. |
CDC |
❌ |
Current release supports Supabase only as a target. |
CDC type |
N/A |
Current release supports Supabase only as a target. |
User defined data types |
✅ |
Enum types, arrays and the types of extensions such as |
Bulk load |
✅ |
Stages rows in a table of the |
Database pooling |
✅ |
Supports connection pooling for efficient resource utilization across multiple pipelines. |
Source persisted internal cache |
N/A |
Target-only connector. |
Target persisted internal cache |
N/A |
Writes go straight to Supabase Postgres without intermediate file buffers. |
Driver / connector |
Built-in JDBC driver |
The PostgreSQL JDBC driver, over the PostgreSQL wire protocol. |
Chains |
N/A |
Target-only connector. |
Truncate operation support (reading) |
N/A |
Target-only connector. |
Truncate operation support (writing) |
✅ |
Supports Core Hub’s "TRUNCATE before snapshot" option when acting as a target. |