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.

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

019 GitHub stars

02Best-practice patterns for transactions, timestamps, and ID generation

03Standardized migration workflows using Drizzle Kit

04Multi-platform support for Local SQLite, Turso Cloud, and Cloudflare D1

05Node.js and Bun runtime compatibility using @libsql/client

06Type-safe schema definitions and queries with Drizzle ORM

Use Cases

01Building serverless applications with Cloudflare Workers and D1

02Rapid prototyping with local SQLite files and type-safe migrations

03Scaling distributed SQLite databases globally using Turso

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add gruckion/marathon-ralph database

For use in Claude.ai and ChatGPT

Download Skill