Turso Edge DB Explorer

Turso is an edge-native database platform built on libSQL, a fork of SQLite. It adds a server mode to SQLite, enabling remote connections over HTTP or WebSockets. Key additions: network access, multi-tenancy (thousands of databases), replication (embedded replicas), and a managed cloud platform — while keeping full SQLite compatibility for your SQL syntax.

@libsql/client is the official JavaScript/TypeScript client for libSQL databases. It supports three connection modes: WebSocket (libsql://) for full features including interactive transactions, HTTP (https://) for edge/serverless runtimes like Cloudflare Workers, and in-memory (:memory:) or local file (file:./local.db) for testing and development.

execute() runs a single SQL statement and returns results. batch() runs multiple statements in a single network round-trip, all within an implicit transaction — best for related writes. transaction() opens an interactive transaction object where you can conditionally run statements based on intermediate results, then commit() or rollback() — best for read-then-write patterns like balance checks.

Yes. Use drizzle-orm/libsql with the @libsql/client for full ORM support. Define your schema using SQLite column types (sqliteTable, text, integer, real, blob). Drizzle's query builder generates type-safe SQLite-compatible SQL that works perfectly with Turso's libSQL engine.

Embedded replicas let you run a local SQLite file that continuously syncs with a remote Turso database. Reads are served from the local file (microsecond latency, zero network cost), while writes are forwarded to the primary. Ideal for edge deployments where you want fast local reads with cloud-backed durability. Initialize with the syncUrl and authToken options in createClient().

Turso/libSQL is SQLite-based (great for simple schemas, low write concurrency, edge affinity). Neon is serverless PostgreSQL (complex queries, extensions, strong ACID). PlanetScale is serverless MySQL with Git-like branching (large-scale MySQL apps). Choose Turso for edge apps with many small databases (multi-tenant SaaS), Neon for relational complexity, PlanetScale for MySQL-heavy teams.