What this kind of tool is for
- Query, inspect, or seed a database without writing a one-off script.
- Let your agent look up schema details before it writes migration code.
- Move a small dataset between tools without leaving the terminal.
How to compare servers like this
- Engine match:
- Confirm it speaks your exact database and version, not just the family.
- Access scope:
- Read-only connections are the safe default — start there before granting writes.
- Safety rails:
- Check whether destructive statements need an explicit confirmation before they run.
- Maintenance signal:
- Database drivers change; a recently updated tool is less likely to break mid-query.
This page carries your copy-paste config: pick your MCP client in the install section on this page and use the copy button.
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.
DATABASE_URLrequiredsecretPostgreSQL connection URL for a database with the pgvector extension enabled.
OPENAI_API_KEYsecretRequired 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_KEYrequiredsecretStable random value of at least 32 characters used to protect admin MFA seeds.
ADMIN_SETTINGS_ENCRYPTION_KEYrequiredsecretStable 32-byte base64url key used to encrypt provider secrets saved in the admin UI.
{
"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>"
}
}
}
}Related MCP servers
UK car repair and servicing cost ranges per car model, in GBP, from PriceMyRepair.

io.github.j-sulliman/hopgraph
Verify ANZ businesses against government registers. Surfaces cross-jurisdictional findings.

Memory MCP Server
SQLite-backed MCP server for persistent memory, full-text retrieval, and graph traversal.

Unofficial read-only access to LINE WORKS AiNote meeting notes: list, search, summaries, transcripts

IWE
Markdown knowledge base as queryable agent memory—structured retrieval without cloud or database.

