skills.rest
baotoq
baotoqCOMMUNITY
Explore all skills by this author →
GitHub

database-architect

Design scalable database architectures with technology selection, schema modeling, and migration planning.

Updated Jan 9, 2025
Search Tags:#architecture#schema design#database#scalability#migration#data modeling
One-click install
npx skills add https://github.com/baotoq/go-shortener --skill database-architect-baotoq
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: database-architect
Source: https://github.com/baotoq/go-shortener/tree/main/.agents/skills/database-architect
Command: npx skills add https://github.com/baotoq/go-shortener --skill database-architect-baotoq

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

This Skill provides expert guidance on designing robust, scalable, and performant database architectures from scratch or by re-architecting existing systems.

Core Features & Use Cases

  • Technology Selection: Recommends optimal database technologies (SQL, NoSQL, Time-Series, etc.) based on specific requirements.
  • Schema Design: Creates logical and physical data models, including normalization, indexing, and partitioning strategies.
  • Migration Planning: Outlines safe, zero-downtime migration strategies for evolving data layers.
  • Use Case: A startup needs to design the data layer for a new social media application expected to scale to millions of users; this Skill will recommend the database technology, design the schema, and plan for sharding.

Quick Start

Design a database schema for a multi-tenant SaaS e-commerce platform.

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 a high-growth application?▼

Designing a scalable database schema involves creating logical and physical data models with normalization, indexing, and partitioning strategies to ensure performance as data volume grows.

What is the best way to choose between SQL and NoSQL for my data modeling requirements?▼

Choosing between SQL and NoSQL for data modeling requires evaluating specific application requirements to recommend optimal technologies, including relational, time-series, or hybrid database paradigms.

How do I plan a zero-downtime database migration for an existing system?▼

Planning a zero-downtime database migration involves outlining safe, step-by-step migration strategies to re-architect evolving data layers without disrupting active system availability.

Can I use this approach to design a data layer for a multi-tenant SaaS platform?▼

Yes, you can use this database architecture approach to design data layers for multi-tenant SaaS platforms by selecting appropriate technologies and modeling schemas tailored to multi-tenant scalability.

When do I need to use sharding in my database architecture?▼

You need to use sharding in your database architecture when planning for massive scalability, such as social media applications expecting millions of users, to distribute data across multiple database instances.

Related Skills

Explore More Software Engineering Skills→
michaelsvanbeekmichaelsvanbeek
1

anomaly-detection

Detect unusual patterns in time-series, logs, and metric data.

Community
Advanced
agnaldo4jagnaldo4j
1

db-migrations

Manage PostgreSQL schema lifecycles with versioned Flyway migrations and HikariCP pooling.

Community
Advanced
nimadorostkarnimadorostkar
25

django

Optimize Django ORM queries and enforce database-level constraints.

Community
Advanced
laurigateslaurigates
10

Infrastructure Terraform

Automate cloud infrastructure provisioning with Terraform and HCL.

Community
Advanced