// MCP TOOL REFERENCE

POSTGREST TOOLS

32 tools from the PostgREST MCP Server, categorised by risk level.

// ALL 32 POSTGREST TOOLS

READ 21 tools

Read get_advisors Gets a list of advisory notices for a Supabase project. LLMs can use this to check for security vulnerabili... Read get_cost Gets the cost of a new project or branch for an organization. Read get_edge_function Retrieves file contents for an Edge Function in a Supabase project. Read get_logs Gets logs for a Supabase project by service type (api, postgres, edge functions, auth, storage, realtime). ... Read get_organization Gets details for an organization. Read get_project Gets details for a project. Read get_project_url Gets the API URL for a project. Read get_publishable_keys Gets the anonymous API keys for a project. Returns an array of client-safe API keys including legacy anon k... Read get_storage_config Gets the storage config for a Supabase project. Read list_branches Lists all development branches. Read list_edge_functions Lists all Edge Functions in a Supabase project. Read list_extensions Lists all extensions in the database. Read list_migrations Lists all migrations in the database. Read list_organizations Lists all organizations that the user is a member of. Read list_projects Lists all Supabase projects for the user. Read list_storage_buckets Lists all storage buckets in a Supabase project. Read list_tables Lists all tables within the specified schemas. Read pause_project Pauses a project. Read rebase_branch Rebases development branch on production to handle migration drift. Read search_docs Searches the Supabase documentation for up-to-date information. LLMs can use this to find answers to questi... Read generate_typescript_types Generates TypeScript types based on the database schema. LLMs can save this to a file and use it in their c...

WRITE 4 tools

Write create_branch Creates a development branch with migrations from production branch. Write create_project Creates a new Supabase project. Write restore_project Restores a project. Write update_storage_config Updates the storage config for a Supabase project (requires a paid plan).

DESTRUCTIVE 2 tools

Destructive delete_branch Deletes a development branch. Destructive reset_branch Resets migrations of a development branch to a prior version.

EXECUTE 4 tools

Execute deploy_edge_function Deploys a new Edge Function to a Supabase project. LLMs can use this to deploy new functions or update exis... Execute execute_sql Executes raw SQL in the database. LLMs should use this for regular queries that don't change the schema. Execute apply_migration Applies a SQL migration to the database. SQL passed to this tool will be tracked within the database, so LL... Execute merge_branch Merges migrations and edge functions from a development branch to production.

FINANCIAL 1 tools

Financial confirm_cost Confirms the user's understanding of new project or branch costs. This is required to create a new project ...

// FAQ

How many tools does the PostgREST MCP server have? +

The PostgREST MCP server exposes 32 tools across 5 categories: Read, Write, Destructive, Execute, Financial.

How do I enforce policies on PostgREST tools? +

Route the PostgREST server through the PolicyLayer gateway. Define allow, deny, or approval rules per tool in the dashboard; they are enforced on every call before it reaches the server.

What risk categories do PostgREST tools fall into? +

PostgREST tools are categorised as Read (21), Write (4), Destructive (2), Execute (4), Financial (1). Each category has a recommended default policy.

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.

GOVERN POSTGREST →

Free to start. No card required.

42,500+ MCP servers and 110,000+ tools scanned and risk-classified.