supabase-ops

What This Skill Does

The supabase-ops skill transforms your AI agent into a senior database engineer specialized in the Supabase ecosystem. It provides a robust, safety-first framework for managing PostgreSQL databases, RLS policies, migrations, and edge functions. By integrating directly with the Supabase CLI, it ensures that your database evolution is version-controlled, reproducible, and aligned with industry best practices.

This skill enforces a mandatory Planning Protocol, requiring the agent to audit existing migrations and current schema types before proposing changes. This prevents common pitfalls like migration drift or unintended data loss, making it an essential tool for professional-grade Next.js development.

Installation

To integrate this skill into your OpenClaw environment, execute the following command in your terminal: clawhub install openclaw/skills/skills/guifav/supabase-ops

Use Cases

• Database Schema Evolution: Easily add, modify, or deprecate tables and columns while ensuring TypeScript types remain perfectly synced.
• Security Hardening: Automatically generate and apply Row Level Security (RLS) policies based on the context of your application.
• Production Deployment Strategy: Safely manage complex migrations using dry-run capabilities to visualize schema impacts before committing to production environments.
• Edge Function Management: Simplify the creation, testing, and deployment of Supabase Edge Functions with integrated service-role credential handling.

Example Prompts

1. "I need to add a 'status' column to the 'orders' table. Please check the current migrations, generate the migration file, update the types, and write an RLS policy that only allows owners to update their orders."
2. "Can you help me migrate the user profile table to a new schema version? Please show me a plan, perform a dry-run first, and highlight any potential data loss risks."
3. "Deploy a new edge function called 'process-payment' that handles stripe webhooks. Make sure to include the necessary environment variable references and error handling."

Tips & Limitations

• Always verify the Plan: The agent is trained to be cautious, but you are the final authority. Review the generated SQL before confirming the execution.
• Credential Security: This skill operates via the CLI; ensure your environment variables are configured in your local environment for seamless CLI authentication.
• Timestamps: The skill strictly enforces timestamptz. Using standard timestamp will trigger a warning from the agent.
• Non-Destructive First: When in doubt, request a backup migration or a dry-run execution plan.