Write and run queries
The editor runs anything from a quick select to a multi-table update directly against your database.
Line numbers, syntax highlighting and a one-tap formatter keep longer statements readable on a phone, and the same
editor scales up to the larger layout on iPad.
It is built for the questions that come up away from your desk: did the migration run, how many people signed up since the last deploy, which row did that customer actually change.
Results you can read on a small screen
Results open under the editor with a preview of the first rows and a status line that tells you whether the query succeeded. The full results view gives the result set the whole screen, and CSV export sends it to a spreadsheet, a ticket or a colleague.
History and snippets
Recent queries stay in history, so the statement you ran during an incident is still there when you write the post-mortem. Queries you run often can be saved as snippets and opened from the toolbar in one tap.
A warning before destructive statements
On a phone, a mistyped statement is easier than it should be. Supanator warns you before a destructive query runs, so you confirm it first and the database sees it second. Reads run immediately.
From a question to a result
Ask Supanator AI a question in plain language and it answers with SQL written against your own tables and columns, because it uses your project's structure as context. Copy the query into the editor, run it and read the result, as in the recording.
It also helps design schemas and draft Row Level Security policies. If you would rather not type SQL at all, the query builder assembles a query visually from tables, columns and filters.
Supabase Cloud and self-hosted
The editor works the same way for Supabase Cloud projects and for self-hosted Supabase.
On self-hosted stacks with direct Postgres access, Supanator also shows active connections and query performance from pg_stat_statements.
Free and Pro
Running queries, reading results and exporting them is free. Saved snippets, the query builder, the AI assistant and the SQL generator come with Pro. The Free and Pro comparison lists everything else.
