pgmnemo-mcp 0.8.0

MCP server wrapping pgmnemo ingest and recall for AI agent memory

pgmnemo-mcp

MCP server for pgmnemo — provenance-gated agent memory in PostgreSQL.

pgmnemo-mcp is an MCP server that exposes pgmnemo's ingest and recall capabilities as tool calls for AI agents and LLM hosts (Claude Desktop, Cursor, Zed, etc.).

Requirements

• Python ≥ 3.11
• A PostgreSQL database with pgmnemo extension installed (CREATE EXTENSION pgmnemo CASCADE;)
• pgmnemo ≥ 0.5.0 (install guide)

Install

pip install pgmnemo-mcp

Quick start

# Set the database URL
export DATABASE_URL="postgresql://user:pass@localhost/mydb"

# Start the MCP server (stdio transport)
pgmnemo-mcp

Add to Claude Desktop (~/Library/Application Support/Claude/claude_desktop_config.json):

{
  "mcpServers": {
    "pgmnemo": {
      "command": "pgmnemo-mcp",
      "env": {
        "DATABASE_URL": "postgresql://user:pass@localhost/mydb"
      }
    }
  }
}

Configuration

Variable	Default	Description
DATABASE_URL	postgresql://localhost/pgmnemo	libpq connection string
MCP_PORT	8765	Port for HTTP/SSE transport (optional)

Tools exposed

Tool	Arguments	Description
pgmnemo.ingest	text: str, metadata?: dict	Store a lesson in agent memory
pgmnemo.recall	query: str, top_k?: int	Retrieve relevant lessons

metadata keys for pgmnemo.ingest: role, topic, importance (1–5), commit_sha.

Usage

# Smoke test — verify DB connectivity
DATABASE_URL=postgresql://user:pass@host/db python -m pgmnemo_mcp --smoke

# SSE transport (for web-based MCP hosts)
MCP_PORT=8765 pgmnemo-mcp

MCP Registry

Field	Value
Server name	pgmnemo
Entry point	pgmnemo-mcp
Transport	stdio (default) · SSE (MCP_PORT)

Links

• pgmnemo GitHub — SQL extension source, benchmarks, docs
• INSTALL.md — extension install guide
• USAGE.md — API reference
• CHANGELOG

License

Apache License 2.0