Marketplace/Postgres MCP

Postgres MCP

Verified

by plugpier · 8.1k installs

Execute SQL, inspect schemas, run migrations, and explore your database directly from your AI context.

96/100Install →

About

A production-grade PostgreSQL integration that lets AI agents query, analyze, and manage your databases safely.

Features

Execute read-only or read-write SQL queries
Inspect table schemas, indexes, and constraints
Run migrations with rollback support
Explore database relationships visually
Connection pooling with configurable limits

Requirements

A PostgreSQL connection string. Supports PostgreSQL 12+.

Tools 5

execute_query

Run a SQL query and return results as JSON.

queryparamsread_only

list_tables

List all tables in the database with row counts.

schema

describe_table

Get column definitions, types, and constraints for a table.

tableschema

list_indexes

Show all indexes on a table with size and usage stats.

table

explain_query

Run EXPLAIN ANALYZE and return the query plan.

query

Reviews

💬

No reviews yet.

Be the first to review after installing.

Quick Install

~/Library/Application Support/Claude/claude_desktop_config.json

{
  "mcpServers": {
    "postgres-mcp": {
      "command": "npx",
      "args": [
        "-y",
        "@plugpier/postgres-mcp"
      ],
      "env": {
        "PLUGPIER_KEY": "YOUR_API_KEY"
      }
    }
  }
}

Stats

Installs8.1k

Tools5

Trust score96/100

LicenseMIT

CategoryData

Related Servers

GitHub MCP

Slack MCP

Linear MCP