skills.rest
JoaoPedroAmaral
JoaoPedroAmaralCOMMUNITY
Explore all skills by this author →
WebsiteGitHub

database-design

Design database schemas and validate them for backend applications.

Updated Aug 23, 2026
Search Tags:#indexing#postgresql#migrations#schema#query-optimization#database-design#orm-selection
One-click install
npx skills add https://github.com/JoaoPedroAmaral/backBarbearia --skill database-design-joaopedroamaral
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: database-design
Source: https://github.com/JoaoPedroAmaral/backBarbearia/tree/main/.claude/skills/database-design
Command: npx skills add https://github.com/JoaoPedroAmaral/backBarbearia --skill database-design-joaopedroamaral

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) components.

What problem does it solve?

Helps teams and engineers make principled database decisions and avoid common pitfalls when designing schemas, choosing storage, planning indexes, and executing safe migrations for production systems.

Core Features & Use Cases

  • Database selection: Decision trees for choosing PostgreSQL, serverless Postgres, edge SQLite, or distributed SQL based on deployment and latency needs.
  • Schema design & PK strategy: Guidance on normalization vs denormalization, primary key types, timestamps, and foreign key semantics.
  • Indexing & optimization: Index type selection, composite index ordering, and N+1 mitigation strategies with query analysis priorities.
  • Migration safety & tooling: Zero-downtime migration patterns, backfill strategies, and recommendations for serverless databases.
  • ORM and validation: ORM selection heuristics and a provided schema validation script to detect common schema issues.

Quick Start

Ask the database-design skill to analyze your application's workload, current schema, and deployment constraints and return a recommended schema design, index plan, ORM choice, and safe migration steps.

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 a multi-tenant SaaS application?▼

To design a database schema for multi-tenant SaaS, you need guidance on normalization vs denormalization, primary key types, and foreign key semantics. This skill provides schema proposals tailored to your deployment environment and multi-tenant constraints.

What is the best way to plan indexing strategies and optimize queries in PostgreSQL?▼

The best way to plan indexing strategies and optimize queries in PostgreSQL is to analyze your workload to determine index types, composite index ordering, and N+1 mitigation strategies. This skill generates an index plan based on query analysis priorities.

How do I execute zero-downtime database migrations safely?▼

To execute zero-downtime database migrations safely, you need structured patterns and backfill strategies. This skill provides migration steps and recommendations that consider deployment environments and zero-downtime constraints for production systems.

How do I choose an ORM and database for edge scenarios vs relational deployments?▼

Choosing an ORM and database for edge scenarios versus relational deployments requires decision trees comparing PostgreSQL, serverless Postgres, edge SQLite, and distributed SQL. This skill applies ORM selection heuristics based on your latency needs.

Can I validate my existing database schema for common design issues?▼

Yes, you can validate your existing database schema for common design issues using a provided schema validation script. This skill produces runnable validation findings to detect potential problems in your backend application's storage setup.

Related Skills

Explore More Software Engineering Skills→
hung-phanhung-phan

oltp-vs-olap

Analyze workload characteristics to select between OLTP and OLAP databases.

Community
Advanced
TiepbmTiepbm

sql-and-query-optimization

Optimize SQL and ORM-generated queries by analyzing execution plans and indexes.

Community
Advanced
januarfontijanuarfonti
10

backend-dev

Orchestrate backend system creation covering architecture, security, deployment, and CI/CD automation.

Community
Advanced
efekrbasefekrbas
41

database-design

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

Community
Intermediate