Connection Guide: Supabase Setup

Connection Guide: Supabase Setup​

1. Create Your Supabase Account​

• Visit supabase.com
• Click "Start your project" or "Sign Up"
• Create an account using your email, GitHub, or other available options
• Verify your email address if required

2. Create a New Project​

• After logging in, click "New Project"
• Fill in the required details:
  • Project Name: Choose a name for your project
  • Database Password: Create a strong password (save this securely)
  • Region: Select the region closest to your users
• Click "Create new project"
• Wait for the project to finish setting up (this may take 1–2 minutes)

3. Retrieve Your Project Credentials​

Finding Your Project URL:​

• In your Supabase dashboard, go to Project Settings (gear icon in the left sidebar)
• Navigate to API section
• Under Project URL, copy the URL
• Example: https://your-project-id.supabase.co

Finding Your API Key (anon/public):​

• On the same API page
• Scroll to Project API keys
• Copy the "Publishable key"
• Example: sb_publishable_vYk*****tOxJg_6gg2cHP4

4. Create Test Schema and Table​

4.1: Access SQL Editor​

• In your Supabase dashboard, click SQL Editor in the left sidebar
• Click "New query"

4.2: Run the Setup SQL​

CREATE SCHEMA IF NOT EXISTS test_schema;

GRANT USAGE ON SCHEMA test_schema
    TO anon, authenticated, service_role;

CREATE TABLE IF NOT EXISTS test_schema.pabbly_users (
    id BIGINT GENERATED BY DEFAULT AS IDENTITY NOT NULL,
    created_at TIMESTAMPTZ NOT NULL DEFAULT now(),
    first_name TEXT NULL,
    last_name TEXT NULL,
    email TEXT NULL,
    phone TEXT NULL,
    CONSTRAINT users_pkey PRIMARY KEY (id)
) TABLESPACE pg_default;

ALTER TABLE test_schema.pabbly_users
    ENABLE ROW LEVEL SECURITY;

CREATE POLICY "full access pabbly_users"
    ON test_schema.pabbly_users
    FOR ALL
    TO anon, authenticated, service_role
    USING (true)
    WITH CHECK (true);

GRANT SELECT, INSERT, UPDATE, DELETE
    ON test_schema.pabbly_users
    TO anon, authenticated, service_role;

5. Configure GraphQL API Settings​

5.1: Navigate to API Settings​

• Go to Project Settings (gear icon in left sidebar)
• Click on Data API in the settings menu
• Scroll down to API Settings section

5.2: Add Schema to Search Path​

• Find the "Extra search path" field under Data API Settings
• Add test_schema to the extra search path
• Click "Save" to apply changes

6. Create Helper Functions (RPC)​

6.1: Access SQL Editor​

• Click SQL Editor in the left sidebar
• Click "New query"

6.2: Create the Functions​

CREATE OR REPLACE FUNCTION public.list_user_schemas()
RETURNS TABLE(schema_name text)
LANGUAGE sql STABLE SECURITY INVOKER
AS $$
    SELECT schema_name
    FROM information_schema.schemata
    WHERE schema_owner NOT IN ('supabase_admin', 'pgbouncer')
      AND schema_name <> 'extensions'
    ORDER BY schema_name;
$$;

CREATE OR REPLACE FUNCTION public.list_tables_for_schema(p_schema text)
RETURNS TABLE(table_name text)
LANGUAGE sql STABLE SECURITY INVOKER
AS $$
    SELECT table_name
    FROM information_schema.tables
    WHERE table_schema = p_schema
      AND table_type = 'BASE TABLE'
    ORDER BY table_name;
$$;

CREATE OR REPLACE FUNCTION public.list_columns_for_table(
    p_schema text,
    p_table text,
    p_mode text DEFAULT 'select'
)
RETURNS TABLE (
    column_name text,
    data_type text,
    is_primary_key boolean
)
LANGUAGE sql STABLE SECURITY INVOKER
AS $$
    SELECT
        c.column_name,
        c.data_type,
        CASE WHEN tc.constraint_type = 'PRIMARY KEY' THEN true ELSE false END AS is_primary_key
    FROM information_schema.columns c
    LEFT JOIN information_schema.key_column_usage kcu
        ON c.table_name = kcu.table_name
        AND c.column_name = kcu.column_name
        AND c.table_schema = kcu.table_schema
    LEFT JOIN information_schema.table_constraints tc
        ON tc.constraint_name = kcu.constraint_name
        AND tc.table_schema = kcu.table_schema
        AND tc.constraint_type = 'PRIMARY KEY'
    WHERE c.table_schema = p_schema
      AND c.table_name = p_table
      AND (
            p_mode <> 'update'
            OR c.column_name NOT IN ('id', 'created_at')
          )
    ORDER BY c.ordinal_position;
$$;

7. Connect to Pabbly Connect​

• Open your Pabbly Connect workflow
• Add a Supabase action step
• When prompted, enter:
  • Project URL: The URL you copied in Step 3
  • API Key: The Publishable key you copied in Step 3
• Save your connection

✅ Setup Complete!​

• Create new records in test_schema.pabbly_users
• Read existing records
• Update record information
• Delete records

Test Your Setup​

⚠️ Important Security Notes​

• Review and restrict Row Level Security (RLS) policies
• Limit the anon role permissions to only necessary operations
• Implement proper authentication and authorization
• Never expose sensitive data through the anon role in production environments

Need Help?​

• Check the Supabase Documentation
• Review your SQL Editor for any error messages
• Verify that all SQL commands executed successfully
• Ensure your API credentials are correctly copied
• Error like this :

• Explanation & Solution:
  This occurs when your table’s Row-Level Security (RLS) policies do not allow the action you are trying to perform (e.g., INSERT). To fix this
  Refer to the official Supabase documentation for guidance: Row-Level Security (RLS) in Supabase.