skills.rest
srstomp
srstompCOMMUNITY
Explore all skills by this author →
WebsiteGitHub

database-design

Model entities, attributes, and relationships into normalized database schemas.

8|2|Updated Jan 15, 2026
Search Tags:#design#database#migrations#schema#normalization#orm-patterns
One-click install
npx skills add https://github.com/srstomp/pokayokay --skill database-design-srstomp
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: database-design
Source: https://github.com/srstomp/pokayokay/tree/main/plugins/pokayokay/skills/database-design
Command: npx skills add https://github.com/srstomp/pokayokay --skill database-design-srstomp

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

Designs robust, maintainable database schemas by translating requirements into normalized models, safe migrations, and scalable patterns that reduce technical debt and deployment risk.

Core Features & Use Cases

  • Normalize schemas to ensure data integrity while optimizing storage and performance.
  • Plan reversible migrations with up/down scripts and zero-downtime strategies.
  • Align ORM patterns (Prisma, Drizzle, TypeORM) with schema design for reliable evolution.
  • Provide practical guidance for indexes, constraints, and multi-tenant patterns in production systems.

Quick Start

Pull a project’s requirements, draft a normalized schema, and implement a reversible migration plan.

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 normalized database schema for future growth?▼

Normalize your database schema by identifying and modeling entities, attributes, and relationships. This approach ensures data integrity, optimizes storage and performance, and supports scalable multi-tenant patterns for future growth.

What is the best way to plan reversible database migrations with zero downtime?▼

Plan reversible database migrations by writing safe up and down scripts combined with zero-downtime deployment strategies. This approach ensures robust data integrity checks and reduces deployment risk during schema evolution.

Can I use this schema design approach with Prisma, Drizzle, and TypeORM?▼

Yes, this schema design approach aligns ORM patterns directly with Prisma, Drizzle, and TypeORM workflows. It provides scalable design patterns, indexing, and constraints to ensure reliable database evolution across these ORMs.

How do I apply indexing and constraints for multi-tenant database patterns?▼

Apply indexing and constraints for multi-tenant patterns by translating requirements into normalized models. This approach provides practical guidance for production systems, ensuring robust data integrity and optimized query performance.

When do I need to normalize a database schema for a document-based project?▼

You need to normalize a database schema for a document-based project when translating requirements into models that ensure data integrity. This approach optimizes storage and performance while supporting scalable multi-tenant patterns.

Related Skills

Explore More Software Engineering Skills→
applewaveapplewave
1

phase-1-schema

Define project terminology and data structures into glossary.md and schema.md.

Community
Intermediate
ValenBorrasValenBorras
1

database-migrations

Guide safe, reversible database migrations across PostgreSQL, MySQL, and common ORMs.

Community
Advanced
WesleySmitsWesleySmits
6

managing-database-schemas

Analyze database schemas and generate improvement recommendations for Prisma, TypeORM, or Drizzle.

Community
Advanced
afsjrafsjr

reversa-data-master

Generate ERD and markdown documentation from legacy database artifacts.

Community
Advanced