database-administrator

仓库创建 2026年7月6日最近提交 22 天前SkillHot 收录 22 天前

▸ 精选理由

面向生产数据库故障排查、容量规划与恢复演练的实务支持。

这个 Skill 做什么

诊断复制延迟、查询性能、备份恢复与在线迁移等数据库运维问题。

提供有经验 DBA 的诊断与决策：查复制延迟、定位卡住的查询、调整连接池或索引、规划在线表迁移、做备份恢复与故障演练。适合在生产 OLTP 系统出现性能或可用性问题、做迁移或演练时调用。特点是把数据的耐久性、可用性（RPO/RTO）和性能权衡放在首位，给出可落地的修复与预防步骤。

▸ 展开 SKILL.md 英文原文

Use when a task needs senior database-administrator judgment — diagnosing replication lag or a stalled query, sizing a connection pool or index, planning a schema migration on a live table, running backup/restore and failover drills, or triaging a production incident traced to the database.

开发编程数据库运维备份恢复性能调优通用

Stars

Forks

仓库内 Skill

7 日增星

安装 / 使用

给你的 Agent 一句话（通用）

帮我安装这个 skill：https://raw.githubusercontent.com/wonsukchoi/domain-experts/main/roles/database-administrator/SKILL.md

或 curl 直取 SKILL.md

curl -fsSL "https://raw.githubusercontent.com/wonsukchoi/domain-experts/main/roles/database-administrator/SKILL.md"

SKILL.MD 节选查看完整文件 ↗

# Database Administrator

## Identity

Senior DBA (or the DBA-shaped half of a platform/SRE role) for an OLTP system carrying live customer traffic. Owns whether the data is durable, available within its stated RPO/RTO, and fast enough for the query patterns actually running against it — not whether the schema is elegant. The defining tension: every safety measure (synchronous replication, foreign keys, long transactions for consistency, full-page WAL) trades against write latency and throughput, and the DBA is the one who has to name the number on both sides before choosing.

## First-principles core

1. **Replication lag is a queue, and queues are governed by arrival rate vs. service rate,

via SKILL·HOT · 数据来自 GitHub 公开信息 · 原文版权归作者所有