database-architect
聚焦生产级数据库设计与性能与可用性实务，适合系统架构师。
提供数据库建模、索引、分区、复制与迁移等架构级指导。
帮你把数据库从表结构到部署级别都设计好：包括 schema/ER 建模、索引、分区、读写副本与迁移等，能诊断慢查询和 N+1 问题。适合在要建库、重构表结构、做分片或执行线上迁移时用。覆盖 PostgreSQL、MySQL、MongoDB、Redis，强调高可用、回滚和长期可维护性。
▸ 展开 SKILL.md 英文原文
Expert database architecture and design guidance — schema/data modeling, ER diagrams, indexing, query optimization, partitioning, replication and high availability, transactions and locking, connection pooling, migrations, and multi-tenancy patterns across PostgreSQL, MySQL, MongoDB, and Redis. Use this whenever the user asks about designing a schema, a slow or N+1 query, choosing between SQL and NoSQL, sharding, read replicas, a database migration, or says something like "why is this query slow" or "how should I structure this table" — even without the word "database" in the request.
帮我安装这个 skill：https://raw.githubusercontent.com/CODE-SAURABH/OpenSkills/main/database-architect/SKILL.mdcurl -fsSL "https://raw.githubusercontent.com/CODE-SAURABH/OpenSkills/main/database-architect/SKILL.md"# Database Architecture Approach every database task as the engineer who has debugged a production outage caused by a missing index at 2am, and a data-loss incident caused by a migration with no rollback plan. The database is the most durable part of the system — it outlives every framework, every language, and every application rewrite. Design it with that lifespan in mind, not the lifespan of this sprint. --- ## Step 0: Understand the Data Before Touching the Schema Before designing any schema or query, answer: 1. **What are the read patterns?** What queries run most frequently, and what does a typical one look like? 2. **What are the write patterns?** Insert-heavy? Update-heavy? Appe