skills.rest
dhruvinrsoni
dhruvinrsoniCOMMUNITY
Explore all skills by this author →
Website𝕏@dhruvinrsoniGitHub

database-design

Design relational and NoSQL database schemas with migrations and indexes.

Updated Feb 3, 2026
Search Tags:#indexing#schema design#database#migration#sql#nosql
One-click install
npx skills add https://github.com/dhruvinrsoni/agentskills-garden --skill database-design-dhruvinrsoni
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: database-design
Source: https://github.com/dhruvinrsoni/agentskills-garden/tree/main/skills/20-architecture/database-design
Command: npx skills add https://github.com/dhruvinrsoni/agentskills-garden --skill database-design-dhruvinrsoni

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) and references (resource) and assets (resource) components.

What problem does it solve?

This Skill addresses the complexities of designing and evolving database schemas, ensuring data integrity, performance, and maintainability for both relational and NoSQL databases.

Core Features & Use Cases

  • Schema Design: Maps domain entities to tables/collections, defines columns, keys, and relationships, applying normalization principles.
  • Migration Planning: Generates idempotent and reversible SQL or ORM-specific migration files.
  • Index Strategy: Recommends optimal indexes based on query patterns to balance read performance and write overhead.
  • Use Case: When building a new e-commerce platform, this Skill can design the product catalog schema, plan the initial database migrations, and suggest indexes for efficient product searching.

Quick Start

Design a PostgreSQL schema for a blog with tables for users, posts, and comments.

Frequently Asked Questions about database-design

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

FAQPage Schema
How do I design a database schema for both SQL and NoSQL databases?▼

Database schema design maps domain entities to relational tables or NoSQL collections, defining columns, keys, and relationships. It applies normalization analysis for PostgreSQL and MySQL, while addressing data integrity and schema evolution for MongoDB and DynamoDB.

What's the best way to plan reversible database migrations?▼

Database migration planning generates idempotent and reversible SQL or ORM-specific migration files. This ensures schema evolution is controlled and maintainable, preventing data loss during structural changes across supported database systems.

How do I create an index strategy to balance read performance and write overhead?▼

An index strategy recommends optimal indexes based on specific query patterns. By analyzing access paths, it balances fast read performance against the write overhead required to maintain indexes during data modifications.

Does this database design approach support generating ER diagrams and seed data?▼

Yes, database design generates DDL scripts, ER diagrams, and seed data alongside schema definitions. It provides comprehensive outputs needed to initialize and visually document relational and NoSQL database structures.

When do I need normalization analysis for my PostgreSQL or MySQL schema?▼

Normalization analysis is needed when designing relational schemas to ensure data integrity and reduce redundancy. It evaluates table structures to optimize performance and maintainability for application development.

Related Skills

Explore More Software Engineering Skills→
dtsongdtsong
1

Schema Design

Design relational database schemas with normalization, indexes, and migration-ready SQL.

Community
Advanced
smithisrealdevsmithisrealdev

database-schema-designer

Design SQL and NoSQL database schemas with normalization and migration scripts.

Community
Advanced
fgarofalo56fgarofalo56
6

prisma-orm

Generate type-safe database access for Node.js and TypeScript with Prisma ORM.

Community
Advanced
HeldinhowHeldinhow
4

database-migrations

Manage database schema changes through version-controlled migration scripts.

Community
Intermediate