Guide database schema design, migrations, query optimization, and data validation.
npx skills add https://github.com/lushly-dev/afd --skill model-data
Please help me install this Agent Skill. Skill: model-data Source: https://github.com/lushly-dev/afd/tree/main/.claude/skills/model-data Command: npx skills add https://github.com/lushly-dev/afd --skill model-data
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.
Guide me through designing a new PostgreSQL schema for a blog, including tables for users and posts with appropriate indexes and relationships.
High-intent search queries and answers about installing and using this skill.
Database schema design involves modeling relational, document, or graph structures to ensure data integrity. You can guide the process by defining normalized tables, relationships, and appropriate indexes for your specific database paradigm.
Planning a database migration with an ORM requires tools like Prisma, Drizzle, Alembic, or Knex to safely alter schemas. You execute versioned migration files to transition structures without losing existing data.
SQL query optimization improves database performance through strategic indexing, query tuning, and performance monitoring. You analyze execution plans to add appropriate indexes and rewrite inefficient query patterns.
Data validation is set up using libraries like Zod or Pydantic alongside database constraints to enforce boundary validation. This ensures incoming application data strictly conforms to defined schema types before database insertion.
Choosing a document database over a relational schema depends on your data modeling needs and database paradigm. Document databases suit flexible, unstructured data, while relational schemas enforce strict normalization for complex relationships.
CQRS and event sourcing are advanced database modeling practices that separate read and write operations into distinct schemas. This approach tracks state changes as a sequence of immutable events for robust data integrity.
HainrixzRecommend database engines and generate initial schema migrations for greenfield projects.
samhvw8Guide MongoDB and PostgreSQL schema design, query optimization, migrations, and backups.
EIS-ITSDefine database models and ORM entities with relationships and constraints.
Khamel83Generate database migration plans with rollback strategies for schema changes.
