MCP Postgres Server

Name: MCP Postgres Server
Author: MCP-Mirror

@MCP-Mirror

代码仓库

关于 MCP Postgres Server

Mirror of

#mcp-postgres #database #cursor

基本信息

分类

数据库

运行时

node

传输方式

stdio

发布者

MCP-Mirror

配置

使用下面的配置,将此服务器添加到你的 MCP 客户端。

{
  "mcpServers": {
    "MadeByNando_mcp-postgres-server": {
      "command": "docker",
      "args": [
        "logs",
        "mcp-postgres-server"
      ]
    }
  }
}

工具

未检测到工具

工具是从 README 中自动提取的。维护者可以在 ## Tools 标题下列出工具,即可填充这部分内容。

概览

What is MCP Postgres Server?

This server implements the Model Context Protocol (MCP) for Cursor, using a PostgreSQL database as storage for model contexts. It is intended for developers who need to query and explore PostgreSQL databases directly from Cursor.

How to use MCP Postgres Server?

Clone the repository and start the server with Docker Compose using docker-compose up -d. Then configure a new MCP connection in Cursor settings with type command and command docker exec -i mcp-postgres-server node dist/index.js. Troubleshoot by checking container logs with docker logs mcp-postgres-server or restarting with docker-compose restart.

Key features of MCP Postgres Server

postgres_query – execute read‑only SQL queries
postgres_list_tables – list all tables in the database
postgres_describe_table – get the schema of a specific table
Docker & Docker Compose based setup
Integrates with Cursor’s MCP settings

Use cases of MCP Postgres Server

Querying a PostgreSQL database directly from Cursor during development
Exploring database schemas without leaving the editor
Listing tables and describing table structures for code generation
Running read‑only SQL checks as part of an MCP‑powered workflow

FAQ from MCP Postgres Server

What are the prerequisites?

Docker and Docker Compose must be installed on your system.

How do I start the server?

Clone the repository and run docker-compose up -d to start the container.

How do I configure it in Cursor?

Go to Cursor Settings > MCP, add a new connection with name “MCP Postgres Server”, type “command”, and command docker exec -i mcp-postgres-server node dist/index.js.