Postgres MCP Server

MCPOpen Source24.2

by hasura • Data & Databases

A customized Model Context Protocol (MCP) Postgres server that supports multiple databases, schema-aware SQL tools, and an integrated Python tool for use with Claude.

Example Use Cases

1
Query and interact with multiple Postgres databases from a single MCP server endpoint.
2
Schema-aware SQL tool descriptions to reduce hallucination and improve query reliability against specific DB schemas.
3
Run Python code/tools alongside database queries via the MCP server (requires python3 in PATH).

Description

This repository provides instructions and a modified MCP Postgres server implementation to support multiple Postgres databases (so each DB can expose its own SQL tool), include DB schema in tool descriptions to reduce hallucinations, and add a Python execution tool. It requires cloning the upstream modelcontextprotocol/servers repo, replacing the Postgres server source file with the provided index.ts, setting database URLs, compiling TypeScript, and optionally running the server for Claude Desktop. The README also documents how to configure Claude Desktop to use the custom MCP server.

Quick Actions

View on GitHub

Security

Scanned 2 month(s) ago

Risk Level

MINIMAL

Read-only data retrieval, no side effects

Trust Score

D40/100

3/17 checks passed

Scores are informational only and provided “as is” without warranty. AgentHotspot assumes no liability for actions taken based on these ratings.

Quick Stats

Service TypeMCP

Pricing ModelUnknown

Capabilities0 Tools / 0 Prompts / 0 Resources

Ownerhasura

CategoryData & Databases

DependenciesPostgreSQLrequired