itunified-io avatar

PostgreSQL MCP Server

itunified-io/mcp-postgres

A comprehensive PostgreSQL client that exposes 27 tools across connection management, queries, schema introspection, CRUD operations, and server administration. You get parameterized queries with EXPLAIN ANALYZE, full schema exploration including indexes and constraints, and type-safe inserts with injection protection. It handles multi-database configs via YAML, supports HashiCorp Vault for credential management through AppRole authentication, and includes practical DBA tools like config reload and database sizing. Safety features like required confirmation flags on destructive operations make it suitable for production use. If you're doing database work through Claude and need more than basic queries, this covers the operational surface area you'd expect from a proper PostgreSQL client.

tool
1
transport
STDIO
env var
1
last updated
Apr 10, 2026

Tools

1 tools

Public tool metadata for what this MCP can expose to an agent.

execute_custom_queryExecute a custom SQL query against the database. WARNING: Use with care. Do not expose to untrusted input.4 params

Execute a custom SQL query against the database. WARNING: Use with care. Do not expose to untrusted input.

Parameters* required
connectionStringstring
PostgreSQL connection string
querystring
SQL query to execute
timeoutnumber
Optional query timeout in milliseconds
valuesarray
Optional parameter values for the query

Sponsors

Configuration

POSTGRES_CONNECTION_STRING

PostgreSQL connection string (e.g. postgresql://user:pass@host:5432/db)

Readme

Details

Repository
github.com/itunified-io/mcp-postgres
Category
Databases
Package
@itunified.io/mcp-postgres
Transport
STDIO
Registry
MCP registry, active

More from itunified-io

Related Databases MCP servers

View all
1rog0x avatarDatabaserog0x/mcp-database-toolsSQL formatting, schema visualization, migration generation0stars
2musaddiq-dev avatarPostgreSQL MCP Servermusaddiq-dev/postgresql-mcp-serverPython MCP server for PostgreSQL database inspection and querying0stars
3neo4j-contrib avatarMcp Neo4j Aura Managerneo4j-contrib/mcp-neo4jMCP server for Neo4j Aura Database Instance Manager.958stars
4waystation-ai avatarSupabasewaystation-ai/mcpConnect to your Supabase database to query data and schemas.0stars
5spences10 avatarMcp Sqlite Toolsspences10/mcp-sqlite-toolsMCP server for local SQLite database operations19stars
6neverinfamous avatarPostgreSQL MCP Serverneverinfamous/postgres-mcpEnterprise PostgreSQL MCP server with 63 tools, 10 resources, 10 prompts for AI-native operations8stars