# SQL Database Specialist

> Design, optimize, and migrate SQL databases with reliability and performance guardrails.

- Skill: `majiayu000/sql-database-specialist` (Agent Skill, multi-file: 2 files)
- Install (CLI): `npx skillmds add majiayu000/sql-database-specialist`
- Raw SKILL.md: https://api.skillmd.com/api/skills/majiayu000/sql-database-specialist/raw
- Safety review: pending
- Works with: Claude Code, Claude.ai, OpenAI Codex
- Category: Data & Analytics
- Author: majiayu000 (https://skillmd.com/u/majiayu000)
- Updated: 2026-09-09
- Page: https://skillmd.com/skills/majiayu000/sql-database-specialist

---



## STANDARD OPERATING PROCEDURE

### Purpose
Deliver correct, performant, and safe SQL schemas, queries, and migrations with explicit validation and rollback plans.

### Triggers
- **Positive:** Query optimization, schema design/refactor, migration planning/execution, indexing strategies, performance diagnostics.
- **Negative:** Non-SQL datastore design (route to data or system design specialist) or pure prompt rewrite (prompt-architect).

### Guardrails
- Structure-first: maintain `SKILL.md`, `readme`, `examples/`, `tests/`, and `resources/`; add missing docs before work.
- Constraint extraction: HARD/SOFT/INFERRED (SLOs, latency/throughput targets, storage budget, compliance, downtime windows).
- Validation discipline: include EXPLAIN plans, regression tests, and rollback scripts; measure before/after metrics.
- Data safety: backups before migrations; no destructive change without rollback; idempotent scripts when possible.
- Confidence ceiling required (inference/report 0.70; research 0.85; observation/definition 0.95).

### Execution Phases
1. **Intake & Context**
   - Capture workload characteristics, current issues, versions/engines, and downtime constraints.
2. **Design/Optimization**
   - Draft schema/index changes; craft query rewrites; plan batching/locking strategy.
   - Produce explain/plan analysis and expected impact.
3. **Validation**
   - Run tests on staging: correctness, performance, and concurrency/locking behavior.
   - Verify migration idempotency and rollback steps.
4. **Delivery**
   - Provide scripts, execution order, monitoring plan, and rollback instructions.
   - Tag MCP memory (`WHO=sql-database-specialist-{session}`, `WHY=skill-execution`).

### Output Format
- Problem statement and constraints.
- Proposed schema/query changes with rationale and plan analysis.
- Test results (before/after metrics) and rollback steps.
- Confidence with ceiling.

### Validation Checklist
- [ ] Constraints confirmed; downtime window known.
- [ ] Explain/plan captured; metrics baseline + post-change recorded.
- [ ] Migration safe (backup + rollback + idempotency).
- [ ] Tests cover correctness and performance.
- [ ] Confidence ceiling stated.

## VCL COMPLIANCE APPENDIX (Internal)
[[HON:teineigo]] [[MOR:root:S-Q-L]] [[COM:SQL+Schmiede]] [[CLS:ge_skill]] [[EVD:-DI<gozlem>]] [[ASP:nesov.]] [[SPC:path:/skills/specialists/database-specialists/sql-database-specialist]]

[[HON:teineigo]] [[MOR:root:E-P-S]] [[COM:Epistemik+Tavan]] [[CLS:ge_rule]] [[EVD:-DI<gozlem>]] [[ASP:nesov.]] [[SPC:coord:EVD-CONF]]


Confidence: 0.74 (ceiling: inference 0.70) - SOP rebuilt using prompt-architect clarity and skill-forge guardrails while preserving SQL depth.