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.

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-server-qdrant: A Qdrant MCP server

qdrant

An official Qdrant Model Context Protocol (MCP) server implementation

637

MCP Server for Milvus

zilliztech

Model Context Protocol Servers for Milvus

235

mcp_mysql_server

xwb602625136

Model Context Protocol (MCP) server that supports secure interaction with MySQL databases and has anomaly analysis capabilities.更加牛逼！更加好用！不仅止于mysql的增删改查功能；还包含了数据库异常分析能力；且便于开发者们进行个性化的工具扩展

245