Supabase Database Webhooks Studio Puzzle #26

💡 Clue: Supabase ➔ Integrations (Click to Navigate)

Catalog & Guide

Supabase Database Engine

Project: production-cluster (eu-central-1) · PostgreSQL 15.6

Trigger: profile_insert_webhook

Webhook Name

Target Table

Events to Monitor

Insert (Active) Update Delete

HTTP Method

POST Asynchronous non-blocking push

Webhook URL

HTTP Headers

Underlying extension: pg_net v0.8.0

	id uuid	user_name text	email text	created_at timestamptz	bio text
	3bd1f629-4d1e-4b21-acee-8980ba9cb5ef	stardust_coder	hello@example.com	2026-02-06 15:44:11.897523+00	Just a human-shaped entity writing some SQL.

Webhook Automation Receiver (n8n / Make Engine)

Endpoint: /webhook/d42a63e0-82d1-432a-bf31...

Delivered (200 OK)

Execution Mode: production | Latency: 38ms

Recent Webhook Ingestion Events 1 event delivered

Timestamp	Event	Table	User Name	HTTP Status	Duration
15:44:11.897	INSERT	profiles	stardust_coder	200 OK	38ms

Automated 7-Point Diagnostic Verification Suite

Validates Supabase Integrations discovery, PostgreSQL trigger event firing, payload schema parity, and HTTP 200 delivery receipt.

1. Integrations Discovery

Navigates to Supabase ➔ Integrations ➔ Database Webhooks

READY

2. Target Table & Event

Monitors public.profiles on SQL INSERT operations

READY

3. Destination Webhook URL

Validates endpoint URL structure & POST HTTP method

READY

4. PostgreSQL Trigger DDL

Verifies pg_net / supabase_functions.http_request DDL

READY

5. Trigger on Event

Executes row mutation & fires event trigger hook

READY

6. Payload Schema Match

Validates exact JSON structure, user_name & email fields

READY

7. Delivery Verification

Confirms HTTP 200 OK receipt & audit execution log

READY

This is the exact SQL trigger code executed by Supabase when a webhook is configured under Integrations:

-- 1. Enable pg_net asynchronous networking
CREATE EXTENSION IF NOT EXISTS pg_net WITH SCHEMA extensions;

-- 2. Define trigger function and hook
CREATE OR REPLACE TRIGGER "profile_insert_webhook"
AFTER INSERT ON "public"."profiles"
FOR EACH ROW
EXECUTE FUNCTION supabase_functions.http_request(
  'https://hook.eu2.make.com/webhook/d42a63e0-82d1-432a-bf31-faaf7aa3d019',
  'POST',
  '{"Content-Type":"application/json"}',
  '{}',
  '5000'
);

Database Webhooks (pg_net)

Automated 7-Point Diagnostic Verification Suite

Insert Row into public.profiles

PostgreSQL Trigger DDL & pg_net Specification

Insert Row into `public.profiles`