← Back to MCP Servers
🐘

PostgreSQL

Query, inspect, and manage PostgreSQL databases with full SQL support

Data Databases node API Key Required

Installation

aivyx hub install mcp-servers/postgres

Environment Variables

POSTGRES_CONNECTION_STRING Required PostgreSQL connection URI (postgres://user:pass@host:5432/db)

Server Configuration

[server]
command = "npx"
args = ["-y","@modelcontextprotocol/server-postgres"]

Tags

databasesqlpostgresdataquery

Templates Using This Server

🔌
API Builder

Designs and implements REST/GraphQL APIs with OpenAPI specs

 🌟
Customer Success Agent

Monitors customer health, analyzes support trends, and proactively addresses churn risks

 📊
Data Analyst

Queries databases, analyzes datasets, and generates charts and statistical summaries

 🔧
Data Engineer

Designs data pipelines, writes SQL queries, and monitors data quality across databases and caches

 🗂️
Database Migration Agent

Plans and validates schema migrations with rollback safety

 💻
Full-Stack Developer

Writes, debugs, and refactors code across frontend and backend with a focus on clean architecture

Similar Databases

⚡
Redis

Read, write, and manage keys in Redis for caching and real-time data

 🗄️
SQLite

Query, inspect, and manage SQLite databases with full SQL support