PostgreSQL MCP Server

Example Use Cases

• 1

  Run read-only SQL SELECT queries against a PostgreSQL database through an LLM tool interface.

• 2

  Fetch and attach database schema and table metadata as resources to provide context for prompts.

• 3

  Reusable prompt templates and query-generation helpers to translate natural language requests into SQL.

Description

This repository implements a minimal Model Context Protocol (MCP) server for PostgreSQL that provides tools (execute_query, test_connection), resources (db://tables, db://tables/{table}, db://schema), and prompt templates for generating SQL. It is designed as a clear, easy-to-adapt template so developers can integrate database access into LLM workflows and prototype agent capabilities quickly. The README includes setup instructions, an example Docker-backed sample database, and links to MCP documentation; note that it is experimental and warns against production use due to limited SQL injection protections.