What is the primary benefit of using Drizzle with Bun?

It combines the high performance of Bun's native SQLite driver with Drizzle's lightweight, type-safe ORM capabilities, resulting in a developer experience that is both fast and safe.

Does it support advanced SQLite features?

Yes, it includes guidance on using specialized column types, JSON storage, timestamps, and raw SQL expressions for features not yet covered by the ORM.

Does this skill help with database migrations?

Yes, it provides specific commands and configuration patterns for Drizzle Kit to generate, apply, and push schema changes efficiently.

Can Claude help me write complex relational queries with this skill?

Absolutely. This skill includes patterns for Drizzle's Relational Query API, allowing Claude to help you write nested joins and complex data fetches.

Bun Drizzle Integration

Name: Bun Drizzle Integration
Author: secondsky

bysecondsky

•

Database Management

Integrates Drizzle ORM with Bun's SQLite driver to provide type-safe database schemas and streamlined migration workflows.

About

This skill provides Claude with the specialized knowledge required to implement a robust, type-safe database layer using Drizzle ORM and the Bun SQLite driver. It streamlines the development process by providing standardized patterns for schema definitions, migration management with Drizzle Kit, and efficient CRUD operations. By leveraging this skill, developers can quickly set up relational data models, handle complex transactions, and utilize prepared statements, ensuring high performance and type safety across their Bun-powered TypeScript applications.

Key Features

Type-safe schema definitions for Bun SQLite core
Automated migration workflows using Drizzle Kit
Comprehensive CRUD patterns including upserts and filters
Relational mapping for complex data structures
Native support for transactions and prepared statements
21 GitHub stars

Use Cases

Converting existing raw SQL queries in a Bun app to a type-safe Drizzle ORM implementation
Architecting complex data relationships and automated migrations for local-first applications
Bootstrapping a new Bun project with a production-ready SQLite database layer

About

Key Features

Type-safe schema definitions for Bun SQLite core
Automated migration workflows using Drizzle Kit
Comprehensive CRUD patterns including upserts and filters
Relational mapping for complex data structures
Native support for transactions and prepared statements
21 GitHub stars

Use Cases

Converting existing raw SQL queries in a Bun app to a type-safe Drizzle ORM implementation
Architecting complex data relationships and automated migrations for local-first applications
Bootstrapping a new Bun project with a production-ready SQLite database layer