Postgram MCP Server

Name: Postgram MCP Server
Author: io.github.ivo-toby

io.github.ivo-toby/postgram

Repository Registry

What is the Postgram MCP server?

Self-hosted memory for AI agents with hybrid search, knowledge graphs, tasks, and document sync.

How to install Postgram

Copy-paste configuration for popular MCP clients.

transport: stdio

Config generated by PluginBench — verify against the source before use.

Environment / auth

DATABASE_URL
required
secret
PostgreSQL connection URL for a database with the pgvector extension enabled.
OPENAI_API_KEY
secret
Required only when OpenAI is selected for embeddings or extraction.
EMBEDDING_PROVIDER
Embedding provider: openai or ollama.
EMBEDDING_BASE_URL
Ollama embedding endpoint when EMBEDDING_PROVIDER is ollama.
ADMIN_MFA_SECRET_KEY
required
secret
Stable random value of at least 32 characters used to protect admin MFA seeds.
ADMIN_SETTINGS_ENCRYPTION_KEY
required
secret
Stable 32-byte base64url key used to encrypt provider secrets saved in the admin UI.

Claude Desktop

~/Library/Application Support/Claude/claude_desktop_config.json

{
  "mcpServers": {
    "postgram": {
      "command": "docker",
      "args": [
        "run",
        "-i",
        "--rm",
        "ghcr.io/ivo-toby/postgram@sha256:29b61fb302bd52862b8eba43305ee2aa4fc072d5f9188652f1fe6324f49d5391",
        "--publish",
        "127.0.0.1:3100:3100",
        "--add-host",
        "host.docker.internal:host-gateway"
      ],
      "env": {
        "DATABASE_URL": "<YOUR_DATABASE_URL>",
        "OPENAI_API_KEY": "<YOUR_OPENAI_API_KEY>",
        "EMBEDDING_PROVIDER": "<YOUR_EMBEDDING_PROVIDER>",
        "EMBEDDING_BASE_URL": "<YOUR_EMBEDDING_BASE_URL>",
        "ADMIN_MFA_SECRET_KEY": "<YOUR_ADMIN_MFA_SECRET_KEY>",
        "ADMIN_SETTINGS_ENCRYPTION_KEY": "<YOUR_ADMIN_SETTINGS_ENCRYPTION_KEY>"
      }
    }
  }
}

Cursor

~/.cursor/mcp.json

{
  "mcpServers": {
    "postgram": {
      "command": "docker",
      "args": [
        "run",
        "-i",
        "--rm",
        "ghcr.io/ivo-toby/postgram@sha256:29b61fb302bd52862b8eba43305ee2aa4fc072d5f9188652f1fe6324f49d5391",
        "--publish",
        "127.0.0.1:3100:3100",
        "--add-host",
        "host.docker.internal:host-gateway"
      ],
      "env": {
        "DATABASE_URL": "<YOUR_DATABASE_URL>",
        "OPENAI_API_KEY": "<YOUR_OPENAI_API_KEY>",
        "EMBEDDING_PROVIDER": "<YOUR_EMBEDDING_PROVIDER>",
        "EMBEDDING_BASE_URL": "<YOUR_EMBEDDING_BASE_URL>",
        "ADMIN_MFA_SECRET_KEY": "<YOUR_ADMIN_MFA_SECRET_KEY>",
        "ADMIN_SETTINGS_ENCRYPTION_KEY": "<YOUR_ADMIN_SETTINGS_ENCRYPTION_KEY>"
      }
    }
  }
}

Windsurf

~/.codeium/windsurf/mcp_config.json

{
  "mcpServers": {
    "postgram": {
      "command": "docker",
      "args": [
        "run",
        "-i",
        "--rm",
        "ghcr.io/ivo-toby/postgram@sha256:29b61fb302bd52862b8eba43305ee2aa4fc072d5f9188652f1fe6324f49d5391",
        "--publish",
        "127.0.0.1:3100:3100",
        "--add-host",
        "host.docker.internal:host-gateway"
      ],
      "env": {
        "DATABASE_URL": "<YOUR_DATABASE_URL>",
        "OPENAI_API_KEY": "<YOUR_OPENAI_API_KEY>",
        "EMBEDDING_PROVIDER": "<YOUR_EMBEDDING_PROVIDER>",
        "EMBEDDING_BASE_URL": "<YOUR_EMBEDDING_BASE_URL>",
        "ADMIN_MFA_SECRET_KEY": "<YOUR_ADMIN_MFA_SECRET_KEY>",
        "ADMIN_SETTINGS_ENCRYPTION_KEY": "<YOUR_ADMIN_SETTINGS_ENCRYPTION_KEY>"
      }
    }
  }
}

VS Code

.vscode/mcp.json

{
  "servers": {
    "postgram": {
      "type": "stdio",
      "command": "docker",
      "args": [
        "run",
        "-i",
        "--rm",
        "ghcr.io/ivo-toby/postgram@sha256:29b61fb302bd52862b8eba43305ee2aa4fc072d5f9188652f1fe6324f49d5391",
        "--publish",
        "127.0.0.1:3100:3100",
        "--add-host",
        "host.docker.internal:host-gateway"
      ],
      "env": {
        "DATABASE_URL": "<YOUR_DATABASE_URL>",
        "OPENAI_API_KEY": "<YOUR_OPENAI_API_KEY>",
        "EMBEDDING_PROVIDER": "<YOUR_EMBEDDING_PROVIDER>",
        "EMBEDDING_BASE_URL": "<YOUR_EMBEDDING_BASE_URL>",
        "ADMIN_MFA_SECRET_KEY": "<YOUR_ADMIN_MFA_SECRET_KEY>",
        "ADMIN_SETTINGS_ENCRYPTION_KEY": "<YOUR_ADMIN_SETTINGS_ENCRYPTION_KEY>"
      }
    }
  }
}

Claude Code

claude mcp add postgram --env DATABASE_URL=<YOUR_DATABASE_URL> --env OPENAI_API_KEY=<YOUR_OPENAI_API_KEY> --env EMBEDDING_PROVIDER=<YOUR_EMBEDDING_PROVIDER> --env EMBEDDING_BASE_URL=<YOUR_EMBEDDING_BASE_URL> --env ADMIN_MFA_SECRET_KEY=<YOUR_ADMIN_MFA_SECRET_KEY> --env ADMIN_SETTINGS_ENCRYPTION_KEY=<YOUR_ADMIN_SETTINGS_ENCRYPTION_KEY> -- docker run -i --rm ghcr.io/ivo-toby/postgram@sha256:29b61fb302bd52862b8eba43305ee2aa4fc072d5f9188652f1fe6324f49d5391 --publish 127.0.0.1:3100:3100 --add-host host.docker.internal:host-gateway