MCP Haus
Data by Model Context Protocol Open source

Postgres MCP

Query relational data from agent workflows

View repository

Install Postgres MCP

Choose the tracked registry command or the raw command.

Recommended

Tracked wget install

Counts the install in MCP Haus and runs the published command.

wget -qO- https://mcphaus.com/api/install/postgres-mcp | sh
Raw command

Direct install command

Use this when you want to paste the command into an MCP client config manually.

npx -y @modelcontextprotocol/server-postgres postgresql://user:pass@localhost:5432/db

What Postgres MCP does

Connect AI agents to PostgreSQL with schema inspection, read-only query controls, and concise table context for safer database exploration. The reference implementation also supports restricted write access for migrations.

How to use Postgres MCP

1. Copy

Copy the tracked install command to record the download in MCP Haus.

2. Run

Run it in your terminal, or copy the raw command into an MCP client config.

3. Connect

Open your AI client and add the server to the MCP servers list.

Which AI clients does Postgres MCP work with?

Postgres MCP works with every MCP-compatible client, including Claude Desktop, Cursor, Continue, Windsurf, Cline, OpenHands, and Claude Code. Add the install command to your client's MCP configuration and restart the session.

Read the MCP guide