PostgreSQL MCP Server

MCPOpen Source25.2

by Tibiritabara • Documentation & Docs

A FastMCP server that lets LLMs explore PostgreSQL schemas, inspect tables, and run read-only SQL queries with results returned in YAML.

Example Use Cases

1
Explore database schemas and discover tables, columns, and basic metadata in a PostgreSQL instance.
2
Inspect table definitions and column details to plan queries, mappings, or data transformations.
3
Run read-only SELECT queries against PostgreSQL and receive results formatted in YAML for downstream processing.

Description

This repository provides a FastMCP (Model Context Protocol) server that exposes PostgreSQL schema and table metadata and a tool to execute SELECT queries, returning results in YAML for easy LLM consumption. It includes resources for schema-wide and per-table inspection, predefined prompts, and a query tool for agents to interact with a PostgreSQL database. The project is a demo for integrating LLM agents with PostgreSQL for schema exploration and data retrieval.

Capabilities(2 total)

Tools (1)

add-note

Add a new note

name:string*content:string*

Prompts (1)

summarize-notes

Creates a summary of all notes

style

Quick Actions

View on GitHub

Security

Scanned 2 month(s) ago

Risk Level

MINIMAL

Read-only data retrieval, no side effects

Trust Score

C51/100

5/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

Capabilities1 Tools / 1 Prompts / 0 Resources

OwnerTibiritabara

CategoryDocumentation & Docs

DependenciesPostgreSQLrequired

Set Your Username