Supabase

Supabase MCP Connector for Claude

A+

Connect your AI to Supabase. Execute database queries, manage users, and trigger PostgreSQL functions directly from your terminal.

13 tools Official Updated Jun 28, 2026 Official Vinkius Partner

Integrate the comprehensive backend infrastructure of Supabase straight into your conversational LLM workflows. By securely authenticating with your service_role key, your AI assistant bypasses row-level security constraints, operating as a fully-privileged database administrator. Query rows, invoke complex PL/pgSQL functions via RPC, evaluate the authenticated user roster, and audit your active storage buckets all through simple natural language commands, accelerating debugging and environment iterations without leaving the terminal.

What you can do

  • Database Interactions — Actively query datasets using db_select, seamlessly add new rows executing db_insert, and modify existing data structures applying db_update or db_delete.
  • Custom Functional Logic — Invoke pre-compiled database procedures and PL/pgSQL functions securely utilizing db_rpc with dynamic JSON arguments.
  • Authentication Tracking — Audit your userbase and confirm authentication statuses instantly fetching native rosters through list_auth_users.
  • Storage Diagnostics — Inspect configured object storage containers mapping file architectures securely invoking list_storage_buckets.

How it works

  1. Enable the Supabase MCP plugin as an active integration inside your configuration.
  2. In the parameter matrix, bind your exact SUPABASE_URL and authenticate the AI utilizing your powerful SUPABASE_SERVICE_ROLE_KEY.
  3. Instruct your AI securely: "Retrieve the last 10 users from the 'subscribers' table where the status is 'active', and verify if our 'profiles' storage bucket is operational."

Who is this for?

  • PostgreSQL Database Administrators — Run complex validation queries and invoke custom RPCs flawlessly parsing responses directly during analytical review workflows.
  • Backend Developers — Iterate database structures, mock rapid insertions, and securely alter state without opening external platforms or writing repetitive query scripts.
  • Full-Stack Engineers — Seamlessly query backend storage or resolve user authorization bugs directly tracking the root dependencies visually connected inside the IDE/CLI environment.
postgresqlbackend-as-a-servicedatabase-managementapi-generationrow-level-security

13 tools expose this connector's capabilities to your AI agent.

delete_auth_user

Requires service_role key. This action is irreversible. Delete an authenticated user permanently

create_storage_bucket

Optionally make it public for unauthenticated reads. Create a new storage bucket

delete_storage_file

Provide a comma-separated list of file paths. Delete files from a storage bucket

get_auth_user

Get detailed information about a specific authenticated user

list_auth_users

List authenticated users from Supabase Auth

db_count

Useful for pagination and analytics. Count rows in a database table with optional filters

db_delete

A match_query is mandatory. This action is irreversible. Delete rows from a database table

db_insert

Provide the payload as a JSON string. Insert a new row into a database table

db_rpc

Provide the function name and optional JSON arguments. Execute a Supabase Postgres Function (RPC)

db_select

For filters, use match_query (e.g. "id=eq.1"). Defaults to 50 rows. Query records from any PostgreSQL database table using PostgREST syntax

db_update

A match_query is required to target specific rows (e.g. "id=eq.123"). Update existing rows in a database table

list_storage_buckets

List all available storage buckets

list_storage_files

List files inside a storage bucket

See how to talk to your AI agent using Supabase.

Verify the 'inventory_products' table sequentially effectively correctly querying all products labeled 'out-of-stock'.

Confirming connections internally locally effectively... **Records Accessed Matrix (`db_select`)**: - Target table: `inventory_products` - Applying filtering natively: `status=eq.out-of-stock` Returning 12 distinct entries reliably safely. Execution successful locally.

Trigger the custom stored procedure 'restock_items' using `db_rpc` to replenish the inventory of IDs 12 and 15 natively.

Preparing RPC execution parameter payload locally... Calling `db_rpc` mapped to 'restock_items' with arguments: `{"ids": [12, 15]}` naturally. Response matrix from PostgreSQL indicates correct execution cleanly dynamically successfully. Items restocked securely.

Check all registered accounts dynamically applying `list_auth_users` for recent logins natively securely.

Authenticating logic cleanly verifying parameters... **Supabase Auth Operatives Located (`list_auth_users`)**: - 15 total authentications indexed. - Latest user confirmed successfully natively. Task complete organically.

The MCP integration operates inherently as an administration module properly securely autonomously. Utilizing the `service_role` actively gracefully securely circumvents logical Row Level Security settings globally, empowering correct system manipulation properly dynamically successfully without error friction organically.

Related Connectors