Cloud-Ready Postgres MCP Server
Hey HN, I built pg-mcp, a Model Context Protocol (MCP) server for PostgreSQL that provides structured schema inspection and query execution for LLMs and agents. It's multi-tenant and runs over HTTP/SSE (not stdio) Features - Supports multiple database connections from multiple agents - Schema Introspection: Returns table structures, types, indexes and constraints; enriched with descriptions from pg_catalog. (for well documented databases) - Read-Only Queries: Controlled execution of queries via MCP. - EXPLAIN Tool: Helps smart agents optimize queries before execution. - Extension…
Cloud-Ready Postgres MCP Server launched on March 30, 2025 with 167 votes, #249 of 7,215 launches that month and more than 95% of that year's launches. The site was still online in September 2026, 1 year on.
In plain words
Cloud-Ready Postgres MCP Server is a Model Context Protocol server that enables large language models and agents to inspect PostgreSQL database schemas and execute read-only queries. It supports multiple concurrent database connections and runs over HTTP/SSE, offering tools like schema introspection with catalog descriptions, query execution with controls, EXPLAIN query optimization, and a YAML-based plugin system for Postgres extensions including pgvector and postgis. It is designed for developers building LLM-powered applications that need structured database access.
written from the facts on this page · September 2026
From the sources
Contribute to stuzero/pg-mcp development by creating an account on GitHub.
In the maker’s words, at launch
Hey HN, I built pg-mcp, a Model Context Protocol (MCP) server for PostgreSQL that provides structured schema inspection and query execution for LLMs and agents. It's multi-tenant and runs over HTTP/SSE (not stdio) Features - Supports multiple database connections from multiple agents - Schema Introspection…
Does a similar job
all alternatives →
Pgmcp, an MCP server to query any Postgres database in natural language2025 · github.com · ▲18An MCP server to query any Postgres database in natural language. - subnetmarco/pgmcp
AI-Driven Index Tuning With Postgres MCP Server2025 · github.com · ▲11Hey HN, Postgres Pro is an open source Model Context Protocol (MCP) server built to support every stage of the development process. It does a lot more than help generate and run SQL—it helps you make sure your application and database actually run well. Features: - Industrial-strength tuning algorithms similar to those in MS SQL Server - “What if?” tool to evaluate LLM-generated index suggestions - Works with Cursor, etc., to make changes in ORM code - Ensures safe SQL execution with restricted mode - Includes health checks to stay ahead of production problems
An MCP server that gives LLMs temporal awareness and time calculation2025 · github.com · ▲91This is an open‑source Model Context Protocol (MCP) server that gives any LLM a sense of the passage of time. Most MCP demos wire LLMs to external data stores. That’s useful, but MCP is also a chance to give models perception — extra senses beyond the prompt text. Six functions (`current_datetime`, `time_difference`, `timestamp_context`, etc.) give Claude/GPT real temporal awareness: It can spot pauses, reason about rhythms, and even label a chat’s “three‑act structure”. Runs locally in <60 s (Python) or via a hosted demo. If time works, what else could we surface? - Location /…
- OSOpen-Source MCP Server for Context and AI Tools2025 · ▲43
Large Language Models (LLMs) are powerful, but they’re limited by fixed context windows and outdated knowledge. What if your AI could access live search, structured data extraction, OCR, and more—all through a standardized interface? We built the JigsawStack MCP Server, an open-source implementation of the Model Context Protocol (MCP) that lets any AI model call external tools effortlessly. Here’s what it unlocks: - Web Search & Scraping: Fetch live information and extract structured data from web pages. - OCR & Structured Data Extraction: Process images, receipts, invoices, and handwritten…
A MCP server and client implementing the latest spec2025 · github.com · ▲72A comprehensive Model Context Protocol (MCP) server implementing the latest specification. - hemanth/paws-on-mcp
Questions this answers
More dev tools this month
the category →
open-source IDE for thoughtful software design. Contribute to devdotfast/whiteboard development by creating an account on GitHub.
Dev tools · 27d ago · github.com
Contribute to reladraw/reladraw development by creating an account on GitHub.
Dev tools · 25d ago · github.com
OpenBot▲362Grok Bot alternative: free, local, open-source, multiplayer
Dev tools · 22d ago · openbot.run
Talanoa▲341Hi HN, I’m a fullstack developer, and honestly, I’ve lost count of how many side projects I’ve worked on over the years. But one idea kept coming back to me: a different kind of email client. It first came to me in 2014: “What if we could handle emails more like conversations?” Every year, I’d revisit this concept in my “Build Notes.” Ten years later, no one had built exactly what I had in mind — so I finally decided to do it myself. That’s how Talanoa was born. I wanted something focused on people, not timelines. I was tired of marking messages as unread just to remember to reply later, or…
Dev tools · 20d ago · talanoa.email
CoreSpeed▲332One MCP for everything your agents need: apps, memory, tools
Dev tools · 27d ago · corespeed.io
Source: Show HN post ↗ · launch text quoted in part
Launched alongside, March 2025
the whole month →
Mimic Human Research & Save Findings in AI Knowledge Base
AI · 2025 · sider.ai
