Sql Optimization

Deep SQL performance workflow—symptom framing, execution plans, indexing strategy, query rewrite, locking/transaction behavior, statistics, partitioning, and...

This guidance is coherent and useful for DB tuning, but it assumes access to a database and the ability to run potentially disruptive commands. Before using it: (1) never grant the agent unrestricted production DB credentials — prefer read-only or restricted-analysis roles for initial investigation; (2) require human approval for any DDL (index creation/drop) or changes that affect writes; use CONCURRENT/online DDL where supported; (3) be cautious with EXPLAIN ANALYZE and load tests — they can execute heavy queries and stress systems; run them against staging or shadow traffic when possible; (4) have backups, monitoring, and rollback plans in place before changing schema or indexes; (5) ensure audit logs and change controls capture any commands the agent runs; and (6) if you want the agent to actually execute commands, explicitly provision least-privilege credentials and limit the scope (specific DB, read-only by default). If these operational safeguards are acceptable, the skill's guidance appears appropriate and coherent.

Type: OpenClaw Skill Name: sql-optimization Version: 1.0.0 The skill bundle provides a structured, high-quality workflow for SQL performance optimization, covering diagnostic steps like execution plan analysis and indexing strategies. The content in SKILL.md consists entirely of instructional guidance for the AI agent and contains no malicious code, data exfiltration attempts, or prompt-injection attacks.