Postgram MCP Server
by ivo-toby
Server Configuration
Describes the environment variables required to run the server.
| Name | Required | Description | Default |
|---|---|---|---|
| PORT | No | HTTP/MCP server port. | 3100 |
| LOG_LEVEL | No | pino log level. | info |
| POSTGRES_DB | No | Compose Postgres database used when DATABASE_URL is unset. | postgram |
| DATABASE_URL | No | Full Postgres connection string. Compose constructs it from the generated Postgres password secret when unset. | |
| OAUTH_ENABLED | No | Enable OAuth authorization-code, PKCE, and Dynamic Client Registration routes for native remote MCP connectors. | false |
| POSTGRES_HOST | No | Compose Postgres host used when DATABASE_URL is unset. Override to host.docker.internal or another hostname for an existing cluster. | postgres |
| POSTGRES_PORT | No | Compose Postgres port used when DATABASE_URL is unset. | 5432 |
| POSTGRES_USER | No | Compose Postgres user used when DATABASE_URL is unset. | postgram |
| OPENAI_API_KEY | No | Required when EMBEDDING_PROVIDER=openai OR (EXTRACTION_ENABLED=true AND EXTRACTION_PROVIDER=openai). Optional otherwise. | |
| EMBEDDING_MODEL | No | Defaults: text-embedding-3-small (openai, 1536 dims), bge-m3 (ollama, 1024 dims). | |
| OLLAMA_BASE_URL | No | Ollama server URL. | http://localhost:11434 |
| PUBLIC_BASE_URL | No | Public HTTPS origin for OAuth metadata and callback URLs. Required when OAUTH_ENABLED=true. Example: https://postgram.example.com. | |
| EXTRACTION_MODEL | No | Model name (defaults: gpt-4o-mini for OpenAI, claude-haiku-4-5-20251001 for Anthropic, llama3.2 for Ollama, gpt-4o-mini for OpenAI-compatible). | |
| ANTHROPIC_API_KEY | No | Anthropic API key. Required when EXTRACTION_PROVIDER=anthropic. | |
| EMBEDDING_API_KEY | No | Optional bearer token for EMBEDDING_BASE_URL. | |
| POSTGRES_PASSWORD | No | Compose Postgres password used when DATABASE_URL is unset. For external hosts, an explicit blank value builds a passwordless URL. | |
| EMBEDDING_BASE_URL | No | Embedding host. Independent from LLM-extraction host so embeddings and inference can target different machines. Required when provider=ollama and not using OLLAMA_BASE_URL. | |
| EMBEDDING_PROVIDER | No | openai or ollama. Compose keeps OpenAI when OPENAI_API_KEY is present, otherwise chooses Ollama unless explicitly set. | openai |
| EXTRACTION_API_KEY | No | Optional bearer token for EXTRACTION_BASE_URL. | |
| EXTRACTION_ENABLED | No | Enable LLM relationship extraction. | false |
| EXTRACTION_BASE_URL | No | Base URL for OpenAI-compatible chat-completions APIs, including any /v1 path. Postgram appends /chat/completions. Required when provider=openai-compatible. | |
| EXTRACTION_PROVIDER | No | LLM provider: openai, anthropic, ollama, or openai-compatible. | openai |
| ADMIN_MFA_SECRET_KEY | No | Stable 32+ character secret used to encrypt admin TOTP seeds. Compose generates and persists it in postgram_secrets when unset. | |
| EMBEDDING_DIMENSIONS | No | Must match the active embedding_models row. Run ./bin/pgm-admin embeddings migrate --target-dimensions <N> --yes to change. | |
| EMBEDDING_TIMEOUT_MS | No | Hard timeout for a single embedding provider call. Bounds how long one stalled call can delay a request. | 15000 |
| ENRICHMENT_POLL_INTERVAL_MS | No | Enrichment worker poll interval. | 1000 |
| ADMIN_SETTINGS_ENCRYPTION_KEY | No | 32-byte base64url installation key used to encrypt DB-backed provider secrets. Compose generates and persists it in postgram_secrets when unset. Keep it outside database backups. |
Instructions
Guidance the server publishes about itself, which clients place ahead of the tool catalog so the model reads it before choosing anything.
This server publishes no instructions, or was last inspected before Glama recorded them.
Capabilities
Server capabilities have not been inspected yet.
Tools
Functions exposed to the LLM to take actions
| Name | Description |
|---|---|
No tools | |
Prompts
Interactive templates invoked by user choice
| Name | Description |
|---|---|
No prompts | |
Resources
Contextual data attached and managed by the client
| Name | Description |
|---|---|
No resources | |
This server cannot be deployed
Maintenance
ActivityMaintained
ResponsivenessResponsive