model-data

What problem does it solve?

This Skill streamlines the complex process of designing robust database schemas, planning safe migrations, optimizing queries, and implementing effective data validation, ensuring data integrity and performance across various database types.

Core Features & Use Cases

• Schema Design: Guides relational, document, and graph database schema creation.
• Migrations & ORMs: Assists with planning and executing database migrations using tools like Prisma, Drizzle, Alembic, and Knex.
• Query Optimization: Provides strategies for indexing, query tuning, and performance monitoring.
• Data Validation: Helps set up validation rules using Zod, Pydantic, and database constraints.
• Use Case: When starting a new project, use this Skill to design a normalized relational schema for user accounts and posts, including appropriate indexes and a migration plan.

Quick Start

Guide me through designing a new PostgreSQL schema for a blog, including tables for users and posts with appropriate indexes and relationships.