spences10

MCP Memory Sqlite — AI skill for Claude Code

AI community

A personal knowledge graph and memory system for AI assistants using SQLite with optimized text search.

How to install MCP Memory Sqlite

This entry records only its repository, not the path inside it, so there is no exact command to give. Open spences10/mcp-memory-sqlite and copy the folder into ~/.claude/skills/, or the file into ~/.claude/agents/.

What MCP Memory Sqlite does

A personal knowledge graph and memory system for AI assistants using SQLite with optimized text search. Perfect for giving Claude (or any MCP-compatible AI) persistent memory across conversations!

Alternatives in AI

  • Wiki Graph — Build the LLM Wiki knowledge graph 2.3k ★
  • Nocturne Memory — A lightweight, rollbackable, and visual Long-Term Memory Server for MCP Agents 1.3k ★
  • OpenContext — A personal context store for AI agents and assistants—reuse your existing coding agent CLI (Codex/Claude/OpenC 1.1k ★

README

mcp-memory-sqlite

A personal knowledge graph and memory system for AI assistants using SQLite with optimized text search. Perfect for giving Claude (or any MCP-compatible AI) persistent memory across conversations!

Why Use This?

Give your AI assistant a memory! This tool lets Claude (or other AI assistants) remember entities, concepts, and their relationships across conversations. Perfect for:

  • 📚 Personal Knowledge Management - Build your own knowledge graph
  • 🤖 AI Assistant Memory - Help Claude remember important information about your projects, preferences, and context
  • 🔗 Relationship Tracking - Connect ideas, people, projects, and concepts
  • 🔍 Smart Text Search - Find information using flexible, relevance-ranked text search

Features

  • 100% Local & Private: All your data stays on your machine
  • Easy Setup: Works out-of-the-box with Claude Desktop
  • Flexible Text Search: Case-insensitive search with fuzzy matching that handles different naming conventions
  • Relevance Ranking: Results prioritized by name match > type match > observation match
  • Smart Deduplication: Automatically prevents duplicate relationships
  • Context-Optimized: Designed specifically for LLM context efficiency - no unnecessary data bloat
  • Simple API: Intuitive tools for creating, searching, and managing your knowledge graph

Quick Start

**For Claude Desktop users** (recommended):

Add this to your Claude Desktop config:

{
	"mcpServers": {
		"memory": {
			"command": "npx",
			"args": ["-y", "mcp-memory-sqlite"]
		}
	}
}

That's it! Claude can now remember things across conversations.

Installation

If you want to use it in your own project:

npm install mcp-memory-sqlite
# or
pnpm add mcp-memory-sqlite

Configuration

**Optional**: Customize the database location with an environment variable:

  • SQLITE_DB_PATH: Where to store your data (default: ./sqlite-memory.db)

MCP T