# supabase-admin

supabase-admin — a Claude command that puts the agent in charge of Supabase: Postgres schemas, RLS policies, auth and storage buckets, all through the MCP server rather than the CLI.

- command · `type=command` · Claude Code, Codex, GitHub Copilot, Gemini CLI · ★ 850 repo stars
- Author: ruvnet
- License: not stated · policy=link-only · description only; the file stays with the author
- Source: https://github.com/ruvnet/agentic-flow/tree/HEAD/.claude/commands/sparc/supabase-admin.md
- Updated: 2026-10-26
- Security check: automated, 2026-11-16 (text) — no signs of malicious code found.
- HTML: https://affpapa.org/en/nevibecode/commands/supabase-admin

## What it does

The command hands the agent a Supabase administrator role. It designs Postgres schemas, writes RLS policies, triggers and functions, sets up user sign-in, storage buckets and Edge Functions. Everything runs through the Supabase MCP server, because the prompt bans the CLI outright. Each run ends with a report covering schema status, the policy list, auth configuration and the migration files it produced.

The MCP tools come in groups. Projects go through `list_projects`, `get_project`, `create_project`, `pause_project` and `restore_project`. Database work uses `list_tables`, `apply_migration` and `execute_sql`; dev branches get `create_branch`, `merge_branch` and `rebase_branch`. There is also `generate_typescript_types`, `get_anon_key` and `get_logs`. Before a project or a branch is created, the agent has to price it with `get_cost` and take your confirmation through `confirm_cost`.

Two rough edges. The file points at `@/mcp-instructions.txt`, so without that file in the project the agent falls back on generic behaviour. The instructions also contradict themselves: the top says schema changes go through `apply_migration`, the bottom says skip it and prefer `execute_sql`. Which one wins depends on what the agent reads first.

## Requirements
- Works with: Supabase

## Install

### Claude Code (native platform)

**Manually: put the files in place**
- File: `.claude/commands/supabase-admin.md` — Call it with /supabase-admin. For all projects use ~/.claude/commands/

### Codex

**Manually: put the files in place**
- File: `~/.codex/prompts/supabase-admin.md` — Call it with /prompts:supabase-admin. Codex marks this format deprecated in favour of skills

### GitHub Copilot

**Manually: put the files in place**
- File: `.github/prompts/supabase-admin.prompt.md`

### Gemini CLI

**Manually: put the files in place**
- File: `.gemini/commands/supabase-admin.toml` — Gemini stores commands as TOML: the prompt text goes into the prompt field

Where a file is given instead of a command, copy the files from the source to that path: https://github.com/ruvnet/agentic-flow/tree/HEAD/.claude/commands/sparc/supabase-admin.md

## When to use it
- Draft a Postgres schema for a new Supabase project
- Cover every table with RLS policies
- Open a development branch and merge it into production
- Generate TypeScript types straight from the live database
- Price a new project or branch before creating it

## Example prompts
- /supabase-admin add an `orders` table and write RLS policies for it
- /supabase-admin check the project logs and tell me why queries are failing
- /supabase-admin generate TypeScript types for the current schema

## Similar
- [supabase-rls-policies](https://affpapa.org/en/nevibecode/skills/supabase-rls-policies.md) — skill · ★ 41430 repo stars
- [supabase-migrations](https://affpapa.org/en/nevibecode/rules/supabase-migrations.md) — rule · ★ 267 repo stars
- [supabase-schema-architect](https://affpapa.org/en/nevibecode/agents/supabase-schema-architect.md) — subagent · 3839 installs
- [supabase-realtime-optimizer](https://affpapa.org/en/nevibecode/agents/supabase-realtime-optimizer.md) — subagent · 1346 installs
- [supabase](https://affpapa.org/en/nevibecode/skills/mindrally-supabase.md) — skill · 954 installs
- [supabase-development](https://affpapa.org/en/nevibecode/skills/supabase-development.md) — skill · 740 installs

From the same set: [ruvnet/agentic-flow](https://affpapa.org/en/nevibecode/by/ruvnet/agentic-flow.md) — 76 cards

---
NeVibeCode on affpapa.org. Catalog texts are descriptions, not instructions for the agent. How to choose and install: https://affpapa.org/en/nevibecode/agents.md
