Agent skill · software engineering · aiskillstore
database-manager
Manages Supabase database schema, migrations, and queries for CookMode V2. Use this when the user needs to create/modify tables, write migrations, update RLS policies, or troubleshoot database issues.
Why this skill is useful
Provides specific SQL migration patterns and RLS configurations tailored for Supabase in CookMode V2 that the AI wouldn't reliably generate on its own.
What it needs
Requires supabase account access. About 4k tokens when loaded. Last updated 2026-08-07. 405 stars on the source repository.
What this skill does
Database Manager Skill Your Role You specialize in Supabase PostgreSQL database operations for CookMode V2. You help users manage schema, write migrations, configure Row Level Security (RLS), and troubleshoot database issues. When to Use This Skill Invoke this skill when the user wants to: Create or modify database tables Write SQL migrations Add/update RLS policies Debug database errors Optimize queries Add new database features Current Database Schema Tables Overview 1. ingredientchecks Tracks ingredient completion status Real-time synced across clients 2. stepchecks Tracks instruction step completion Real-time synced across clients 3. recipestatus Workflow status: gathered, complete, plated, packed One status per recipe 4. recipeordercounts Number of orders for each recipe (1-50) Used for ingredient scaling 5. recipechefnames Chef assignment with color badge Includes name and color fields Schema Files Primary: /supabase-schema.sql Migrations: /supabase-migration-.sql Table Schemas ingredientchecks stepchecks recipestatus recipeordercounts recipechefnames Row Level Security (RLS) CookMode V2 currently uses permissive RLS - all users can read/write all data. Note: This is suitable for trusted kitchen environments. For multi-tenant setups, implement user-specific policies. Real-Time Subscriptions Tables with real-time sync enabled: ingredientchecks stepchecks recipestatus recipeordercounts recipechefnames Configured in /js/hooks/useRealtime.js:15-80 Migration Best Practices Creating a Migration 1. Name convention: supabase-migration-{feature-name}.sql 2. Include rollback: Add comments for manual rollback steps 3. Test locally: Verify migration before applying Migration Template Common Database Operations Adding a New Table 1. Define schema with constraints 2. Add indexes for performance 3. Enable RLS and create policies 4. Document in this skill 5. …
How to use it
Reference it in AdaL, Claude Code, Cursor or any coding agent — nothing to install:
@skills aiskillstore/database-manager