database-design

Name: database-design
Availability: InStock
Author: Ivan

Guide relational schema, indexing, ORM, and migration decisions from project context.

2|Updated Jan 19, 2026

Search Tags:#indexing #database #drizzle #sql #orm #prisma #schema-design

Ready to run

npx skills add https://github.com/ivanshtokov/copilot-kit --skill database-design-ivanshtokov

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: database-design
Source: https://github.com/ivanshtokov/copilot-kit/tree/main/.github/skills/database-design
Command: npx skills add https://github.com/ivanshtokov/copilot-kit --skill database-design-ivanshtokov

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Database design decisions often slow teams: choosing between normalization vs denormalization, selecting the right ORM, and planning safe migrations in diverse environments.

Core Features & Use Cases

Context-driven guidance: Tailors schema design, indexing, and deployment recommendations to project needs.
Decision checklist: Provides steps to verify requirements, choose DB tech, and plan migrations.
Use case: When building a multi-tenant SaaS app, apply principled normalization, appropriate foreign keys, and an indexing plan to support scalable queries.
Use case: For small teams, select lightweight ORMs and serverless options to reduce operational overhead.

Quick Start

Design a scalable relational schema for a multi-tenant app, with proper indexing, ORM selection, and a safe 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 relational database schema for a scalable multi-tenant app?▼

To design a relational database schema for a scalable multi-tenant app, apply principled normalization, define appropriate foreign keys, and create an indexing plan to support high-volume queries and ensure data integrity.

What's the best way to choose an ORM like Prisma or Drizzle for my project?▼

Choosing an ORM like Prisma or Drizzle depends on your project context; select lightweight ORMs for small teams to reduce operational overhead, while evaluating specific schema design and migration needs for larger applications.

How do I plan safe database migrations in serverless environments?▼

Planning safe database migrations in serverless environments requires following verified migration strategies tailored to your deployment context, ensuring schema changes do not disrupt application availability or data consistency.

When should I use normalization vs denormalization in SQL schema design?▼

Use normalization in SQL schema design to ensure data integrity and reduce redundancy, while applying denormalization strategically when your project context demands optimized read performance for specific scalable query patterns.

How do I create an indexing strategy for performance-focused database queries?▼

Creating an indexing strategy for performance-focused database queries involves analyzing your project context to apply targeted indexes, supporting scalable query execution and reducing latency in relational databases.