How to sync schema

[ai]

The Kysely officially recommended workflow is to auto-generate schema from DB (after running migrations).

What is recommended solution if I am using pglite during the development?

[dnlsandiego]

I just implemented a CLI for generating types based on Kysely migrations or an existing PGlite database that's been persisted on disk. Usage would be:

npx kysely-pglite ./src/db/migrations --outFile ./src/db/schema.ts

It's mostly a wrapper around kysely-codegen, using its internal codegen directly. The CLI accepts the same options/flags as kysely-codegen. Currently it expects migration files to export up and down functions, same pattern as postgresql-migration-example.

It also has a --watch option, it will watch the migrations and regenerate the types when a migration file changes/deleted/added.