MCP Postgres Server

@MCP-Mirror

代码仓库

基本信息

分类

数据库

传输方式

stdio

作者

MCP-Mirror

关于 MCP Postgres Server

Mirror of

#mcp-postgres#database #cursor

MCP Postgres Server 配置

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

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

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

常见问题

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`.

How do I troubleshoot if the server fails?

Check the container logs with `docker logs mcp-postgres-server` or restart the service with `docker-compose restart`.

What tools does the server expose?

It exposes three tools: `postgres_query`, `postgres_list_tables`, and `postgres_describe_table`.

数据库分类下的更多 MCP 服务器

MCP Server for MySQL based on NodeJS

benborla

A Model Context Protocol server that provides read-only access to MySQL databases. This server enables LLMs to inspect database schemas and execute read-only queries.

1.9K

Lawstronaut

Lawstronaut-FZCO

Access millions of official legal and regulatory source documents from 155+ jurisdictions via MCP. Lawstronaut supports AI agents with structured legal research, legal data, laws, regulations, cases, guidance, official s