spex-db

What problem does it solve?

This Skill automates the complex and error-prone process of designing database schemas, ERDs, and safe migration strategies, ensuring data integrity and efficient development.

Core Features & Use Cases

• Schema Design: Models entities, attributes, types, and constraints based on project requirements.
• ERD Generation: Creates visual Entity-Relationship Diagrams for clear understanding.
• Migration Planning: Designs additive and safe destructive migration strategies, including rollback plans.
• Database Engine Selection: Recommends and configures schemas for PostgreSQL, MariaDB/MySQL, and others.
• Use Case: When a new feature requires storing user preferences, use this Skill to design the user_preferences table, define its columns (e.g., theme, notifications_enabled), specify data types, and generate a migration script that can be safely applied to production.

Quick Start

Design the database schema for the new user profile feature, including tables for profiles, avatars, and settings.