Skip to content
Brain Framework

SQLite Adapter

The SQLite Adapter provides embedded database functionality, ideal for development and single-instance deployments.

Installation

  1. Install required packages:
    Terminal window
    npm i github:elizaos-plugins/adapter-sqlite

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

  • ✔️ Built-in caching
  • ✔️ BLOB storage support
  • ✔️ Zero setup requirements

Collections Structure

The adapter automatically manages these collections:

  • rooms
  • participants
  • accounts
  • memories
  • knowledge

Additional metadata is stored as JSON within these collections.

Best Practices

  • ✔️ Use for development and testing
  • ✔️ Monitor database file size