Hein
a993859c62
CI / build-and-test (push) Has been cancelled
* Introduced oauth_clients table with fields for client_id, client_name, redirect_uris, and created_at. * Updated agent_persona_parts, agent_persona_skills, agent_persona_guardrails, agent_persona_traits, and arc_stage_parts tables to use unique constraints instead of primary keys for composite indexes.
Schema workflow
The schema/*.dbml files are the database schema source of truth.
Generate SQL migrations
Run:
make generate-migrations
This uses relspec to convert the DBML files into PostgreSQL SQL and writes the generated schema migration to:
migrations/020_generated_schema.sql
Generate ResolveSpec models
Run:
make generate-models
This uses relspec to convert schema/*.dbml into Bun/ResolveSpec-compatible
Go models in:
internal/generatedmodels/
Check schema drift
Run:
make check-schema-drift
This regenerates the SQL from schema/*.dbml and compares it with migrations/020_generated_schema.sql.
If the generated output differs, the command fails so CI can catch schema drift.
Workflow
- Update the DBML files in
schema/ - Run
make generate-migrations - Run
make generate-models - Review generated SQL and generated models
- Commit DBML changes and generated outputs
Existing handwritten migrations stay in place. Going forward, update the DBML first and regenerate the SQL from there.