calendarbackup-db

Database schema and migrations for a Supabase backend are managed through numbered migration scripts. This approach handles schema changes systematically, ensuring database structures remain synchronized across different deployment environments.

Multi-tenant row-level security in Supabase is set up by implementing specific RLS policies. This Skill manages these policies to isolate tenant data, enforcing strict access controls directly at the database level for backend workflows.

SQL function and trigger creation in Supabase is automated by executing dedicated database scripts. This automation handles setup and management of triggers, streamlining backend database operations and reducing manual SQL execution.

TypeScript types are generated from a Supabase database schema using built-in generation scripts. This process automatically produces type definitions, ensuring frontend or backend code matches the current database structure accurately.

Supabase TEST and PROD environments are separated by verifying the project URL before applying migrations. Running a project URL check ensures database modifications target the correct environment, maintaining safety between test and production data.

The best way to handle database migrations for a multi-tenant application is using a structured schema management process. This approach combines numbered migrations with row-level security to maintain data isolation and schema integrity.