经 AI Skill Hub 精选评估,SQLite内存MCP服务器 获评「推荐使用」。这款MCP工具在功能完整性、社区活跃度和易用性方面表现出色,AI 评分 7.5 分,适合有一定技术背景的用户使用。
基于SQLite的MCP内存服务器,提供WAL并发安全、FTS5全文搜索和会话管理功能。支持Claude等AI助手的持久化记忆存储,适合需要为AI系统构建知识库和对话历史管理的开发者。
SQLite内存MCP服务器 是一款遵循 MCP(Model Context Protocol)标准协议的 AI 工具扩展。通过 MCP 协议,它可以让 Claude、Cursor 等主流 AI 客户端直接访问和操作外部工具、数据源和服务,实现 AI 能力的无缝扩展。无论是文件操作、数据库查询还是 API 调用,都可以通过自然语言在 AI 对话中直接触发,极大提升生产效率。
基于SQLite的MCP内存服务器,提供WAL并发安全、FTS5全文搜索和会话管理功能。支持Claude等AI助手的持久化记忆存储,适合需要为AI系统构建知识库和对话历史管理的开发者。
SQLite内存MCP服务器 是一款遵循 MCP(Model Context Protocol)标准协议的 AI 工具扩展。通过 MCP 协议,它可以让 Claude、Cursor 等主流 AI 客户端直接访问和操作外部工具、数据源和服务,实现 AI 能力的无缝扩展。无论是文件操作、数据库查询还是 API 调用,都可以通过自然语言在 AI 对话中直接触发,极大提升生产效率。
# 方式一:通过 Claude Code CLI 一键安装
claude skill install https://github.com/RMANOV/sqlite-memory-mcp
# 方式二:手动配置 claude_desktop_config.json
{
"mcpServers": {
"sqlite--mcp---": {
"command": "npx",
"args": ["-y", "sqlite-memory-mcp"]
}
}
}
# 配置文件位置
# macOS: ~/Library/Application Support/Claude/claude_desktop_config.json
# Windows: %APPDATA%/Claude/claude_desktop_config.json
# 安装后在 Claude 对话中直接使用 # 示例: 用户: 请帮我用 SQLite内存MCP服务器 执行以下任务... Claude: [自动调用 SQLite内存MCP服务器 MCP 工具处理请求] # 查看可用工具列表 # 在 Claude 中输入:"列出所有可用的 MCP 工具"
// claude_desktop_config.json 配置示例
{
"mcpServers": {
"sqlite__mcp___": {
"command": "npx",
"args": ["-y", "sqlite-memory-mcp"],
"env": {
// "API_KEY": "your-api-key-here"
}
}
}
}
// 保存后重启 Claude Desktop 生效
project field scopes entities; omit it to share across all projects@modelcontextprotocol/server-memory work identically in sqlite_memory, with 47 more tools available from companion serversfastmcp is required for MCP protocol; sqlite3 is Python stdlib. Optional orjson, sqlite-vec, and sentence-transformers add speed and semantic searchmemory.json knowledge graphs on first runUse this path when you want to verify the install before wiring Claude Code:
```bash git clone https://github.com/RMANOV/sqlite-memory-mcp.git cd sqlite-memory-mcp python -m venv .venv source .venv/bin/activate pip install -e ".[gui,dev]"
pip install -e .
```bash
mkdir -p ~/.claude/memory/bridge cd ~/.claude/memory/bridge git init
pip install PyQt6
```bash
```python
The search_nodes tool uses SQLite FTS5 with BM25 ranking. Queries support the standard FTS5 syntax:
```
```python
SQLITE_MEMORY_DB=/tmp/sqlite-memory-mcp-demo.db task-tray ```
If sqlite-memory-doctor is clean and the tray opens the demo DB, the local install is healthy enough to connect to Claude Code.
claude mcp add --scope user sqlite_unified -- python /path/to/unified_server.py
If you install the package instead of running from a checkout, the same servers are available as console scripts:
bash claude mcp add --scope user sqlite_memory -- sqlite-memory-core claude mcp add --scope user sqlite_tasks -- sqlite-memory-tasks claude mcp add --scope user sqlite_session -- sqlite-memory-session claude mcp add --scope user sqlite_bridge -- sqlite-memory-bridge claude mcp add --scope user sqlite_collab -- sqlite-memory-collab claude mcp add --scope user sqlite_entity -- sqlite-memory-entity claude mcp add --scope user sqlite_intel -- sqlite-memory-intel
claude mcp add --scope user sqlite_unified -- sqlite-memory-unified
Codex can use the same console-script servers:
bash codex mcp add sqlite_memory -- sqlite-memory-core codex mcp add sqlite_tasks -- sqlite-memory-tasks codex mcp add sqlite_session -- sqlite-memory-session codex mcp add sqlite_bridge -- sqlite-memory-bridge codex mcp add sqlite_collab -- sqlite-memory-collab codex mcp add sqlite_entity -- sqlite-memory-entity codex mcp add sqlite_intel -- sqlite-memory-intel
codex mcp add sqlite_unified -- sqlite-memory-unified ```
Prefer claude mcp add --scope user ... above and verify with claude mcp list; prefer codex mcp add ... and verify with codex mcp list for Codex. Some Claude Code builds no longer surface legacy ~/.claude/settings.json mcpServers entries in claude mcp list, and Codex uses its own ~/.codex/config.toml, so one client's manual block does not prove the other client can load the servers.
If you need a manual fallback, add these server/file pairs to your ~/.claude/settings.json under mcpServers:
| MCP server name | Python entry file | Purpose |
|---|---|---|
sqlite_memory | server.py | Core 9 drop-in memory tools |
sqlite_tasks | task_server.py | Task CRUD, digest, archive, overdue bump |
sqlite_session | session_server.py | Session recall, project search, health, resume |
sqlite_bridge | bridge_server.py | Cross-machine bridge sync, sharing review |
sqlite_collab | collab_server.py | Collaborator and public-knowledge workflows |
sqlite_entity | entity_server.py | Task-entity linking and merge helpers |
sqlite_intel | intel_server.py | Context assessment and enrichment tools |
sqlite_unified | unified_server.py | Optional all-in-one server that mounts the full 57-tool OSS stack |
Each server should share the same environment values:
"env": {
"SQLITE_MEMORY_DB": "/home/user/.claude/memory/memory.db",
"BRIDGE_REPO": "/home/user/.claude/memory/bridge"
}
The SQLITE_MEMORY_DB environment variable controls where the database is stored. If omitted, it defaults to ~/.claude/memory/memory.db. BRIDGE_REPO is only needed for bridge/collab flows.
The 57 OSS tools are grouped by MCP server:
| MCP server | Tool count | Tools |
|---|---|---|
sqlite_memory | 9 | create_entities, add_observations, create_relations, delete_entities, delete_observations, delete_relations, read_graph, search_nodes, open_nodes |
sqlite_session | 5 | session_save, session_recall, search_by_project, knowledge_health, resume_context |
sqlite_tasks | 8 | create_task_or_note, upsert_note_by_title_project, update_task, query_tasks, find_by_title, task_digest, archive_done_tasks, bump_overdue_priority |
sqlite_bridge | 7 | bridge_push, bridge_pull, bridge_status, bridge_doctor, assign_task, review_shared_tasks, process_recurring_tasks |
sqlite_collab | 9 | manage_collaborators, share_knowledge, review_shared_knowledge, request_publish, cancel_publish, search_public_knowledge, rate_public_knowledge, get_knowledge_ratings, update_verification |
sqlite_entity | 7 | link_task_entity, unlink_task_entity, get_task_links, get_entity_tasks, suggest_task_links, find_entity_overlaps, merge_entities |
sqlite_intel | 12 | assess_context, queue_clarification, record_human_answer, extract_candidate_claims, promote_candidate, build_context_pack, explain_impact, audit_memory, replay_memory, govern_fact, list_memory_issues, enrich_context |
You can extend your Claude Code session hook (~/.claude/hooks/session_context.py) to automatically recall recent sessions and inject them into the system prompt. See examples/session_context_hook.py for a reference implementation.
Tasks are organized into five sections following a GTD-style workflow:
| Section | Purpose |
|---|---|
inbox | Unprocessed tasks (default) |
today | Tasks to complete today |
next | Next actions queue |
someday | Deferred / maybe |
waiting | Blocked on someone else |
| Feature | sqlite-memory-mcp | Official MCP Memory | claude-mem0 | @pepk/sqlite | simple-memory | mcp-memory-service | memsearch | memory-mcp | MemoryGraph |
|---|---|---|---|---|---|---|---|---|---|
| Storage | SQLite | JSONL file | Mem0 Cloud | SQLite | JSON file | ChromaDB | Qdrant | SQLite | Neo4j |
| Concurrent 10+ sessions | WAL mode | file locks | cloud | no WAL | file locks | yes | yes | no | yes |
| Hybrid search (BM25 + vector) | yes (RRF fusion) | substring | no | no | no | vector only | vector only | no | Cypher only |
| Session tracking | built-in | no | no | no | no | no | no | no | no |
| Task management | built-in | no | no | no | no | no | no | no | no |
| Cross-project sharing | project field | no | no | no | no | no | no | no | no |
| Drop-in compatible | 9/9 tools | baseline | no | partial | no | no | no | partial | no |
| Setup effort | pip install | npx | API key + pip | pip | npx | Docker + pip | Docker + pip | pip | Docker + Neo4j |
| Dependencies | sqlite3 (stdlib) | Node.js | Cloud API | sqlite3 | Node.js | ChromaDB | Qdrant | sqlite3 | Neo4j |
GBrain — Garry Tan's structured knowledge layer for AI agents — launched 2026-04-10. It and sqlite-memory-mcp arrived independently at the same architectural conclusions: local-first storage, hybrid lexical + vector search fused via Reciprocal Rank Fusion, rule-based zero-LLM entity extraction, and a memory-consolidation cycle (GBrain calls it dream, sqlite-memory-mcp calls it reflect). When two solo founders converge on the same architecture, the design space is real.
The two projects ship different bets for different deployments. Public git history establishes that sqlite-memory-mcp's hybrid search shipped on 2026-03-18 (commit feat(search): add hybrid semantic search via sqlite-vec + RRF fusion) — twenty-three days before GBrain's first public release.
| Axis | GBrain | sqlite-memory-mcp |
|---|---|---|
| Initial public release | 2026-04-10 | **2026-03-01** (v0.1.0, 40-day lead) |
| Hybrid search (BM25 + vector + RRF) | shipped 2026-04-10 | **shipped 2026-03-18** (23-day lead) |
| Storage primitive | Markdown files in git + PGLite (embedded Postgres) + pgvector | Single SQLite file (FTS5 + sqlite-vec) + bridge git repo |
| Infrastructure footprint | Postgres runtime + git remote + LLM API | Single binary, single file, optional local embeddings |
| Embeddings | OpenAI API (network call per page write) | sentence-transformers, fully local |
| Memory consolidation | "dream cycle" (uses LLM) | reflect_audit Phase 0.5 — **deterministic SQL, no LLM cost** |
| Per-candidate review | atomic store-level output | per-row accept / reject / defer with apply snapshots |
| Cross-machine sync | git remote of the brain repo | bridge JSON + per-field LWW-Register CRDT (proven 2000+ tasks across 3 machines) |
| Source of truth | Markdown (human-readable) | SQLite + JSON bridge exports (machine-portable) |
| Air-gapped / regulated deployment | blocked by OpenAI embedding requirement | **fully supported** (no external network in hot path) |
| Companion stack | GStack (Garry's Claude Code setup) | MCP-native, works with any MCP client (Claude Code, Codex, Cursor) |
Where each one wins:
gbrain.io targets teams that don't want to run their own runtime.This is convergent validation, not derivative work. The architecture is decided; the markets diverge.
sqlite.ai is adjacent, not identical. It is a broader SQLite platform around cloud sync, extensions, AI inference, vector search, agent memory, and MCP tooling. Its related projects include sqlite-memory, a Markdown-based agent memory system, and sqlite-vector, a vector-search extension for embedded SQLite workloads.
sqlite-memory-mcp is focused on local-first MCP memory governance for coding agents, not on vector search as the center of the product:
- WAL-backed task, session, entity, and note memory in one local SQLite file - FTS5-first retrieval, with vector search as an optional backend - cross-machine bridge sync for private multi-machine workflows - event/provenance tracking for memory mutations - reviewable consolidation instead of silent memory rewriting - debate/protocol workflows for conductor, executor, and devil's advocate agents - an explicit OSS/premium runtime boundary with signed entitlement, manifest, and policy checks
sqlite-vec is therefore not the product center; it is one possible local retrieval backend. If sqlite-vector proves better for this workload, it can become a candidate backend. The harder problem this project targets is memory governance: how agents remember, revise, sync, debate, and promote durable context without turning the memory store into an unreviewable pile of contradictions.
SQLite 内存 MCP 服务器概述
SQLite 内存 MCP 服务器功能
环境依赖与系统要求
安装 SQLite 内存 MCP 服务器
使用 SQLite 内存 MCP 服务器
配置 SQLite 内存 MCP 服务器
SQLite 内存 MCP 服务器 API
SQLite 内存 MCP 服务器工作流
SQLite 内存 MCP 服务器常见问题
创新的MCP内存解决方案,采用SQLite+WAL确保安全,FTS5搜索功能完整。代码量小,但星数偏低,需更多社区验证。
AI Skill Hub 为第三方内容聚合平台,本页面信息基于公开数据整理,不对工具功能和质量作任何法律背书。
建议在沙箱或测试环境中充分验证后,再部署至生产环境,并做好必要的安全评估。
✅ MIT 协议 — 最宽松的开源协议之一,可自由商用、修改、分发,仅需保留版权声明。
AI Skill Hub 点评:SQLite内存MCP服务器 的核心功能完整,质量良好。对于Claude Desktop / Claude Code 用户来说,这是一个值得纳入个人工具库的选择。建议先在非生产环境试用,再逐步推广。
| 原始名称 | sqlite-memory-mcp |
| 原始描述 | 开源MCP工具:SQLite-backed MCP Memory Server with WAL concurrent safety, FTS5 search, session。⭐10 · Python |
| Topics | MCP协议AI内存SQLite并发安全全文搜索 |
| GitHub | https://github.com/RMANOV/sqlite-memory-mcp |
| License | MIT |
| 语言 | Python |
收录时间:2026-05-20 · 更新时间:2026-05-22 · License:MIT · AI Skill Hub 不对第三方内容的准确性作法律背书。
选择 Agent 类型,复制安装指令后粘贴到对应客户端