MCP Postgres Query Server

@RathodDarshil

リポジトリ

基本情報

カテゴリ

データベース

トランスポート

stdio

作者

RathodDarshil

MCP Postgres Query Server について

概要はまだありません

MCP Postgres Query Server の設定

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

{
  "mcpServers": {
    "postgres-query": {
      "command": "node",
      "args": [
        "/path/to/your/mcp-postgres-query-server/dist/index.js",
        "postgresql://username:password@hostname:port/database"
      ]
    }
  }
}

MCP Postgres Query Server のツール

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

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

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

概要

What is MCP Postgres Query Server?

MCP Postgres Query Server is a Model Context Protocol server that provides a secure, read-only interface to a PostgreSQL database. It is designed for use with Claude Desktop and other MCP clients, allowing users to execute SELECT queries safely.

How to use MCP Postgres Query Server?

Clone the repository, install dependencies (npm install), and build (npm run build). Configure Claude Desktop by adding the server to claude_desktop_config.json with the command node and an argument pointing to the built dist/index.js followed by your PostgreSQL connection string. Then restart Claude Desktop.

Key features of MCP Postgres Query Server

Read-only database access (SELECT queries only)
Query validation to block non-SELECT SQL
Automatic 10-second query timeout
Full MCP protocol implementation
Structured JSON query results

Use cases of MCP Postgres Query Server

Query a PostgreSQL database securely through Claude Desktop
Generate read-only database reports using natural language
Explore database schemas and data without write permissions
Integrate PostgreSQL data into MCP-based AI workflows

よくある質問

What queries are allowed?

Only SQL SELECT queries are permitted; all other SQL statements are rejected by the validation logic.

What runtime dependencies are required?

Node.js v14 or later, npm, and a PostgreSQL database with connection credentials.

How do I connect the server to Claude Desktop?

Edit the `claude_desktop_config.json` file (accessible from Settings > Developer > Edit Config) and add a `postgres-query` entry with the correct path to the built server and your PostgreSQL connection string.

Does the server support write operations?

No, the server is strictly read-only. Query validation ensures only SELECT queries can execute.

How are database credentials handled?

Credentials are passed directly as a command-line argument (the connection string) and are not stored in configuration files.

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

Expired Domains MCP | Karma.Domains

karma-domains

Connect Karma.Domains to ChatGPT, Claude, Cursor, VS Code, or another MCP client — and find a domain in plain language. The same auctions, expired, backorder, and buy-now data you use in the app, plus saved filters, note