DatabasesOfficialTypeScript

PostgreSQL MCP Server

Run read-only SQL queries and inspect PostgreSQL schemas from your MCP client.

3.2k starsUpdated Aug 23, 2026npm/@modelcontextprotocol/server-postgres

Ads

Overview

Exposes schema discovery and query tools for PostgreSQL databases with a focus on safe, read-only access patterns.

Installation

npx -y @modelcontextprotocol/server-postgres <connection-string>

Configuration

{
  "mcpServers": {
    "postgres": {
      "command": "npx",
      "args": [
        "-y",
        "@modelcontextprotocol/server-postgres",
        "postgresql://user:pass@localhost:5432/app"
      ]
    }
  }
}

Capabilities

list_tables
List tables in the connected database.
describe_table
Return columns and types for a table.
query
Execute a read-only SQL query.

Supported clients

Claude Desktop
Cursor

Related MCP servers

InstantDB

Official

Create, manage, and update applications on InstantDB, the modern Firebase.

10.5kDatabasesUpdated 1 day ago

Jitsu

Official

Manage Jitsu data pipelines from your AI assistant — destinations, streams, connections, syncs, functions, and live events.

5kDatabasesUpdated 3 days ago

Financial Datasets

Official

Stock market API made for AI agents

2.3kDatabasesUpdated Jun 5, 2025

pg-aiguide

Official

Postgres skills and documentation to help AI coding tools generate better PostgreSQL code.

1.8kDatabasesUpdated 1 day ago

DatabasesOfficialTypeScript

PostgreSQL MCP Server

Run read-only SQL queries and inspect PostgreSQL schemas from your MCP client.

3.2k starsUpdated Aug 23, 2026npm/@modelcontextprotocol/server-postgres

View on GitHub

Ads

Overview

Exposes schema discovery and query tools for PostgreSQL databases with a focus on safe, read-only access patterns.

Installation

npx -y @modelcontextprotocol/server-postgres <connection-string>

Configuration

{
  "mcpServers": {
    "postgres": {
      "command": "npx",
      "args": [
        "-y",
        "@modelcontextprotocol/server-postgres",
        "postgresql://user:pass@localhost:5432/app"
      ]
    }
  }
}