Turso CLI Has a Free API That Most Developers Dont Know About

#database #sqlite #serverless #webdev

Turso is SQLite for production — edge-hosted, replicated, and managed. The CLI lets you manage databases, create replicas, and run queries.

Setup

brew install tursodatabase/tap/turso
turso auth login
turso db create my-app
turso db show my-app  # Shows URL and token

Database Operations

# Create database with location
turso db create my-app --location iad

# Add replicas
turso db replicate my-app cdg  # Paris
turso db replicate my-app nrt  # Tokyo

# Shell
turso db shell my-app
> CREATE TABLE users (id INTEGER PRIMARY KEY, name TEXT, email TEXT);
> INSERT INTO users (name, email) VALUES (Alice, alice@example.com);
> SELECT * FROM users;

Client SDK

import { createClient } from "@libsql/client";

const db = createClient({
  url: process.env.TURSO_DATABASE_URL,
  authToken: process.env.TURSO_AUTH_TOKEN
});

const result = await db.execute("SELECT * FROM users WHERE id = ?", [1]);
const batch = await db.batch([
  "INSERT INTO users (name) VALUES (Bob)",
  "SELECT last_insert_rowid()"
]);