Supabase

Connect Supabase and your assistant can work with your database — selecting and counting rows, inserting, updating, upserting, and deleting data, and calling stored procedures.

What’s included

With Supabase connected, your assistant can:

Read data — select rows and count rows in your tables
Write data — insert single rows or batches, update, upsert, and delete rows
Run logic — call remote procedures (Postgres functions)

Connecting Supabase

Go to Integrations
Find Supabase and click Connect
Enter your Supabase project subdomain and service role key (find them in your Supabase project’s API settings)
Return to Town

Your assistant works directly against your live database. You can revoke access anytime from Supabase.

What your assistant can do

Capability	What it does	Makes changes?
Select rows	Read data from a table	No
Count rows	Count matching rows	No
Insert rows	Add single rows or batches	Yes
Update and upsert rows	Modify or create-or-update rows	Yes
Delete rows	Remove rows	Yes
Call procedures	Run Postgres functions	Yes*

* Procedures may read or write depending on how they’re defined.

Use cases

Data lookups — “how many signups landed in the users table this week?”
Quick fixes — update a row after a support conversation.
Data logging — routines that insert rows from other tools.

Good to know

Writes and deletes change your live database — use approval-required tool settings in routines that modify data.
For project provisioning, see the Supabase Management API integration.

Integrations overview — How integrations give your assistant context
Supabase Management API — Project-level operations