[gareve]

for the db schema definition for this tool, where does the source of truth lives?

I'm trying to think what happens when a column gets deleted or added in the prod, ci, or dev db tier. Ideally those db schema changes should happen at the same time but real life doesn't work like that.

[igalklebanov]

Kysely has community projects that offer Database interface auto-generation.

kysely-codegen can introspect all core dialects. prisma-kysely can generate straight from Prisma schemas.

We recommend using these in production apps. You could verify everything is aligned in your CICD workflows.