Skip to main content
Glama
PascalNoisette

MCP Memory

by PascalNoisette
OverviewSchemaSourceRelated ServersDiscussionsAdmin
Python
Local

MCP Memory — Open code / Kilo Code Session Recall

MCP server providing read-only access to Kilo Code and Opencode server conversations stored in the local SQLite database. Query projects, list sessions, read conversation history, and search across all messages with keyword recall.

Available Tools

Tool

Description

list_projects

List all Kilo Code projects

list_sessions

List sessions within a project (paginated)

read_messages

Read conversation messages from a session (paginated)

recall_session

Full-text keyword search across all session messages

Related MCP server: Conversation Search MCP Server

Quick start : MCP Client Configuration

mkdir -p /home/opencode/workspace/
cd /home/opencode/workspace/
git clone github.com/PascalNoisette/netpascal_mcp_memory
pip install -r requirements.txt
{
  "mcp": {
    "servers": {
      "memory": {
        "type": "local",
        "enabled": true,
        "command": [
          "python3",
          "/home/opencode/workspace/netpascal_mcp_memory/server.py"
        ],
        "environment": {
          "DATABASE_PATH": "/home/opencode/.local/share/opencode/opencode.db:rw",
          "SERVER_NAME":"memory"
        }
      }
  }
}

Environment variables:

  • DATABASE_PATH (required) Primary opencode DB path.

  • SERVER_NAME (required) Unique tag for this MCP instance (e.g. 'prod', 'dev').

  • FTS_DB_PATH (optional) Shared FTS5 index path, otherwise DATABASE_PATH is used with a default suffix

Architecture

MCP read primary opencode database (via DATABASE_PATH) and writes to a shared FTS index (via FTS_DB_PATH). The SERVER_NAME env var identifies this instance so that rows in the shared FTS index are tagged and can be filtered.

┌────────────────────────────────────┐ 
│  MCP instance                      │s
│  SERVER_NAME=memory                │
│                                    │
│  DB:             (opencode.db)     │
│                       │            │ 
│  ┌────────┐           │            │
│  │  part  │───────────┼────────────┤─────────────────────────────
│  └────────┘           │            │                             │
│  ┌────────┐           │            │                             │
│  │session │────────── ┼            │                             │
│  └────────┘                        │                             │
└────────────────────────────────────┘                             │            
                                                                   │
FTS Database created (opencode.db_fts.db)                          │
┌──────────────────────────────────────────────────────────────┐   │
│  part_fts  (FTS5)  ← includes a "server" column for tagging  │ ◄─┘
│  part_fts_meta (per-server watermarks)                       │
└──────────────────────────────────────────────────────────────┘

This server cannot be deployed

One endpoint for every MCP toolRayrun runs every MCP server behind one URL and holds the credentials. Each call is decided per client, tool, and argument, then recorded.ray.runAd

Maintenance

ActivityMaintained
ResponsivenessNo issues

Resources

Related MCP Connectors

Related MCP Servers

  • Cursor DB MCP Server

    TaylorChen
    A
    license
    Not graded
    quality
    D
    maintenance
    Enables querying, searching, and analyzing Cursor IDE conversation history from SQLite workspaceStorage databases. Supports exporting chat data in multiple formats and provides workspace utilities for managing conversation data across projects.
    MIT

  • Conversation Search MCP Server

    cordlesssteve
    -
    license
    Not graded
    quality
    Not graded
    maintenance
    Enables comprehensive search and analysis of Claude Code conversation history using full-text search, optional semantic vector search, and conversation management tools. Provides fast SQLite-based indexing with role-based filtering, project organization, and hybrid search capabilities combining keyword and semantic matching.
    -

  • mcp-copilotcli-history

    MicroMichaelIE
    A
    license
    A
    quality
    C
    maintenance
    Enables searching and analyzing GitHub Copilot's conversation history stored locally, providing tools for full-text search, session listing, statistics, and file-based retrieval.
    6
    4
    MIT