広告掲載
MCP.so
ログイン

PostgreSQL Full Access MCP Server

@kamusis

リポジトリ

基本情報

カテゴリ

データベース

トランスポート

stdio

作者

kamusis

PostgreSQL Full Access MCP Server について

A fully featured PostgreSQL server adapter for the Model Context Protocol (MCP), providing robust read/write access and enhanced schema metadata for LLM and AI-powered applications. Supports full SQL DML/DDL operations.

PostgreSQL Full Access MCP Server の設定

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

{
  "mcpServers": {
    "mcp-postgres-full-access-extended": {
      "command": "docker",
      "args": [
        "build",
        "-t",
        "mcp-postgres-full-access",
        "."
      ]
    }
  }
}

PostgreSQL Full Access MCP Server のツール

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

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

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

概要

What is PostgreSQL Full Access MCP Server?

A Model Context Protocol server that provides full read-write access to PostgreSQL databases. It is an independently maintained fork of the original mcp-postgres-full-access, enabling LLMs to both query and modify database content with transaction management and safety controls.

How to use PostgreSQL Full Access MCP Server?

Install via npx and configure Claude Desktop by editing claude_desktop_config.json with the server command and connection string. Use environment variables to customize timeouts and safety limits. The server can also be run in a Docker container. Example configurations are provided in the README.

Key features of PostgreSQL Full Access MCP Server

  • Execute DML, DDL, DCL, and TCL operations with safety controls
  • Rich schema information including primary keys, foreign keys, and indexes
  • Transaction management with explicit commit and rollback
  • SQL query classification and automatic timeout monitoring
  • Two-step commit process requiring user approval
  • Docker support for containerized deployment

Use cases of PostgreSQL Full Access MCP Server

  • Create new tables and insert data with user approval
  • Perform read-only data analysis and reporting
  • Manage database objects and schema changes
  • Review and safely commit write transactions after verification

よくある質問

1

How does PostgreSQL Full Access MCP Server differ from the official MCP PostgreSQL server?

The official server is read-only; this server provides full read-write access with transaction management and safety controls.

2

What environment variables are available?

Key variables include `TRANSACTION_TIMEOUT_MS`, `MAX_CONCURRENT_TRANSACTIONS`, `ENABLE_TRANSACTION_MONITOR`, `PG_STATEMENT_TIMEOUT_MS`, `PG_MAX_CONNECTIONS`, and `MONITOR_INTERVAL_MS`. Defaults are specified in the README.

3

What permissions should I grant the database user?

Create a dedicated user with restricted grants. Avoid superuser access. For example, grant SELECT on all tables and INSERT/UPDATE/DELETE only on specific tables as needed.

4

How does the two-step commit safety workflow work?

For write operations, the SQL executes in a transaction and the conversation ends. The user reviews results, then starts a new conversation saying "Yes" to commit or "No" to rollback.

5

Can I run this server in Docker?

Yes. Build the Docker image and run it with a PostgreSQL connection string. On macOS use `host.docker.internal` to reach the host network.

コメント

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

Xata MCP Server

The Xata MCP server lets AI assistants and agents interact with your Xata organizations, projects, and Postgres database branches.

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

golfdata.online - Verified Golf Clubs

golfdata.online

Verified golf club data for AI agents: holes, par, address, phone, booking links, facilities, visitor rules and green fees for golf clubs in Spain (Canary Islands and mainland), expanding across Europe. Every fact comes

PostgreSQL Model Context Protocol (PG-MCP) Server

stuzero

540

Schemity

tbson

Local database MCP server: your agent sees a migration's impact before it runs, for PostgreSQL, MySQL, SQL Server and SQLite, with no database credentials.

広告掲載