skills.rest
ivanshtokov
ivanshtokovCOMMUNITY
Explore all skills by this author →
GitHub

database-design

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
One-click install
npx skills add https://github.com/ivanshtokov/copilot-kit --skill database-design-ivanshtokov
Or copy as Structured Prompt for Agent▼
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.

Related Skills

Explore More Software Engineering Skills→
dtsongdtsong
1

intake-skill

Transform natural language project descriptions into structured engagement briefs.

Community
Advanced
AnthonyCongHieuAnthonyCongHieu

database-design

Guide database schema, indexing, and deployment design decisions.

Community
Advanced
marquesfelipmarquesfelip

sql-injection-prevention

Identify and fix SQL injection vulnerabilities in data access layers.

Community
Advanced
Fancu1Fancu1

database-design

Design and optimize relational and NoSQL database schemas with migration patterns.

Community
Intermediate