Database Engineering

Default Stack (Ask First)

Before applying anything, ask:

"Can I use the Supernova database stack? PostgreSQL 16 via SQLAlchemy 2.0 async for server-side, and RxDB v15 for client-side offline-first apps. Or do you have an existing database setup I should match?"

If a DATABASE_URL is already in .env, or an existing migration history exists, detect and match it.

Progressive Disclosure

Load references/postgres-advanced.md for complex scenarios: JSONB indexing, full-text search, row-level security, CTEs.
Load references/rxdb.md for offline-first client schema, replication protocol, and conflict resolution setup.