Turso llms.txt

The actual file

Source Markdown

The saved llms.txt text, displayed as source. The file belongs to its publisher; the live endpoint may change.

Showing the first 18000 characters. Load the complete file to read the remainder.

# Turso

- [Welcome to Turso](https://docs.turso.tech/introduction.md): The small database to power your big dreams in the age of AI.
- [Quickstart](https://docs.turso.tech/tursodb/quickstart.md)
- [Connect to Turso using JavaScript](https://docs.turso.tech/connect/javascript.md)
- [Connect to Turso using Python](https://docs.turso.tech/connect/python.md)
- [Connect to Turso using Go](https://docs.turso.tech/connect/go.md)
- [Connect to Turso using Rust](https://docs.turso.tech/connect/rust.md)
- [Connect to Turso using Dart](https://docs.turso.tech/connect/dart.md)
- [Connect to Turso using Java](https://docs.turso.tech/connect/java.md)
- [Change Data Capture](https://docs.turso.tech/tursodb/cdc.md)
- [Concurrent Writes](https://docs.turso.tech/tursodb/concurrent-writes.md)
- [Encryption](https://docs.turso.tech/tursodb/encryption.md)
- [Vector Search](https://docs.turso.tech/guides/vector-search.md): Build semantic search, recommendation systems, and RAG workflows with native vector search in Turso.
- [Usage](https://docs.turso.tech/sync/usage.md): How to enable and use sync with Turso across TypeScript, Python, and Go.
- [Local Sync Server](https://docs.turso.tech/sync/local-sync-server.md): Use the Turso CLI as a local sync server for development and testing without Turso Cloud.
- [Partial sync](https://docs.turso.tech/sync/partial.md): Sync only what you need. Faster cold starts and lower bandwidth by lazily fetching database pages on demand.
- [Conflict Resolution](https://docs.turso.tech/sync/conflict-resolution.md): How Turso sync handles concurrent changes from multiple clients.
- [Checkpoint](https://docs.turso.tech/sync/checkpoint.md): How to compact the local WAL to bound disk usage while preserving sync state.
- [Agent Databases](https://docs.turso.tech/guides/agent-databases.md)
- [AI Memory](https://docs.turso.tech/guides/ai-memory.md)
- [Code Indexing](https://docs.turso.tech/guides/code-indexing.md)
- [Content Caching](https://docs.turso.tech/guides/content-caching.md)
- [Secrets Vault](https://docs.turso.tech/guides/secrets-vault.md)
- [Getting Started](https://docs.turso.tech/sql-reference/cli/getting-started.md): Install and use the Turso interactive SQL shell
- [Command-Line Options](https://docs.turso.tech/sql-reference/cli/command-line-options.md): CLI flags, arguments, and server modes for the tursodb command
- [Shell Commands](https://docs.turso.tech/sql-reference/cli/shell-commands.md): Dot commands available in the Turso interactive SQL shell
- [SQLite Compatibility](https://docs.turso.tech/sql-reference/compatibility.md): Turso compatibility with SQLite - supported features, known differences, and limitations
- [Data Types](https://docs.turso.tech/sql-reference/data-types.md): Storage classes, type affinity, STRICT tables, and custom types in Turso
- [Expressions](https://docs.turso.tech/sql-reference/expressions.md): SQL expression syntax including literals, operators, CAST, CASE, and subqueries
- [CREATE TABLE](https://docs.turso.tech/sql-reference/statements/create-table.md): Create a new table in the database with column definitions, constraints, and table options
- [ALTER TABLE](https://docs.turso.tech/sql-reference/statements/alter-table.md): Modify the structure of an existing table by renaming, adding, or dropping columns
- [CREATE INDEX](https://docs.turso.tech/sql-reference/statements/create-index.md): Create an index on one or more columns or expressions to accelerate queries
- [CREATE VIEW](https://docs.turso.tech/sql-reference/statements/create-view.md): Create a named view based on a SELECT statement
- [CREATE MATERIALIZED VIEW](https://docs.turso.tech/sql-reference/statements/create-materialized-view.md): Create a materialized view that stores precomputed results and updates automatically
- [CREATE TRIGGER](https://docs.turso.tech/sql-reference/statements/create-trigger.md): Create a trigger that executes statements automatically in response to table changes
- [CREATE TYPE](https://docs.turso.tech/sql-reference/statements/create-type.md): Define a custom type with encoding, decoding, validation, operators, and defaults for use in STRICT tables
- [CREATE DOMAIN](https://docs.turso.tech/sql-reference/statements/create-domain.md): Define a named constraint wrapper over a base type for use in STRICT tables
- [CREATE SEQUENCE](https://docs.turso.tech/sql-reference/statements/create-sequence.md): Define a named sequence generator for producing auto-incrementing numeric values
- [CREATE VIRTUAL TABLE](https://docs.turso.tech/sql-reference/statements/create-virtual-table.md): Create a virtual table backed by a module that provides custom data access
- [DROP TABLE](https://docs.turso.tech/sql-reference/statements/drop-table.md): Remove a table and all its data from the database
- [DROP INDEX](https://docs.turso.tech/sql-reference/statements/drop-index.md): Remove an index from the database
- [DROP VIEW](https://docs.turso.tech/sql-reference/statements/drop-view.md): Remove a view from the database
- [DROP TRIGGER](https://docs.turso.tech/sql-reference/statements/drop-trigger.md): Remove a trigger from the database
- [DROP TYPE](https://docs.turso.tech/sql-reference/statements/drop-type.md): Remove a user-defined custom type from the database
- [DROP DOMAIN](https://docs.turso.tech/sql-reference/statements/drop-domain.md): Remove a user-defined domain from the database
- [DROP SEQUENCE](https://docs.turso.tech/sql-reference/statements/drop-sequence.md): Remove a named sequence generator from the database
- [SELECT](https://docs.turso.tech/sql-reference/statements/select.md): Query rows from one or more tables using filtering, joining, grouping, sorting, and set operations
- [INSERT](https://docs.turso.tech/sql-reference/statements/insert.md): Add new rows to a table using literal values, query results, or default values
- [UPDATE](https://docs.turso.tech/sql-reference/statements/update.md): Modify existing rows in a table
- [DELETE](https://docs.turso.tech/sql-reference/statements/delete.md): Remove rows from a table
- [REPLACE](https://docs.turso.tech/sql-reference/statements/replace.md): Insert a row, replacing any existing row that conflicts on a unique constraint
- [INSERT ... ON CONFLICT (Upsert)](https://docs.turso.tech/sql-reference/statements/upsert.md): Insert rows with automatic conflict resolution using DO NOTHING or DO UPDATE
- [EXPLAIN](https://docs.turso.tech/sql-reference/statements/explain.md): Display the execution plan or bytecode for a SQL statement
- [Transactions](https://docs.turso.tech/sql-reference/statements/transactions.md): Start, commit, and roll back transactions to group operations atomically
- [ATTACH DATABASE](https://docs.turso.tech/sql-reference/statements/attach-database.md): Attach an additional database file to the current connection
- [DETACH DATABASE](https://docs.turso.tech/sql-reference/statements/detach-database.md): Remove an attached database from the current connection
- [ANALYZE](https://docs.turso.tech/sql-reference/statements/analyze.md): Collect statistics about indexes to help the query optimizer
- [REINDEX](https://docs.turso.tech/sql-reference/statements/reindex.md): Rebuild indexes from scratch
- [VACUUM](https://docs.turso.tech/sql-reference/statements/vacuum.md): Rebuild the database file to reclaim unused space and defragment storage
- [Scalar Functions](https://docs.turso.tech/sql-reference/functions/scalar.md): Built-in scalar functions for string manipulation, math, type inspection, and more
- [Aggregate Functions](https://docs.turso.tech/sql-reference/functions/aggregate.md): Built-in aggregate functions for computing summary values over groups of rows
- [Window Functions](https://docs.turso.tech/sql-reference/functions/window.md): Perform calculations across sets of rows related to the current row without collapsing them
- [Math Functions](https://docs.turso.tech/sql-reference/functions/math.md): Mathematical functions for trigonometry, logarithms, rounding, and arithmetic
- [Date and Time Functions](https://docs.turso.tech/sql-reference/functions/date-time.md): Functions for creating, formatting, and manipulating dates, times, and timestamps
- [JSON Functions](https://docs.turso.tech/sql-reference/functions/json.md): Create, extract, modify, and aggregate JSON data
- [Vector Functions](https://docs.turso.tech/sql-reference/functions/vector.md): Create, compare, and manipulate vector embeddings
- [Array Functions](https://docs.turso.tech/sql-reference/functions/array.md): Create, manipulate, and query array values
- [Full-Text Search](https://docs.turso.tech/sql-reference/functions/fts.md): Full-text search with Tantivy-powered FTS indexes, scoring, and highlighting
- [Multi-Process Access](https://docs.turso.tech/sql-reference/multiprocess-access.md): Share a Turso database file between multiple OS processes using the experimental multiprocess WAL coordinator
- [Extensions](https://docs.turso.tech/sql-reference/extensions.md): Built-in and loadable extensions for additional SQL functions and virtual tables
- [PRAGMA Statements](https://docs.turso.tech/sql-reference/pragmas.md): Database configuration and metadata commands in Turso
- [Experimental Features](https://docs.turso.tech/sql-reference/experimental-features.md): How to enable experimental features in the CLI and each SDK
- [Changelog](https://docs.turso.tech/tursodb/changelog.md)
- [Turso Cloud Documentation](https://docs.turso.tech/turso-cloud.md): Fully managed platform for SQLite-compatible databases. Deploy Turso, a rewrite of SQLite with concurrent writes and multi-user access built in, or libSQL, the battle-tested SQLite fork. No need to switch to Postgres for concurrency.
- [Quickstart](https://docs.turso.tech/quickstart.md): Welcome to Turso Cloud! Get started in minutes.
- [Local Development](https://docs.turso.tech/local-development.md): Build locally with a local Turso database, or a local libSQL server.
- [libSQL](https://docs.turso.tech/libsql.md): libSQL is a production-ready fork of SQLite, maintained by Turso.
- [Limitations](https://docs.turso.tech/cloud/limitations.md): Known limitations and differences when using SQLite on Turso Cloud.
- [Migrate to Turso](https://docs.turso.tech/cloud/migrate-to-turso.md): Learn how to import your existing SQLite database to Turso.
- [Durability Guarantees](https://docs.turso.tech/cloud/durability.md)
- [Private Endpoints](https://docs.turso.tech/cloud/private-endpoints.md): Learn how to configure private endpoints for your Turso Database on AWS.
- [Database Access Allow Rules](https://docs.turso.tech/cloud/allow-rules.md): Restrict database access to specific IP addresses, CIDR ranges, or AWS VPC endpoints.
- [BYOK Encryption](https://docs.turso.tech/cloud/encryption.md)
- [Usage & Billing](https://docs.turso.tech/help/usage-and-billing.md)
- [AI & Embeddings](https://docs.turso.tech/features/ai-and-embeddings.md): Vector Similarity Search is built into Turso and libSQL Server as a native feature.
- [Embedded Replicas](https://docs.turso.tech/features/embedded-replicas/introduction.md)
- [Embedded Replicas on Fly](https://docs.turso.tech/features/embedded-replicas/with-fly.md): Deploy a JavaScript app using [Turso Cloud embedded replicas](/features/embedded-replicas) to [Fly.io](https://www.fly.io/).
- [Turso + Render](https://docs.turso.tech/features/embedded-replicas/with-render.md): Deploy a JavaScript app using [Turso Cloud embedded replicas](/features/embedded-replicas) to [Render](https://render.com/).
- [Turso + Koyeb](https://docs.turso.tech/features/embedded-replicas/with-koyeb.md): Deploy a JavaScript/Rust app using [Turso Cloud embedded replicas](/features/embedded-replicas) to [Koyeb](https://www.koyeb.com/).
- [Turso + Railway](https://docs.turso.tech/features/embedded-replicas/with-railway.md): Deploy a JavaScript/Rust app using [Turso Cloud embedded replicas](/features/embedded-replicas) to [Railway](https://railway.app/).
- [Turso + Linode by Akamai](https://docs.turso.tech/features/embedded-replicas/with-akamai.md): Deploy a JavaScript/Rust app using [Turso Cloud embedded replicas](/features/embedded-replicas) to [Akamai](https://www.linode.com/).
- [Branching](https://docs.turso.tech/features/branching.md)
- [Point-in-Time Recovery](https://docs.turso.tech/features/point-in-time-recovery.md)
- [Recover Deleted Databases](https://docs.turso.tech/features/recover-deleted-databases.md): Restore databases and groups for up to five days after deletion.
- [SQLite Extensions](https://docs.turso.tech/features/sqlite-extensions.md): Learn how to use SQLite extensions with Turso.
- [Multi-DB Schemas (Deprecated)](https://docs.turso.tech/features/multi-db-schemas.md): Create and share a single schema across multiple databases.
- [Attach Database (Deprecated)](https://docs.turso.tech/features/attach-database.md): Attach and read data across multiple databases.
- [Data Edge (Deprecated)](https://docs.turso.tech/features/data-edge.md): Allow your users to reach local replicas of your database, wherever they are.
- [Turso SDKs](https://docs.turso.tech/sdk/introduction.md)
- [Authentication](https://docs.turso.tech/sdk/authentication.md)
- [Authorization](https://docs.turso.tech/sdk/authorization.md)
- [Platform Tokens](https://docs.turso.tech/sdk/authorization/tokens.md)
- [External Auth Providers](https://docs.turso.tech/sdk/authorization/jwks.md)
- [Fine-Grained Permissions](https://docs.turso.tech/sdk/authorization/fine-grained-permissions.md)
- [Turso Quickstart (SQL over HTTP)](https://docs.turso.tech/sdk/http/quickstart.md): Get started with SQL over HTTP for Turso in a few simple steps.
- [SQL over HTTP Reference](https://docs.turso.tech/sdk/http/reference.md)
- [Turso Quickstart (TypeScript)](https://docs.turso.tech/sdk/ts/quickstart.md): Get started with Turso and TypeScript in a few simple steps.
- [Reference](https://docs.turso.tech/sdk/ts/reference.md): TypeScript Reference for Turso
- [Examples](https://docs.turso.tech/sdk/ts/examples.md)
- [Next.js + Turso](https://docs.turso.tech/sdk/ts/guides/nextjs.md): Set up Turso in your Next.js project in minutes.
- [Remix + Turso](https://docs.turso.tech/sdk/ts/guides/remix.md): Set up Turso in your Remix project in minutes
- [Astro + Turso](https://docs.turso.tech/sdk/ts/guides/astro.md): Set up Turso in your Astro project in minutes.
- [Nuxt + Turso](https://docs.turso.tech/sdk/ts/guides/nuxt.md): Set up Turso in your Nuxt project in minutes
- [Qwik + Turso](https://docs.turso.tech/sdk/ts/guides/qwik.md): Set up Turso in your Qwik project in minutes
- [SvelteKit + Turso](https://docs.turso.tech/sdk/ts/guides/sveltekit.md): Set up Turso in your SvelteKit project in minutes
- [Quasar + Turso](https://docs.turso.tech/sdk/ts/guides/quasar.md): Set up Turso in your Quasar project in minutes
- [Elysia + Turso](https://docs.turso.tech/sdk/ts/guides/elysia.md): Set up Turso in your Elysia project in minutes.
- [Hono + Turso](https://docs.turso.tech/sdk/ts/guides/hono.md): Set up Turso in your Hono project in minutes.
- [Drizzle + Turso](https://docs.turso.tech/sdk/ts/orm/drizzle.md): Configure Drizzle to work with Turso
- [Prisma + Turso](https://docs.turso.tech/sdk/ts/orm/prisma.md): Configure Prisma to work with your Turso database
- [Sentry](https://docs.turso.tech/sdk/ts/integrations/sentry.md): Trace slow queries and capture SQL errors with Sentry.
- [Turso Quickstart (Rust)](https://docs.turso.tech/sdk/rust/quickstart.md): Get started with Turso and Rust in a few simple steps.
- [Reference](https://docs.turso.tech/sdk/rust/reference.md): Rust Reference for Turso
- [Examples](https://docs.turso.tech/sdk/rust/examples.md)
- [Turso + Actix](https://docs.turso.tech/sdk/rust/guides/actix.md): Set up Turso in your Actix project in minutes
- [Turso + Axum](https://docs.turso.tech/sdk/rust/guides/axum.md): Set up Turso in your Axum project in minutes
- [Turso + Rocket](https://docs.turso.tech/sdk/rust/guides/rocket.md): Set up Turso in your Rocket project in minutes
- [Tauri + Turso](https://docs.turso.tech/sdk/rust/guides/tauri.md): Set up Turso in your Tauri project in minutes
- [Toasty + Turso](https://docs.turso.tech/sdk/rust/orm/toasty.md): Use Toasty, the async ORM from the Tokio project, with Turso Database.
- [Turso Quickstart (Go)](https://docs.turso.tech/sdk/go/quickstart.md): Get started with Turso and Go in a few simple steps.
- [Reference](https://docs.turso.tech/sdk/go/reference.md): Go Reference for Turso
- [Examples](https://docs.turso.tech/sdk/go/examples.md)
- [Turso Quickstart (Python)](https://docs.turso.tech/sdk/python/quickstart.md): Get started with Turso and Python in a few simple steps.
- [Reference](https://docs.turso.tech/sdk/python/reference.md): Python Reference for Turso
- [Examples](https://docs.turso.tech/sdk/python/examples.md)
- [Flask + Turso](https://docs.turso.tech/sdk/python/guides/flask.md): Set up Turso in your Flask project in minutes
- [SQLAlchemy + Turso](https://docs.turso.tech/sdk/python/orm/sqlalchemy.md): Configure SQLAlchemy to work with your Turso database
- [Turso Quickstart (PHP)](https://docs.turso.tech/sdk/php/quickstart.md): Get started with Turso and PHP using the libSQL client in a few simple steps.
- [Reference](https://docs.turso.tech/sdk/php/reference.md): libSQL PHP Reference
- [Examples](https://docs.turso.tech/sdk/php/examples.md)
- [Turso + Doctrine DBAL](https://docs.turso.tech/sdk/php/orm/doctrine-dbal.md): Set up Turso in your PHP + Doctrine DBAL project in minutes
- [Turso Quickstart (Laravel)](https://docs.turso.tech/sdk/php/guides/laravel.md)
- [Turso Quickstart (Ruby)](https://docs.turso.tech/sdk/ruby/quickstart.md): Get started with Turso and Ruby using the libSQL client in a few simple steps.
- [Turso Examples (Ruby)](https://docs.turso.tech/sdk/ruby/examples.md)
- [Turso Quickstart (ActiveRecord)](https://docs.turso.tech/sdk/activerecord/quickstart.md): Get started with Turso and ActiveRecord in a few simple steps.
- [Ruby on