Notre avis

Ce skill permet de concevoir et gérer des bases de données relationnelles, incluant la création de tables, les migrations et le design de schémas.

Quand l'utiliser

Lorsque vous devez créer ou modifier une base de données relationnelle et souhaitez des migrations structurées et sécurisées.

Quand l'éviter

Pour des bases de données non relationnelles ou lorsque des solutions ORM haut niveau suffisent sans gestion explicite des migrations.

Exemples

Create users table

Create a users table with id, email, password_hash, created_at, and appropriate constraints.

Add migration for orders

Generate a migration to add an orders table with foreign key to users, including forward and backward steps.

Design schema for e-commerce

Design a relational schema for an e-commerce platform with products, customers, orders, and line items.

name: database-skill description: Design and manage relational databases including table creation, migrations, and schema design. Use for database modeling and maintenance.

Database Skill – Schema Design & Migrations

Table Creation
- Define clear and consistent table structures
- Use appropriate data types and constraints
- Apply primary keys and foreign keys correctly
Schema Design
- Normalize data where appropriate
- Model relationships explicitly
- Design for scalability and maintainability
Migrations
- Create forward and backward migrations
- Ensure migrations are idempotent and safe
- Avoid destructive changes without backups
Indexes & Constraints
- Add indexes for frequently queried columns
- Enforce uniqueness and referential integrity
- Use constraints to protect data correctness

CREATE TABLE users (
  id UUID PRIMARY KEY,
  email TEXT UNIQUE NOT NULL,
  password_hash TEXT NOT NULL,
  created_at TIMESTAMP DEFAULT NOW()
);