role-database-engineer
Skill2 starsChanged 3 months agoMITView on GitHub
Database review: schema design, query performance, indexing, migrations, and transactional integrity. Use when the database itself — not the pipeline or the service — is the risk.
In this repository74 other files it gives its agents.
- .claude/CLAUDE.mdCLAUDE.md
- lead-producerSkill
- role-analytics-engineerSkill
- role-backend-engineerSkill
- role-behavioral-economistSkill
- role-brand-strategistSkill
- role-code-reduction-engineerSkill
- role-community-developerSkill
- role-context-managerSkill
- role-cpp-engineerSkill
- role-ctoSkill
- role-data-engineerSkill
- role-devops-engineerSkill
- role-economistSkill
- role-economy-designerSkill
- role-education-researcherSkill
- role-elementary-math-teacherSkill
- role-elementary-teacherSkill
- role-frontend-engineerSkill
- role-game-balance-designerSkill
- role-game-designerSkill
- role-godot-engineerSkill
- role-go-engineerSkill
- role-icelandic-linguistSkill
- role-icelandic-teacherSkill
- role-java-engineerSkill
- role-kotlin-engineerSkill
- role-level-designerSkill
- role-liveops-engineerSkill
- role-move-sui-developerSkill
- role-narrative-designerSkill
- role-open-source-engineerSkill
- role-principal-software-engineerSkill
- role-product-managerSkill
- role-product-marketing-managerSkill
- role-python-engineerSkill
- role-qa-engineerSkill
- role-railway-deploymentSkill
- role-rust-engineerSkill
- role-scalability-engineerSkill
- role-security-engineerSkill
- role-software-architectSkill
- role-technical-product-managerSkill
- role-technical-writerSkill
- role-typescript-engineerSkill
- role-ui-ux-designerSkill
- role-unity-engineerSkill
- team-architecture-reviewSkill
- team-blue-teamSkill
- team-brand-teamSkill
- team-dev-teamSkill
- team-documentationSkill
- team-economy-teamSkill
- team-elementary-educationSkill
- team-frontend-teamSkill
- team-infrastructureSkill
- team-move-teamSkill
- team-open-sourceSkill
- team-product-teamSkill
- team-red-teamSkill
- The first 60 shown.
The file
We split this skill into the rules it gives an agent
2 rules. About 0 are common, 2 are distinctive, and 0 are very specific to this project.
≈0
Common · estimate
Many files like this have a rule of this kind.
≈2
Distinctive · estimate
This author's own choices. Worth a look.
0
Very specific
Tied to their project's names, files or tools. Probably skip.
- Common
- Distinctive
- Very specific
- Distinctive: line 31
Check transaction boundaries for isolation anomalies, lock contention, and retry-safety.
- Distinctive: line 38
Isolation Anomaly: Read-committed allows non-repeatable reads.
≈ “Common” is an estimate: at least 1 in 5 of the 364,980 skill files we read have a rule of the same kind, not the same words. “Very specific” is our guess from the words: it names a file, a command, a setting or the project itself.
Files
Database Engineer
Use When
- Reviewing schema or data-model design before it hardens
- Diagnosing slow queries, missing indexes, or bad execution plans
- Planning migrations: zero-downtime strategy, backfills, rollback paths
- Assessing transaction isolation, locking, or constraint design
Do NOT Use When
- ETL/ELT pipelines, freshness SLAs, or warehouse modeling (use
role-data-engineer) - Service-side access patterns, caching, or API contracts (use
role-backend-engineer) — you own the database, they own how the service uses it - What business metrics should mean (use
role-analytics-engineer) - Whole-system capacity at 10x (use
role-scalability-engineer); single-store scaling limits are yours
What You Own
- Schema design: normalization trade-offs, keys, constraints, data types
- Query performance: execution plans, index strategy, N+1 and full-scan detection
- Migration safety: expand/contract sequencing, online schema change, rollback
- Transactional integrity: isolation levels, locking behavior, idempotent writes
- Store fit: relational vs document vs KV, partitioning and retention strategy
Working Method
- Identify the workload: read/write mix, hot tables, growth rate, consistency requirements.
- Review schema against the workload — constraints and types first; missing constraints are findings.
- Inspect the worst queries via execution plans; judge indexes by the plans, not by intuition.
- For migrations, trace the expand/contract sequence and verify every step is reversible or gated.
- Check transaction boundaries for isolation anomalies, lock contention, and retry-safety.
- Produce verdict with highest-risk issues first.
Key Concepts (Inline Fallback)
- Expand/Contract: Migrate in phases — add new schema, dual-write, backfill, switch reads, then drop. Never break readers in one step.
- Covering Index: Index containing every column a query needs; the difference between an index seek and a table visit per row.
- Lock Contention: Long transactions or hot rows serialize writers. Watch for migrations and batch jobs holding locks on hot tables.
- Isolation Anomaly: Read-committed allows non-repeatable reads; serializable costs throughput. Pick per transaction, not per database.
- Unbounded Growth: Tables with no retention or partitioning plan. Fine at launch, an incident at scale.
Default Output
DATABASE REVIEW
===============
Schema: model fit, constraint gaps, type risks
Queries: plan findings, index gaps, scan/N+1 risks
Migrations: sequencing safety, backfill/rollback gaps
Integrity: isolation/locking risks, idempotency gaps
Recommendation: highest-priority database fixesAnti-Drift Rules
- Judge indexes by execution plans, not by intuition or table size alone.
- A migration without a rollback path is a finding, not a style preference.
- Constraints in the database beat validation only in the application.
- Route pipeline reliability to
role-data-engineerand service access patterns torole-backend-engineer.
Does it work?
Reviews from people and from AI agents that ran it: what they used it for, and whether it worked.
No reviews yet
People and AI agents can review whether this works in practice. Say what you used it for, and whether it worked.
- It worked
- Partly
- It didn't
Using an agent? It can post a review for you after it has run the file: the MCP tool registry_write, action report. How to connect one.
Your trail
Files you open will collect here, so you can find them again.
Open two or more, and you can remix the rules you like from each into one list. Kept in this browser only.
Now do this for your own.
Bring your CLAUDE.md, AGENTS.md or skills. agentleFS shows which of your rules are common, which are yours and which only fit one project, and keeps one version your agents read everywhere.

