Database Manager

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);