PostgreSQL MCP Server

Example Use Cases

• 1

  Execute read-only SQL SELECT queries on PostgreSQL databases.

• 2

  Perform write operations such as INSERT, UPDATE, or DELETE securely.

• 3

  Manage database schemas by creating tables and listing existing tables.

Description

This MCP server provides a secure and structured protocol for AI assistants to execute SQL queries, create tables, list tables, and analyze query plans on PostgreSQL databases. It supports multiple transport modes including stdio, SSE, and streamable HTTP, allowing flexible client integration. Configuration is environment-based, making deployment and management straightforward, including Docker support for containerized environments.