MCP PostgreSQL Backend Service

This service adheres to the MCP (Model Context Protocol) specification for Cursor, enabling the utilization of a PostgreSQL relational database as the persistence layer for model contexts.

Prerequisites

• Docker runtime environment
• Docker Compose utility

Deployment and Initialization

1. Obtain a copy of this repository's source files.
2. Initiate the service stack via Docker Compose:

docker-compose up -d

Configuration within Cursor

1. Launch the Cursor application.
2. Navigate to Settings -> MCP Integration.
3. Establish a new connection entry using these parameters:
4. Alias: MCP Postgres Server
5. Connection Type: command
6. Execution Command: docker exec -i mcp-postgres-server node dist/index.js

Troubleshooting Guide

Should the service fail to achieve a running state:

1. Inspect the container logs for diagnostic information:

bash docker logs mcp-postgres-server

1. To forcefully restart the entire service stack:

bash docker-compose restart

Available MCP Server Capabilities

The PostgreSQL MCP backend exposes the following discrete tools accessible by Cursor:

1. postgres_query - Executes supplied SQL commands restricted to read-only operations.
2. postgres_list_tables - Returns a comprehensive enumeration of all relations (tables) within the database.
3. postgres_describe_table - Fetches the structural definition (schema) for a specified relational entity.

These exposed functionalities grant Cursor secure capabilities for database exploration and data interrogation.