mcp-postgres-server

mcp-postgres-server

3.1

If you are the rightful owner of mcp-postgres-server and would like to certify it and/or have it hosted online, please leave a comment on the right or send an email to henry@mcphub.com.

The MCP Postgres Server implements the Model Context Protocol for Cursor, utilizing a PostgreSQL database for model context storage.

The MCP Postgres Server is designed to facilitate the use of a PostgreSQL database as a storage solution for model contexts within the Cursor environment. By leveraging Docker and Docker Compose, the server can be easily deployed and managed, providing a robust and scalable solution for handling model context data. The server supports various operations such as executing read-only SQL queries, listing database tables, and describing table schemas, which are essential for exploring and querying the database securely. This setup is particularly beneficial for users who require a reliable and efficient way to manage model contexts in a PostgreSQL environment.

Features

  • Easy deployment with Docker and Docker Compose
  • Supports read-only SQL query execution
  • Ability to list all tables in the database
  • Provides schema details for specific tables
  • Secure and efficient database exploration

Tools

  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