supabase-automation
Automate Supabase Operations
Automate Supabase database queries, schema inspection, project management, and SQL execution through Rube MCP integration for seamless database administration.
Télécharger le ZIP du skill
Importer dans Claude
Allez dans Paramètres → Capacités → Skills → Importer un skill
Activez et commencez Ă utiliser
Tester
Utilisation de "supabase-automation". List all tables in my Supabase project
RĂ©sultat attendu:
Found 5 tables: users, products, orders, inventory, analytics. Each table includes row count estimates and size information.
Utilisation de "supabase-automation". Get the schema for the users table
RĂ©sultat attendu:
Users table columns: id (uuid), email (text), created_at (timestamp), status (text). Foreign keys: none. Indexes: id (primary), email (unique).
Utilisation de "supabase-automation". Check service health for my project
RĂ©sultat attendu:
All services healthy: auth (operational), db (operational), rest (operational), storage (operational), realtime (operational).
Audit de sécurité
SûrAll 203 static findings are false positives. The skill uses Rube MCP (a legitimate Model Context Protocol server) to interact with Supabase APIs. The flagged patterns are: (1) Backtick syntax in markdown documentation for code examples - not actual shell execution; (2) Reference to rube.app/mcp endpoint - legitimate service URL; (3) Documentation about handling API keys - not actual secret access; (4) SQL query examples - not crypto or reconnaissance. This is a genuine Supabase automation skill with no malicious intent.
Score de qualité
Ce que vous pouvez construire
Database Developer Workflows
Query tables, inspect schemas, and execute SQL for data manipulation without leaving the AI assistant
Project Administration
Manage Supabase projects, organizations, and monitor service health through AI commands
Schema Exploration and Type Generation
Discover database structure and automatically generate TypeScript types for type-safe applications
Essayez ces prompts
List all tables in my Supabase project. First find the project reference, then list tables in the public schema.
Query the users table to find all records where the status equals 'active', ordered by created_at descending, limit 10.
Run a SQL query to count users by status and return the results in a readable format.
Generate TypeScript types for all tables in the public schema of my Supabase project.
Bonnes pratiques
- Always call RUBE_SEARCH_TOOLS first to get current tool schemas before starting a workflow
- Use read_only: true for SELECT queries to prevent accidental mutations
- Verify connection status shows ACTIVE before running any Supabase operations
Éviter
- Do not use JSON array syntax for PostgreSQL array columns - use ARRAY['item1', 'item2']
- Do not omit schema prefix for case-sensitive table names - use "public"."MyTable"
- Do not leave services array empty when checking service health status