skills.rest
dr-code
dr-codeCOMMUNITY
Explore all skills by this author →
GitHub

supabase-automation

Automate Supabase database queries, schema inspection, and project administration via Rube MCP tools.

Updated Mar 18, 2026
Search Tags:#automation#database#schema#supabase#mcp#sql#rube
One-click install
npx skills add https://github.com/dr-code/beacon --skill supabase-automation-dr-code
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: supabase-automation
Source: https://github.com/dr-code/beacon/tree/main/plugins/all-skills/skills/supabase-automation
Command: npx skills add https://github.com/dr-code/beacon --skill supabase-automation-dr-code

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Provides a single, guided workflow to automate Supabase database queries, schema inspection, project and organization management, storage bucket listing, and edge function inspection so users no longer need to manually discover schemas, assemble SQL, or manage project metadata across the Supabase API.

Core Features & Use Cases

  • Discover and Inspect: List projects and tables, retrieve detailed table schemas, and generate TypeScript types from database metadata.
  • Query and Execute SQL: Run safe read-only selects via SELECT_FROM_TABLE and execute complex or mutating statements via RUN_SQL_QUERY with read_only safeguards and timeout considerations.
  • Admin & Storage Tools: Enumerate organizations and members, check project service health, list edge functions, and list storage buckets; includes precautions for handling API keys and permission errors.
  • Use Case: A developer needs to count active users by signup date across a Supabase project, discover relevant table schemas to build safe queries, and then run a read-only SQL aggregation via Rube MCP.

Quick Start

Run a read-only SQL query on my Supabase project to count active users by signup date.

Frequently Asked Questions about supabase-automation

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I automate Supabase database queries and schema inspection?▼

To automate Supabase database queries and schema inspection, use a guided workflow that lists projects and tables, retrieves detailed schemas, and executes SQL via Rube MCP tools. This removes the need to manually discover schemas or assemble SQL across the Supabase API.

Can I run read-only SQL queries on Supabase tables without manual API calls?▼

Yes, you can run read-only SQL queries on Supabase tables without manual API calls by applying the SUPABASE_SELECT_FROM_TABLE or SUPABASE_BETA_RUN_SQL_QUERY MCP tools. These tools include read-only safeguards to protect your data during automated execution.

Do I need a Rube MCP connection to manage Supabase projects and storage?▼

Yes, you need an active Rube MCP connection with the Supabase toolkit to manage Supabase projects and storage. This connection provides the necessary MCP tools to enumerate organizations, list storage buckets, and check project service health.

What is required to generate TypeScript types from a Supabase database schema?▼

Generating TypeScript types from a Supabase database schema requires retrieving detailed table metadata through an automated schema inspection workflow. By listing tables and inspecting schemas via Rube MCP, the database structure is translated into TypeScript definitions.

How do I handle API keys and permission errors when automating Supabase admin tasks?▼

When automating Supabase admin tasks, handle API keys and permission errors by following built-in precautions for managing org members and storage. The workflow requires valid 20-letter lowercase project_ref values and appropriate parameters to avoid permission issues.

Related Skills

Explore More Software Engineering Skills→
AJBcodingAJBcoding
4

moai-domain-notion

Automate Notion workspace and database operations through MCP integration.

Community
Advanced
abdullah1854abdullah1854
1

sql-analyzer

Analyze SQL queries for anti-patterns and performance issues.

Community
Intermediate
vanducngvanducng
5

miudb

Query and manage saved database connections via a headless CLI.

Community
Intermediate
wendleywwendleyw

supabase-patterns

Guide Supabase database queries, RLS policies, Edge Functions, migrations, real-time, and storage.

Community
Advanced