Skip to main content

Documentation Index

Fetch the complete documentation index at: https://docs.mcp-assistant.in/llms.txt

Use this file to discover all available pages before exploring further.

Zero-configuration persistent storage, faster than file-based JSON storage. SQLite provides a single-file relational database that is robust and requires no external server process. It is ideal for:
  • Single-instance production apps
  • Persistent development state
  • Applications that need ACID transactions without a full database server
  • Local deployments where Redis or Supabase would be unnecessary

​
Installation

SQLite support uses the optional better-sqlite3 peer dependency: 
npm install better-sqlite3
npm install -D @types/better-sqlite3

​
Configuration

# Explicit selection
MCP_TS_STORAGE_TYPE=sqlite

# SQLite DB path (optional, defaults to ./sessions.db)
MCP_TS_STORAGE_SQLITE_PATH=./data/mcp.db
If MCP_TS_STORAGE_TYPE is not set, the storage layer also auto-detects SQLite when MCP_TS_STORAGE_SQLITE_PATH is present.

​
Features

  • Persistent single-file database
  • Fast local reads and writes
  • ACID compliant transactions
  • No external service required
  • Automatic database and table setup

​
Usage

When MCP_TS_STORAGE_TYPE=sqlite or MCP_TS_STORAGE_SQLITE_PATH are present in your environment, the global sessions proxy automatically uses the SQLite backend. 
import { sessions } from '@mcp-ts/sdk/server';

// This will use SQLite automatically if env vars are set
const sessionList = await sessions.list('user-123');
console.log('Stored sessions:', sessionList);

​
Option 2: Manual Instantiation

If you want to manage the SQLite backend yourself: 
import { SqliteStorage } from '@mcp-ts/sdk/server';

const sqliteBackend = new SqliteStorage({ path: './data/mcp.db' });
await sqliteBackend.init(); // Sets up table if missing

const sessionList = await sqliteBackend.list('user-123');

​
Troubleshooting

​
better-sqlite3 is not installed

Install the optional dependency in the application that uses SQLite storage: 
npm install better-sqlite3

​
Database Path Is Not Writable

Make sure the parent directory exists and is writable by the process: 
mkdir -p ./data
touch ./data/mcp.db