広告掲載
MCP.so
ログイン

MCP Postgres Server

@MadeByNando

リポジトリ

基本情報

カテゴリ

データベース

トランスポート

stdio

作者

MadeByNando

MCP Postgres Server について

概要はまだありません

#mcp-postgres-server#postgresql#database

MCP Postgres Server の設定

以下の設定を使って、このサーバーを MCP 対応クライアントに追加してください。

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

MCP Postgres Server のツール

ツール一覧はまだありません

この掲載には表示できるツール一覧がまだありません。サーバーにツールがないという意味ではありません。対応機能はプロジェクトのドキュメントをご確認ください。

ツールは README から自動的に抽出されます。メンテナーは ## Tools という見出しの下に記載することで、このタブに反映できます。

概要

What is MCP Postgres Server?

MCP Postgres Server implements the Model Context Protocol (MCP) for Cursor, letting you use a PostgreSQL database as storage for model contexts. It is designed for developers who want to securely query and explore PostgreSQL databases directly from Cursor.

How to use MCP Postgres Server?

Clone the repository and start the server with Docker Compose (docker-compose up -d). Then configure a new MCP connection in Cursor (Settings > MCP) using the command docker exec -i mcp-postgres-server node dist/index.js.

Key features of MCP Postgres Server

  • Runs PostgreSQL as MCP storage via Docker.
  • Exposes three tools: query, list tables, describe table.
  • postgres_query executes read-only SQL queries.
  • postgres_list_tables lists all database tables.
  • postgres_describe_table returns a table’s schema.
  • Enables secure database exploration from Cursor.

Use cases of MCP Postgres Server

  • Querying a PostgreSQL database directly from Cursor’s agent.
  • Listing tables and inspecting schemas during development.
  • Integrating database context into AI‑assisted coding workflows.
  • Troubleshooting database structure without leaving the editor.

よくある質問

1

What are the prerequisites to run MCP Postgres Server?

Docker and Docker Compose must be installed on your system.

2

How do I configure MCP Postgres Server in Cursor?

In Cursor, go to Settings > MCP, add a new connection with the command `docker exec -i mcp-postgres-server node dist/index.js`.

3

What tools does MCP Postgres Server expose?

It exposes three tools: `postgres_query` (read-only SQL), `postgres_list_tables` (list all tables), and `postgres_describe_table` (describe a table’s schema).

4

Is the query tool safe for production databases?

Yes, `postgres_query` is explicitly read-only, so it cannot modify data.

5

How do I troubleshoot if the server fails to start?

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

コメント

「データベース」の他のコンテンツ

Postgres Mcp

crystaldba

Postgres MCP Pro provides configurable read/write access and performance analysis for you and your AI agents.

3.0K

Sqlite

modelcontextprotocol

Model Context Protocol Servers

88.1K

mcp-server-qdrant: A Qdrant MCP server

qdrant

An official Qdrant Model Context Protocol (MCP) server implementation

637

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

MCP Alchemy

runekaagaard

A MCP (model context protocol) server that gives the LLM access to and knowledge about relational databases like SQLite, Postgresql, MySQL & MariaDB, Oracle, and MS-SQL.

412
広告掲載