Supabase CLI

Summary

Supabase announces its CLI as the first step toward running Supabase locally, managing database migrations, generating types and API or validation schemas from a database, managing projects, and eventually pushing local changes to production. The local stack runs through Docker Compose, using tools described as 100% compatible with every Supabase project, and a React setup can initialize it with supabase init before supabase start. For schema changes, the post favors database diffing over accumulating manual SQL migrations and adds a CLI mode and Docker image for pgAdmin Schema Diff, which tracks view-owner changes needed for Row Level Security and handles domains. The supabase eject command outputs Docker Compose, Kong, and Postgres configuration for self-hosting. An update dated 15 August 2022 states that CLI V1 is generally available and that a Management API is in beta.

Takeaways

1. 1

   Supabase’s local setup uses Docker Compose, and the post says its local-development tools are 100% compatible with every Supabase project.

2. 2

   Supabase selected pgAdmin Schema Diff because it tracks view-owner changes required for Row Level Security on views; a CLI mode and Docker image were added because the original tool was GUI-only.

3. 3

   The supabase eject command produces docker-compose.yml plus kong and postgres directories, allowing the stack to be started with docker compose up and adapted to an existing Postgres database.