Skip to main content
Glama

Supabase: Update policy

supabase_update_policy
Destructive

Update an existing Supabase RLS policy by dropping and recreating it with new definitions, roles, and checks.

Instructions

[UNIFIED] Update an existing RLS policy. Drops and recreates the policy.

Tool call template

Replace each placeholder with a value matching the input schema. Only required parameters are included; add optional parameters as needed.

{
  "id": 1,
  "jsonrpc": "2.0",
  "method": "tools/call",
  "params": {
    "arguments": {
      "site": "<site>",
      "table": "<table>",
      "name": "<name>",
      "definition": "<definition>"
    },
    "name": "supabase_update_policy"
  }
}

Input Schema

NameRequiredDescriptionDefault
nameYes
siteYes
checkNo
rolesNo
tableYes
schemaNopublic
commandNoALL
definitionYes

Schema Changelog

Changes observed during successful MCP inspections.

  1. Addedv3.14.0
  2. Removedv3.13.1
  3. First observedv3.4.0

TDQS

B3.1/5.0
Behavior4/5

Does the description disclose side effects, auth requirements, rate limits, or destructive behavior?

Annotations already declare destructiveHint=true and idempotentHint=false, so the bar is lower. The description nonetheless earns credit by disclosing the mechanism — "Drops and recreates the policy" — which explains why the operation is destructive and implies a brief window where the policy is absent and that unspecified attributes may be reset.

Agents need to know what a tool does to the world before calling it. Descriptions should go beyond structured annotations to explain consequences.

Conciseness4/5

Is the description appropriately sized, front-loaded, and free of redundancy?

Two short sentences, front-loaded with the action and followed by the behavioral caveat. Tight and waste-free apart from the unexplained "[UNIFIED]" token.

Shorter descriptions cost fewer tokens and are easier for agents to parse. Every sentence should earn its place.

Completeness2/5

Given the tool's complexity, does the description cover enough for an agent to succeed on first attempt?

For an 8-parameter destructive mutation with zero schema descriptions and no output schema, the definition is far too thin — an agent cannot populate required fields like definition or command semantically, nor anticipate what the response contains after the drop/recreate.

Complex tools with many parameters or behaviors need more documentation. Simple tools need less. This dimension scales expectations accordingly.

Parameters2/5

Does the description clarify parameter syntax, constraints, interactions, or defaults beyond what the schema provides?

Schema description coverage is 0% across 8 parameters, so the description carries the full burden and fails: it says nothing about name, site, table, schema, definition, check, roles, or command, including the notable defaults (roles=["authenticated"], command="ALL", schema="public").

Input schemas describe structure but not intent. Descriptions should explain non-obvious parameter relationships and valid value ranges.

Purpose4/5

Does the description clearly state what the tool does and how it differs from similar tools?

States a specific verb and resource ("Update an existing RLS policy"), which clearly distinguishes it from supabase_create_policy and supabase_delete_policy. The "[UNIFIED]" prefix is unexplained noise that adds no discriminating information.

Agents choose between tools based on descriptions. A clear purpose with a specific verb and resource helps agents select the right tool.

Usage Guidelines2/5

Does the description explain when to use this tool, when not to, or what alternatives exist?

No guidance on when to update versus drop-and-recreate via delete_policy/create_policy, and no prerequisites such as required permissions or whether the table/schema must already exist. The agent must infer everything from the verb.

Agents often have multiple tools that could apply. Explicit usage guidance like "use X instead of Y when Z" prevents misuse.

Deploy Server

Other Tools