Turso

Docs

• Audit Filesystem Changes: Inspect and analyze what an agent did during a session
• MCP Server Integration: Use AgentFS as an MCP server for AI assistants
• NFS Server Access: Export AgentFS over the network via NFS
• Copy-on-Write Overlays: How copy-on-write isolation works in AgentFS
• Agentic Coding: Run AI coding agents safely with AgentFS sandboxing
• Shared Agent Sessions: Share state between multiple agents and terminals with named sessions
• Sync with Turso Cloud: Synchronize agent filesystems with remote Turso databases
• Installation: Install the AgentFS CLI on Linux, macOS, and Windows
• AgentFS: A filesystem for AI agents, built on Turso
• CLI Reference: Complete reference for the AgentFS command-line interface
• Python SDK: AgentFS Python SDK for building AI agents
• Rust SDK: Complete reference for the AgentFS Rust SDK
• TypeScript/JavaScript SDK: Complete reference for the AgentFS TypeScript and JavaScript SDK
• List Audit Logs: Return the audit logs for the given organization, ordered by the created_at field in descending order.
• Authentication
• Retrieve Database Configuration: Retrieve an individual database configuration belonging to the organization or user.
• Create Database: Creates a new database in a group for the organization or user.
• Generate Database Auth Token: Generates an authorization token for the specified database.
• Delete Database: Delete a database belonging to the organization or user.
• Invalidate All Database Auth Tokens: Invalidates all authorization tokens for the specified database.
• List Databases: Returns a list of databases belonging to the organization or user.
• List Database Instances: Returns a list of instances of a database. Instances are the individual primary or replica databases in each region defined by the group.
• Retrieve Database: Returns a database belonging to the organization or user.
• Retrieve Database Instance: Return the individual database instance by name.
• Retrieve Database Stats: Fetch the top queries of a database, including the count of rows read and written.
• Update Database Configuration: Update a database configuration belonging to the organization or user.
• Upload Database
• Retrieve Database Usage: Fetch activity usage for a database in a given time period.
• Retrieve Group Configuration: Retrieve an individual group configuration belonging to the organization or user.
• Create Group: Creates a new group for the organization or user.
• Create Group Auth Token: Generates an authorization token for the specified group.
• Delete Group: Delete a group belonging to the organization or user.
• Invalidate All Group Auth Tokens: Invalidates all authorization tokens for the specified group.
• List Groups: Returns a list of groups belonging to the organization or user.
• Retrieve Group: Returns a group belonging to the organization or user.
• Transfer Group: Transfer a group to another organization that you own or a member of.
• Unarchive Group: Unarchive a group that has been archived due to inactivity.
• Update Group Configuration: Update a group configuration belonging to the organization or user.
• Turso Platform API: Programmatically manage databases, groups, organizations, and tokens with the Turso Platform API.
• Closest Region: Returns the closest region to the user's location.
• List Locations: Returns a list of locations where you can create or replicate databases.
• Create Invite: Invite a user to an organization. If the user isn't already registered with Turso, they will receive a signup link. If an existing pending invite exists for the same email, it will be replaced.
• Delete Invite: Delete a pending invite for the organization by email.
• List Invites: Returns a list of pending invites for the organization.
• List Invoices: Returns a list of invoices for the organization.
• List Organizations: Returns a list of organizations the authenticated user owns or is a member of.
• Add Member: Add an existing Turso user to an organization.
• List Members: Returns a list of members part of the organization.
• Remove Member: Remove a user from the organization by username.
• Retrieve Member: Retrieve details of a specific member in the organization.
• Update Member Role: Update the role of an organization member. Only organization admins or owners can perform this action.
• List Plans: Returns a list of available plans and their quotas.
• Retrieve Organization: Retrieve details of a specific organization.
• Current Subscription: Returns the current subscription details for the organization.
• Update Organization: Update an organization you own or are a member of.
• Organization Usage: Fetch current billing cycle usage for an organization.
• Quickstart: Get started with Turso API in a few easy steps.
• Errors
• Create API Token: Returns a new API token belonging to a user.
• List API Tokens: Returns a list of API tokens belonging to a user.
• List Organization API Tokens: Returns the API tokens scoped to this organization (both organization-scoped and group-scoped). Unrestricted tokens are not returned here — manage those via GET /v1/auth/api-tokens.
• Revoke API Token: Revokes the provided API token belonging to a user.
• Revoke Organization API Token: Revokes a token scoped to this organization.
• Validate API Token: Validates an API token belonging to a user.
• Get Current User: Returns information about the currently authenticated user.
• auth api-tokens list
• auth api-tokens mint
• auth api-tokens revoke
• auth login
• auth logout
• auth signup
• auth token
• auth whoami
• Authentication
• contact bookmeeting
• contact feedback
• db create
• db destroy
• db export
• db import
• db inspect
• db list
• db locations
• db shell
• db show
• db tokens create
• db tokens invalidate
• dev
• group aws-migration abort
• group aws-migration info
• group aws-migration start
• group create
• group destroy
• group list
• group tokens create
• group tokens invalidate
• group transfer
• group unarchive
• group update
• Headless Mode
• Help
• Installation: Learn how to install the Turso CLI on Mac, Linux and Windows.
• Introduction
• org billing
• org create
• destroy
• org list
• org members add
• org members invite
• org members list
• org members rm
• org switch
• plan overages disable
• plan overages enable
• plan select
• plan show
• plan upgrade
• Upgrading: Update the Turso CLI to the latest version to benefit from all the latest features, and fixes.
• Durability Guarantees
• BYOK Encryption
• Limitations: Known limitations and differences when using SQLite on Turso Cloud.
• Migrate to Turso: Learn how to import your existing SQLite database to Turso.
• Private Endpoints: Learn how to configure private endpoints for your Turso Database on AWS.
• Connect to Turso using Dart
• Connect to Turso using Go
• Connect to Turso using Java
• Connect to Turso using JavaScript
• Connect to Turso using Python
• Connect to Turso using Rust
• AI & Embeddings: Vector Similarity Search is built into Turso and libSQL Server as a native feature.
• Attach Database (Deprecated): Attach and read data across multiple databases.
• Branching
• Data Edge (Deprecated): Allow your users to reach local replicas of your database, wherever they are.
• Embedded Replicas
• Turso + Linode by Akamai: Deploy a JavaScript/Rust app using Turso Cloud embedded replicas to Akamai.
• Embedded Replicas on Fly: Deploy a JavaScript app using Turso Cloud embedded replicas to Fly.io.
• Turso + Koyeb: Deploy a JavaScript/Rust app using Turso Cloud embedded replicas to Koyeb.
• Turso + Railway: Deploy a JavaScript/Rust app using Turso Cloud embedded replicas to Railway.
• Turso + Render: Deploy a JavaScript app using Turso Cloud embedded replicas to Render.
• Multi-DB Schemas (Deprecated): Create and share a single schema across multiple databases.
• Point-in-Time Recovery
• SQLite Extensions: Learn how to use SQLite extensions with Turso.
• Agent Databases
• AI Memory
• Code Indexing
• Content Caching
• Vector Search: Build semantic search, recommendation systems, and RAG workflows with native vector search in Turso.
• Usage & Billing
• Vercel: Use Turso with Vercel serverless and edge functions.
• Welcome to Turso: The small database to power your big dreams in the age of AI.
• libSQL: libSQL is a production-ready fork of SQLite, maintained by Turso.
• Local Development: Build locally using SQLite, libSQL Server or Turso.
• Quickstart: Welcome to Turso Cloud! Get started in minutes.
• Ruby on Rails + Turso: Set up Turso in your Ruby on Rails project in minutes.
• Turso Quickstart (ActiveRecord): Get started with Turso and ActiveRecord in a few simple steps.
• Authentication
• Authorization
• Fine-Grained Permissions
• External Auth Providers
• Platform Tokens
• Turso Examples (C)
• Turso Quickstart (C): Get started with Turso and C using the libSQL client in a few simple steps.
• C Reference: libSQL C Reference
• Examples
• Drift + Turso / LibSQL: Configure drift to work with libsql_dart
• Turso Quickstart (Flutter / Dart): Get started with Flutter and Dart using the libSQL client in a few simple steps
• Reference: libSQL Flutter / Dart Reference
• Examples
• Turso Quickstart (Go): Get started with Turso and Go in a few simple steps.
• Reference: Go Reference for Turso
• Turso Quickstart (SQL over HTTP): Get started with SQL over HTTP for Turso in a few simple steps.
• SQL over HTTP Reference
• Turso SDKs
• Turso Quickstart (Android): Get started with Turso and Android using the libSQL client in a few simple steps.
• Android Reference: libSQL Android Reference
• Examples
• Turso Quickstart (Laravel)
• Turso + Doctrine DBAL: Set up Turso in your PHP + Doctrine DBAL project in minutes
• Turso Quickstart (PHP): Get started with Turso and PHP using the libSQL client in a few simple steps.
• Reference: libSQL PHP Reference
• Examples
• Flask + Turso: Set up Turso in your Flask project in minutes
• SQLAlchemy + Turso: Configure SQLAlchemy to work with your Turso database
• Turso Quickstart (Python): Get started with Turso and Python in a few simple steps.
• Reference: Python Reference for Turso
• Turso Examples (Ruby)
• Turso Quickstart (Ruby): Get started with Turso and Ruby using the libSQL client in a few simple steps.
• Examples
• Turso + Actix: Set up Turso in your Actix project in minutes
• Turso + Axum: Set up Turso in your Axum project in minutes
• Turso + Rocket: Set up Turso in your Rocket project in minutes
• Tauri + Turso: Set up Turso in your Tauri project in minutes
• Toasty + Turso: Use Toasty, the async ORM from the Tokio project, with Turso Database.
• Turso Quickstart (Rust): Get started with Turso and Rust in a few simple steps.
• Reference: Rust Reference for Turso
• Turso Quickstart (Swift): Get started with Turso and Swift using the libSQL client in a few simple steps.
• Swift Reference: libSQL Swift Reference
• Examples
• Astro + Turso: Set up Turso in your Astro project in minutes.
• Elysia + Turso: Set up Turso in your Elysia project in minutes.
• Hono + Turso: Set up Turso in your Hono project in minutes.
• Next.js + Turso: Set up Turso in your Next.js project in minutes.
• Nuxt + Turso: Set up Turso in your Nuxt project in minutes
• Quasar + Turso: Set up Turso in your Quasar project in minutes
• Qwik + Turso: Set up Turso in your Qwik project in minutes
• Remix + Turso: Set up Turso in your Remix project in minutes
• SvelteKit + Turso: Set up Turso in your SvelteKit project in minutes
• Sentry: Trace slow queries and capture SQL errors with Sentry.
• Drizzle + Turso: Configure Drizzle to work with Turso
• Prisma + Turso: Configure Prisma to work with your Turso database
• Turso Quickstart (TypeScript): Get started with Turso and TypeScript in a few simple steps.
• Reference: TypeScript Reference for Turso
• Command-Line Options: CLI flags, arguments, and server modes for the tursodb command
• Getting Started: Install and use the Turso interactive SQL shell
• Shell Commands: Dot commands available in the Turso interactive SQL shell
• SQLite Compatibility: Turso compatibility with SQLite - supported features, known differences, and limitations
• Data Types: Storage classes, type affinity, STRICT tables, and custom types in Turso
• Experimental Features: How to enable experimental features in the CLI and each SDK
• Expressions: SQL expression syntax including literals, operators, CAST, CASE, and subqueries
• Extensions: Built-in and loadable extensions for additional SQL functions and virtual tables
• Aggregate Functions: Built-in aggregate functions for computing summary values over groups of rows
• Array Functions: Create, manipulate, and query array values
• Date and Time Functions: Functions for creating, formatting, and manipulating dates, times, and timestamps
• Full-Text Search: Full-text search with Tantivy-powered FTS indexes, scoring, and highlighting
• JSON Functions: Create, extract, modify, and aggregate JSON data
• Math Functions: Mathematical functions for trigonometry, logarithms, rounding, and arithmetic
• Scalar Functions: Built-in scalar functions for string manipulation, math, type inspection, and more
• Vector Functions: Create, compare, and manipulate vector embeddings
• Window Functions: Perform calculations across sets of rows related to the current row without collapsing them
• Multi-Process Access: Share a Turso database file between multiple OS processes using the experimental multiprocess WAL coordinator
• PRAGMA Statements: Database configuration and metadata commands in Turso
• ALTER TABLE: Modify the structure of an existing table by renaming, adding, or dropping columns
• ANALYZE: Collect statistics about indexes to help the query optimizer
• ATTACH DATABASE: Attach an additional database file to the current connection
• CREATE DOMAIN: Define a named constraint wrapper over a base type for use in STRICT tables
• CREATE INDEX: Create an index on one or more columns or expressions to accelerate queries
• CREATE MATERIALIZED VIEW: Create a materialized view that stores precomputed results and updates automatically
• CREATE TABLE: Create a new table in the database with column definitions, constraints, and table options
• CREATE TRIGGER: Create a trigger that executes statements automatically in response to table changes
• CREATE TYPE: Define a custom type with encoding, decoding, validation, operators, and defaults for use in STRICT tables
• CREATE VIEW: Create a named view based on a SELECT statement
• CREATE VIRTUAL TABLE: Create a virtual table backed by a module that provides custom data access
• DELETE: Remove rows from a table
• DETACH DATABASE: Remove an attached database from the current connection
• DROP DOMAIN: Remove a user-defined domain from the database
• DROP INDEX: Remove an index from the database
• DROP TABLE: Remove a table and all its data from the database
• DROP TRIGGER: Remove a trigger from the database
• DROP TYPE: Remove a user-defined custom type from the database
• DROP VIEW: Remove a view from the database
• EXPLAIN: Display the execution plan or bytecode for a SQL statement
• INSERT: Add new rows to a table using literal values, query results, or default values
• REPLACE: Insert a row, replacing any existing row that conflicts on a unique constraint
• SELECT: Query rows from one or more tables using filtering, joining, grouping, sorting, and set operations
• Transactions: Start, commit, and roll back transactions to group operations atomically
• UPDATE: Modify existing rows in a table
• INSERT ... ON CONFLICT (Upsert): Insert rows with automatic conflict resolution using DO NOTHING or DO UPDATE
• VACUUM: Rebuild the database file to reclaim unused space and defragment storage
• Checkpoint: How to compact the local WAL to bound disk usage while preserving sync state.
• Conflict Resolution: How Turso sync handles concurrent changes from multiple clients.
• Local Sync Server: Use the Turso CLI as a local sync server for development and testing without Turso Cloud.
• Partial sync: Sync only what you need. Faster cold starts and lower bandwidth by lazily fetching database pages on demand.
• Usage: How to enable and use sync with Turso across TypeScript, Python, and Go.
• Turso Cloud Documentation: Your fully managed SQLite-compatible database platform built on libSQL
• Change Data Capture
• Changelog
• Concurrent Writes
• Encryption
• Quickstart

OpenAPI Specs

• openapi

Optional

• Turso Homepage
• Discord
• GitHub