skills.rest
hainamchung
hainamchungCOMMUNITY
Explore all skills by this author →
GitHub

database-architect

Plan scalable data architectures and select database technologies for relational, NoSQL, and time-series stores.

54|18|Updated Jan 21, 2026
Search Tags:#performance#indexing#scalability#migrations#data-modeling#schema-design#database-architecture
One-click install
npx skills add https://github.com/hainamchung/agent-assistant --skill database-architect-hainamchung
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: database-architect
Source: https://github.com/hainamchung/agent-assistant/tree/main/skills/database-architect
Command: npx skills add https://github.com/hainamchung/agent-assistant --skill database-architect-hainamchung

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

The skill helps organizations design scalable, robust data layers that ensure data integrity, performance, and evolvability across evolving applications.

Core Features & Use Cases

  • Database technology selection across relational, document, key-value, and time-series stores to match workload.
  • Schema design & normalization strategies including patterns for transactional and analytical workloads, along with indexing and denormalization guidance.
  • Migration planning & disaster recovery with zero-downtime strategies and rollback plans.
  • Use Case: Designing a new service's data layer to support high-velocity writes and complex analytics.

Quick Start

Outline a scalable data layer for a new service, including technology choice, schema patterns, and growth plans.

Frequently Asked Questions about database-architect

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

FAQPage Schema
How do I design a scalable database schema for high-velocity writes and complex analytics?▼

A scalable data architecture requires selecting appropriate database technologies for your workload, applying workload-aware schema design, and planning indexing strategies to support both high-velocity writes and complex analytics.

What is the best way to choose between relational, NoSQL, and time-series databases?▼

The best way to choose between relational, NoSQL, and time-series databases is by matching the database technology to your specific workload, ensuring the data layer supports your required data integrity and performance.

How do I plan zero-downtime database migrations with a rollback strategy?▼

Planning zero-downtime database migrations requires detailed migration planning that includes creating robust rollback plans and disaster recovery strategies to ensure data integrity and evolvability without service interruption.

When do I need time-series data stores in my data architecture?▼

You need time-series data stores in your data architecture when your application requires handling high-velocity time-stamped data workloads, ensuring robust data modeling and performance tuning across multi-model database environments.

Can I use denormalization and indexing strategies for analytical workloads?▼

Yes, you can use denormalization and indexing strategies for analytical workloads by applying specific schema design patterns that optimize complex queries and ensure performance tuning across your data layer.

Related Skills

Explore More Software Engineering Skills→
jfrometajfrometa

database-design

Guide schema design, indexing, ORM selection, and serverless database options.

Community
Basic
Cure-Consulting-GroupCure-Consulting-Group
1

database-architect

Design database schemas and plan migrations for Firestore, PostgreSQL, and SQLite.

Official
Advanced
jzallenjzallen
1

Gateway Builder

Create gateway classes that integrate external services via Protocol interfaces.

Community
Advanced
rahlplxrahlplx

database-design

Guide schema design, indexing strategies, and ORM selection for databases.

Community
Intermediate