Postgres Memory MCP Server

> [!IMPORTANT]
> Prerequisites for Use
>
> To ensure efficient operation and connectivity with Postgres, please verify the following:
>
> 1. Rule Configuration: You must add the defined operational rules to your editor or extension's system prompt (e.g., .clinerules). See System Prompts.
> 2. MCP Configuration: The mcp.json file must be strictly configured as detailed in the MCP Client Configuration section.
> 3. Tool Authorization: For users of Cline, Roo Code, Kilo Code, or similar extensions: You must enable all tool permissions (check all boxes) upon initialization. Failure to approve these tools will prevent the server from authenticating and connecting to the Postgres instance.

An MCP server that provides semantic memory storage using a local PostgreSQL database with the pgvector extension. This enables your AI assistant to store, retrieve, and search memories using vector embeddings.

Features

- Semantic Search: Uses OpenAI-compatible embeddings (Xenova/all-MiniLM-L6-v2) to find relevant memories.
- Local Postgres: Runs entirely on your local machine using Docker or a local Postgres instance.
- Memory Management: Store, list, delete, and inspect memories.
- Project Isolation: Memories are scoped by project_id.

Prerequisites

1. Docker Desktop: Ensure Docker is installed and running.
2. Node.js: Version 18 or higher.

Installation

$3

This server is designed to work with the Docker container provided in the following repository, which includes Postgres configured with the pgvector extension:
https://github.com/cbuntingde/post-pgvector-docker

You can use the docker-compose.yml from that repository (or create one like below):

``yaml
services:
db:
image: pgvector/pgvector:pg16
restart: always
ports:
- "5432:5432"
environment:
POSTGRES_USER: postgres
POSTGRES_PASSWORD: password
POSTGRES_DB: postgres
volumes:
- pgdata:/var/lib/postgresql/data

volumes:
pgdata:
`

Run it:
`bash
docker-compose up -d
`

$3

`bash
npx postgres-pgvector-memory-mcp setup
`

This interactive setup will:
1. Ask for your Postgres Connection String (default: postgresql://postgres:password@localhost:5432/postgres).
2. Connect to the database.
3. Automatically apply the database schema (create memories table and vector extension).

$3

Add the following to your mcp.json or MCP settings:

`json
{
"mcpServers": {
"postgres-memory": {
"command": "node",
"args": [
"c:/mcpservers/post-pgvector-mcp/dist/index.js"
],
"env": {
"POSTGRES_URL": "postgresql://postgres:password@localhost:5432/postgres"
}
}
}
}
`

Tools

- store_memory: Save a snippet of information with a category.
- search_memories: Find memories semantically related to a query.
- list_memories: recent memories for a project.
- delete_memory: Remove a memory by ID.
- get_project_stats: Count memories for a project.

Development

1. Install dependencies:
`bash
npm install
`

2. Build:
`bash
npm run build
`

3. Run locally:
`bash
npm run dev
``

License

MIT