sqlite-utils 4.0

Simon Willison announced the release of sqlite-utils 4.0, introducing built-in database schema migrations. sqlite-utils is a command-line tool and Python library for manipulating SQLite databases, popular among developers for quick data tasks. The new feature allows users to define schema changes declaratively and apply them incrementally, preserving existing data. This addresses a common pain point: manually updating database schemas when data structures evolve. According to Willison, migrations support adding, renaming, dropping columns, and more, all while avoiding data loss. The tool outputs a plan before executing, giving visibility into changes. For AI workflow builders who often use SQLite as a lightweight store for logs, metadata, or intermediate results, this update reduces friction when iterating on data models. Rather than writing custom migration scripts or dumping and reloading data, teams can rely on a straightforward, automated process. The release aligns with broader trends toward simpler database management in local-first development.