PostgreSQL Docs MCP Server

This project exposes one MCP tool, get-postgres-docs, that searches the official PostgreSQL documentation site and returns relevant content as a markdown string.

Tool Contract

Tool name: get-postgres-docs

Input body:

{
  "query": "jsonb operators",
  "version": "17"
}

• query is required.
• version is optional. Examples: current, 18, 17, 16, 9.6, devel.

The tool response is a markdown string assembled from the official PostgreSQL documentation pages.

Install

pnpm install

Run The Hono HTTP Server

pnpm dev:http

By default the Hono server listens on http://localhost:3000.

• MCP endpoint: http://localhost:3000/mcp
• Health endpoint: http://localhost:3000/health

Run The Stdio MCP Server

pnpm dev:stdio

For a built server:

pnpm build
pnpm start:http
pnpm start:stdio

Notes

• The server fetches documentation live from postgresql.org.
• The HTTP transport uses Hono.
• The tool is read-only and returns markdown text suitable for LLM context.