Supabase MCP connector

Supabase is an open-source backend platform built on PostgreSQL that provides database, authentication, storage, and real-time APIs for building scalable applications. The Supabase MCP connector allows AI agents to query and modify database tables, retrieve schema information, and restore project snapshots. It also supports managing table data through create, update, and delete operations across your Supabase instance.

Authentication type

• OAuth 2.0 Authorization Code - Requires a one-time user login to authorize the agent to access the service on their behalf.

Uses

Use the Supabase MCP connector to perform the following actions:

• Retrieve customer records from Supabase to populate CRM workflows
• Insert new order transactions into Supabase from e-commerce platforms
• Update product inventory levels in Supabase when sales occur
• Delete expired records from Supabase to maintain data compliance
• Extract database schema from Supabase to audit table structures
• Restore Supabase projects after accidental data loss or corruption
• Sync user account changes across applications using Supabase as the source

Example prompts

Use the following example prompts to invoke Supabase MCP connector tools from your AI assistant or Boomi Connect workflow:

• Show me all active customers from the users table in Supabase.
• Create a new order record in Supabase with today's transaction data.
• Update the inventory count for product SKU-12345 in Supabase.
• Delete all expired promotional codes from the promotions table in Supabase.
• What columns exist in the orders table in my Supabase database?
• Restore my Supabase project to the backup from last week.
• Get all unpaid invoices from the last 30 days in Supabase.
• Add 50 new employee records to the staff table in Supabase.
• Find all customers who made purchases above $1,000 in Supabase.
• Remove duplicate entries from the contacts table in Supabase.

Supabase MCP connector tools

The Supabase MCP connector provides the following tools. Each tool maps to a specific action you can invoke from your AI agent or automation.

Tool	Description
supabase_supabaserestoreproject_invoke	Restores a previously backed-up project to a specified point in time.
getSchema	Retrieves the structure and definitions of all tables in the database.
getRows	Fetches records from a specified table with optional filtering and sorting.
createRows	Inserts new records into a table with the provided data.
updateRows	Modifies existing records in a table based on specified conditions.
deleteRows	Removes records from a table matching the given criteria.