Open CLI

supabase

officialscriptabledatabase
$ brew install supabase/tap/supabase
Summary

Local backend, type generation, and db workflows from the terminal.

  • supabase fits data & db well, especially for local backend, type generation, and db workflows from the terminal.
  • It is the official CLI from Supabase.
  • Good for scripts and agents.
  • Good fit for coding-agent workflows and repeatable scripts.
  • Structured output is available for automation and parsing.
database-supabase-SKILL.md

Supabase guide

The official CLI from Supabase. Local backend, type generation, and db workflows from the terminal. Start with `supabase init` and go from there. Supports structured output — good for scripts and agents. Runs entirely on your machine.

Open CLI packages the install path, verify step, and safe-start workflow so this tool can move from “interesting CLI” to something you can actually use. It also integrates with skills.sh so each CLI comes with the right companion skills, not just a binary and a docs link.

When to apply

  • local backend, type generation, and db workflows from the terminal.
  • You're on Supabase and want the official terminal experience.
  • You need local backend.
  • You need type generation.
  • You need db workflows.

Quick reference

Installbrew install supabase/tap/supabase
Verifysupabase --version
First real commandsupabase init && supabase start

Open CLI × skills.sh

Open CLI integrates supabase with the right skills.sh companions so you get the tool and the workflow together.

Supabase Postgres Best Practices

Verified pairing

Open CLI integrates supabase with this skills.sh skill because it is the clearest fit for how supabase is usually used. Schema, query, and migration guidance for Postgres workflows on Supabase.

View on skills.sh
$ npx skills add https://github.com/supabase/agent-skills --skill supabase-postgres-best-practices
Starter prompt

Use supabase together with the Supabase Postgres Best Practices skills.sh skill. Inspect the current schema or data first, summarize what matters, and ask before any migration or write action.

Also useful from skills.sh
Database Schema Designskills.shData Analysisskills.sh

Why this tool

  • supabase fits data & db well, especially for local backend, type generation, and db workflows from the terminal.
  • It is the official CLI from Supabase.
  • Good for scripts and agents.

Watch-outs

  • Start with read-only or dry-run commands.

Example workflow

1. supabase init
2. supabase start
3. supabase db reset

Safe start

Step 1

Install supabase.

Step 2

Run `supabase --version` first.

Step 3

Start with `supabase init && supabase start`.

Step 4

Install a CLI that matches your database engine.

Alternatives worth considering

prisma

Schema design, migrations, and type-safe db workflows from the terminal.

drizzle-kit

Migrations, schema diffs, and typescript db tooling from the terminal.

usql

Universal SQL shell, multiple databases, and db scripts from the terminal.