molt

Builds a folder of plain SQL into a DuckDB database: in dependency order, with tests, in one transaction.

$ go install github.com/vt100io/molt/cmd/molt@latest View on GitHub →

Why

DuckDB made analytics simple: one engine, one file, no server. The tools around it put a layer between you and the engine. molt removes the layer: it assumes DuckDB and nothing else, and lets DuckDB do every job it can already do.

Every run is one transaction. A failing model or test rolls everything back, so readers never see half a rebuild or data that failed its tests.

Leans on DuckDB.