Supabase MCP connector
Supabase is an open-source backend-as-a-service platform built on top of PostgreSQL that provides database, authentication, and storage infrastructure for applications. The Supabase MCP connector allows AI agents to query and manage database schemas, read and write table records, and restore projects when needed. It also supports broader database administration tasks, helping teams maintain data integrity and streamline application backend operations.
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 instantly from Supabase tables for quick business review
- Add new orders or leads directly into Supabase without manual entry
- Update inventory counts or customer statuses across Supabase tables in real time
- Remove outdated or duplicate records from Supabase to keep data clean
- Inspect table structures in Supabase before building new workflows or reports
- Recover a Supabase project quickly after accidental deletion or configuration errors
- Sync business data between Supabase and other workflow tools automatically
Example prompts
Use the following example prompts to invoke Supabase MCP connector tools from your AI assistant or Boomi Connect workflow:
Show me all open invoices from last month in Supabase.Add a new customer record to my Supabase orders table.Update the shipping status for order 4521 in Supabase.Delete the duplicate contact entries from my Supabase database.What tables and columns exist in my Supabase project?Restore my Supabase project to its last working state.Pull all rows from the inventory table in Supabase.Create three new product listings in Supabase.Find customers in Supabase who haven't ordered in 90 days.Update the price for all items in the clearance category 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 | Restore a project in Supabase |
| getSchema | Get database schema |
| getRows | Get rows from table |
| createRows | Create new rows |
| updateRows | Update existing rows |
| deleteRows | Delete rows |
