skills.rest
HammadNadeem21
HammadNadeem21COMMUNITY
Explore all skills by this author →
GitHub

database-skill

Create and evolve relational database schemas with normalized entities and idempotent migrations.

Updated Feb 25, 2026
Search Tags:#design#migrations#schema#constraints#normalization#databases
One-click install
npx skills add https://github.com/HammadNadeem21/hackathon-todo-application --skill database-skill-hammadnadeem21
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: database-skill
Source: https://github.com/HammadNadeem21/hackathon-todo-application/tree/main/.claude/skills/database-skill
Command: npx skills add https://github.com/HammadNadeem21/hackathon-todo-application --skill database-skill-hammadnadeem21

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Relational database design, maintenance, and migrations are complex; this skill provides structured guidance to model entities, enforce constraints, and plan safe evolutionary changes.

Core Features & Use Cases

  • Schema Design: Model entities, relationships, and constraints with proper normalization.
  • Migrations & Evolution: Create forward and backward migrations with safe rollbacks and version control.
  • Indexing & Performance: Add indexes and enforce data integrity for scalable workloads.

Quick Start

Design a normalized schema for a user-management and order-tracking system using the entities users(id, email, password_hash) and orders(id, user_id, created_at, total).

Frequently Asked Questions about database-skill

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I design a normalized relational database schema with proper constraints?▼

Design a normalized schema by modeling entities, relationships, and constraints. Enforce primary keys, foreign keys, and indexes to ensure data integrity and maintain scalable workloads.

What is the best way to create safe database migrations with rollback capabilities?▼

Create safe database migrations by writing idempotent forward and backward migration scripts. This approach ensures safe rollbacks and allows controlled schema evolution across projects of varying complexity.

When do I need to add indexes to my database schema?▼

You add indexes to your database schema to enforce data integrity and optimize query performance for scalable workloads. Indexes are crucial when maintaining large relational datasets and evolving schemas through migrations.

Can I use this approach for both database design and schema maintenance across existing projects?▼

Yes, this approach applies to database design, migrations, and schema maintenance across projects of varying complexity. It provides structured guidance to model entities and plan safe evolutionary changes for existing relational databases.

How do I model relationships and constraints for a user management and order tracking system?▼

Model relationships and constraints by defining entities like users and orders with primary keys, then link them using foreign keys. Enforce normalization to maintain structured data across interconnected relational tables.

Related Skills

Explore More Software Engineering Skills→
seb1nseb1n
147

database-schema-design

Design normalized relational database schemas and generate SQL DDL scripts.

Community
Intermediate
diegoliriodiegolirio

sql-extract-ddl-oracle-mcp

Export Oracle schema DDL via MCP into Flyway-compatible SQL migrations.

Community
Advanced
yangqiongyangqiong

Database Schema Design Skill

Design normalized PostgreSQL schemas with indexes and constraints.

Community
Intermediate
chef0111chef0111
1

databases

Manage MongoDB and PostgreSQL databases with schema design, CRUD, indexing, and migrations.

Community
Advanced