Does this skill support Cloudflare D1?

Yes, it includes specific Drizzle configurations and driver patterns designed for the Cloudflare D1 HTTP driver and Workers runtime.

Why is bun:sqlite discouraged for Next.js?

Next.js runs on the Node.js runtime. Since bun:sqlite is built specifically for the Bun runtime, using it in a Next.js app will result in a 'module not found' error.

How are migrations handled?

It supports two workflows: 'db:push' for rapid synchronization during development and a formal 'generate/migrate' process for production environments.

Which database client does this skill recommend?

The skill strongly recommends @libsql/client because it provides universal compatibility across Node.js and Bun, avoiding errors common in Next.js environments.

SQLite & Drizzle Database Management

Name: SQLite & Drizzle Database Management
Author: gruckion

bygruckion

데이터베이스 관리

Implements type-safe SQLite database workflows using LibSQL and Drizzle ORM for local, Turso, and Cloudflare D1 environments.

소개

This skill provides a standardized framework for managing SQLite databases within TypeScript applications, specifically optimized for the 'better-t-stack'. It offers comprehensive guidance on setting up LibSQL clients, defining type-safe schemas, and executing complex queries while avoiding common pitfalls like runtime incompatibilities in Next.js. Whether you are developing locally with the Turso CLI, deploying to a distributed Turso cloud, or using Cloudflare D1, this skill ensures consistent patterns for migrations, relationships, and performance optimization.

주요 기능

Type-safe schema patterns and CRUD operations with Drizzle ORM
Environment-aware configuration for Node.js and Bun runtimes
0 GitHub stars
Standardized migration workflows including push, generate, and migrate commands
Pre-configured patterns for transactions, relations, and automatic timestamps
Multi-target support for Local SQLite, Turso Cloud, and Cloudflare D1

사용 사례

Building high-performance distributed applications with Turso
Implementing type-safe data layers in Next.js applications
Architecting serverless backends with Cloudflare Workers and D1

소개

주요 기능

Type-safe schema patterns and CRUD operations with Drizzle ORM
Environment-aware configuration for Node.js and Bun runtimes
0 GitHub stars
Standardized migration workflows including push, generate, and migrate commands
Pre-configured patterns for transactions, relations, and automatic timestamps
Multi-target support for Local SQLite, Turso Cloud, and Cloudflare D1

사용 사례

Building high-performance distributed applications with Turso
Implementing type-safe data layers in Next.js applications
Architecting serverless backends with Cloudflare Workers and D1