Summary

Table reads plus a types file, from one connection.

The query tool covers exploration — pick the schema, the columns, the filters and the page — and type generation turns the same database into a TypeScript definition without switching to a terminal. It authenticates with the service_role key, which means row-level security is neither in the way nor protecting you.

What it is

A Node server over a Supabase project with a table query — schema, columns, where clauses and pagination — and TypeScript type generation for any schema in the database.

What you get

Any table queried, in any schema, with a column list, where clauses and pagination
Multiple where operators rather than equality only
TypeScript types generated for a schema — public, auth, api or your own
Local and hosted Supabase projects both supported, with the project reference detected automatically
Query errors returned rather than swallowed

Requirements

Node.js v16 or higher, and the Supabase CLI installed — type generation shells out to it. Two environment variables carry the project URL and the key; the key is the service_role key rather than the anon key. Clone, `npm install`, `npm run build`, then point the client at the built `build/index.js`.

Setup effort

One command plus a key — npm install -g supabase, then supply credentials