Marketplace

sql-database-specialist

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

allowed_tools: Read, Write, Edit, Bash, Glob, Grep, Task, TodoWrite

model: sonnet

$ インストール

git clone https://github.com/DNYoussef/context-cascade /tmp/context-cascade && cp -r /tmp/context-cascade/skills/specialists/database-specialists/sql-database-specialist ~/.claude/skills/context-cascade

// tip: Run this command in your terminal to install the skill

SKILL.md

View on GitHub →

name: sql-database-specialist description: Design, optimize, and migrate SQL databases with reliability and performance guardrails. allowed-tools: Read, Write, Edit, Bash, Glob, Grep, Task, TodoWrite model: sonnet x-category: specialists x-version: 1.1.0 x-vcl-compliance: v3.1.1 x-cognitive-frames:

HON
MOR
COM
CLS
EVD
ASP
SPC

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

Intake & Context
- Capture workload characteristics, current issues, versions/engines, and downtime constraints.
Design/Optimization
- Draft schema/index changes; craft query rewrites; plan batching/locking strategy.
- Produce explain/plan analysis and expected impact.
Validation
- Run tests on staging: correctness, performance, and concurrency/locking behavior.
- Verify migration idempotency and rollback steps.
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]] [[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]] [[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.