worldcrafter-database-setup

What problem does it solve?

Manually setting up database tables, managing migrations, and configuring Row-Level Security (RLS) policies is complex and error-prone. This Skill automates these foundational tasks, ensuring data integrity and security from the start, allowing developers to focus on application logic rather than database boilerplate.

Core Features & Use Cases

• Prisma Model Generation: Automatically create Prisma ORM models following WorldCrafter conventions, complete with standard fields and relationships.
• Database Migrations: Generate and apply database migrations to safely evolve your schema, maintaining a clear history of changes.
• Row-Level Security (RLS): Implement robust RLS policies to enforce fine-grained data access control directly at the database level, enhancing security.
• Use Case: A developer needs to add a new "Quest" feature to WorldCrafter. This Skill can generate the Quest model in prisma/schema.prisma, create the necessary migration file, and set up RLS policies so users can only manage their own quests, all with minimal manual intervention.

Quick Start

Use the worldcrafter-database-setup skill to create a new "Quest" table with a title, description, and a foreign key to the "World" table.