MCP Postgres Query Server

Example Use Cases

• 1

  Secure, read-only access to PostgreSQL data to answer user questions without risking any write operations.

• 2

  Validated SQL execution with automatic timeout protection (10 seconds) to avoid long-running queries and resource exhaustion.

• 3

  Seamless integration with Claude Desktop (via MCP) to fetch structured query results (rows, rowCount, fields) in JSON format.

Description

This project implements an MCP server that accepts validated SELECT queries and returns JSON-formatted results from a PostgreSQL database. It enforces read-only access, validates SQL to prevent non-SELECT statements, and applies a 10-second query timeout to protect resources. The server is designed to integrate with Claude Desktop via MCP and is configured by passing the database connection string on launch. Results include rows, row counts, and column metadata for easy consumption by agents.