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
pgmnemoextension 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 (all top-level) | Description |
|---|---|---|
pgmnemo.ingest |
text (req), role, topic, importance, project_id, commit_sha, artifact_hash, metadata |
Store a lesson |
pgmnemo.recall |
query (req), top_k |
Retrieve relevant lessons |
ingest arguments are top-level — do not nest them under metadata. Defaults:
role="mcp_agent", topic="general", importance=3, project_id=1. Pass commit_sha
or artifact_hash to satisfy the provenance gate (without one the lesson is a "ghost",
excluded from recall by default).
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
1 maintainer
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
Built Distribution
Filter files by name, interpreter, ABI, and platform.
If you're not sure about the file name format, learn more about wheel file names.
Copy a direct link to the current filters
File details
Details for the file pgmnemo_mcp-0.19.1.tar.gz.
File metadata
- Download URL: pgmnemo_mcp-0.19.1.tar.gz
- Upload date:
- Size: 23.5 kB
- Tags: Source
- Uploaded using Trusted Publishing? Yes
- Uploaded via:
twine/7.0.0 CPython/3.13.14
File hashes
| Algorithm | Hash digest | |
|---|---|---|
| SHA256 |
a7989e23dbbc64b23756c01c807f619881eabc97201a9a43f067595b5c8ac3a9
|
|
| MD5 |
f227eef05fa7136f2b7f85640d4e2b31
|
|
| BLAKE2b-256 |
b5a2e76b24e8f1cbdae577bbec87199d918fda7944f3d7c382238835ac257e59
|
Provenance
The following attestation bundles were made for pgmnemo_mcp-0.19.1.tar.gz:
Publisher:
release.yml on pgmnemo/pgmnemo
-
Statement:
-
Statement type:
https://in-toto.io/Statement/v1 -
Predicate type:
https://docs.pypi.org/attestations/publish/v1 -
Subject name:
pgmnemo_mcp-0.19.1.tar.gz -
Subject digest:
a7989e23dbbc64b23756c01c807f619881eabc97201a9a43f067595b5c8ac3a9 - Sigstore transparency entry: 2515279029
- Sigstore integration time:
-
Permalink:
pgmnemo/pgmnemo@5d106b9c6dd9d7f399ffd877bca487336aced6f1 -
Branch / Tag:
refs/tags/v0.19.1 - Owner: https://github.com/pgmnemo
-
Access:
public
-
Token Issuer:
https://token.actions.githubusercontent.com -
Runner Environment:
github-hosted -
Publication workflow:
release.yml@5d106b9c6dd9d7f399ffd877bca487336aced6f1 -
Trigger Event:
push
-
Statement type:
File details
Details for the file pgmnemo_mcp-0.19.1-py3-none-any.whl.
File metadata
- Download URL: pgmnemo_mcp-0.19.1-py3-none-any.whl
- Upload date:
- Size: 19.3 kB
- Tags: Python 3
- Uploaded using Trusted Publishing? Yes
- Uploaded via:
twine/7.0.0 CPython/3.13.14
File hashes
| Algorithm | Hash digest | |
|---|---|---|
| SHA256 |
9b06ae71620a391e2b99dba99c036625d08e9a204804a6ffdd4a6f65e84b0279
|
|
| MD5 |
e54ff2287f4a1ee58b0cd89cae1abf58
|
|
| BLAKE2b-256 |
6d6e1e2f32a1b4a6233235a2787211dcf429bb44c3edf941310580ffbe0458ea
|
Provenance
The following attestation bundles were made for pgmnemo_mcp-0.19.1-py3-none-any.whl:
Publisher:
release.yml on pgmnemo/pgmnemo
-
Statement:
-
Statement type:
https://in-toto.io/Statement/v1 -
Predicate type:
https://docs.pypi.org/attestations/publish/v1 -
Subject name:
pgmnemo_mcp-0.19.1-py3-none-any.whl -
Subject digest:
9b06ae71620a391e2b99dba99c036625d08e9a204804a6ffdd4a6f65e84b0279 - Sigstore transparency entry: 2515279038
- Sigstore integration time:
-
Permalink:
pgmnemo/pgmnemo@5d106b9c6dd9d7f399ffd877bca487336aced6f1 -
Branch / Tag:
refs/tags/v0.19.1 - Owner: https://github.com/pgmnemo
-
Access:
public
-
Token Issuer:
https://token.actions.githubusercontent.com -
Runner Environment:
github-hosted -
Publication workflow:
release.yml@5d106b9c6dd9d7f399ffd877bca487336aced6f1 -
Trigger Event:
push
-
Statement type:
