Our review
This skill helps design and manage relational databases, including table creation, migrations, and schema modeling.
Strengths
- Clear and consistent table structures with proper constraints
- Normalization and explicit relationship modeling
- Safe forward/backward migrations with idempotency
- Optimization through indexes and referential integrity constraints
Limitations
- Does not cover non-relational (NoSQL) databases
- Requires careful planning to avoid regressions
- Destructive migrations without backups are risky
Use this skill when designing a relational schema from scratch or performing schema migrations on an existing database.
Avoid this skill for projects using NoSQL databases, rapid prototyping without a fixed schema, or when persistence is handled by an automatic ORM.
Security analysis
SafeSkill provides only advisory instructions for database design and migrations; no execution of destructive commands, network calls, or obfuscated payloads. No declared tools mitigate risk further.
No concerns found
Examples
Create a SQL migration to add a 'users' table with columns: id (UUID primary key), email (unique, not null), password_hash (not null), and created_at timestamp with default now. Also add an index on email.Write a database migration to add a 'orders' table with a foreign key referencing 'users.id'. Include a down migration that drops the table safely.I have a table with repeated vendor names and addresses. How should I normalize it into separate 'vendors' and 'products' tables? Show the SQL schema and a migration plan.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
Instructions
-
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
Best Practices
- Use consistent naming conventions
- Keep schemas simple and well-documented
- Version control all migrations
- Test migrations in non-production environments
- Follow relational database design principles
Example Structure
CREATE TABLE users (
id UUID PRIMARY KEY,
email TEXT UNIQUE NOT NULL,
password_hash TEXT NOT NULL,
created_at TIMESTAMP DEFAULT NOW()
);
Next.js App Router Expert
Development
A skill that turns Claude into a Next.js App Router expert.
README Generator
Development
Creates professional and comprehensive README.md files for your projects.
API Documentation Writer
Development
Generates comprehensive API documentation in OpenAPI/Swagger format.