Triplit

Triplit provides a full-stack database where the client SDK and the server stay in sync automatically — write to the local client DB, changes replicate to the server and all connected clients in real-time. Built-in schema (TypeScript-defined collections and fields), offline support (client continues to work without network), and access control rules enforced by the server. For agents: the REST API enables server-side data access; the TypeScript client SDK handles client-side sync. Strong fit for collaborative real-time apps where you want a single data layer spanning client and server. Self-hostable via Docker or Triplit Cloud. MIT license. Confidence is docs-derived.

TypeScript SDK (@triplit/client): const client = new TriplitClient({serverUrl, token}); client.insert("todos", {text: "...", done: false}); client.query("todos").where("done", "=", false).subscribe(handler). Subscriptions automatically reflect server-synced changes. client.update("todos", id, {done: true}) writes to local + syncs to server. REST API: POST /api/insert, POST /api/fetch, POST /api/update, POST /api/delete — for server-side operations without client SDK. Schema defined in TypeScript: const schema = {todos: {schema: S.Schema({text: S.String(), done: S.Boolean()})}}. Access control: rules defined in schema (client.query blocked by rules enforced server-side).

Token auth: JWT-based. Service token (full server access) for server-side REST API calls; external auth provider JWT (with configured secret) for client connections. Token from Triplit Cloud dashboard or generated for self-hosted. HTTPS enforced on Triplit Cloud; operator-managed for self-hosted. Access control rules in schema define what each JWT role can read/write. No OAuth2 — integrate with Clerk, Auth0, or custom JWT provider for user auth.

Client SDK: optimistic updates (write appears immediately in local cache; rolls back if server rejects). Conflict resolution: last-write-wins based on server timestamp. Offline: changes queued locally, flushed when reconnected. REST API: standard HTTP status codes with JSON error bodies. 400 for schema validation failures. Server rejects violate access control rules — client SDK surfaces as subscription error. Triplit Cloud uptime at status.triplit.dev. Self-hosted: operator-managed. Active development — check changelog before upgrading (API is still evolving).

triplit.dev/docs covers schema definition, client SDK API, queries/filters/subscriptions, access control, server deployment, and framework integration (React, SvelteKit, Vue, SolidJS). Getting started: npx create-triplit-app scaffolds a project with local Triplit server in under 5 minutes. Triplit Cloud for hosted server. MIT license (GitHub: aspen-cloud/triplit, actively maintained). Community via Triplit Discord (team-responsive) and GitHub. TypeScript-first approach means full IDE autocomplete for queries and schema types.