PostgreSQL MCP Server

Example Use Cases

• 1

  Safely query PostgreSQL databases with read-only access.

• 2

  Discover database schema details such as tables and column structures.

• 3

  Execute SELECT queries with security and performance constraints.

Description

This MCP server enables AI clients to interact safely with PostgreSQL databases by exposing tools to list tables, execute read-only SELECT queries, and describe table structures. It enforces security by restricting access to the public schema, validating queries to block dangerous SQL commands, and limiting query results to 100 rows. The server communicates over Server-Sent Events (SSE) and follows the MCP protocol, facilitating seamless integration with MCP-compatible clients.