AI Atlas

Database · Developer Tools

MCP Postgres Server logo

MCP Postgres Server

antonorlov/mcp-postgres-server

A Model Context Protocol (MCP) server for PostgreSQL: local, Docker, RDS, Neon, and Supabase databases.

View on GitHub2

Install

npx -y mcp-postgres-server

Client configuration

{
  "mcpServers": {
    "postgres": {
      "command": "npx",
      "args": [
        "-y",
        "mcp-postgres-server"
      ],
      "env": {
        "DATABASE_URL": "<DATABASE_URL>",
        "PG_ALLOW_WRITE": "<PG_ALLOW_WRITE>"
      }
    }
  }
}

Environment variables

DATABASE_URLPG_ALLOW_WRITEPG_HOSTPG_PORTPG_USERPG_PASSWORDPG_DATABASEPG_SSH_HOSTPG_SSH_USERPG_SSH_PRIVATE_KEYPG_SSH_FINGERPRINT
GitHub stars
2
Author
@antonorlov
Category
Database, Developer Tools
License
MIT
Updated
Oct 6, 2026

About MCP Postgres Server

The server is small and auditable, with four runtime dependencies: the MCP SDK, pg, pg-connection-string, and zod (plus ssh2, an optional dependency used only for SSH tunneling).

Features

  • Read-only by default; writes are an explicit opt-in (PG_ALLOW_WRITE=true)

  • Read-only enforced by the engine (BEGIN READ ONLY), never by client-side SQL parsing

  • Data access behind a small typed interface; the pg driver never leaks past it

  • DATABASE_URL support with SSL (sslmode=disable|allow|prefer|require|verify-ca|verify-full, custom CA)

  • Prepared-statement parameters: $1-style placeholders, bound by the driver

  • Result size cap (byte budget) with an explicit truncated flag instead of flooding the model's context

  • Session statement timeout plus a client deadline; transaction poolers may not preserve session settings

  • Errors returned as readable tool results with SQLSTATE-based hints, so the model can self-correct

  • Survives dropped connections - reconnects lazily instead of crashing

  • Optional SSH tunneling (PG_SSH_*) with mandatory host-key verification, loaded only when configured

Tools (6)

  • query

  • execute

    Always (refuses writes unless PG_ALLOW_WRITE=true)

  • connect_db

    Only when PG_ENABLE_RUNTIME_CONNECT=true

  • list_schemas

    List all schemas in the connected database.

  • list_tables

    List tables in the connected database.

  • describe_table

    Get the structure of a specific table (columns, types, nullability, defaults, primary keys).

Details on this page are taken from the project's README. Open README

Supported clients

Clients mentioned in this server's README:

View all
Cursor logo

Cursor

Desktop · Freemium · Proprietary

The first agentic IDE. The Cursor editor truly merges how developers and AI work together, delivering a magical coding experience.

WindowsMacOSLinux
Windsurf logo

Windsurf

Desktop · Freemium · Proprietary

The first agentic IDE. The Windsurf editor truly merges how developers and AI work together.

WindowsMacOSLinux
VS Code GitHub Copilot logo

VS Code GitHub Copilot

Desktop · Freemium · MIT

VS Code integrates MCP with GitHub Copilot through agent mode, allowing direct interaction with MCP-provided tools in your agentic coding workflow. Configure servers in Claude Desktop, workspace, or user settings, with guided MCP installation and secure handling of secrets in input variables to avoid leaking hardcoded keys.

WindowsMacOSLinuxWeb

Related MCP servers

More servers
Supabase MCP logo

Supabase MCP

supabase-community/supabase-mcp

1.3k

The Model Context Protocol (MCP) standardizes how Large Language Models (LLMs) talk to external services like Supabase. It connects AI assistants directly with your Supabase project and allows them to perform tasks like managing tables, fetching config, and querying data. See the full list of tools.

Database
Genai Toolbox logo

Genai Toolbox

googleapis/genai-toolbox

769

MCP Toolbox for Databases is an open source Model Context Protocol (MCP) server that connects your AI agents, IDEs, and applications directly to your enterprise databases.

Database
Supabase MCP Server logo

Supabase MCP Server

alexander-zuev/supabase-mcp-server

677

Query MCP is an open-source MCP server that lets your IDE safely run SQL, manage schema changes, call the Supabase Management API, and use Auth Admin SDK — all with built-in safety controls.

Database
Awesome MCP List logo

Awesome MCP List

MobinX/awesome-mcp-list

645

This is a continuously updated curated list of MCP servers, covering categories such as browser control, arts and culture, cloud platforms, command line, communication, customer data platforms, databases, developer tools, data science tools, file systems, finance and fintech, gaming, knowledge and memory, location services, marketing, monitoring, search and utilities. Each project includes a GitHub link and star count for quick reference and use.

Database
PostgreSQL Model Context Protocol (PG MCP) Server logo

PostgreSQL Model Context Protocol (PG MCP) Server

stuzero/pg-mcp-server

440

PG-MCP is a server implementation of the Model Context Protocol for PostgreSQL databases. It provides a comprehensive API for AI agents to discover, connect to, query, and understand PostgreSQL databases through MCP's resource-oriented architecture.

Database
dbhub logo

dbhub

bytebase/dbhub

332

[!NOTE] If you need an enterprise-level database MCP server with built-in guardrails like approval flow, access control, data masking, and audit logging beyond what DBHub offers, check out Bytebase.

Database