PostgreSQL MCP Server

Example Use Cases

• 1

  Execute read-only SQL queries on PostgreSQL databases.

• 2

  Perform data modification operations with transaction control.

• 3

  Retrieve database schema information such as table lists and descriptions.

Description

This server implements the Model Context Protocol (MCP) to allow AI assistants to execute PostgreSQL queries, data modifications, and table structure operations securely. It manages database transactions with timeout and concurrency controls, ensuring safe and efficient database access. The server supports integration with Cursor editor and provides configurable environment variables for customization.