skills.rest
CODE-SAURABH
CODE-SAURABHCOMMUNITY
Explore all skills by this author →
GitHub

database-architect

Design and troubleshoot database schemas, queries, and migrations for PostgreSQL, MySQL, MongoDB, and Redis.

2|1|Updated Jul 25, 2026
Search Tags:#query optimization#indexing#schema design#migrations#multi-tenancy#replication#database architecture
One-click install
npx skills add https://github.com/CODE-SAURABH/OpenSkills --skill database-architect-code-saurabh
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: database-architect
Source: https://github.com/CODE-SAURABH/OpenSkills/tree/main/database-architect
Command: npx skills add https://github.com/CODE-SAURABH/OpenSkills --skill database-architect-code-saurabh

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

This Skill helps engineers design reliable, scalable database systems and resolve production data problems before they become outages, performance failures, migration incidents, or security issues.

Core Features & Use Cases

  • Schema and Data Modeling: Design normalized schemas, entity relationships, constraints, indexes, multi-tenant models, and MongoDB document structures.
  • Performance and Reliability: Diagnose slow queries and N+1 patterns, choose indexes, plan partitioning, configure connection pooling, and evaluate replication, failover, and consistency requirements.
  • Safe Operations: Plan reversible, lock-conscious migrations; select transaction isolation and locking strategies; protect sensitive data; and validate backups and point-in-time recovery.
  • Use Case: When a production query becomes slow as data grows, use this Skill to analyze access patterns, review the execution plan, recommend targeted indexes or query changes, and define monitoring and rollout safeguards.

Quick Start

Ask the database architect skill to design a production-ready schema for a multi-tenant SaaS application, including indexes, transaction boundaries, migration steps, and backup requirements.

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 multi-tenant database schema for a SaaS application?▼

Designing a multi-tenant database schema requires structuring entity relationships, constraints, and indexes to isolate tenant data. This Skill helps model normalized schemas and multi-tenant architectures for PostgreSQL or MongoDB, ensuring reliable performance and data separation.

How do I optimize slow PostgreSQL queries as data grows in production?▼

Optimizing slow PostgreSQL queries involves analyzing access patterns, reviewing execution plans, and recommending targeted indexes. This Skill diagnoses slow queries and N+1 patterns, selecting appropriate indexes and partitioning strategies to restore performance.

What is the best way to plan reversible and lock-conscious database migrations?▼

Planning reversible database migrations requires selecting transaction isolation and locking strategies to prevent outages. This Skill helps plan lock-conscious migrations, define rollback steps, and establish monitoring safeguards for safe schema evolution.

How do I configure database replication and high availability for failover?▼

Configuring database replication and high availability requires evaluating consistency requirements and failover scenarios. This Skill assesses replication topologies and connection pooling to ensure capacity-aware, reliable production data infrastructure.

When do I need partitioning instead of standard indexing for large tables?▼

Partitioning is needed when standard indexing cannot manage query latency across massive datasets. This Skill evaluates your access patterns and data growth to determine when partitioning or targeted indexing best resolves performance bottlenecks.

How do I validate backup and point-in-time recovery plans for production databases?▼

Validating backup and point-in-time recovery plans requires testing restoration procedures and security controls. This Skill helps define and test recovery plans, ensuring your production database can safely recover from failures without data loss.

Related Skills

Explore More Software Engineering Skills→
sakamoto-family-smilesakamoto-family-smile

jpa-patterns

Define Spring Boot data models and repository access patterns with JPA.

Community
Intermediate
enchantednaturesenchantednatures

migration-planning

Plan and execute reversible database, code, and infrastructure migrations.

Community
Advanced
JonathanMitchell1234JonathanMitchell1234

postgresql-expert

Administer PostgreSQL databases with advanced queries, performance tuning, and production operations.

Community
Advanced
MovchanetsMovchanets

database-admin

Plan and validate database administration workflows for cloud and self-managed environments.

Community
Advanced