Turso & LibSQL

Build edge-first applications with Turso's distributed SQLite. Generates embedded replica configs, Drizzle ORM integration, multi-tenant database-per-user patterns, and edge function connections.

This skill helps you build applications with Turso's distributed LibSQL database. It configures embedded replicas for local-first reads, sets up the @libsql/client for edge functions, integrates with Drizzle ORM for type-safe queries, implements multi-tenant database-per-user architectures, creates migration workflows, and configures read replicas across regions. Covers the Turso CLI, Platform API, and database branching.

When to use

Use when building apps with Turso/LibSQL, implementing embedded replicas, designing multi-tenant database architectures, or using SQLite at the edge.

Examples

Edge-first app

Configure embedded replicas for fast reads

Set up Turso with embedded replicas in my Next.js app: configure @libsql/client for local reads, Drizzle ORM schema, and sync from the remote primary on writes

Multi-tenant

Database-per-tenant architecture

Implement a multi-tenant SaaS with Turso database-per-tenant: create databases on signup, route requests to the right database, and manage schema migrations across all tenant databases