Product
SQLite Extensions
Product
SQLite Extensions
Learn how to use SQLite extensions with Turso.
Turso comes loaded with extensions that provide additional functionality to SQLite. Some plans will have more extensions preloaded.
If you’re looking to enable vector extensions, you should instead consider using the native libSQL vector datatype.
Preloaded Extensions
The following extensions are always-on and available:
| Extension | Version | Description |
|---|---|---|
| JSON | Built-in | Work with JSON data in SQLite. |
| FTS5 | Built-in | Full-text search and indexing. |
| R*Tree | Built-in | Indexing and querying spatial data. |
| SQLean Crypto | 0.24.1 | Hashing, message digest, encoding, and decoding. |
| SQLean Fuzzy | 0.24.1 | Fuzzy string matching and phonetics. A fork of Spellfix1 with improvements. |
| SQLean Math | 0.24.1 | Advanced mathematical calculations. |
| SQLean Stats | 0.24.1 | Common statistical functions with SQLite. |
| SQLean Text | 0.24.1 | String manipulation (reverse, split) with SQLite. |
| SQLean UUID | 0.24.1 | Limited support for RFC 4122 compliant UUIDs. |
Optional Extensions
The following extensions are also enabled in addition to the preloaded extensions on databases using the Fly Cloud Provider (Pro & Enterprise).
| Extension | Version | Description |
|---|---|---|
| SQLean Regexp | 0.24.1 | Regular expressions with SQLite. |
| sqlite-vec | 0.1.3 | The Vector Search successor to sqlite-vss. |