Design Drizzle ORM schemas, migrations, and queries for Bun SQLite.
npx skills add https://github.com/vobase/vobase --skill drizzle-orm-sqlite
Please help me install this Agent Skill. Skill: drizzle-orm-sqlite Source: https://github.com/vobase/vobase/tree/main/.agents/skills/drizzle-orm-sqlite Command: npx skills add https://github.com/vobase/vobase --skill drizzle-orm-sqlite
Provides clear, production-minded guidance for using Drizzle ORM with Bun's sqlite driver to design schemas, run reliable migrations, and write correct, type-safe queries so teams avoid data loss, type mismatches, and runtime surprises.
Initialize Drizzle with bun:sqlite, generate a migration from your schema file, review the SQL, and apply the migration to your database.
High-intent search queries and answers about installing and using this skill.
To set up Drizzle ORM with Bun SQLite, initialize the drizzle-orm instance using the bun:sqlite driver, define your sqliteTable schemas, and generate migrations using the drizzle-kit tooling for type-safe query execution.
The best way to avoid destructive schema changes during Drizzle migrations is to use the drizzle-kit generate workflow, carefully review the generated SQL output, and actively avoid destructive DROP or RECREATE patterns in production environments.
Yes, Drizzle ORM supports both sync and async APIs for bun:sqlite, allowing you to execute selects, inserts, updates, deletes, joins, and transactions flexibly while maintaining type safety across your database operations.
To fix SQLITE_BUSY errors and tune performance in Bun SQLite, apply PRAGMA tuning settings such as WAL mode, synchronous, foreign_keys, and busy_timeout, alongside batching and concurrency guidance to mitigate locking issues.
Common gotchas when defining sqliteTable schemas with Drizzle ORM include unexpected type affinity behavior, issues with foreign keys, and default function misconfigurations, which require careful TypeScript inference and debugging to resolve.
Yes, you can use prepared statements and transactions with Drizzle ORM in Bun to execute batched selects, inserts, updates, and deletes efficiently while ensuring type-safe and reliable database query execution.
outfitter-devGenerate Bun runtime patterns for sqlite, HTTP, testing, and file operations.
Prompt-or-Die-LabsGenerate and apply Drizzle Kit migrations for PostgreSQL or SQLite schema changes.
SOFIA-ASIFBuild type-safe database schemas, queries, and migrations in TypeScript.
bobmatnycDefine TypeScript database schemas and build type-safe SQL queries.