MCP Tool Directory

Deploys an Edge Function to a Supabase project. If the function already exists, this will create a new version. Example: import "jsr:@supabase/functions-js/edge-runtime.d.ts"; Deno.serve(async (req: Request) => { const data = { message: "Hello there!" }; return new Response(JSON.stringify(data), { headers: { 'Content-Type': 'application/json', 'Connection': 'keep-alive' } }); });

Creates a development branch on a Supabase project. This will apply all migrations from the main project to a fresh branch database. Note that production data will not carry over. The branch will get its own project_id via the resulting project_ref. Use this ID to execute queries and migrations on the branch.

Lists all development branches of a Supabase project. This will return branch details including status which you can use to check when operations like merge/rebase/reset complete.

Deletes a development branch.

Merges migrations and edge functions from a development branch to production.

Resets migrations of a development branch. Any untracked data or schema changes will be lost.

Rebases a development branch on production. This will effectively run any newer migrations from production onto this branch to help handle migration drift.

List records from a Supabase table/view with PostgREST filtering, column selection, ordering, and pagination. Filter syntax: age=gt.18, status=eq.active, name=ilike.*john*, id=in.(1,2,3). Resource embedding (JOINs): select=*,orders(*)

Insert one or more records into a Supabase table. Pass a single object or an array of objects. Use return=representation to get the created records back.

Update records in a Supabase table matching a filter. Filter is REQUIRED to prevent accidental full-table updates. Use return=representation to see what changed.

Upsert (insert or update on conflict) records in a Supabase table. Uses merge-duplicates by default. Specify on_conflict for non-primary-key columns.

Delete records from a Supabase table matching a filter. Filter is REQUIRED to prevent accidental full-table deletion. Use sb_list_records first to verify which records will be deleted.

Call a stored PostgreSQL function (RPC) in Supabase. Use method=GET for immutable functions, POST for volatile ones (default).

List all storage buckets in the Supabase project. Returns bucket name, public status, size limits, and allowed MIME types.

Create a new storage bucket in Supabase. Set public=true for publicly accessible files. Optionally set file size limit and allowed MIME types.

Delete a storage bucket from Supabase. The bucket must be empty before deletion. Use sb_delete_objects to remove files first.

List objects (files) in a Supabase storage bucket. Supports prefix filtering, pagination, and search.

Delete one or more objects from a Supabase storage bucket. Provide an array of file paths to delete.

Create a temporary signed URL for a private storage object. The URL expires after the specified duration.

List all users in the Supabase Auth system. Returns paginated results with user details including email, metadata, and creation date.

Get a single user by ID from Supabase Auth. Returns full user details including metadata, identities, and last sign-in.

Create a new user in Supabase Auth. Set email_confirm=true to skip email verification. Use app_metadata for admin-controlled data (roles, permissions).

Update a user in Supabase Auth. Can change email, phone, password, metadata, or ban the user.

Delete a user from Supabase Auth. This permanently removes the user and all their auth data.

List all Supabase projects in your account. Returns project name, ref, region, status, and database info. Requires SUPABASE_ACCESS_TOKEN.

Get details of a specific Supabase project by reference ID. Returns name, region, status, database host, and API URL.

Create a new Supabase project. Requires organization ID, region, and database password. Project creation takes a few minutes.

Pause a Supabase project. Paused projects stop all services (database, auth, storage) and free up resources. Free tier projects auto-pause after inactivity.

Restore a paused Supabase project. Restarts all services including database, auth, and storage.

Execute a SQL query on a Supabase project database via the Management API. Supports SELECT, INSERT, UPDATE, DELETE, CREATE TABLE, and all SQL. Returns query results as JSON.