Skip to content
Brain Framework

SQLite Adapter

The SQLite Adapter provides embedded database functionality, ideal for development and single-instance deployments. Visit Elizaos SQLite Adapter docs for more details.

Installation

Section titled “Installation”
  1. Install required packages:
    Terminal window
    npm i github:elizaos-plugins/adapter-sqlite

Basic Setup

Section titled “Basic Setup”
import { AgentBuilder } from "@iqai/agent";
import SqliteAdapter from "@elizaos/adapter-sqlite";




const databaseAdapter = new SqliteDatabaseAdapter();


const agent = new AgentBuilder()
  .withDatabase(databaseAdapter)
  // ... other configuration
  .build();

Key Features

Section titled “Key Features”
  • ✔️ Built-in caching
  • ✔️ BLOB storage support
  • ✔️ Zero setup requirements

Collections Structure

Section titled “Collections Structure”

The adapter automatically manages these collections:

  • rooms
  • participants
  • accounts
  • memories
  • knowledge

Additional metadata is stored as JSON within these collections.

Best Practices

Section titled “Best Practices”
  • ✔️ Use for development and testing
  • ✔️ Monitor database file size