1. Enable IPv4 Add On

To do this:

  1. Go to your project settings in Supabase
  2. Click on Add Ons
  3. Enable IPv4

2. Find your Supabase credentials

You can find this under Settings > Database > Connection Parameters.

Be sure to uncheck connection pooler!

We will need the following:

  1. Database Host
  2. Database Port (Should be 5432)
  3. Username
  4. Password
  5. Database

To create a service account, run this in Supabase:

CREATE USER artie_transfer WITH PASSWORD 'password';

-- Grant replication permissions
ALTER USER artie_transfer REPLICATION;

-- Grant read-only access to future tables
ALTER DEFAULT PRIVILEGES IN SCHEMA public GRANT SELECT ON TABLES TO artie_transfer;
-- Grant access to existing tables
GRANT SELECT ON ALL TABLES IN SCHEMA public TO artie_transfer;

CREATE PUBLICATION dbz_publication FOR ALL TABLES;