Database Manager

Manage Supabase database schema, migrations, and Row Level Security policies.

Updated Oct 16, 2025
One-click install
npx skills add https://github.com/AdamFehse/cookmodeV2 --skill database-manager
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: Database Manager
Source: https://github.com/AdamFehse/cookmodeV2/tree/main/.claude/skills/database-manager
Command: npx skills add https://github.com/AdamFehse/cookmodeV2 --skill database-manager

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Manually managing database schema, writing migrations, and configuring Row Level Security (RLS) can be complex and error-prone. This Skill streamlines these critical database operations for CookMode V2, ensuring data integrity and efficient development.

Core Features & Use Cases

  • Schema Management: Create, modify, and document database tables and their relationships with ease.
  • Migration Generation: Automatically generate robust SQL migration scripts for schema changes, reducing manual effort and potential errors.
  • RLS & Query Optimization: Configure secure Row Level Security policies and optimize database queries for peak performance.
  • Use Case: Need to add a new recipe_notes table to track chef comments? This Skill can generate the complete SQL, including RLS policies and indexing, ensuring consistency and security without manual database work.

Quick Start

Example: Adding a new table with RLS

CREATE TABLE recipe_notes ( id SERIAL PRIMARY KEY, recipe_slug TEXT NOT NULL, note_text TEXT NOT NULL ); ALTER TABLE recipe_notes ENABLE ROW LEVEL SECURITY; CREATE POLICY "Enable all access" ON recipe_notes FOR ALL USING (true);

Frequently Asked Questions about Database Manager

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

FAQPage Schema
How do I automate Supabase schema changes and migrations?

Automate Supabase schema changes by generating SQL migration scripts that define table structure, relationships, and constraints. This Skill creates robust migrations with rollback notes, reducing manual effort and ensuring consistency across environments without error-prone database work.

How do I configure Row Level Security policies in Supabase?

Configure Row Level Security by defining permissive RLS policies that control data access at the row level. This Skill generates and applies RLS policies to tables, ensuring secure data isolation while enabling real-time subscriptions and client-side queries.

Can I use migrations to manage PostgreSQL table definitions and indexes?

Yes. Migrations manage PostgreSQL table definitions, indexes, and relationships systematically. This Skill generates complete SQL including table creation, indexing, and RLS configuration, enabling you to track schema evolution and roll back changes safely.

What's the best way to optimize Supabase queries and set up real-time updates?

Optimize Supabase queries through proper indexing and schema design, then enable real-time updates using subscriptions. This Skill configures both query patterns via hooks and real-time subscriptions, ensuring efficient data delivery across clients.

Do I need to manually write RLS policies for each table?

No. This Skill generates permissive RLS policies automatically based on table definitions, eliminating manual policy writing and reducing configuration errors while maintaining data security.

How do I handle schema changes without breaking client queries?

Use migrations with rollback notes to version schema changes safely. This Skill generates migrations that preserve client-side query patterns and real-time subscriptions, enabling you to modify tables without disrupting active connections.