MadeByNando_mcp-postgres-server

MadeByNando_mcp-postgres-server

0
databases

The MCP Postgres Server is a specialized server that implements the Model Context Protocol to enable PostgreSQL databases to be used for storing and querying model contexts within Cursor. It includes features for secure exploration and querying of databases.

MCP Postgres Server

This server implements the Model Context Protocol (MCP) for Cursor, enabling the use of a PostgreSQL database as storage for model contexts.

Prerequisites

  • Docker
  • Docker Compose

Installation and Startup

  1. Clone this repository
  2. Start the server with Docker Compose

Configuration in Cursor

  1. Open Cursor
  2. Go to Settings > MCP
  3. Add a new connection with the appropriate parameters

MCP Server Features

The MCP PostgreSQL server exposes the following tools for Cursor:

  • postgres_query - Execute a read-only SQL query
  • postgres_list_tables - List all database tables
  • postgres_describe_table - Get the schema of a specific table

These tools allow Cursor to securely explore and query the database.