drizzle-sqlite-scaffold
Drizzle SQLite Scaffold automates project initialization and table scaffolding for Drizzle + SQLite, emitting driver-specific config, singleton client, schema files with inferred types, and CRUD repository modules. Supports better-sqlite3, libsql/Turso, and bun:sqlite with built-in conventions for pragmas, relations, timestamps, and soft deletes.
Drizzle SQLite Scaffold generates production-ready Drizzle ORM + SQLite boilerplate with config, client, and schema templates for any supported driver.
AI-generated summary based on this skill's SKILL.md
Decision gist · record as of 2026-07-24
Drizzle SQLite Scaffold generates production-ready Drizzle ORM + SQLite boilerplate with config, client, and schema templates for any supported driver. Drizzle SQLite Scaffold automates project initialization and table scaffolding for Drizzle + SQLite, emitting driver-specific config, singleton client, schema files with inferred types, and CRUD repository modules. Supports better-sqlite3, libsql/Turso, and bun:sqlite with built-in conventions for pragmas, relations, timestamps, and soft deletes.
Use it when
- Yes.
- Drizzle SQLite Scaffold outputs driver-specific config, a singleton client, schema files with inferred types.
Verify before relying
Read SKILL.md below before installing (15 files). Open directory: indexed for reading, not audited.
Install
pproenca/dot-skills/drizzle-sqlite-scaffold · repository language: Shell
Open directory. Skills are indexed for reading, not audited. Review a skill's body before installing it.
Frequently asked questions
AI-generated answers based on this skill's SKILL.md and metadata
How do I scaffold a drizzle sqlite project?
Drizzle SQLite Scaffold automates initialization by generating driver-specific config, a singleton client, and schema files with inferred types. It supports better-sqlite3, libsql/Turso, and bun:sqlite, each with pre-configured pragmas and conventions for timestamps and soft deletes.
Can I add a table to my existing Drizzle project?
Yes. Drizzle SQLite Scaffold generates new table definitions with schema and a complete CRUD repository module for any existing Drizzle project. It infers types from your schema and scaffolds validators alongside the repository.
What does Drizzle SQLite Scaffold emit for a new project?
Drizzle SQLite Scaffold outputs driver-specific config, a singleton client, schema files with inferred types, and optional CRUD repository modules. It includes built-in conventions for pragmas, relations, timestamps, and soft deletes tailored to your chosen SQLite driver.
Which SQLite drivers does Drizzle SQLite Scaffold support?
Drizzle SQLite Scaffold supports better-sqlite3, libsql/Turso, and bun:sqlite. Each driver receives its own configuration and client setup, with pragmas and conventions optimized for that driver's runtime environment.
How does Drizzle SQLite Scaffold generate CRUD and validators?
Drizzle SQLite Scaffold generates CRUD repository modules and Zod validators from your existing table schema. It infers types directly from Drizzle definitions, ensuring validators and repository methods stay synchronized with schema changes.
Can I set up better-sqlite3 with Drizzle using this scaffold?
Yes. Drizzle SQLite Scaffold includes dedicated better-sqlite3 setup with pre-configured pragmas, connection pooling conventions, and a singleton client pattern optimized for synchronous SQLite access in Node.js environments.
SKILL.md
Rendered from the published skill. Quoted content, verbatim.
Drizzle SQLite Scaffold
Parameterized templates for bootstrapping Drizzle + SQLite in a fresh project, or adding a new table/repository to an existing one. Every output bakes in the conventions documented in references/conventions.md — explicit primary keys, indexed foreign keys, relations() declarations,
(truncated - see the full file via the links below)
File tree — 15 files
skills/.experimental/drizzle-sqlite-scaffold/SKILL.md
skills/.experimental/drizzle-sqlite-scaffold/assets/templates/client.better-sqlite3.ts.template
skills/.experimental/drizzle-sqlite-scaffold/assets/templates/client.bun-sqlite.ts.template
skills/.experimental/drizzle-sqlite-scaffold/assets/templates/client.libsql.ts.template
skills/.experimental/drizzle-sqlite-scaffold/assets/templates/drizzle.config.local.ts.template
skills/.experimental/drizzle-sqlite-scaffold/assets/templates/drizzle.config.turso.ts.template
skills/.experimental/drizzle-sqlite-scaffold/assets/templates/gitignore.template
skills/.experimental/drizzle-sqlite-scaffold/assets/templates/repository.ts.template
skills/.experimental/drizzle-sqlite-scaffold/assets/templates/schema-index.ts.template
skills/.experimental/drizzle-sqlite-scaffold/assets/templates/table.ts.template
skills/.experimental/drizzle-sqlite-scaffold/assets/templates/validators.ts.template
skills/.experimental/drizzle-sqlite-scaffold/config.json
skills/.experimental/drizzle-sqlite-scaffold/gotchas.md
skills/.experimental/drizzle-sqlite-scaffold/metadata.json
skills/.experimental/drizzle-sqlite-scaffold/references/conventions.md
Let your AI agent find skills like this
Example. Real query, live index.
You found this page by searching. An agent finds it by wishing: SkillFed indexes 56,283 agent skills by what they can do, searchable in plain language.
wish › “Bootstrap a new Drizzle + SQLite project with config, client, and schema structure”
Give your agent the search over MCP, or paste the wish link into any chat. No install? Search from any chat →
Related skills
Drizzle ORM is a lightweight, type-safe TypeScript ORM that treats SQL as a first-class citizen. This skill covers schema definition, database connections across PostgreSQL, SQLite, and Turso, relational queries, and performance patterns like proper indexing and pagination.
drizzle-orm-d1 equips you with a complete type-safe ORM layer for Cloudflare D1 databases, handling schema definition, migration generation via Drizzle Kit, and D1-specific patterns like batch operations instead of traditional transactions. It includes templates for common queries, relations, and prepared statements, plus an error catalog addressing D1-specific issues like binding errors and foreign key constraints.
Turso is a globally distributed SQLite platform built on libSQL that combines edge-hosted databases with embedded replicas for low-latency local reads. It supports vector similarity search, multi-database per-tenant architectures, batch operations, and integrates with Drizzle ORM for schema management. Use it for applications requiring offline-capable replicas, programmatic database provisioning, or distributed deployments.
Drizzle is a TypeScript-first ORM built for compile-time type safety and edge-runtime performance. Define schemas with SQL-like syntax, execute queries with full type inference, and manage one-to-many and many-to-many relations without runtime dependencies.
This skill guides you through Drizzle ORM's migration workflow for SQLite databases, covering schema definition, column types, and common changes like adding tables or indexes. Learn production-ready strategies for generating migrations, applying them in code, and managing relations between tables.
Nuxthub extends Nuxt with backend services including a type-safe database layer via Drizzle ORM (supporting SQLite, PostgreSQL, and MySQL), key-value storage, file blob storage, and caching. It handles schema definition, migrations, and multi-cloud deployment across Cloudflare, Vercel, Deno, and Netlify with virtual module imports for seamless server-side access.
More skills Drizzle Orm (unlicensed) · drizzle-orm-patterns (MIT)