Introducing Declarative Database Schema

Supabase now offers a powerful new way to manage changes to your Postgres database: Declarative Database Schema.

✍️ Declarative Database Schema (blog post): https://www.supabase.com/blog/declara...

Declarative Database Schema allows you to keep a single source of truth for the state of the database in schema files, similar to how some ORMs do, rather than having the state be scattered all over multiple migration files. Within the schema files, you define the schema of the database. When you want to change the database schema, you edit the schema file and run the diff command to automatically generate migrations.

Key features:
🚀 Simple and consistent migration workflows
🤖 Automatically generate migration files with `supabase db diff`
👮 Supports RLS policies, Views, and Functions
🤝 Version-controlled SQL for clarity and team collaboration

Whether you’re scaling your side project or working on a production app, this approach helps keep your database clean, predictable, and easy to maintain.

👉 Try it out and let us know what you think in the comments!

💻 Videos to watch next:
▶    • Announcing the Supabase UI Library  
▶    • Announcing Updates to Edge Functions  
▶    • Introducing Realtime Broadcast from D...  

👇 Learn more about Supabase 👇

🕸 Website: https://supabase.com/
🏁 Get started: https://app.supabase.com/
📄 Docs: https://supabase.com/docs

🔔 Subscribe for more tutorials and feature updates from Supabase:    / @supabase  

📱 Connect with Us:
🐙 Github: https://www.github.com/supabase
💬 Discord: https://discord.supabase.com/
🐦 Twitter:   / supabase  
▶ Instagram (follow for memes):   / supabasecom  


ABOUT SUPABASE:
Supabase is the open-source Firebase alternative. Supabase provides a full Postgres database for every project with pgvector, backups, realtime, and more. Add and manage email and password, passwordless, OAuth, and mobile logins to your project through a suite of identity providers and APIs.

Build in a weekend, scale to millions.

#Supabase #AppDevelopment #DeveloperTools