Skip to main content
Glama
mcp-sqlite-graph-memory

mcp-sqlite-graph-memory

by Luiguard

mcp-sqlite-graph-memory

License: MIT Python: 3.10+ MCP: 2024-11-05

Universal Model Context Protocol (MCP) server delivering dynamic SQLite-backed code knowledge graph memory for AI coding assistants and autonomous agents.

Automatically detects active workspaces, parses multi-language ASTs and structural dependencies into an isolated local SQLite knowledge graph, and exposes precision MCP tools to inspect symbols, calculate shortest call/import paths, and navigate code topologies.


๐ŸŒŸ Key Capabilities

  • Zero Runtime Dependencies: Written entirely in Python standard library (ast, sqlite3, json, re, hashlib, threading).

  • Dynamic Multi-Workspace Isolation: Generates deterministic SHA-256 hashes per workspace root; stores isolated SQLite databases in ~/.mcp-graph-memory/storage/graph_<hash>.db.

  • Incremental Stat Caching: Verifies file mtime and size to achieve sub-millisecond skips for unchanged files during re-indexing.

  • Multi-Language AST & Structural Parser:

    • Python: Classes, methods, functions, async functions, decorators, imports (from x import y, import z), inheritance hierarchies, call sites.

    • TypeScript / JavaScript: Classes, interfaces, types, functions, arrow functions, ES6 imports/exports, CommonJS require().

    • Go: Packages, imports, structs, interfaces, functions, methods.

    • Rust: Modules, structs, enums, traits, impl blocks, fn signatures.

    • C / C++ / Java / PHP / Ruby / Kotlin / Swift / Shell: Structs, classes, definitions.

  • Freeze & CPU Starvation Protection:

    • Non-blocking asynchronous daemon initialization.

    • Non-busy stdio transport (for raw_line in sys.stdin:).

    • Strict ignore list for node_modules/, .git/, .venv/, binary weights, and cache blobs.


Related MCP server: Synapse

๐Ÿ› ๏ธ MCP Tools Specification

Tool

Parameters

Description

graph_reindex

force (bool), format (str)

Scans and updates workspace graph memory incrementally or forced.

graph_query_symbol

query (str), type (str), exact (bool), format (compact|json)

Finds symbols with exact file paths, line ranges, signatures, and relations.

graph_find_paths

source (str), target (str), max_depth (int), format (compact|json)

Calculates shortest dependency / import / call paths between two files or symbols.

graph_get_neighbors

node_id_or_path (str), direction (in/out/both), relation, format (compact|json)

Inspects direct callers, callees, imports, and containment edges.

graph_structure_overview

depth (int), focus_path (str), format (compact|json)

Returns architectural metrics, hub modules, and directory tree.

graph_find_files

pattern (str), extension (str), contains_symbol (str), format (compact|json)

Finds workspace files by path pattern, extension, or contained symbols.


โšก Token Minimization & Compact Mode

All query tools support a format parameter:

  • format: "compact" (Recommended for AI agents): Formats symbols and graph edges into SCIP-style single-line text (e.g. [class] OrderService @ service.py#L16-L21 | sig: class OrderService), achieving up to 75% reduction in LLM context token consumption.

  • format: "json": Serializes responses into compact, unindented single-line JSON, cutting whitespace overhead by ~40%.


๐Ÿš€ Installation

git clone https://github.com/Luiguard/mcp-sqlite-graph-memory.git ~/.mcp-graph-memory
chmod +x ~/.mcp-graph-memory/server.py

๐Ÿ”Œ Integration Guides

1. Google Antigravity Integration

Add graph-memory to your global Antigravity MCP configuration file at ~/.gemini/config/mcp_config.json:

{
  "mcpServers": {
    "graph-memory": {
      "command": "python3",
      "args": [
        "/home/YOUR_USER/.mcp-graph-memory/server.py"
      ]
    }
  }
}

(Replace /home/YOUR_USER with your actual $HOME directory path or use an absolute path).

Option B: Workspace-Level Configuration

For per-project activation, place mcp_config.json inside your workspace root under .agents/mcp_config.json:

{
  "mcpServers": {
    "graph-memory": {
      "command": "python3",
      "args": [
        "${workspaceFolder}/.mcp-graph-memory/server.py"
      ]
    }
  }
}

2. Claude Desktop Integration

Locate your Claude configuration:

  • Linux: ~/.config/Claude/claude_desktop_config.json

  • macOS: ~/Library/Application Support/Claude/claude_desktop_config.json

  • Windows: %APPDATA%\Claude\claude_desktop_config.json

Add the server definition:

{
  "mcpServers": {
    "graph-memory": {
      "command": "python3",
      "args": [
        "/path/to/mcp-sqlite-graph-memory/server.py"
      ]
    }
  }
}

3. Cursor / VSCode / Windsurf Integration

In .cursor/mcp.json or .vscode/mcp.json:

{
  "mcpServers": {
    "graph-memory": {
      "command": "python3",
      "args": [
        "/path/to/mcp-sqlite-graph-memory/server.py"
      ]
    }
  }
}

๐Ÿ”ง Environment Variables

Variable

Default

Description

MCP_GRAPH_STORAGE_DIR

~/.mcp-graph-memory/storage

Persistent directory for SQLite databases (graph_<hash>.db).

MCP_WORKSPACE_ROOT

os.getcwd()

Fallback workspace path if client omits rootUri in initialize.


๐Ÿงช Verification & Testing

Execute the automated integration suite:

python3 test_server.py

๐Ÿ“„ License

MIT License - Copyright (c) 2026 Benjamin Leimer. See LICENSE for details.

Tool Schema Changelog

Recent tool additions, removals, and schema changes observed during successful MCP inspections.

Loading tool schema changelogโ€ฆ

    Related MCP Connectors

    Related MCP Servers

    • A
      license
      Not graded
      quality
      D
      maintenance
      Provides AI assistants with a structured, token-efficient map of a codebase's symbols, dependencies, and relationships via MCP tools like overview, query, and impact analysis.
      9
      MIT
    • F
      license
      Not graded
      quality
      D
      maintenance
      Provides structural code intelligence via 26 MCP tools, enabling AI assistants to query code symbols, dependencies, and call graphs accurately without file-pasting.
      -
    • A
      license
      Not graded
      quality
      C
      maintenance
      Enables AI coding agents to query a local, continuously updated symbol graph of a codebase, providing ranked search, caller/callee exploration, dependency paths, and git-diff impact analysis through MCP tools.
      14 npm
      Apache 2.0
    • A
      license
      B
      quality
      B
      maintenance
      Indexes a Python/JS/TS repository into a local SQLite knowledge graph so agents can trace callers, callees, imports, subclasses and covering tests, measure impact radius, rank diff risk, and summarize architecture without grepping files. Exposes these queries as MCP tools alongside an equivalent CLI, with no daemon, embeddings, or network access.
      10
      MIT