skills.rest
ag47-pt
ag47-ptCOMMUNITY
Explore all skills by this author →
GitHub

database-design

Design database architectures with schema modeling, indexing, and query optimization.

1|Updated May 6, 2026
Search Tags:#query optimization#indexing#schema design#database#migrations#orm
One-click install
npx skills add https://github.com/ag47-pt/Website --skill database-design-ag47-pt
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: database-design
Source: https://github.com/ag47-pt/Website/tree/main/.claude/skills/database-design
Command: npx skills add https://github.com/ag47-pt/Website --skill database-design-ag47-pt

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) components.

What problem does it solve?

This Skill helps developers make reliable database architecture decisions by avoiding poor schema choices, inefficient queries, and unsuitable database or ORM selections.

Core Features & Use Cases

  • Database Selection Guidance: Compare relational, serverless, edge, and embedded database options based on project requirements.
  • Schema and Performance Design: Apply principles for normalization, relationships, indexing, migrations, and query optimization.
  • Use Case: When building a new web application, use this Skill to choose the right database stack, design efficient tables, and identify performance improvements before production.

Quick Start

Use the database-design skill to help design a scalable schema and recommend the best database and ORM for my application requirements.

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 new web application?▼

Database selection involves comparing relational, serverless, edge, and embedded databases based on your project requirements. Evaluating factors like scalability, data structure, and latency helps identify the most suitable database stack for your application.

What is the best way to optimize database queries and indexing?▼

Query optimization and indexing require applying performance tuning principles to your schema design. Identifying bottlenecks early and implementing proper indexing strategies improves query execution times and overall application performance.

How do I choose the right ORM for my database architecture?▼

Choosing an ORM involves evaluating your selected database type, schema complexity, and migration requirements. Selecting an appropriate ORM prevents inefficient queries and ensures reliable data modeling within your backend development workflow.

Can I use this approach for both relational and serverless database migrations?▼

Yes, this approach supports both relational and serverless database migrations. Applying structured migration principles ensures reliable schema evolution across various database types without disrupting application availability.

Related Skills

Explore More Software Engineering Skills→
HechaoYannetHechaoYannet

create-architecture

Generate a master architecture document from GDDs, ADRs, and governance constraints.

Community
Advanced
salverius-techsalverius-tech

database-workflow

Provide database best practices for migrations, schema design, and query optimization.

Community
Advanced
Tony363Tony363
19

agent-fullstack-developer

Develop complete software features across database, backend, and frontend layers.

Community
Advanced
laurigateslaurigates
10

Infrastructure Terraform

Automate cloud infrastructure provisioning with Terraform and HCL.

Community
Advanced