Postgram
Self-hosted memory for AI agents with hybrid search, knowledge graphs, tasks, and…
- Pricing
- Open source
- Runs
- Remotely
- Version
- 0.1.3
- Listing updated
- 5 days ago
About Postgram
Postgram is an open-source MCP server. It runs as a hosted remote server, so there is nothing to install locally.
Self-hosted memory for AI agents with hybrid search, knowledge graphs, tasks, and document sync.
Install
Run in a terminal
claude mcp add postgram --env DATABASE_URL='<DATABASE_URL>' --env OPENAI_API_KEY='<OPENAI_API_KEY>' --env ADMIN_MFA_SECRET_KEY='<ADMIN_MFA_SECRET_KEY>' --env ADMIN_SETTINGS_ENCRYPTION_KEY='<ADMIN_SETTINGS_ENCRYPTION_KEY>' -- docker run -i --rm -e DATABASE_URL -e OPENAI_API_KEY -e ADMIN_MFA_SECRET_KEY -e ADMIN_SETTINGS_ENCRYPTION_KEY ghcr.io/ivo-toby/postgram@sha256:29b61fb302bd52862b8eba43305ee2aa4fc072d5f9188652f1fe6324f49d5391Add to claude_desktop_config.json
{
"mcpServers": {
"postgram": {
"command": "docker",
"args": [
"run",
"-i",
"--rm",
"-e",
"DATABASE_URL",
"-e",
"OPENAI_API_KEY",
"-e",
"ADMIN_MFA_SECRET_KEY",
"-e",
"ADMIN_SETTINGS_ENCRYPTION_KEY",
"ghcr.io/ivo-toby/postgram@sha256:29b61fb302bd52862b8eba43305ee2aa4fc072d5f9188652f1fe6324f49d5391"
],
"env": {
"DATABASE_URL": "<DATABASE_URL>",
"OPENAI_API_KEY": "<OPENAI_API_KEY>",
"ADMIN_MFA_SECRET_KEY": "<ADMIN_MFA_SECRET_KEY>",
"ADMIN_SETTINGS_ENCRYPTION_KEY": "<ADMIN_SETTINGS_ENCRYPTION_KEY>"
}
}
}
}Add to ~/.cursor/mcp.json
{
"mcpServers": {
"postgram": {
"command": "docker",
"args": [
"run",
"-i",
"--rm",
"-e",
"DATABASE_URL",
"-e",
"OPENAI_API_KEY",
"-e",
"ADMIN_MFA_SECRET_KEY",
"-e",
"ADMIN_SETTINGS_ENCRYPTION_KEY",
"ghcr.io/ivo-toby/postgram@sha256:29b61fb302bd52862b8eba43305ee2aa4fc072d5f9188652f1fe6324f49d5391"
],
"env": {
"DATABASE_URL": "<DATABASE_URL>",
"OPENAI_API_KEY": "<OPENAI_API_KEY>",
"ADMIN_MFA_SECRET_KEY": "<ADMIN_MFA_SECRET_KEY>",
"ADMIN_SETTINGS_ENCRYPTION_KEY": "<ADMIN_SETTINGS_ENCRYPTION_KEY>"
}
}
}
}Add to .vscode/mcp.json
{
"servers": {
"postgram": {
"type": "stdio",
"command": "docker",
"args": [
"run",
"-i",
"--rm",
"-e",
"DATABASE_URL",
"-e",
"OPENAI_API_KEY",
"-e",
"ADMIN_MFA_SECRET_KEY",
"-e",
"ADMIN_SETTINGS_ENCRYPTION_KEY",
"ghcr.io/ivo-toby/postgram@sha256:29b61fb302bd52862b8eba43305ee2aa4fc072d5f9188652f1fe6324f49d5391"
],
"env": {
"DATABASE_URL": "<DATABASE_URL>",
"OPENAI_API_KEY": "<OPENAI_API_KEY>",
"ADMIN_MFA_SECRET_KEY": "<ADMIN_MFA_SECRET_KEY>",
"ADMIN_SETTINGS_ENCRYPTION_KEY": "<ADMIN_SETTINGS_ENCRYPTION_KEY>"
}
}
}
}Add to ~/.codeium/windsurf/mcp_config.json
{
"mcpServers": {
"postgram": {
"command": "docker",
"args": [
"run",
"-i",
"--rm",
"-e",
"DATABASE_URL",
"-e",
"OPENAI_API_KEY",
"-e",
"ADMIN_MFA_SECRET_KEY",
"-e",
"ADMIN_SETTINGS_ENCRYPTION_KEY",
"ghcr.io/ivo-toby/postgram@sha256:29b61fb302bd52862b8eba43305ee2aa4fc072d5f9188652f1fe6324f49d5391"
],
"env": {
"DATABASE_URL": "<DATABASE_URL>",
"OPENAI_API_KEY": "<OPENAI_API_KEY>",
"ADMIN_MFA_SECRET_KEY": "<ADMIN_MFA_SECRET_KEY>",
"ADMIN_SETTINGS_ENCRYPTION_KEY": "<ADMIN_SETTINGS_ENCRYPTION_KEY>"
}
}
}
}Add to your client's MCP settings (most use this shape)
{
"mcpServers": {
"postgram": {
"command": "docker",
"args": [
"run",
"-i",
"--rm",
"-e",
"DATABASE_URL",
"-e",
"OPENAI_API_KEY",
"-e",
"ADMIN_MFA_SECRET_KEY",
"-e",
"ADMIN_SETTINGS_ENCRYPTION_KEY",
"ghcr.io/ivo-toby/postgram@sha256:29b61fb302bd52862b8eba43305ee2aa4fc072d5f9188652f1fe6324f49d5391"
],
"env": {
"DATABASE_URL": "<DATABASE_URL>",
"OPENAI_API_KEY": "<OPENAI_API_KEY>",
"ADMIN_MFA_SECRET_KEY": "<ADMIN_MFA_SECRET_KEY>",
"ADMIN_SETTINGS_ENCRYPTION_KEY": "<ADMIN_SETTINGS_ENCRYPTION_KEY>"
}
}
}
}Using several servers? Build one config file with the MCP config generator.
Configuration
DATABASE_URLPostgreSQL connection URL for a database with the pgvector extension enabled.RequiredOPENAI_API_KEYRequired only when OpenAI is selected for embeddings or extraction.EMBEDDING_PROVIDEREmbedding provider: openai or ollama.EMBEDDING_BASE_URLOllama embedding endpoint when EMBEDDING_PROVIDER is ollama.ADMIN_MFA_SECRET_KEYStable random value of at least 32 characters used to protect admin MFA seeds.RequiredADMIN_SETTINGS_ENCRYPTION_KEYStable 32-byte base64url key used to encrypt provider secrets saved in the admin UI.Required
Pricing
Open source
Prices change. Check postgram.dev before you buy.
Postgram FAQ
Is Postgram free?
Yes. Postgram is open source, so you can use and self-host it for free.
How do I add Postgram to Claude Code?
Run this command in your terminal: claude mcp add postgram --env DATABASE_URL='<DATABASE_URL>' --env OPENAI_API_KEY='<OPENAI_API_KEY>' --env ADMIN_MFA_SECRET_KEY='<ADMIN_MFA_SECRET_KEY>' --env ADMIN_SETTINGS_ENCRYPTION_KEY='<ADMIN_SETTINGS_ENCRYPTION_KEY>' -- docker run -i --rm -e DATABASE_URL -e OPENAI_API_KEY -e ADMIN_MFA_SECRET_KEY -e ADMIN_SETTINGS_ENCRYPTION_KEY ghcr.io/ivo-toby/postgram@sha256:29b61fb302bd52862b8eba43305ee2aa4fc072d5f9188652f1fe6324f49d5391
Where this comes from
- Description: from the official MCP Registry entry.
- Install steps: from the official MCP Registry entry.