PostgreSQL MCP Server

MCPOpen Source13.8

by pyljain • Identity & Access

Provides read-only access to PostgreSQL databases for LLMs, exposing table schemas and executing read-only SQL queries.

Example Use Cases

1
Inspect database table schemas (columns and types) to understand data structure before generating queries.
2
Execute safe, read-only SQL queries against a PostgreSQL database to fetch data for answering questions or generating reports.
3
Integrate database access into workflows or UI tooling (e.g., Claude Desktop) using Docker or npx-based deployment.

Description

A Model Context Protocol (MCP) server that exposes PostgreSQL database schemas and allows agents to run read-only SQL queries inside read-only transactions. It automatically discovers table schema metadata (column names and types) and offers a single "query" tool for executing safe read-only SQL. The README includes usage examples for Docker and npx integrations, and notes compatibility with Claude Desktop. Licensed under the MIT License.

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 ModelFree

Capabilities0 Tools / 0 Prompts / 0 Resources

Ownerpyljain

CategoryIdentity & Access

DependenciesStandalone