db-seed

What problem does it solve?

This Skill automates the process of applying seed data to a database, ensuring data integrity and consistency across environments through idempotent operations.

Core Features & Use Cases

• Idempotent Seeding: Safely applies seed data, preventing duplicate entries or errors on re-runs using patterns like INSERT ... ON CONFLICT.
• Environment Consistency: Ensures development, staging, and production databases can be seeded reliably.
• Pre-flight Checks & Validation: Validates seed files for dangerous patterns (like TRUNCATE) and confirms idempotency.
• Snapshotting: Creates database snapshots before seeding for easy rollback.
• Logging: Documents all seeding operations for auditability.
• Use Case: Apply a standard set of initial product categories and user roles to a new development database without fear of breaking existing data.

Quick Start

Use the db-seed skill to apply the seed data from the file '/path/to/seed.sql' in interactive mode.