skills.rest
efekrbas
efekrbasCOMMUNITY
Explore all skills by this author →
Website𝕏@efekrbsGitHub

database-design

Design database schemas, indexing strategies, ORM choices, and migration plans.

41|5|Updated Sep 30, 2025
Search Tags:#database design#query optimization#indexing#schema design#migrations#orm selection
One-click install
npx skills add https://github.com/efekrbas/discord-hypesquad-manager --skill database-design-efekrbas
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: database-design
Source: https://github.com/efekrbas/discord-hypesquad-manager/tree/main/.agents/skills/database-design
Command: npx skills add https://github.com/efekrbas/discord-hypesquad-manager --skill database-design-efekrbas

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) components.

What problem does it solve?

This Skill helps you make sound database decisions without guessing, reducing schema mistakes, performance bottlenecks, and risky migration changes.

Core Features & Use Cases

  • Schema Design Guidance: Plan tables, keys, relationships, timestamps, and normalization choices for new applications.
  • Database Selection: Compare relational, serverless, edge, and embedded options based on deployment and workload needs.
  • Performance Tuning: Identify where indexes belong, how composite indexes should be ordered, and how to avoid common query inefficiencies.
  • Safe Change Management: Apply migration patterns that support gradual rollout, backfills, and rollback planning.
  • Example Use Case: A product team building a SaaS app can use this Skill to choose between SQLite, PostgreSQL, or a serverless alternative, define the schema, and plan indexes before implementation.

Quick Start

Ask the database-design skill to review my app requirements and recommend the best database, schema, indexing plan, and migration strategy.

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 with the right normalization and primary keys?▼

Schema design requires planning tables, relationships, primary and foreign keys, and normalization levels to structure relational data accurately and prevent update anomalies.

What's the best way to plan safe database migrations with backfills and rollbacks?▼

Safe database migrations apply patterns supporting gradual rollout, data backfills, and rollback planning to execute schema changes without downtime or data loss.

How do I optimize query performance with composite indexes?▼

Query optimization identifies where indexes belong and determines composite index ordering to match query patterns and eliminate common database retrieval inefficiencies.

How do I choose between PostgreSQL, SQLite, and serverless database options?▼

Database selection compares relational, serverless, edge, and embedded options by evaluating deployment environments and workload needs to determine the optimal fit.

When do I need schema validation workflows for my application database?▼

Schema validation workflows are needed when designing schemas for new applications to enforce data constraints, ensure integrity, and maintain consistency across migrations.

Related Skills

Explore More Software Engineering Skills→
oracleoracle
785

oke-gva-deployer

Deploy and configure OKE nodes with Generic VNIC Attachment.

Official
Advanced
rodmena-limitedrodmena-limited
3

moai-domain-database

Provide database schema design, query optimization, and indexing strategies.

Official
Advanced
MovchanetsMovchanets

database-design

Design database schemas for microservices applications with migration planning.

Community
Intermediate
george11642george11642
2

db-supabase

Execute SQL, apply migrations, and deploy edge functions via Supabase MCP tools.

Community
Intermediate