Extensions are experimental. Join us on Discord to add your suggestions and feedback.

​
Default Extensions

The extensions enabled by default in all databases are:

JSON

Work with JSON data in SQLite.

Full-Text Search

Full-text search and indexing.

R*Tree

Indexing and querying spatial data.

​
Supported Extensions

You can enable the following extensions when creating a new database using the CLI or API:

Vector Similarity Search

Vector search capabilities based on Faiss.

SQLean Crypto

Hashing, message digest, encoding, and decoding.

SQLean Fuzzy

Fuzzy string matching and phonetics. A fork of Spellfix1 with improvements.

SQLean Math

Advanced mathematical calculations.

SQLean Regexp

Regular expressions with SQLite.

SQLean Stats

Common statistical functions with SQLite.

SQLean Text

String manipulation (reverse, split) with SQLite.

SQLean Unicode

Case-insensitive string comparison for Unicode strings.

SQLean UUID

Limited support for RFC 4122 compliant UUIDs.

​
Usage

You can enable all extensions when creating a new database using the CLI or API:

turso db create [database-name] --enable-extensions

If you already have a group created with extensions disabled, you can update all databases in a group to enable extensions:

turso group update <group-name> --extensions all

Was this page helpful?

Local DevelopmentlibSQL