supabase/cli v2.109.0

on GitHub

Supabase CLI v2.109.0 — 2026-06-30

v2.109.0 moves migration commands to TypeScript with a critical fix for pipeline-incompatible SQL statements, adds db reset --sql-paths for CI workflows, and resolves several database operation bugs.

Highlights

• Migration files with pipeline-incompatible statements now apply correctly — migration up/down now handle CREATE INDEX CONCURRENTLY, VACUUM CONCURRENTLY, REINDEX CONCURRENTLY, ALTER SYSTEM, CLUSTER without failing. (#5671)

New features

• db reset --sql-paths — Override seed SQL patterns per-reset without editing config.toml. (#5691)

Bug fixes

• Declarative schema sync detects stale local Postgres images and suggests restart instead of silently generating broken migrations. (#5646)
• db diff no longer fails when schema_paths glob patterns match no files, enabling gradual adoption of declarative schema. (#5702)
• Fixed db diff, db pull, and db schema push crashing when supabase/migrations directory already exists (Windows OneDrive, etc.). (#5724)
• Fixed supabase functions serve crashing with "name too long" error on Windows when runtime bootstrap is large. (#5712)
• Fixed config push failing when remote Storage config is missing the optional databasePoolMode setting. (#5729)

TypeScript port progress

• Now served by the TypeScript shell: migration new, migration list, migration fetch, migration repair, migration up, migration down. Behavior matches the Go CLI. (#5671)

Plus 20 internal improvements and dependency updates.

Full changelog: v2.108.0...v2.109.0