Supabase Integration

Connect Dunmore to Supabase to stream all payment events into a PostgreSQL table via the PostgREST API. Build custom dashboards, run SQL queries, or use Supabase Realtime to subscribe to new events.

Setup

1. Create a table in your Supabase project (see schema below)
2. Get your Supabase URL and Service Role Key from Settings > API
3. Add a Supabase connector in the Dunmore console or via the API

Table Schema

Create a table named dunmore_events (or your preferred name) with this schema:

Column	Type	Description
event_id	text	Dunmore event ID (evt_xxx)
event_type	text	Event type (e.g., payment.settled)
timestamp	timestamptz	Event timestamp
project_id	text	Dunmore project ID
amount_raw	text	Raw amount in atomic units
amount_usd	numeric	Amount converted to USD
currency	text	Currency code (e.g., USDC)
network	text	CAIP-2 chain ID
endpoint	text	Endpoint path
payer_wallet	text	Payer wallet address
tx_hash	text	Settlement transaction hash
data	jsonb	Full event data object

Supported Events

All event types are inserted into Supabase. The connector does not filter — it receives everything for complete event logging.

Configuration

{
  "type": "supabase",
  "config": {
    "url": "https://xxxxx.supabase.co",
    "apiKey": "your-service-role-key",
    "table": "dunmore_events"
  },
  "eventTypes": ["*"]
}

Field	Required	Default	Description
url	Yes	—	Supabase project URL
apiKey	Yes	—	Service role key (or anon key with RLS)
table	No	dunmore_events	Target table name

API Example

curl -X POST https://api.dunmore.xyz/api/projects/{projectId}/connectors \
  -H "Authorization: Bearer {token}" \
  -H "Content-Type: application/json" \
  -d '{
    "type": "supabase",
    "config": {
      "url": "https://xxxxx.supabase.co",
      "apiKey": "YOUR_SERVICE_ROLE_KEY",
      "table": "dunmore_events"
    },
    "eventTypes": ["*"]
  }'