Store adapters

Choose the adapter that matches the database layer your application already operates.

Package	Use when
@anvia/memory-prisma	The application already uses Prisma and owns Prisma migrations.
@anvia/memory-drizzle	The application uses Drizzle with Postgres.
@anvia/memory-postgres	The application owns a Postgres pool without an ORM.
@anvia/memory-sqlite	Local or small deployments need durable SQLite storage.

All official adapters implement MemoryStore, maintain ordered message rows, support scoped conversations, and expose compaction and read-only inspection capabilities.

Prisma

Generate the models, review them, and apply them through the application's normal migration workflow.

pnpm add @anvia/memory-prisma @anvia/core @prisma/client
npx @anvia/memory-prisma init
npx @anvia/memory-prisma init --write
npx prisma validate
npx prisma migrate dev --name add_anvia_memory

const memory = createPrismaMemoryStore(prisma, {
  scope: { metadataKeys: ['tenantId'] },
})

Drizzle

Add drizzleMemorySchema to the Drizzle schema and generate a migration normally.

const memory = createDrizzleMemoryStore(db)

Postgres

const memory = await createPostgresMemoryStore({
  connectionString: process.env.DATABASE_URL,
})

The adapter creates its tables by default. Set createIfMissing: false when migrations own schema creation.

SQLite

const memory = createSqliteMemoryStore({
  path: 'data/anvia-memory.sqlite',
  scope: { metadataKeys: ['tenantId'] },
})

SQLite uses Node's built-in node:sqlite driver and creates its tables by default.