DATABASES Signal 294
alchemy-utils 0.1a0
↗
Illustration only Photo by Tyler on Unsplash
Simon Willison released alchemy-utils 0.1a0, an alpha Python library and CLI that mirrors the sqlite-utils API but runs against PostgreSQL, SQLite, and DuckDB via SQLAlchemy.
This brings the sqlite-utils command-line workflow, insert, upsert, create, update, and table introspection, to databases beyond SQLite. It is an early alpha built as a prototype with coding agents, so production use carries that caveat.
Written by elseif from the cluster below · every claim links back to a sourceThe three things worth knowing
alchemy-utils 0.1a0 mirrors the sqlite-utils API (insert, upsert, insert_all, upsert_all, create, update, and table introspection) but is backed by SQLAlchemy for multi-engine support.
The alpha has been tested against PostgreSQL, SQLite, and DuckDB, and is installable via uvx with database-specific extras such as [postgresql] and [duckdb].
Willison built the prototype using Codex and GPT-5.6 Sol Ultra, reporting that it took very few follow-up prompts to reach a releasable state.
THE CLUSTER