supabase-automation

# Supabase Automation via Rube MCP Automate Supabase operations including database queries, table schema inspection, SQL execution, project and organization management, storage buckets, edge functions, and service health monitoring through Composio's Supabase toolkit. **Toolkit docs**: [composio.dev/toolkits/supabase](https://composio.dev/toolkits/supabase) ## Prerequisites - Rube MCP must be connected (RUBE_SEARCH_TOOLS available) - Active Supabase connection via `RUBE_MANAGE_CONNECTIONS` with toolkit `supabase` - Always call `RUBE_SEARCH_TOOLS` first to get current tool schemas ## Setup **Get Rube MCP**: Add `https://rube.app/mcp` as an MCP server in your client configuration. No API keys needed — just add the endpoint and it works. 1. Verify Rube MCP is available by confirming `RUBE_SEARCH_TOOLS` responds 2. Call `RUBE_MANAGE_CONNECTIONS` with toolkit `supabase` 3. If connection is not ACTIVE, follow the returned auth link to complete Supabase authentication 4. Confirm connection status shows ACTIVE before running any workflows ## Core Workflows ### 1. Query and Manage Database Tables **When to use**: User wants to read data from tables, inspect schemas, or perform CRUD operations **Tool sequence**: 1. `SUPABASE_LIST_ALL_PROJECTS` - List projects to find the target project_ref [Prerequisite] 2. `SUPABASE_LIST_TABLES` - List all tables and views in the database [Prerequisite] 3. `SUPABASE_GET_TABLE_SCHEMAS` - Get detailed column types, constraints, and relations...