database-architect

Design scalable data layers with schema modeling and migration planning.

6|Updated Mar 1, 2026
One-click install
npx skills add https://github.com/ChrstprJohn/SamsonDentalCenter --skill database-architect-chrstprjohn
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: database-architect
Source: https://github.com/ChrstprJohn/SamsonDentalCenter/tree/main/.agent/skills/database/database-architect
Command: npx skills add https://github.com/ChrstprJohn/SamsonDentalCenter --skill database-architect-chrstprjohn

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Builds scalable, maintainable data layers from the ground up, ensuring the right foundation for performance, evolution, and reliability. Provides guidance on technology selection, schema modeling, and architecture decisions that align with business needs and future growth.

Core Features & Use Cases

  • Technology selection and evaluation for database ecosystems (RDBMS, NoSQL, time-series, and more).
  • Conceptual, logical, and physical data modeling, including normalization, denormalization, and schema evolution.
  • Migration planning, rollback strategies, and zero-downtime deployment patterns across platforms.

Quick Start

Capture data domain, access patterns, and scale targets to inform the data layer design.

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 modern applications?

Design a scalable database schema by applying conceptual, logical, and physical data modeling techniques. This ensures the data layer foundation supports performance, future evolution, and reliability while aligning with specific business needs and growth targets.

How do I plan a zero-downtime database migration?

Plan a zero-downtime database migration by defining rollback strategies and deployment patterns across platforms. This approach minimizes operational risk and ensures continuous availability during technology selection transitions and architectural re-platforming.

What is the best way to choose between RDBMS and NoSQL for my data architecture?

Choosing between RDBMS and NoSQL requires technology evaluation based on your specific access patterns and scale targets. Evaluating database ecosystems ensures the selected technology aligns with your data domain and future growth requirements.

When do I need database partitioning strategies for performance optimization?

You need database partitioning strategies when optimizing data layer performance for high-scale applications. Partitioning distributes data efficiently, maintaining query responsiveness and supporting architectural evolution as system demands increase.

How do I approach data modeling for a greenfield database architecture?

Approach greenfield data modeling by capturing the data domain, access patterns, and scale targets. This initial capture informs the ground-up design, specifying required capabilities from conceptual schema design to physical implementation.

What security considerations are needed when evaluating database technology?

Evaluating database technology requires integrating security considerations alongside schema modeling and architecture decisions. Risk-aware implementations ensure zero-surprise deployments by addressing data protection requirements during technology selection and migration planning.