supabase-automation by sickn33/antigravity-awesome-skills
npx skills add https://github.com/sickn33/antigravity-awesome-skills --skill supabase-automation通过 Composio 的 Supabase 工具包,自动化执行 Supabase 操作,包括数据库查询、表结构检查、SQL 执行、项目与组织管理、存储桶、边缘函数以及服务健康监控。
RUBE_SEARCH_TOOLS 可用)RUBE_MANAGE_CONNECTIONS 建立活跃的 Supabase 连接,并指定工具包为 supabaseRUBE_SEARCH_TOOLS 以获取当前工具模式获取 Rube MCP:在您的客户端配置中将 https://rube.app/mcp 添加为 MCP 服务器。无需 API 密钥——只需添加端点即可工作。
RUBE_SEARCH_TOOLS 有响应来验证 Rube MCP 是否可用supabase 调用 广告位招租
在这里展示您的产品或服务
触达数万 AI 开发者,精准高效
RUBE_MANAGE_CONNECTIONS使用时机:用户希望从表中读取数据、检查结构或执行 CRUD 操作
工具调用顺序:
SUPABASE_LIST_ALL_PROJECTS - 列出项目以找到目标 project_ref [先决条件]SUPABASE_LIST_TABLES - 列出数据库中的所有表和视图 [先决条件]SUPABASE_GET_TABLE_SCHEMAS - 获取详细的列类型、约束和关系 [写入操作的前提]SUPABASE_SELECT_FROM_TABLE - 通过过滤、排序和分页查询行数据 [读取操作必需]SUPABASE_BETA_RUN_SQL_QUERY - 执行任意 SQL 以进行复杂查询、插入、更新或删除 [写入操作必需]SELECT_FROM_TABLE 的关键参数:
project_ref:20 个小写字母组成的项目引用标识table:要查询的表或视图名称select:逗号分隔的列列表(支持嵌套选择和 JSON 路径,如 profile->avatar_url)filters:过滤器对象数组,包含 column、operator、valueorder:排序表达式,如 created_at.desclimit:返回的最大行数(最小为 1)offset:分页时要跳过的行数PostgREST 过滤器运算符:
eq、neq:等于 / 不等于gt、gte、lt、lte:比较运算符like、ilike:模式匹配(区分大小写 / 不区分大小写)is:IS 检查(用于 null、true、false)in:在值列表中cs、cd:包含 / 被包含(数组)fts、plfts、phfts、wfts:全文搜索变体RUN_SQL_QUERY 的关键参数:
ref:项目引用(20 个小写字母,模式 ^[a-z]{20}$)query:有效的 PostgreSQL SQL 语句read_only:布尔值,强制只读事务(对 SELECT 查询更安全)常见陷阱:
project_ref 必须恰好是 20 个小写字母(仅 a-z,无数字或连字符)SELECT_FROM_TABLE 是只读的;使用 RUN_SQL_QUERY 进行 INSERT、UPDATE、DELETE 操作ARRAY['item1', 'item2'] 或 '{"item1", "item2"}' 语法,而不是 JSON 数组语法 '["item1", "item2"]'使用时机:用户希望列出项目、检查配置或管理组织
工具调用顺序:
SUPABASE_LIST_ALL_ORGANIZATIONS - 列出所有组织(ID 和名称)[必需]SUPABASE_GETS_INFORMATION_ABOUT_THE_ORGANIZATION - 通过 slug 获取详细的组织信息 [可选]SUPABASE_LIST_MEMBERS_OF_AN_ORGANIZATION - 列出组织成员及其角色和 MFA 状态 [可选]SUPABASE_LIST_ALL_PROJECTS - 列出所有项目及其元数据 [必需]SUPABASE_GETS_PROJECT_S_POSTGRES_CONFIG - 获取数据库配置 [可选]SUPABASE_GETS_PROJECT_S_AUTH_CONFIG - 获取身份验证配置 [可选]SUPABASE_GET_PROJECT_API_KEYS - 获取 API 密钥(敏感信息——请谨慎处理)[可选]SUPABASE_GETS_PROJECT_S_SERVICE_HEALTH_STATUS - 检查服务健康状况 [可选]关键参数:
ref:项目特定工具的项目引用slug:组织 slug(URL 友好的标识符),用于组织相关工具services:用于健康检查的服务数组:auth、db、db_postgres_user、pg_bouncer、pooler、realtime、rest、storage常见陷阱:
LIST_ALL_ORGANIZATIONS 返回 id 和 slug;LIST_MEMBERS_OF_AN_ORGANIZATION 期望 slug,而不是 idGET_PROJECT_API_KEYS 返回实时密钥——切勿记录、显示或持久化完整的密钥值GETS_PROJECT_S_SERVICE_HEALTH_STATUS 需要一个非空的 services 数组;空数组会导致 invalid_request 错误使用时机:用户希望了解表结构、列、约束或生成类型定义
工具调用顺序:
SUPABASE_LIST_ALL_PROJECTS - 找到目标项目 [先决条件]SUPABASE_LIST_TABLES - 枚举所有表和视图及其元数据 [必需]SUPABASE_GET_TABLE_SCHEMAS - 获取特定表的详细结构 [必需]SUPABASE_GENERATE_TYPE_SCRIPT_TYPES - 根据结构生成 TypeScript 类型 [可选]LIST_TABLES 的关键参数:
project_ref:项目引用schemas:要搜索的模式名称数组(例如 ["public"]);省略则搜索所有非系统模式include_views:包含视图以及表(默认为 true)include_metadata:包含行数估计和大小信息(默认为 true)include_system_schemas:包含 pg_catalog、information_schema 等(默认为 false)GET_TABLE_SCHEMAS 的关键参数:
project_ref:项目引用table_names:表名数组(每次请求最多 20 个);支持模式前缀,如 public.users、auth.usersinclude_relationships:包含外键信息(默认为 true)include_indexes:包含索引信息(默认为 true)exclude_null_values:通过隐藏空字段获得更清晰的输出(默认为 true)GENERATE_TYPE_SCRIPT_TYPES 的关键参数:
ref:项目引用included_schemas:逗号分隔的模式名称(默认为 "public")常见陷阱:
public 模式row_count 和 size_bytes 对于视图或新创建的表可能为 null;应视为未知,而不是零使用时机:用户希望列出、检查或处理 Supabase 边缘函数
工具调用顺序:
SUPABASE_LIST_ALL_PROJECTS - 找到项目引用 [先决条件]SUPABASE_LIST_ALL_FUNCTIONS - 列出所有边缘函数及其元数据 [必需]SUPABASE_RETRIEVE_A_FUNCTION - 获取特定函数的详细信息 [可选]关键参数:
ref:项目引用常见陷阱:
LIST_ALL_FUNCTIONS 仅返回元数据,不返回函数代码或日志created_at 和 updated_at 可能是纪元毫秒时间戳;请转换为人类可读的时间格式使用时机:用户希望列出存储桶或管理文件存储
工具调用顺序:
SUPABASE_LIST_ALL_PROJECTS - 找到项目引用 [先决条件]SUPABASE_LISTS_ALL_BUCKETS - 列出所有存储桶 [必需]关键参数:
ref:项目引用常见陷阱:
LISTS_ALL_BUCKETS 仅返回存储桶列表,不返回存储桶内容或访问策略SUPABASE_RESUMABLE_UPLOAD_SIGN_OPTIONS_WITH_ID 仅处理 TUS 可恢复上传的 CORS 预检请求proxy_execute 配合 Supabase 存储 APISUPABASE_LIST_ALL_PROJECTS -- 提取 ref 字段(20 个小写字母)SUPABASE_LIST_ALL_ORGANIZATIONS -- 对下游组织工具使用 slug(而非 id)SUPABASE_LIST_TABLES -- 在查询前枚举可用表SUPABASE_GET_TABLE_SCHEMAS -- 在写入前检查列和约束SUPABASE_SELECT_FROM_TABLE:使用 offset + limit 分页。按 limit 递增 offset,直到返回的行数少于 limit。SUPABASE_LIST_ALL_PROJECTS:对于大型账户可能分页;请跟随游标/页码直到耗尽。SUPABASE_LIST_TABLES:对于大型数据库可能分页。SUPABASE_GET_TABLE_SCHEMAS 或 SUPABASE_LIST_TABLESread_only: true 以防止意外修改SELECT * FROM "MyTable" 而不是 SELECT * FROM MyTableARRAY['a', 'b'] 而不是 ['a', 'b']^[a-z]{20}$id(UUID)和 slug(URL 友好字符串)两种形式;不同工具接受的形式不同LIST_MEMBERS_OF_AN_ORGANIZATION 需要 slug,而不是 idBETA_RUN_SQL_QUERY 对复杂操作有约 60 秒的超时限制ARRAY['item'] 或 '{"item"}',而不是 JSON 语法 '["item"]'GET_PROJECT_API_KEYS 返回服务角色密钥——切勿暴露完整值LIST_TABLES 的 row_count 和 size_bytes 可能为 null;不要将其视为零include_system_schemas: true 以查看它们include_views: false,否则视图将与表一起显示GETS_PROJECT_S_SERVICE_HEALTH_STATUS 在 services 数组为空时会失败——请始终至少指定一项| 任务 | 工具标识 | 关键参数 |
|---|---|---|
| 列出组织 | SUPABASE_LIST_ALL_ORGANIZATIONS | (无) |
| 获取组织信息 | SUPABASE_GETS_INFORMATION_ABOUT_THE_ORGANIZATION | slug |
| 列出组织成员 | SUPABASE_LIST_MEMBERS_OF_AN_ORGANIZATION | slug |
| 列出项目 | SUPABASE_LIST_ALL_PROJECTS | (无) |
| 列出表 | SUPABASE_LIST_TABLES | project_ref、schemas |
| 获取表结构 | SUPABASE_GET_TABLE_SCHEMAS | project_ref、table_names |
| 查询表 | SUPABASE_SELECT_FROM_TABLE | project_ref、table、select、filters |
| 运行 SQL | SUPABASE_BETA_RUN_SQL_QUERY | ref、query、read_only |
| 生成 TS 类型 | SUPABASE_GENERATE_TYPE_SCRIPT_TYPES | ref、included_schemas |
| Postgres 配置 | SUPABASE_GETS_PROJECT_S_POSTGRES_CONFIG | ref |
| 身份验证配置 | SUPABASE_GETS_PROJECT_S_AUTH_CONFIG | ref |
| 获取 API 密钥 | SUPABASE_GET_PROJECT_API_KEYS | ref |
| 服务健康状态 | SUPABASE_GETS_PROJECT_S_SERVICE_HEALTH_STATUS | ref、services |
| 列出边缘函数 | SUPABASE_LIST_ALL_FUNCTIONS | ref |
| 获取边缘函数 | SUPABASE_RETRIEVE_A_FUNCTION | ref、函数 slug |
| 列出存储桶 | SUPABASE_LISTS_ALL_BUCKETS | ref |
| 列出数据库分支 | SUPABASE_LIST_ALL_DATABASE_BRANCHES | ref |
此技能适用于执行概述中描述的工作流或操作。
每周安装量
105
代码仓库
GitHub 星标数
27.4K
首次出现
2026 年 2 月 6 日
安全审计
安装于
codex100
opencode99
gemini-cli97
github-copilot97
kimi-cli97
amp96
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.
RUBE_MANAGE_CONNECTIONS with toolkit supabaseRUBE_SEARCH_TOOLS first to get current tool schemasGet 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.
RUBE_SEARCH_TOOLS respondsRUBE_MANAGE_CONNECTIONS with toolkit supabaseWhen 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 referencetable: Table or view name to queryselect: Comma-separated column list (supports nested selections and JSON paths like profile->avatar_url)filters: Array of filter objects with column, operator, valueorder: Sort expression like created_at.descPostgREST filter operators :
eq, neq: Equal / not equalgt, gte, lt, lte: Comparison operatorslike, ilike: Pattern matching (case-sensitive / insensitive)is: IS check (for null, true, false)in: In a list of valuescs, : Contains / contained by (arrays)Key parameters for RUN_SQL_QUERY :
ref: Project reference (20 lowercase letters, pattern ^[a-z]{20}$)query: Valid PostgreSQL SQL statementread_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 operationsARRAY['item1', 'item2'] or '{"item1", "item2"}' syntax, NOT JSON array syntax '["item1", "item2"]'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 toolsslug: Organization slug (URL-friendly identifier) for org toolsservices: Array of services for health check: auth, db, db_postgres_user, pg_bouncer, pooler, realtime, rest, storagePitfalls :
LIST_ALL_ORGANIZATIONS returns both id and slug; LIST_MEMBERS_OF_AN_ORGANIZATION expects slug, not idGET_PROJECT_API_KEYS returns live secrets -- NEVER log, display, or persist full key valuesGETS_PROJECT_S_SERVICE_HEALTH_STATUS requires a non-empty services array; empty array causes invalid_request errorWhen 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 referenceschemas: Array of schema names to search (e.g., ["public"]); omit for all non-system schemasinclude_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 referencetable_names: Array of table names (max 20 per request); supports schema prefix like public.users, auth.usersinclude_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 referenceincluded_schemas: Comma-separated schema names (default "public")Pitfalls :
public schemarow_count and size_bytes from LIST_TABLES may be null for views or recently created tables; treat as unknown, not zeroWhen 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 referencePitfalls :
LIST_ALL_FUNCTIONS returns metadata only, not function code or logscreated_at and updated_at may be epoch milliseconds; convert to human-readable timestampsWhen 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 referencePitfalls :
LISTS_ALL_BUCKETS returns bucket list only, not bucket contents or access policiesSUPABASE_RESUMABLE_UPLOAD_SIGN_OPTIONS_WITH_ID handles CORS preflight for TUS resumable uploads onlyproxy_execute with the Supabase storage APISUPABASE_LIST_ALL_PROJECTS -- extract ref field (20 lowercase letters)SUPABASE_LIST_ALL_ORGANIZATIONS -- use slug (not id) for downstream org toolsSUPABASE_LIST_TABLES -- enumerate available tables before queryingSUPABASE_GET_TABLE_SCHEMAS -- inspect columns and constraints before writesSUPABASE_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.SUPABASE_GET_TABLE_SCHEMAS or SUPABASE_LIST_TABLES before writing SQLread_only: true for SELECT queries to prevent accidental mutationsSELECT * FROM "MyTable" not SELECT * FROM MyTableARRAY['a', 'b'] not ['a', 'b']^[a-z]{20}$id (UUID) and slug (URL-friendly string); tools vary in which they acceptLIST_MEMBERS_OF_AN_ORGANIZATION requires slug, not idBETA_RUN_SQL_QUERY has ~60 second timeout for complex operationsARRAY['item'] or '{"item"}', NOT JSON syntax '["item"]'GET_PROJECT_API_KEYS returns service-role keys -- NEVER expose full valuesrow_count and size_bytes from LIST_TABLES can be null; do not treat as zeroinclude_system_schemas: true to see theminclude_views: falseGETS_PROJECT_S_SERVICE_HEALTH_STATUS fails with empty services array -- always specify at least one| Task | Tool Slug | Key Params |
|---|---|---|
| List organizations | SUPABASE_LIST_ALL_ORGANIZATIONS | (none) |
| Get org info | SUPABASE_GETS_INFORMATION_ABOUT_THE_ORGANIZATION | slug |
| List org members | SUPABASE_LIST_MEMBERS_OF_AN_ORGANIZATION | slug |
| List projects | SUPABASE_LIST_ALL_PROJECTS |
This skill is applicable to execute the workflow or actions described in the overview.
Weekly Installs
105
Repository
GitHub Stars
27.4K
First Seen
Feb 6, 2026
Security Audits
Gen Agent Trust HubWarnSocketWarnSnykWarn
Installed on
codex100
opencode99
gemini-cli97
github-copilot97
kimi-cli97
amp96
Azure 升级评估与自动化工具 - 轻松迁移 Functions 计划、托管层级和 SKU
96,200 周安装
limitoffset: Rows to skip for paginationcdfts, plfts, phfts, wfts: Full-text search variants| (none) |
| List tables | SUPABASE_LIST_TABLES | project_ref, schemas |
| Get table schemas | SUPABASE_GET_TABLE_SCHEMAS | project_ref, table_names |
| Query table | SUPABASE_SELECT_FROM_TABLE | project_ref, table, select, filters |
| Run SQL | SUPABASE_BETA_RUN_SQL_QUERY | ref, query, read_only |
| Generate TS types | SUPABASE_GENERATE_TYPE_SCRIPT_TYPES | ref, included_schemas |
| Postgres config | SUPABASE_GETS_PROJECT_S_POSTGRES_CONFIG | ref |
| Auth config | SUPABASE_GETS_PROJECT_S_AUTH_CONFIG | ref |
| Get API keys | SUPABASE_GET_PROJECT_API_KEYS | ref |
| Service health | SUPABASE_GETS_PROJECT_S_SERVICE_HEALTH_STATUS | ref, services |
| List edge functions | SUPABASE_LIST_ALL_FUNCTIONS | ref |
| Get edge function | SUPABASE_RETRIEVE_A_FUNCTION | ref, function slug |
| List storage buckets | SUPABASE_LISTS_ALL_BUCKETS | ref |
| List DB branches | SUPABASE_LIST_ALL_DATABASE_BRANCHES | ref |