preferences-schema-versioning

To manage schema migrations safely, use declarative SQL files to handle database schema changes. This approach ensures cross-database compatibility between PostgreSQL and DuckDB through SQLMesh transpilation.

You can generate type-safe Python models from database schema migrations by processing your declarative SQL files. This Skill uses Atlas and sqlc to produce language-specific data models and query functions.

Declarative schema versioning is the process of evolving data schemas over time using declarative SQL files. It prevents disrupting existing applications or data integrity during development and deployment transitions.

Yes, SQLMesh works with PostgreSQL and DuckDB by providing transpilation capabilities. This allows your declarative schema migrations to maintain cross-database compatibility across both database systems.

Yes, you can generate TypeScript and Go data models from SQL schema definitions. The type-safe code generation feature produces language-specific data models and query functions for Python, TypeScript, and Go.

The best way to add a new field without breaking type safety is using declarative schema versioning. It safely migrates the database, generates updated data models, and ensures queries are type-checked against the new schema.