« Back to Glossary Index

SQLite is a software library that provides a relational database management system. The lite in SQLite means light weight in terms of setup, database administration, and required resource. Unlike most other SQL databases, SQLite does not have a separate server process. SQLite reads and writes directly to ordinary disk files.


SQLite is often used in LLMs for logging, caching, or storing structured data that can be queried by the LLM. For example, LLMs can use SQLite to log all prompts and responses to a SQLite database, or to connect to a SQL database with LangChain SQLChain and answer questions over a SQL database.

« Back to Glossary Index