skills.rest
leenBaksh
leenBakshCOMMUNITY
Explore all skills by this author →
WebsiteGitHub

database-skill

Design normalized database schemas and versioned migrations with constraints.

1|Updated Feb 2, 2026
Search Tags:#database#migrations#schema#sql#orm#data-modeling#postgres
One-click install
npx skills add https://github.com/leenBaksh/Hackathon-II-Phase --skill database-skill-leenbaksh
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: database-skill
Source: https://github.com/leenBaksh/Hackathon-II-Phase/tree/main/phase-II-Task-todo/.claude/skills/database-skill
Command: npx skills add https://github.com/leenBaksh/Hackathon-II-Phase --skill database-skill-leenbaksh

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Designing and implementing robust, scalable database schemas and migrations is error-prone and time-consuming without a structured approach.

Core Features & Use Cases

  • Schema Design Principles: Normalize data, define primary and foreign keys, plan indexes, and document relationships for clarity.
  • Migration Strategy: Use versioned migrations with rollback, environment-specific configurations, and seed data management.
  • Table Creation Guidelines: Choose appropriate data types, enforce constraints, set defaults, and add documentation to each table.

Quick Start

Design a normalized schema for a simple app (users, posts, comments) and create the initial migrations to establish the baseline.

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 database schema with primary and foreign keys?▼

Design a normalized database schema by defining primary and foreign keys, planning indexing strategies, and enforcing strict constraints to ensure scalable data persistence.

What is the best way to manage SQL migrations across different environments?▼

Manage SQL migrations across environments by using versioned migrations with rollback capabilities, applying environment-specific configurations, and maintaining seed data for reliable transitions from prototyping to production.

How do I create database tables with appropriate data types and constraints?▼

Create database tables by choosing appropriate data types, enforcing strict constraints, setting default values, adding audit columns, and documenting each table to ensure robust data integrity.

Can I use an ORM for data modeling and still apply strict database constraints?▼

You can use an ORM for data modeling while applying strict database constraints by ensuring your schema design enforces primary and foreign keys, indexes, and audit columns at the database level.

When do I need versioned migrations with rollback for my database?▼

You need versioned migrations with rollback when managing database schemas across environments, ensuring reliable transitions from prototyping to production while maintaining baseline data integrity and seed data.

Related Skills

Explore More Software Engineering Skills→
TorbenMerraldTorbenMerrald
1

Backend Models

Define and enforce database models and entity schemas across ORM and migration scripts.

Community
Advanced
OneWave-AIOneWave-AI
245

database-schema-designer

Design optimized SQL and NoSQL database schemas with ERDs and migration scripts.

Official
Basic
silaslopes100silaslopes100

reversa-data-master

Generate data dictionaries and ERD diagrams from DDL, migrations, and ORM models.

Community
Advanced
DauQuangThanhDauQuangThanh
14

database-design

Design relational and NoSQL database schemas from business requirements.

Community
Advanced