Power user mode
SQL editor
Skip the UI when you need to - write a one-off query, save it as a snippet, or prototype a view before promoting it to a dashboard widget.
sql / snippets / top-closing.sql
⌘↩ to run
-- top 5 deals closing this week
select d.id, d.name, d.amount, c.name as company, u.email as owner
from crm.deals d
join crm.companies c on c.id = d.company_id
join supasheet.users u on u.id = d.owner_id
where d.close_date between current_date and current_date + interval '7 days'
order by d.amount desc
limit 5;5 rows · 42 ms · cachedok
| id | name | amount | company | owner |
|---|---|---|---|---|
| d_77c | Hooli Lighthouse | $185,000 | Hooli | lena@… |
| d_8a2 | Acme renewal | $48,000 | Acme Corp | lena@… |
| d_3f1 | Initech expansion | $96,200 | Initech | mei@… |
| d_4a8 | Vandelay renewal | $33,000 | Vandelay | asha@… |
| d_910 | Globex pilot | $12,500 | Globex | rohan@… |
What it does
The capabilities you get out of the box.
Capability01
Full Postgres
Every Postgres extension you have installed is available.
Capability02
Cached results
TanStack Query caches results across navigations.
Capability03
Parameter binding
Prepared-statement parameters prevent SQL injection.
How it works
Three steps from SQL to UI.
- 01Open the editorAvailable in any project where you have SQL access.
- 02Write & runResults render in a paginated table with column type hints.
- 03PromoteSave as a view and tag it as a dashboard widget or report.
Get started
Try it on your own Supabase project.
Connect a project, install the Supasheet schema, and your tables are live in minutes.
No credit cardSelf-host or managedMIT licensed