Our review

This skill helps design and manage relational databases, including table creation, migrations, and schema design.

When to use it

When you need to create or modify a relational database and want structured, safe migrations.

When not to use it

For non-relational databases or when high-level ORM solutions suffice without explicit migration management.

Examples

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()
);