pg_attach_partition

What pg_attach_partition does on PostgreSQL MCP Server

AI agents use pg_attach_partition to create or update resources in PostgreSQL MCP Server, usually the action step of a workflow, after the agent has gathered context. Every call changes real data in your PostgreSQL MCP Server environment.

Why pg_attach_partition is rated Medium

This tool performs a structural modification to the database (converting a standalone table into a partition of a parent table). While reversible via DETACH PARTITION, it materially changes the table's properties, constraints, and behavioral characteristics. This is primarily a Write operation because it modifies data organization and schema relationships, not a destructive operation since partitions can be detached.

From the tool's definition The tool 'pg_attach_partition' modifies the database schema by attaching an existing table as a partition, which is a reversible schema modification operation that alters table structure and constraints.

The rule that runs pg_attach_partition safely

PolicyLayer is an MCP gateway: it sits between your AI agents and PostgreSQL MCP Server, and checks every tool call against a rule you set before the call runs. Nothing changes on the server itself. For pg_attach_partition, this is the rule to start with:

{
  "version": "1",
  "default": "deny",
  "tools": {
    "pg_attach_partition": {
      "limits": [
        {
          "counter": "pg_attach_partition_rate",
          "window": "minute",
          "max": 30,
          "scope": "grant"
        }
      ]
    }
  }
}

Questions about pg_attach_partition