Supabase

Supabase is an open-source Firebase alternative that provides a complete backend-as-a-service (BaaS) platform built on PostgreSQL. It offers developers a suite of tools for building and managing modern applications, including database hosting, authentication, real-time subscriptions, storage, and serverless functions. This integration platform enables users to query, monitor, and manage their Supabase infrastructure, projects, and configurations programmatically.

Category	Database
Direction	Query source
Sign-in	Personal Access Token
Query languages	SQLite
Tables	6
Query templates	21
Website	supabase.com

Before you start

Huntbase signs in to Supabase with Personal Access Token. Create the credential in Supabase first, then keep it to hand for the Connect step.

1. In the Supabase dashboard, open your account's access tokens settings at https://supabase.com/dashboard/account/tokens.
2. Generate a new token. Supabase recommends a scoped token. Choose the organizations and projects to cover, grant Read access to the permissions you need, and set an expiration date.
3. Copy the token. Scoped tokens are shown only once.

Watch out for

• A classic token carries your account's full access to every organization and project you belong to, including ones you join later.

For the vendor's own instructions, see Supabase personal access token documentation.

tip

Use a dedicated, read-only credential for Huntbase where the product allows it. Huntbase only needs to read.

Connect Supabase

1. Go to Connections and click New connection, or click New connection on the Supabase product page.
2. On Product, pick Supabase and choose the Owner.
3. On Details, give the connection a Name and, optionally, a Description.
4. On Connect, fill in the settings and credentials described below.
5. On Verify, review the summary and click Create & check.

For everything else on the setup page — saving a draft, I'll do this later, and what each check result means — see Connections.

Credentials

The only Method is Personal Access Token. Enter a Credential label (for example Production), then fill in:

Field	Required	Notes
Personal Access Token	Yes	Your personal access token. It starts with sbp_ (scoped tokens start with sbp_fc). Secret — not shown again after you save it.

Query it

Once connected, Supabase can serve these languages in a query tab, and Scout can use it when you ask in Auto:

Language	Use it for
SQLite	SQL over the 6 tables listed below, alongside every other connected source.

Example: SQLite

Supabase Organizations Basic Info — Retrieve the name and ID of all Supabase organizations.

SELECT
  name,
  id
FROM
  supabase_organization;

Supabase ships with 21 query templates. Find them in Library › Queries — see Query templates.

Tables

Supabase adds 6 tables. Browse their columns from Schema in the query bar's ⋯ menu.

All 6 tables

Table	Contains
supabase_function	Supabase Function
supabase_organization	Supabase Organization
supabase_project	Supabase Project
supabase_project_custom_hostname	Supabase Project Custom Hostname
supabase_project_network_restriction	Supabase Project Network Restrictions
supabase_secret	Supabase Secret

Next steps

• Connections — health, credentials and settings after you connect
• Query languages — syntax, parameters and time ranges
• Chatting with Scout — ask questions without writing a query
• All integrations — the rest of the catalog