skills.rest
HouseGarofalo
HouseGarofaloOFFICIAL
Explore all skills by this author →
GitHub

database-architect-agent

Guide database architecture, data modeling, schema optimization, and query performance tuning.

3|1|Updated Feb 2, 2026
Search Tags:#database design#migration#data modeling#query tuning#database scaling#schema optimization
One-click install
npx skills add https://github.com/HouseGarofalo/claude-code-base --skill database-architect-agent
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: database-architect-agent
Source: https://github.com/HouseGarofalo/claude-code-base/tree/main/.claude/skills/database-architect-agent
Command: npx skills add https://github.com/HouseGarofalo/claude-code-base --skill database-architect-agent

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

This Skill provides expert guidance for designing, optimizing, and scaling databases, ensuring efficient data management and performance.

Core Features & Use Cases

  • Database Design: Assists in creating robust data models and schemas for relational and NoSQL databases.
  • Performance Tuning: Optimizes query performance, indexing strategies, and identifies bottlenecks.
  • Migration Planning: Guides through complex database migration processes.
  • Scaling Strategies: Recommends and explains patterns for vertical and horizontal scaling.
  • Use Case: You are designing a new e-commerce platform and need to create an efficient, scalable database schema. This Skill can guide you through entity-relationship modeling, normalization, and suggest appropriate indexing strategies.

Quick Start

Use the database architect agent to design a schema for a new social media application, focusing on user profiles and posts.

Frequently Asked Questions about database-architect-agent

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I design a scalable database schema for a new application?▼

Database design for scalable applications starts with robust data modeling and entity-relationship mapping. This Skill guides you through schema optimization and normalization, recommending appropriate indexing strategies for relational and NoSQL databases to ensure efficient data management.

What's the best way to optimize query performance and identify database bottlenecks?▼

Query performance tuning optimizes indexing strategies to eliminate bottlenecks. This Skill provides comprehensive guidance on identifying performance issues and applying schema optimization techniques to improve relational and NoSQL database response times.

How do I plan a complex database migration without data loss?▼

Database migration planning requires careful strategy to prevent data loss during transitions. This Skill guides you through complex migration processes, offering structured approaches for moving between database technologies while maintaining data integrity.

When should I use vertical vs horizontal database scaling patterns?▼

Database scaling patterns dictate when to use vertical scaling versus horizontal scaling based on your workload. This Skill recommends and explains appropriate scaling strategies for relational and NoSQL databases to match your specific growth requirements.

Does this database architecture guidance support both relational and NoSQL databases?▼

Database architecture guidance here fully supports both relational and NoSQL databases. This Skill covers technology selection, data modeling, and indexing strategies tailored to your specific database type, ensuring fit for your platform and scale.

Why does my database query performance degrade as data volume grows?▼

Database query performance degrades as data volume grows due to unoptimized schemas and missing indexes. This Skill identifies bottlenecks and applies query tuning and indexing strategies to resolve performance limitations in large-scale relational and NoSQL environments.

Related Skills

Explore More Software Engineering Skills→
LucasMalessaLucasMalessa

ring:pre-dev-data-model

Define abstract data structures and relationships before selecting a database technology.

Community
Advanced
jinwoonghongjinwoonghong

moai-domain-database

Design PostgreSQL, MongoDB, Redis, and Oracle schemas with indexing and query optimization.

Community
Advanced
rnavarychrnavarych
14

role-database:database-devops

Automate database provisioning, Kubernetes deployment, and CI/CD integration with Terraform.

Community
Advanced
NabilThangeNabilThange
1

database-design

Guide database design decisions for schema, indexing, ORM, and migrations.

Community
Advanced