​
1. Enable IPv4 Add On

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

​
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 access to existing tables
GRANT SELECT ON ALL TABLES IN SCHEMA public TO artie_transfer;

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

CREATE PUBLICATION dbz_publication FOR ALL TABLES;