Open Skills Logo
Open Skills

supabase-automation

通过Rube MCP（Composio）自动化Supabase数据库查询、表管理、项目管理、存储操作、边缘函数执行及SQL命令运行。始终优先使用工具检索当前数据库架构信息。

查看详情
name:supabase-automationdescription:Automate Supabase database queries, table management, project administration, storage, edge functions, and SQL execution via Rube MCP (Composio). Always search tools first for current schemas.requires:mcp:[rube]

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.

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.


  • Verify Rube MCP is available by confirming RUBE_SEARCH_TOOLS responds

  • Call RUBE_MANAGE_CONNECTIONS with toolkit supabase

  • If connection is not ACTIVE, follow the returned auth link to complete Supabase authentication

  • 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:

  • SUPABASE_LIST_ALL_PROJECTS - List projects to find the target project_ref [Prerequisite]

  • SUPABASE_LIST_TABLES - List all tables and views in the database [Prerequisite]

  • SUPABASE_GET_TABLE_SCHEMAS - Get detailed column types, constraints, and relationships [Prerequisite for writes]

  • SUPABASE_SELECT_FROM_TABLE - Query rows with filtering, sorting, and pagination [Required for reads]

  • SUPABASE_BETA_RUN_SQL_QUERY - Execute arbitrary SQL for complex queries, inserts, updates, or deletes [Required for writes]

    • Key parameters for SELECT_FROM_TABLE:

  • project_ref: 20-character lowercase project reference

  • table: Table or view name to query

  • select: Comma-separated column list (supports nested selections and JSON paths like profile->avatar_url)

  • filters: Array of filter objects with column, operator, value

  • order: Sort expression like created_at.desc

  • limit: Max rows to return (minimum 1)

  • offset: Rows to skip for pagination

    • PostgREST filter operators:

  • eq, neq: Equal / not equal

  • gt, gte, lt, lte: Comparison operators

  • like, ilike: Pattern matching (case-sensitive / insensitive)

  • is: IS check (for null, true, false)

  • in: In a list of values

  • cs, cd: Contains / contained by (arrays)

  • fts, plfts, phfts, wfts: Full-text search variants

    • Key parameters for RUN_SQL_QUERY:

  • ref: Project reference (20 lowercase letters, pattern ^[a-z]{20}$)

  • query: Valid PostgreSQL SQL statement

  • read_only: Boolean to force read-only transaction (safer for SELECTs)

    • Pitfalls:

  • project_ref must be exactly 20 lowercase letters (a-z only, no numbers or hyphens)

  • SELECT_FROM_TABLE is read-only; use RUN_SQL_QUERY for INSERT, UPDATE, DELETE operations

  • For PostgreSQL array columns (text[], integer[]), use ARRAY['item1', 'item2'] or '{"item1", "item2"}' syntax, NOT JSON array syntax '["item1", "item2"]'

  • SQL identifiers that are case-sensitive must be double-quoted in queries

  • Complex DDL operations may timeout (~60 second limit); break into smaller queries

  • ERROR 42P01 "relation does not exist" usually means unquoted case-sensitive identifiers

  • ERROR 42883 "function does not exist" means you are calling non-standard helpers; prefer information_schema queries

    • 2. Manage Projects and Organizations

    When to use: User wants to list projects, inspect configurations, or manage organizations

    Tool sequence:

  • SUPABASE_LIST_ALL_ORGANIZATIONS - List all organizations (IDs and names) [Required]

  • SUPABASE_GETS_INFORMATION_ABOUT_THE_ORGANIZATION - Get detailed org info by slug [Optional]

  • SUPABASE_LIST_MEMBERS_OF_AN_ORGANIZATION - List org members with roles and MFA status [Optional]

  • SUPABASE_LIST_ALL_PROJECTS - List all projects with metadata [Required]

  • SUPABASE_GETS_PROJECT_S_POSTGRES_CONFIG - Get database configuration [Optional]

  • SUPABASE_GETS_PROJECT_S_AUTH_CONFIG - Get authentication configuration [Optional]

  • SUPABASE_GET_PROJECT_API_KEYS - Get API keys (sensitive -- handle carefully) [Optional]

  • SUPABASE_GETS_PROJECT_S_SERVICE_HEALTH_STATUS - Check service health [Optional]

    • Key parameters:

  • ref: Project reference for project-specific tools

  • slug: Organization slug (URL-friendly identifier) for org tools

  • services: Array of services for health check: auth, db, db_postgres_user, pg_bouncer, pooler, realtime, rest, storage

    • Pitfalls:

  • LIST_ALL_ORGANIZATIONS returns both id and slug; LIST_MEMBERS_OF_AN_ORGANIZATION expects slug, not id

  • GET_PROJECT_API_KEYS returns live secrets -- NEVER log, display, or persist full key values

  • GETS_PROJECT_S_SERVICE_HEALTH_STATUS requires a non-empty services array; empty array causes invalid_request error

  • Config tools may return 401/403 if token lacks required scope; handle gracefully rather than failing the whole workflow

    • 3. Inspect Database Schema

    When to use: User wants to understand table structure, columns, constraints, or generate types

    Tool sequence:

  • SUPABASE_LIST_ALL_PROJECTS - Find the target project [Prerequisite]

  • SUPABASE_LIST_TABLES - Enumerate all tables and views with metadata [Required]

  • SUPABASE_GET_TABLE_SCHEMAS - Get detailed schema for specific tables [Required]

  • SUPABASE_GENERATE_TYPE_SCRIPT_TYPES - Generate TypeScript types from schema [Optional]

    • Key parameters for LIST_TABLES:

  • project_ref: Project reference

  • schemas: Array of schema names to search (e.g., ["public"]); omit for all non-system schemas

  • include_views: Include views alongside tables (default true)

  • include_metadata: Include row count estimates and sizes (default true)

  • include_system_schemas: Include pg_catalog, information_schema, etc. (default false)

    • Key parameters for GET_TABLE_SCHEMAS:

  • project_ref: Project reference

  • table_names: Array of table names (max 20 per request); supports schema prefix like public.users, auth.users

  • include_relationships: Include foreign key info (default true)

  • include_indexes: Include index info (default true)

  • exclude_null_values: Cleaner output by hiding null fields (default true)

    • Key parameters for GENERATE_TYPE_SCRIPT_TYPES:

  • ref: Project reference

  • included_schemas: Comma-separated schema names (default "public")

    • Pitfalls:

  • Table names without schema prefix assume public schema

  • row_count and size_bytes from LIST_TABLES may be null for views or recently created tables; treat as unknown, not zero

  • GET_TABLE_SCHEMAS has a max of 20 tables per request; batch if needed

  • TypeScript types include all tables in specified schemas; cannot filter individual tables

    • 4. Manage Edge Functions

    When to use: User wants to list, inspect, or work with Supabase Edge Functions

    Tool sequence:

  • SUPABASE_LIST_ALL_PROJECTS - Find the project reference [Prerequisite]

  • SUPABASE_LIST_ALL_FUNCTIONS - List all edge functions with metadata [Required]

  • SUPABASE_RETRIEVE_A_FUNCTION - Get detailed info for a specific function [Optional]

    • Key parameters:

  • ref: Project reference

  • Function slug for RETRIEVE_A_FUNCTION

    • Pitfalls:

  • LIST_ALL_FUNCTIONS returns metadata only, not function code or logs

  • created_at and updated_at may be epoch milliseconds; convert to human-readable timestamps

  • These tools cannot create or deploy edge functions; they are read-only inspection tools

  • Permission errors may occur without org/project admin rights

    • 5. Manage Storage Buckets

    When to use: User wants to list storage buckets or manage file storage

    Tool sequence:

  • SUPABASE_LIST_ALL_PROJECTS - Find the project reference [Prerequisite]

  • SUPABASE_LISTS_ALL_BUCKETS - List all storage buckets [Required]

    • Key parameters:

  • ref: Project reference

    • Pitfalls:

  • LISTS_ALL_BUCKETS returns bucket list only, not bucket contents or access policies

  • For file uploads, SUPABASE_RESUMABLE_UPLOAD_SIGN_OPTIONS_WITH_ID handles CORS preflight for TUS resumable uploads only

  • Direct file operations may require using proxy_execute with the Supabase storage API

    • Common Patterns

    ID Resolution


  • Project reference: SUPABASE_LIST_ALL_PROJECTS -- extract ref field (20 lowercase letters)

  • Organization slug: SUPABASE_LIST_ALL_ORGANIZATIONS -- use slug (not id) for downstream org tools

  • Table names: SUPABASE_LIST_TABLES -- enumerate available tables before querying

  • Schema discovery: SUPABASE_GET_TABLE_SCHEMAS -- inspect columns and constraints before writes

    • Pagination


  • SUPABASE_SELECT_FROM_TABLE: Uses offset + limit pagination. Increment offset by limit until fewer rows than limit are returned.

  • SUPABASE_LIST_ALL_PROJECTS: May paginate for large accounts; follow cursors/pages until exhausted.

  • SUPABASE_LIST_TABLES: May paginate for large databases.

    • SQL Best Practices


  • Always use SUPABASE_GET_TABLE_SCHEMAS or SUPABASE_LIST_TABLES before writing SQL

  • Use read_only: true for SELECT queries to prevent accidental mutations

  • Quote case-sensitive identifiers: SELECT FROM "MyTable" not SELECT FROM MyTable

  • Use PostgreSQL array syntax for array columns: ARRAY['a', 'b'] not ['a', 'b']

  • Break complex DDL into smaller statements to avoid timeouts

    • Known Pitfalls

    ID Formats


  • Project references are exactly 20 lowercase letters (a-z): pattern ^[a-z]{20}$

  • Organization identifiers come as both id (UUID) and slug (URL-friendly string); tools vary in which they accept

  • LIST_MEMBERS_OF_AN_ORGANIZATION requires slug, not id

    • SQL Execution


  • BETA_RUN_SQL_QUERY has ~60 second timeout for complex operations

  • PostgreSQL array syntax required: ARRAY['item'] or '{"item"}', NOT JSON syntax '["item"]'

  • Case-sensitive identifiers must be double-quoted in SQL

  • ERROR 42P01: relation does not exist (check quoting and schema prefix)

  • ERROR 42883: function does not exist (use information_schema instead of custom helpers)

    • Sensitive Data


  • GET_PROJECT_API_KEYS returns service-role keys -- NEVER expose full values

  • Auth config tools exclude secrets but may still contain sensitive configuration

  • Always mask or truncate API keys in output

    • Schema Metadata


  • row_count and size_bytes from LIST_TABLES can be null; do not treat as zero

  • System schemas are excluded by default; set include_system_schemas: true to see them

  • Views appear alongside tables unless include_views: false

    • Rate Limits and Permissions


  • Enrichment tools (API keys, configs) may return 401/403 without proper scopes; skip gracefully

  • Large table listings may require pagination

  • GETS_PROJECT_S_SERVICE_HEALTH_STATUS fails with empty services array -- always specify at least one

    • Quick Reference

    TaskTool SlugKey Params
    List organizationsSUPABASE_LIST_ALL_ORGANIZATIONS(none)
    Get org infoSUPABASE_GETS_INFORMATION_ABOUT_THE_ORGANIZATIONslug
    List org membersSUPABASE_LIST_MEMBERS_OF_AN_ORGANIZATIONslug
    List projectsSUPABASE_LIST_ALL_PROJECTS(none)
    List tablesSUPABASE_LIST_TABLESproject_ref, schemas
    Get table schemasSUPABASE_GET_TABLE_SCHEMASproject_ref, table_names
    Query tableSUPABASE_SELECT_FROM_TABLEproject_ref, table, select, filters
    Run SQLSUPABASE_BETA_RUN_SQL_QUERYref, query, read_only
    Generate TS typesSUPABASE_GENERATE_TYPE_SCRIPT_TYPESref, included_schemas
    Postgres configSUPABASE_GETS_PROJECT_S_POSTGRES_CONFIGref
    Auth configSUPABASE_GETS_PROJECT_S_AUTH_CONFIGref
    Get API keysSUPABASE_GET_PROJECT_API_KEYSref
    Service healthSUPABASE_GETS_PROJECT_S_SERVICE_HEALTH_STATUSref, services
    List edge functionsSUPABASE_LIST_ALL_FUNCTIONSref
    Get edge functionSUPABASE_RETRIEVE_A_FUNCTIONref, function slug
    List storage bucketsSUPABASE_LISTS_ALL_BUCKETSref
    List DB branchesSUPABASE_LIST_ALL_DATABASE_BRANCHESref