Low Risk

list_migrations

Lists all migrations in the database.

How to control list_migrations ↓

AI agents call list_migrations to retrieve information from PostgREST without modifying anything — typically the context-gathering step in research, monitoring, and reporting workflows, before the agent takes action elsewhere.

Low Risk

This tool performs a read-only operation to enumerate existing database migrations. It has no side effects, does not execute code, and does not modify or delete data. The blast radius of misuse is minimal—an AI agent listing migrations could at worst gather information about database schema changes, but cannot cause harm through this tool alone.

From the tool's definition Tool name 'list_migrations' and description 'Lists all migrations in the database' indicate a query operation that retrieves information without modifying or executing anything.

Documented attack patterns abuse exactly the kind of access list_migrations gives an agent:

PolicyLayer is an MCP gateway — it sits between your AI agents and PostgREST, and nothing reaches the server without passing your rules. This is the rule we recommend for list_migrations:

policy.json
{
  "version": "1",
  "default": "deny",
  "tools": {
    "list_migrations": {}
  }
}

list_migrations is read-only, so it stays allowed — but everything else on the server is denied unless you say otherwise.

  1. Create a free account and register PostgREST — nothing to install.
  2. Add this policy — paste it, or build it visually.
  3. Point your MCP client (Claude, Cursor, anything) at your gateway URL.
CAP THIS TOOL →

Free to start. No card required.

Go deeper

What does the list_migrations tool do? +

Lists all migrations in the database. It is categorised as a Read tool in the PostgREST MCP Server, which means it retrieves data without modifying state.

How do I enforce a policy on list_migrations? +

Register the PostgREST MCP server in PolicyLayer and add a rule for list_migrations: allow, deny, rate-limit, or require approval. Point your MCP client at the PolicyLayer proxy URL and the rule is enforced on every call, before it reaches PostgREST. Nothing to install.

What risk level is list_migrations? +

list_migrations is a Read tool with low risk. Read-only tools are generally safe to allow by default.

Can I rate-limit list_migrations? +

Yes. Add a rate_limit block to the list_migrations rule in your PolicyLayer policy. For example, setting max: 10 and window: 60 limits the tool to 10 calls per minute. Rate limits are tracked per agent session and reset automatically.

How do I block list_migrations completely? +

Set action: deny in the PolicyLayer policy for list_migrations. The AI agent will receive a policy violation error and cannot call the tool. You can also include a reason field to explain why the tool is blocked.

What MCP server provides list_migrations? +

list_migrations is provided by the PostgREST MCP server (supabase/mcp). PolicyLayer sits as a proxy in front of this server to enforce policies before tool calls reach the server.

Enforce policy on every PostgREST tool call.

Deterministic rules across all 32 PostgREST tools. Per-identity grants. Full audit log. Live in minutes. Nothing to install.

Free to start. No card required.

32 PostgREST tools catalogued and risk-classified — across an index of 42,500+ MCP servers.

// GET IN TOUCH

Have a question or want to learn more? Send us a message.

Message sent.

We'll get back to you soon.