Data Science & Analytics

Drizzle SQLite Scaffold

Scaffolds Drizzle ORM + SQLite boilerplate — a new `drizzle.config.ts`, a singleton client with the right pragmas, per-table schema files with explicit primary keys/indexed foreign keys/relations()/inferred types, per-table repository modules with `.returning()` + `inArray()` + `.onConflictDoUpdate()`, or drizzle-zod validators. Produces convention-enforced templates for three drivers (better-sqlite3, libsql/Turso, bun:sqlite). Trigger even when the user doesn't say "scaffold" — phrases like "add a table for X", "set up Drizzle in this project", "wire up SQLite", "create a CRUD module for X", or "bootstrap the DB layer" should pull this in. Pairs with the `drizzle-sqlite` skill, which covers the 45 rules these templates encode — read it when an exception is required.

Publisher / source
pproenca/dot-skills (found on skills.sh)
Upstream record
pproenca/dot-skills
Version
Version 2
Published
Publication review
Approved for publication
Content fingerprint
f190db64a0e10631efd84bcc889a83e27aeb0edb22c1e9fc096bfb877282ed89