Database

What It Does

The kit uses Supabase/PostgreSQL with SQL-first schemas, generated app schemas, and generated migration bundles.

When To Use

• Adding or modifying tables/policies/functions.
• Regenerating migrations after setup changes.
• Running local database workflows.

Prerequisites

• Docker Desktop running locally.
• Supabase CLI installed.

How To Use

Core directories

Standard flow

Copy to Clipboardpnpm run supabase:start
creatorem generate-sql
pnpm run db:reset
pnpm run db:types

Command details

• creatorem generate-sql: reads app setup (.creatorem/setup.json), generates supabase/app-schemas/*, then assembles the merged migration file in supabase/migrations/*.
• pnpm run db:reset: resets the local Supabase database, applies the generated SQL migration state, and rebuilds the local database from that SQL source.
• pnpm run db:types: run this after db:reset with the Supabase Docker instance running; it generates TypeScript DB types from the current database state and refreshes Drizzle schema artifacts.

Reset local database

Copy to Clipboardpnpm run db:reset

MCP Context

Expand
Copy to Clipboardcapability: database_workflow
entrypoints:
  - supabase/schemas/
  - supabase/app-schemas/
  - supabase/migrations/
  - creatorem generate-sql
  - package.json scripts (db:reset, db:types)
inputs:
  - sql_sources
  - setup_json
outputs:
  - generated_migration_sql
  - updated_local_database
  - refreshed_types
constraints:
  - generated migration file should not be edited manually
  - ordering in supabase/schemas affects merge output
side_effects:
  - writes SQL files
  - mutates local db state
Expand

Agent Recipe

1. Edit SQL sources or setup definitions.
2. Start local Supabase (pnpm run supabase:start) and keep it running.
3. Run creatorem generate-sql.
4. Run pnpm run db:reset.
5. Run pnpm run db:types.

Troubleshooting

• If migration output is empty, verify SQL files exist in supabase/schemas and/or generated app schemas.
• If runtime queries fail after schema updates, regenerate types with pnpm run db:types.

Related

• CLI
• Deployment