Skip to main content
Glama
Sign In
enesfrjakozh

MCP Postgres Server

by MadeByNando
GitHub
JavaScript
  • Linux
  • Apple
OverviewInspectNewSchemaRelated ServersReviewsScore
Need Help?View Source CodeReport Issue

Integrations

  • Provides tools for exploring and querying a PostgreSQL database, including executing read-only SQL queries, listing tables, and obtaining schema information for specific tables.

MCP Postgres Server

This server implements the Model Context Protocol (MCP) for Cursor, allowing a PostgreSQL database to be used as storage for model contexts.

Prerequisites

  • Docker
  • Docker Compose

Installation and startup

  1. Clone this repository
  2. Start the server with Docker Compose:
docker-compose up -d

Configuration in Cursor

  1. Open Cursor
  2. Go to Settings > MCP
  3. Add a new connection with the following settings:
    • Name: MCP Postgres Server
    • Type: command
    • Command: docker exec -i mcp-postgres-server node dist/index.js

Troubleshooting

If the server does not start correctly:

  1. Check the container logs:
    docker logs mcp-postgres-server
  2. To restart the server:
    docker-compose restart

MCP Server Features

The MCP PostgreSQL server exposes the following tools for Cursor:

  1. postgres_query - Execute a read-only SQL query
  2. postgres_list_tables - List all tables in the database
  3. postgres_describe_table - Get the schema of a specific table

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

This server cannot be installed

-
security - not tested
F
license - not found
-
quality - not tested

remote-capable server

The server can be hosted and run remotely because it primarily relies on remote services or has no dependency on the local environment.

A server implementing the Model Context Protocol (MCP) for Cursor that allows using a PostgreSQL database as storage for model contexts, enabling secure database exploration and querying.

  1. Prerequisites
    1. Installation and startup
      1. Configuration in Cursor
        1. Troubleshooting
          1. MCP Server Features

            Related Resources

            Related MCP Servers

            • db-mcp-tool

              wirdes
              A
              security
              A
              license
              A
              quality
              A powerful Model Context Protocol (MCP) tool for exploring and managing different types of databases including PostgreSQL, MySQL, and Firestore.
              Last updated -
              9
              3
              TypeScript
              MIT License

            • mcp-turso-cloud

              spences10
              A
              security
              A
              license
              A
              quality
              🗂️ A Model Context Protocol (MCP) server that provides integration with Turso databases for LLMs. This server implements a two-level authentication system to handle both organization-level and database-level operations, making it easy to manage and query Turso databases directly from LLMs.
              Last updated -
              8
              87
              4
              TypeScript
              MIT License
              • Linux

            • Cursor MCP Installer

              matthewdcage
              -
              security
              A
              license
              -
              quality
              A Model Context Protocol (MCP) server for Cursor IDE that simplifies the installation and configuration of other MCP servers.
              Last updated -
              882
              23
              JavaScript
              MIT License
              • Apple
              • Linux

            • MCP PostgreSQL Server

              a21071
              -
              security
              F
              license
              -
              quality
              A Model Context Protocol server that enables performing PostgreSQL database operations (create, read, update, delete) on User and Post entities through MCP tools.
              Last updated -
              TypeScript

            View all related MCP servers

            Appeared in Searches

            New MCP Servers

            ID: 2xjj29nqrm