{"id":"turso-api","name":"Turso","homepage":"https://docs.turso.tech","repo_url":"https://github.com/tursodatabase/libsql","category":"database","subcategories":["sqlite","edge","serverless","multi-tenant"],"tags":["turso","sqlite","libsql","edge-database","rest-api","multi-tenant","embedded","serverless","replication","database-per-user"],"what_it_does":"Turso is an edge-deployed database platform built on libSQL — an open-source fork of SQLite with extensions for network access, replication, and encryption. It enables the database-per-user or database-per-tenant architecture at scale: each user or tenant gets a fully isolated SQLite database deployed to the nearest edge location globally. The Platform API manages organizations, databases, groups, and auth tokens. The HTTP API (Hrana protocol) executes SQL queries against individual databases. Turso is ideal for multi-tenant SaaS applications, mobile offline-first apps, and edge computing use cases where low latency and data isolation are paramount.","use_cases":["Per-user or per-tenant SQLite database provisioning for multi-tenant SaaS at scale","Edge-deployed databases that serve queries from the nearest PoP globally for sub-5ms latency","Mobile and offline-first applications using the embedded libSQL driver","Lightweight serverless functions with a local SQLite database at the edge (e.g., Cloudflare Workers)","AI agent persistent memory using SQLite as a per-agent database with full isolation","Rapid prototyping with SQLite compatibility — no schema migration tools required for simple schemas"],"not_for":["Heavy analytical workloads requiring complex joins over billions of rows (SQLite is single-writer)","Applications requiring PostgreSQL-specific features: JSONB operators, arrays, partitioning, or complex stored procedures","High-concurrency write-heavy workloads — SQLite serializes writes; Turso's replication is eventually consistent","Very large single-database workloads (>10GB practical SQLite limit for performance)"],"best_when":"An agent needs to provision or query SQLite-compatible databases at the edge, especially for multi-tenant architectures where each tenant has a fully isolated database with global replication and no operational overhead.","avoid_when":"You need PostgreSQL semantics, high-concurrency writes, or very large single-database workloads beyond SQLite's practical limits.","alternatives":[{"id":"neon-api","reason":"Neon uses PostgreSQL instead of SQLite — better for complex schemas and SQL features"},{"id":"supabase-api","reason":"Supabase provides PostgreSQL with full platform features; better for team collaboration"},{"id":"planetscale-api","reason":"PlanetScale offers MySQL with horizontal scaling; better for traditional RDBMS at scale"}],"af_score":59.9,"security_score":72.0,"reliability_score":null,"package_type":"mcp_server","discovery_source":["github"],"priority":"low","status":"evaluated","version_evaluated":"current","last_evaluated":"2026-03-01T09:50:06.315735+00:00","performance":{"latency_p50_ms":3,"latency_p99_ms":25,"uptime_sla_percent":99.9,"rate_limits":"Not strictly documented per plan; scales with tier. Row reads and writes are metered and reset monthly.","data_source":"llm_estimated","measured_on":null}}