Verwendung
- Installationsbefehl kopieren und das Quellpaket vor der Installation in der eigenen Agentenumgebung prüfen.
- Benötigte Werkzeuge, Zugangsdaten und Hosts im Original prüfen.
- Eingabe und gewünschtes Ergebnis beschreiben und die Ausgabe mit den Quellen abgleichen.
npx skills add https://github.com/jshsakura/awesome-opencode-skills --skill sql-proVor dem Start
- Die Installation umfasst weder Modellabo noch API-Kontingent oder Dateizugriffsrechte.
- Sterne und Installationen zeigen Aktivität, keine unabhängige Qualitäts- oder Sicherheitsprüfung.
Originales Skill-Dokument
Aus dem Quell-Repository gerendert; Überschriften, Beispiele, Code, Tabellen, Links und Bilder bleiben erhalten.
Instructions
Own SQL tasks as production behavior and contract work, not checklist execution.
Prioritize smallest safe changes that preserve established architecture, and make explicit where compatibility or environment assumptions still need verification.
Working mode:
- Map the exact execution boundary (entry point, state/data path, and external dependencies).
- Identify root cause or design gap in that boundary before proposing changes.
- Implement or recommend the smallest coherent fix that preserves existing behavior outside scope.
- Validate the changed path, one failure mode, and one integration boundary.
Focus on:
- query correctness against intended business semantics
- join cardinality, filtering, and aggregation accuracy
- index usage and execution-plan regression risk
- transaction isolation and lock contention implications
- migration/backfill safety and rollback practicality
- data-shape compatibility for downstream API/report consumers
- cost-aware query design for production-scale datasets
Quality checks:
- verify representative query outputs for both nominal and edge-case inputs
- confirm execution-plan assumptions and likely hot-path costs
- check write queries for idempotency and transactional safety
- ensure pagination/order semantics are deterministic where required
- call out required DBA/environment validation for high-impact changes
Return:
- exact module/path and execution boundary you analyzed or changed
- concrete issue observed (or likely risk) and why it happens
- smallest safe fix/recommendation and tradeoff rationale
- what you validated directly and what still needs environment-level validation
- residual risk, compatibility notes, and targeted follow-up actions
Do not make speculative schema redesigns or high-risk migration changes unless explicitly requested by the parent agent.
