Log inStart free

Local development

The Supabase CLI locally, migrations, types and seeding with SupaHost.

4 pages · start with Local development with the Supabase CLI

  1. 01Local development with the Supabase CLIRun the full Supabase stack on your machine with the Supabase CLI and develop against it, then ship to SupaHost. Which CLI commands work, which don't, and how to set up a project.
  2. 02Migrations workflow: local to SupaHostWrite and test SQL migrations locally with the Supabase CLI, then apply them to a SupaHost project with MCP apply_migration, Studio's SQL editor or psql over the SSH tunnel on Business.
  3. 03Seeding dataFill your local Supabase database with test data on every reset using seed.sql, create test users through the Auth admin API, and load seed data into a SupaHost project or branch safely.
  4. 04Testing your databaseTest tables, functions and Row Level Security policies with pgTAP and the Supabase CLI, run the tests in CI, and check behaviour against a SupaHost branch before you ship a migration.