skills.rest
aiunlocked1412
aiunlocked1412COMMUNITY
Explore all skills by this author →
WebsiteGitHub

database-architect

Designs scalable database schemas and zero-downtime migration plans for PostgreSQL, MySQL, and NoSQL systems.

14|6|Updated Apr 16, 2026
Search Tags:#indexing#database#migrations#nosql#zero-downtime#postgres#schema-design
One-click install
npx skills add https://github.com/aiunlocked1412/claude-skill-unlock --skill database-architect-aiunlocked1412
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: database-architect
Source: https://github.com/aiunlocked1412/claude-skill-unlock/tree/main/skills/03-tech/database-architect
Command: npx skills add https://github.com/aiunlocked1412/claude-skill-unlock --skill database-architect-aiunlocked1412

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Traditional database design can hinder growth and uptime due to improper schema choices, missing indexes, and risky migrations that cause production outages. This Skill provides a structured approach to design scalable schemas, audit indexing, and plan zero-downtime migrations across relational and NoSQL systems.

Core Features & Use Cases

  • Normalize with 3NF and apply denormalization only when necessary for performance.
  • Perform index audits using EXPLAIN ANALYZE and plan optimized strategies.
  • Create migration plans that minimize downtime and safeguard data, including backups and rollback paths.
  • Choose appropriate DB approaches (SQL vs NoSQL vs hybrid) for evolving product requirements.
  • Deliver a full DB blueprint with schema + indexes + migration plan for real projects.

Quick Start

Create a complete database blueprint for a domain, including schema, indexes, and a zero-downtime migration plan.

Frequently Asked Questions about database-architect

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

FAQPage Schema
How do I plan zero-downtime database migrations for PostgreSQL?▼

Zero-downtime database migrations require structured plans that include backfill-backup steps, constraints, and rollback paths. This approach enforces safe deployment practices to ensure non-disruptive production updates across PostgreSQL and MySQL systems.

What's the best way to design scalable database schemas for production?▼

Designing scalable database schemas involves normalizing to 3NF and applying denormalization only when necessary for performance. This process delivers a full database blueprint with optimized indexes and safe migration plans tailored for real production projects.

How do I audit database indexes using EXPLAIN ANALYZE?▼

Index audits using EXPLAIN ANALYZE evaluate query performance to plan optimized indexing strategies. This identifies missing or inefficient indexes within your schema, ensuring database queries remain performant as underlying data scales.

When should I choose NoSQL over SQL for evolving product requirements?▼

Choosing NoSQL versus SQL or a hybrid approach depends on your evolving product requirements. This database design process evaluates your specific data access patterns to recommend the appropriate database approach for scalability and performance.

Can I use this database schema design approach with MySQL?▼

Yes, this database schema design approach supports tool compatibility across PostgreSQL, MySQL, and NoSQL options. It normalizes schemas, applies indexing strategies, and creates safe migration plans that work across these specific database systems.

Related Skills

Explore More Software Engineering Skills→
Eigo-Mt-FujiEigo-Mt-Fuji

database-schema-designer

Design database schemas, ER diagrams, and DDL for relational and NoSQL databases.

Community
Advanced
tradewinds-centertradewinds-center
3

migration-helper

Plan and execute Convex schema migrations with backfill strategies.

Official
Advanced
jeremylongshorejeremylongshore
2.6k

generating-orm-code

Generate ORM models and database schemas across multiple frameworks.

Community
Intermediate
rnavarychrnavarych
14

role-database:database-migration

Plan database schema and data migrations across engines with zero-downtime strategies.

Community
Advanced