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.