PostgreSQL
MCP serverby antonorlovSRC
MCP server for PostgreSQL: local, Docker, RDS, Neon, Supabase, or behind an SSH bastion.
SRC Publisher-stated: these are the publisher's own words, not an assessment.
Key facts
- Type
- MCP server · mcp-localSRC
- Publisher
- antonorlov · individualSRC
- Licence
- MITSRC
- Open source
- YesDER
- Hosting
- Local (runs on your machine)SRC
- Latest version
- 0.3.1SRC
- Languages
- typescriptSRC
- First published
- SRC
- In this catalogue since
- DER
- Last verified
- Not verified by a researcher. Last seen in a source on 2026-11-21.
Capabilities and categories
Assigned by keyword rules from the description unless marked otherwise. The matched word is shown so you can judge the match.
| Capability | Evidence | Kind |
|---|---|---|
| Backend as a Service | matched supabase | DER |
| SQL Databases | matched postgresql | DER |
| Managed Postgres | matched supabase | DER |
Filed underData & KnowledgeDatabases
Integrations DER
Platform compatibility
No pairing has been tested by AgentSidekick. Each status says what kind of evidence exists, not whether it works for you.
Protocol-level29
Each platform listed officially documents support for MCP. This specific pairing has not been tested.
Platform discontinued1
| Platform | Basis |
|---|---|
| Roo CodeDiscontinued | Roo Code documented support for MCP but is discontinued. Project shut down and repository archived. |
Unknown17
| Platform | Basis |
|---|---|
| OpenClaw | Could not confirm whether OpenClaw supports MCP. |
| OpenHands | OpenHands documents MCP support, but it runs only on web, api, slack surfaces and this server runs locally as a process on your machine. Whether OpenHands can reach a local server is not established. |
| Aider | Could not confirm whether Aider supports MCP. |
| Bolt (bolt.new) | Bolt (bolt.new) documents MCP support, but it runs only on web surfaces and this server runs locally as a process on your machine. Whether Bolt (bolt.new) can reach a local server is not established. |
| Amazon Q DeveloperWinding down | Could not confirm whether Amazon Q Developer supports MCP. |
| Amazon Bedrock Agents (Agents Classic)Maintenance only | Could not confirm whether Amazon Bedrock Agents (Agents Classic) supports MCP. |
| GPTs (custom GPTs)Winding down | Could not confirm whether GPTs (custom GPTs) supports MCP. |
| Gemini (app) | Gemini (app) documents MCP support, but it runs only on web, mobile surfaces and this server runs locally as a process on your machine. Whether Gemini (app) can reach a local server is not established. |
| Gemini Enterprise Agent Platform (formerly Vertex AI / Vertex AI Agent Builder) | Gemini Enterprise Agent Platform (formerly Vertex AI / Vertex AI Agent Builder) documents MCP support, but it runs only on web, api surfaces and this server runs locally as a process on your machine. Whether Gemini Enterprise Agent Platform (formerly Vertex AI / Vertex AI Agent Builder) can reach a local server is not established. |
| GitHub Copilot ExtensionsDiscontinued | Could not confirm whether GitHub Copilot Extensions supports MCP. |
| Google AI Studio | Could not confirm whether Google AI Studio supports MCP. |
| JulesWinding down | Could not confirm whether Jules supports MCP. |
| Microsoft Copilot | Could not confirm whether Microsoft Copilot supports MCP. |
| Microsoft Copilot Studio | Microsoft Copilot Studio documents MCP support, but it runs only on web surfaces and this server runs locally as a process on your machine. Whether Microsoft Copilot Studio can reach a local server is not established. |
| Replit Agent | Replit Agent documents MCP support, but it runs only on web surfaces and this server runs locally as a process on your machine. Whether Replit Agent can reach a local server is not established. |
| Sourcegraph Cody | Could not confirm whether Sourcegraph Cody supports MCP. |
| v0 | v0 documents MCP support, but it runs only on web, api surfaces and this server runs locally as a process on your machine. Whether v0 can reach a local server is not established. |
Install
Read from registry metadata. Follow the publisher's instructions; we have not run this.
| Registry | Package | Transport | Runtime |
|---|---|---|---|
| npm | mcp-postgres-server | stdio | npx |
Environment variables SRC
| Name | Required | Secret | Publisher's description |
|---|---|---|---|
| DATABASE_URL | No | Secret | Full connection string (preferred). Supports sslmode in the URL. |
| PG_HOST | No | No | Database host (fallback when DATABASE_URL is not set). |
| PG_PORT | No | No | Database port. |
| PG_USER | No | No | Database user. |
| PG_PASSWORD | No | Secret | Database password. |
| PG_DATABASE | No | No | Database name. |
| PG_ALLOW_WRITE | No | No | When true, execute performs writes and reads are sent directly. Off (default) is read-only: execute refuses writes and each read runs in a READ ONLY transaction. |
| PG_SSLMODE | No | No | TLS mode. require/allow/prefer encrypt without verifying the certificate; verify-ca/verify-full verify it (supply a CA via PG_SSL_CA). Unlike libpq, allow/prefer do not fall back to plaintext, so a server without TLS needs disable. |
| PG_SSL_CA | No | No | Path to a CA certificate file. Setting it by itself implies verify-full. |
| PG_ENABLE_RUNTIME_CONNECT | No | No | Register the connect_db tool (runtime credential switching). |
| PG_MAX_RESULT_BYTES | No | No | Byte budget for a query result sent to the model. Whole rows are kept while they fit; over the budget returnedRows < rowCount and truncated is true. |
| PG_STATEMENT_TIMEOUT | No | No | Statement timeout in milliseconds, applied to every session. |
| PG_CONNECT_TIMEOUT | No | No | Timeout in milliseconds for a single connect attempt (raise it for slow links or SSH tunnels). |
| PG_SSH_HOST | No | No | SSH bastion host. Setting it enables tunneling: the server reaches the database only through an SSH tunnel to this host. Needs the ssh2 optional dependency. |
| PG_SSH_PORT | No | No | SSH bastion port. |
| PG_SSH_USER | No | No | SSH username. |
| PG_SSH_PRIVATE_KEY | No | No | Path to a private key file. If unset, auth falls back like ssh: a running agent (SSH_AUTH_SOCK), then a default key (~/.ssh/id_ed25519, id_rsa, id_ecdsa). |
| PG_SSH_PASSPHRASE | No | Secret | Passphrase for the private key, if encrypted. |
| PG_SSH_AGENT | No | No | true to use the ambient agent (SSH_AUTH_SOCK), or an explicit socket path / Windows named pipe. |
| PG_SSH_PASSWORD | No | Secret | SSH login password. Opt-in; a key or agent takes precedence. Prefer keys, a bastion often disables password auth. |
| PG_SSH_FINGERPRINT | No | No | Pinned host-key fingerprint (SHA256:...). Host-key verification is mandatory and set only this way: without it the tunnel refuses to connect. Get it with ssh-keygen -lF host. |
| PG_SSH_KEEPALIVE_INTERVAL | No | No | SSH keepalive interval in ms; the tunnel drops after 3 unanswered keepalives, and the next call reconnects. |
Permissions and signals
Signals, not a safety verdict. They describe what the product's metadata references. Security review: not reviewed.
| Signal | Evidence | How observed | Observed |
|---|---|---|---|
| Runs a local process | runs locally via npm | registry metadata | 2026-11-21 |
| Asks for a secret | declares secret env var(s): DATABASE_URL, PG_PASSWORD, PG_SSH_PASSPHRASE, PG_SSH_PASSWORD | registry metadata | 2026-11-21 |
Known advisories for the published package SRC
An advisory existing does not mean the listed version is affected: compare the vulnerable range with the version you install. None found is not evidence of safety.
No advisories found
No published advisory matches a package this product declares. Products without a declared package cannot be matched at all. This is not evidence of safety.
Evaluation
Separate dimensions, each with its evidence. There is no overall score: the dimensions do not add up to one number honestly.
- Source authority
Publisher-submitted
Published to the official MCP Registry by the namespace owner. Field values are the publisher's own claims.
- Publisher verification
Namespace verified by registry
The MCP Registry verifies namespace ownership (GitHub login or DNS) before publishing. This confirms who published it, not what it does.
- Maintenance activity
Active
Last push 2026-09-16 (66 days before this page was built).
- Licence clarity
MIT
Licence identifier as reported by GitHub repository metadata.
- Installation clarity
Machine-readable
1 package(s) and 0 remote endpoint(s) declared in registry metadata.
- Documentation
Repository / website only
No dedicated documentation URL on record. AgentSidekick has not assessed documentation quality.
- Compatibility evidence
Protocol-level only
Compatibility is inferred from the standard it implements. No pairing has been tested.
- Security review
Not reviewed
AgentSidekick has not audited this product. 2 automated signal(s) are listed under Permissions & signals — they describe what it references, not whether it is safe.
Pricing
Not published in any source we track. The code is open source, which says nothing about the cost of any hosted service.
Repository activity
antonorlov/mcp-postgres-server. Read from the GitHub API on 2026-11-21.
Version history SRC
- 0.3.1
- 0.3.0
Change history
What changed between two ingests of the same source, and when the product was first seen. Registry releases are under Version history.
- First seen
Competitors and alternativesDER
Paired by shared capabilities and integrations. Similar on paper; not tested side by side.
Direct
Same type, overlapping capabilities.
MCP serverby akalsoftwareSRC
SharesSQL DatabasesBackend as a ServiceManaged PostgresPostgreSQL
MCP serverby scribase.comSRC
SharesSQL DatabasesBackend as a ServiceManaged PostgresPostgreSQL
MCP serverby Muhandis-onlineSRC
SharesSQL DatabasesBackend as a ServiceManaged PostgresSupabase
MCP serverby CloudCorpRecordsSRC
SharesSQL DatabasesBackend as a ServiceManaged PostgresPostgreSQL
MCP serverby ekwo.aiSRC
SharesSQL DatabasesBackend as a ServiceManaged PostgresPostgreSQL
MCP serverby databrush.aiSRC
SharesBackend as a ServiceManaged PostgresSupabase
Provenance
Which source set each field, what kind of claim it is, and when.
| Field | Source | Kind | Set on |
|---|---|---|---|
| Canonical URL | Official MCP Registry | SRC | 2026-11-21 |
| Publisher | Official MCP Registry | SRC | 2026-11-21 |
| Description | Official MCP Registry | SRC | 2026-11-21 |
| Hosting | Official MCP Registry | SRC | 2026-11-21 |
| Integration type | Official MCP Registry | SRC | 2026-11-21 |
| Languages | GitHub repository metadata | SRC | 2026-11-21 |
| Latest version | Official MCP Registry | SRC | 2026-11-21 |
| Licence | GitHub repository metadata | SRC | 2026-11-21 |
| Name | Official MCP Registry | SRC | 2026-11-21 |
| Open source | GitHub repository metadata | DER | 2026-11-21 |
| Type | Official MCP Registry | SRC | 2026-11-21 |
| Published | Official MCP Registry | SRC | 2026-11-21 |
| Repository | Official MCP Registry | SRC | 2026-11-21 |
| source_updated_at | Official MCP Registry | SRC | 2026-11-21 |
| Source URL | Official MCP Registry | SRC | 2026-11-21 |
| Website | Official MCP Registry | SRC | 2026-11-21 |
Sources
- Official MCP Registry: registry.modelcontextprotocol.io (external)checked
Not verified by a researcher. Last seen in a source on . Report incorrect information