Runs all SQL files in base/ (02-base equivalent with real natuleadan company data)

Runs all SQL files in data/ (03-data.ee equivalent with real users, products, courses)

Runs base seed then data seed in order

Lists all SQL files available in base/ and data/

Run a raw SQL SELECT query against the database. READ ONLY - for inspection/verification.

List all tables in the public schema

Run any SQL statement (INSERT, UPDATE, DELETE, SELECT, etc.) with full bypass of RLS. Use with care.

Run a SELECT query impersonating a user role (applies RLS). Useful to test what a role can see. Only available in supabase mode.

List all Supabase storage buckets with their visibility

List files in a bucket folder

Upload any local file to a storage bucket. local_path can be absolute (/Users/...) or relative to buckets/{bucket}/

Delete a file from a storage bucket

Generate a signed URL for a private bucket file

Get the public URL for a file in a public bucket

Download files from Supabase storage to local buckets/ folder. Can download all buckets, one bucket, a specific folder, or a single file.

List all foreign tables in the iceberg schema (mapped via FDW in Postgres)

SELECT from an Iceberg foreign table via Postgres FDW (e.g. 'iceberg.aud_analytics_lake')

List tables directly from the Iceberg REST Catalog (requires CATALOG_URI + AWS credentials)

Bootstrap the Iceberg FDW on Postgres: creates namespace + tables in catalog, configures FDW server, maps foreign tables, and verifies connection.

Describe table schema: columns, types, constraints, indexes

Get column statistics: cardinality, NULL count, data distribution

Parse SQL without executing - catch syntax errors early

Run query with EXPLAIN ANALYZE for performance debugging

List active/long-running queries with details (duration, memory, locks)

Database statistics: table sizes, row counts, growth metrics

List indexes with size, scan count, and usage stats

Upload multiple local files to storage with optional filtering by file type. Can upload individual files or an entire folder with selective file extensions.

Call a Supabase PostgreSQL function (RPC) via the REST API. Uses service_role — bypasses RLS.

Execute SQL file content (PL/pgSQL blocks, multi-statement scripts). Pass raw SQL from file as string.

Generate a signed URL for a private bucket file and update the URL in a DB media table

Create, update, delete or empty a storage bucket. Works with Supabase Storage (supabase mode) or S3-compatible (postgres mode).