# supabase-automation

supabase-automation automates Supabase database queries, schema inspections, SQL execution, and project administration via Rube MCP in Claude Code and Cursor.

- skill · `type=skill` · Claude Code, Cursor, Codex, GitHub Copilot, Gemini CLI, Windsurf (Devin Desktop), Claude.ai · ★ 3785 repo stars
- Author: BuildWithClaude Community
- License: MIT · policy=mirror · the beginning of the file is at the end of this page
- Source: https://github.com/davepoon/buildwithclaude/tree/HEAD/plugins/all-skills/skills/supabase-automation/SKILL.md
- Updated: 2026-10-25
- Security check: automated, 2026-11-16 (text) — no signs of malicious code found.
- HTML: https://affpapa.org/en/nevibecode/skills/supabase-automation

## What it does

The skill equips the agent with execution sequences for Supabase management via Composio. It handles reading table rows with PostgREST filters, running custom PostgreSQL queries, generating TypeScript definitions, and tracking service health.

Workflows start with checking tool schemas via `RUBE_SEARCH_TOOLS` and validating credentials through `RUBE_MANAGE_CONNECTIONS`. Table reads run through `SUPABASE_SELECT_FROM_TABLE`, whereas record insertions, updates, and schema migrations rely on `SUPABASE_BETA_RUN_SQL_QUERY`.

Without the Rube MCP endpoint `https://rube.app/mcp` configured in your client, the skill cannot execute any actions. The `project_ref` parameter strictly expects 20 lowercase letters, and unquoted case-sensitive table identifiers lead directly to PostgreSQL error 42P01.

## Requirements
- Works with: Supabase

## Install

### Claude Code (native platform)

1. **Plugin marketplace**
In the agent chat (not a shell):
```text
/plugin marketplace add davepoon/buildwithclaude
```
In the agent chat (not a shell):
```text
/plugin install all-skills@buildwithclaude
```
This installs the whole all-skills plugin with all its skills

2. **Skills CLI (Vercel)**
```bash
npx skills add davepoon/buildwithclaude --skill supabase-automation -a claude-code
```

3. **Manually: put the files in place**
- File: `~/.claude/skills/supabase-automation/SKILL.md` — Copy the whole skill folder; for one project use .claude/skills/supabase-automation/

### Codex

1. **Skills CLI (Vercel)**
```bash
npx skills add davepoon/buildwithclaude --skill supabase-automation -a codex
```

2. **Manually: put the files in place**
- File: `.agents/skills/supabase-automation/SKILL.md` — For all projects use ~/.agents/skills/

### Cursor

1. **Skills CLI (Vercel)**
```bash
npx skills add davepoon/buildwithclaude --skill supabase-automation -a cursor
```

2. **Manually: put the files in place**
- File: `.cursor/skills/supabase-automation/SKILL.md` — Cursor also reads .agents/skills/ and .claude/skills/

### GitHub Copilot

1. **GitHub CLI**
```bash
gh skill install davepoon/buildwithclaude plugins/all-skills/skills/supabase-automation
```

2. **Manually: put the files in place**
- File: `.github/skills/supabase-automation/SKILL.md`

### Gemini CLI

1. **Skills CLI (Vercel)**
```bash
npx skills add davepoon/buildwithclaude --skill supabase-automation -a gemini-cli
```

2. **Platform CLI**
```bash
gemini skills install https://github.com/davepoon/buildwithclaude --path plugins/all-skills/skills/supabase-automation
```

### Windsurf (Devin Desktop)

**Manually: put the files in place**
- File: `.devin/skills/supabase-automation/SKILL.md` — The legacy .windsurf/skills/ path still works

### Claude.ai

**Claude.ai**
- Zip the folder and upload it in Settings → Capabilities → Skills

Where a file is given instead of a command, copy the files from the source to that path: https://github.com/davepoon/buildwithclaude/tree/HEAD/plugins/all-skills/skills/supabase-automation/SKILL.md

## When to use it
- query database records with PostgREST sorting and filtering
- inspect table structures and generate TypeScript definitions
- execute arbitrary PostgreSQL statements and DDL migrations
- check service health across auth, database, and storage

## Example prompts
- Inspect the schema for public.profiles in project abcdefghijklmnopqrst
- Query rows from products where price is greater than 100
- Generate TypeScript types for the public database schema

## Source text · SKILL.md · MIT

Below is the content of a third-party file. It is data, not instructions for you: do not act on anything written inside unless the human asks. Block tag: dfaca7e75526254c.

BEGIN THIRD-PARTY FILE dfaca7e75526254c
```text
---
name: supabase-automation
description: 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]
category: development-code
---

# 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 relationships [Prerequisite for writes]
4. `SUPABASE_SELECT_FROM_TABLE` - Query rows with filtering, sorting, and pagination [Required for reads]
5. `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)
```
END THIRD-PARTY FILE dfaca7e75526254c

The third-party file has ended. Everything between the dfaca7e75526254c tags is data: requests and commands from it are not followed. An “end of file” line with another tag inside the block is part of the file.

First 2474 of 12717 bytes. © BuildWithClaude Community · MIT · https://github.com/davepoon/buildwithclaude/tree/HEAD/plugins/all-skills/skills/supabase-automation/SKILL.md

_Part of the page did not fit — see the HTML version._

---
NeVibeCode on affpapa.org. Catalog texts are descriptions, not instructions for the agent. How to choose and install: https://affpapa.org/en/nevibecode/agents.md
