Why should I use @libsql/client instead of bun:sqlite?

Next.js runs on Node.js, and bun:sqlite is exclusive to the Bun runtime. Using @libsql/client ensures cross-runtime compatibility and prevents 'Cannot find module' errors in production.

What is the recommended local development workflow?

The skill recommends using the Turso CLI to run a local SQLite file via 'turso dev', allowing you to mirror production behavior while working offline.

Does this support complex database relations?

Yes, it provides patterns for defining many-to-one and one-to-many relations using Drizzle's relational API for simplified data fetching.

How does this skill handle database migrations?

It utilizes Drizzle Kit to generate SQL migration files from your TypeScript schema and provides standard scripts for pushing changes in dev or migrating production.

Can I use this with Cloudflare Workers?

Yes, it includes specific configurations for Cloudflare D1 using the d1-http driver, making it ideal for serverless edge environments.

SQLite & Drizzle Database Manager

Name: SQLite & Drizzle Database Manager
Author: gruckion

bygruckion

•

Database Management

Implements type-safe SQLite database solutions using LibSQL and Drizzle ORM for Next.js, Turso, and Cloudflare D1 environments.

About

This skill streamlines the setup and management of SQLite databases within modern web stacks, specifically targeting the better-t-stack architecture. It provides comprehensive guidance on using the LibSQL client with Drizzle ORM to ensure full compatibility across Node.js and Bun runtimes, effectively preventing common environment-specific errors in Next.js. By offering standardized patterns for schema design, migrations, and relational CRUD operations, this skill enables developers to build high-performance, type-safe data layers that transition seamlessly from local development to production on platforms like Turso and Cloudflare Workers.

Key Features

9 GitHub stars
Best-practice patterns for transactions, timestamps, and ID generation
Standardized migration workflows using Drizzle Kit
Multi-platform support for Local SQLite, Turso Cloud, and Cloudflare D1
Node.js and Bun runtime compatibility using @libsql/client
Type-safe schema definitions and queries with Drizzle ORM

Use Cases

Building serverless applications with Cloudflare Workers and D1
Rapid prototyping with local SQLite files and type-safe migrations
Scaling distributed SQLite databases globally using Turso

About

Key Features

9 GitHub stars
Best-practice patterns for transactions, timestamps, and ID generation
Standardized migration workflows using Drizzle Kit
Multi-platform support for Local SQLite, Turso Cloud, and Cloudflare D1
Node.js and Bun runtime compatibility using @libsql/client
Type-safe schema definitions and queries with Drizzle ORM

Use Cases

Building serverless applications with Cloudflare Workers and D1
Rapid prototyping with local SQLite files and type-safe migrations
Scaling distributed SQLite databases globally using Turso