SQLite Extensions

SQLite Cloud comes with the following pre-installed SQLite extensions. These extensions are available for use in your SQLite Cloud databases.

Extensions

  • SQLite-AI: Local LLM inference, embeddings, chat, audio transcription, and multimodal AI from SQL.
  • SQLite-Memory: Persistent, searchable memory for AI agents with hybrid vector and full-text retrieval.
  • SQLite-Vector: High performance vector storage and similarity search.
  • SQLite-Sync: Local-first data synchronization for offline-capable applications.
  • SQLite-Columnar: Column-oriented virtual tables and analytical helpers for local OLAP workloads.
  • SQLite-JS: JavaScript integration in SQLite for custom scalar, aggregate, window, and collation functions.
  • Full-text Search 5: Full-text search engine that allows you to search for text in a database.
  • JSON1: Allows you to easily store, query, and manipulate JSON data.
  • Math: Mathematical functions.
  • RTree: R-Tree index for storing and querying spatial data.
  • Geopoly: A set of functions for working with geospatial data. For a complete guide, see the comprehensive tutorial here.

In the future, we plan to allow users to install their own extensions. If you have a specific extension you would like to use, please let us know by adding to this issue.