Turso + LibSQL + Drizzle: SQLite at the Edge in 2026

curl -sSfL https://get.tur.so/install.sh | bash
turso auth login
turso db create my-app
turso db show my-app --url
turso db tokens create my-app

npm install @libsql/client drizzle-orm drizzle-kit

// db/schema.ts
import { sqliteTable, text, integer } from "drizzle-orm/sqlite-core";

export const users = sqliteTable("users", {
  id: text("id").primaryKey(),
  email: text("email").notNull().unique(),
  name: text("name").notNull(),
  createdAt: integer("created_at", { mode: "timestamp" }).notNull(),
});

export const posts = sqliteTable("posts", {
  id: text("id").primaryKey(),
  userId: text("user_id").notNull().references(() => users.id),
  title: text("title").notNull(),
  body: text("body").notNull(),
  publishedAt: integer("published_at", { mode: "timestamp" }),
});

// db/index.ts
import { createClient } from "@libsql/client";
import { drizzle } from "drizzle-orm/libsql";
import * as schema from "./schema";

const client = createClient({
  url: process.env.TURSO_DATABASE_URL!,
  authToken: process.env.TURSO_AUTH_TOKEN!,
});
export const db = drizzle(client, { schema });

// Reads hit local SQLite. Writes go to the Turso primary.
const client = createClient({
  url: "file:./local.db",
  syncUrl: process.env.TURSO_DATABASE_URL!,
  authToken: process.env.TURSO_AUTH_TOKEN!,
  syncInterval: 60,
});
await client.sync();
export const db = drizzle(client, { schema });

async function getTenantDb(tenantId: string) {
  const client = createClient({
    url: `libsql://${tenantId}-myapp.turso.io`,
    authToken: process.env.TURSO_AUTH_TOKEN!,
  });
  return drizzle(client, { schema });
}

// Complete data isolation -- physical separation
const tenantDb = await getTenantDb(user.tenantId);
const data = await tenantDb.select().from(posts);