A comprehensive six-stage database performance workflow for diagnosing symptoms, analyzing execution plans, and implementing verified query and index optimizations.
Install & Download
1. ClawHub CLI
The fastest way to install a skill directly from the registry.
npx clawhub@latest install sql-optimization
2. Manual Installation
Copy the skill folder to one of these locations
~/.openclaw/skills/ <project>/skills/ Priority: Workspace > Local > Bundled
3. Prompt Installation
Copy this prompt to OpenClaw to install it automatically.
Help me install sql-optimization using Clawhub. If Clawhub is not installed, install it first (npm i -g clawhub).
Prefer to download?
Get the raw skill files in a ZIP archive.
What is SQL Optimization (Deep Workflow)?
The SQL Optimization skill is a high-level performance engineering framework designed for Openclaw Skills users who need to move beyond guesswork. It provides a structured observe-explain-change-verify methodology to tackle complex database bottlenecks. By focusing on technical truths like execution plans, lock behavior, and write amplification, this skill ensures that database improvements are both measurable and sustainable.
This workflow is engine-agnostic but depth-aware, providing tailored guidance for PostgreSQL, MySQL, SQL Server, and more. It helps developers identify the root causes of high P99 latencies, CPU spikes, and replication lag by analyzing the interaction between ORM-generated SQL and the underlying storage engine architecture.
SQL Optimization (Deep Workflow) Use Cases
- Resolving slow user-facing queries or batch processing timeouts
- Mitigating database CPU spikes caused by inefficient execution plans
- Optimizing ORM-generated SQL to eliminate N+1 query patterns
- Managing index bloat and reducing write amplification on high-traffic tables
- Transitioning from legacy OFFSET pagination to high-performance keyset pagination
How SQL Optimization (Deep Workflow) Works
- Frame the Problem: Define specific SLOs and identify the exact metrics or endpoints failing performance requirements.
- Reproduce & Measure: Establish a stable baseline using representative data cardinality and tools like EXPLAIN (ANALYZE, BUFFERS).
- Analyze Execution Plans: Identify dominant costs such as sequential scans, nested loop explosions, or disk-based sort spills.
- Schema & Index Engineering: Design optimal composite, partial, or covering indexes while considering the impact on write performance.
- Query & Transaction Tuning: Rewrite SQL logic to reduce rows touched and optimize transaction windows to minimize locking contention.
- Verification & Guardrails: Validate the fix with production-like parameters and implement monitoring to prevent future regressions.
SQL Optimization (Deep Workflow) Setup
To integrate this workflow into your Openclaw Skills environment, ensure your agent has access to database schema metadata and query execution tools.
# Example: Installing the SQL Optimization skill via Openclaw CLI
openclaw install skill sql-optimization
# Ensure your database user has sufficient permissions for analysis
# PostgreSQL: GRANT pg_read_all_stats TO openclaw_user;
SQL Optimization (Deep Workflow) Data Schema & Taxonomy
The skill organizes its optimization lifecycle through a structured data taxonomy to ensure repeatable results:
| Data Component | Description |
|---|---|
| Problem Statement | Documentation of the regression, SLO, and specific metric (e.g., p95 latency). |
| Baseline Plan | The original execution plan hash and cost metrics for A/B comparison. |
| DDL Proposal | Proposed schema changes including rationale and a verified rollback strategy. |
| Stats & Histograms | Metadata regarding row counts, column cardinality, and NDV (Number of Distinct Values). |
| Performance Guardrails | Configuration for statement timeouts and alerts for sequential scans. |
SQL Optimization (Deep Workflow) Advanced Features
- Multi-engine adaptation for PostgreSQL, MySQL, and SQL Server specific hint syntaxes
- Advanced partitioning and materialized view strategy recommendations
- Lock-wait and transaction isolation level analysis for high-concurrency environments
- Automated identification of stale statistics and parameter sniffing issues
- Integration with shadow traffic or load testing workflows for safe verification
SKILL.md
Loading
Related Openclaw Skills
My Stock Watchlist Skill
A specialized AI skill for managing stock portfolios and watchlists directly within DingTalk multidimensional tables.
Social Radar MVP
Social Radar MVP is an internal networking tool for Spaces that automates user onboarding, profile drafting, and intelligent peer recommendations.
rapiddns
A powerful command-line interface for rapid DNS reconnaissance and subdomain enumeration leveraging the RapidDNS API.
Dusk Ascension
A specialized image generation skill that produces ethereal product hero shots using a 1990s high-fashion analog film aesthetic.
Weibo Config
A specialized configuration utility to bridge Weibo channel credentials with the OpenClaw ecosystem.
State Management Deep Workflow
A comprehensive framework for modeling domain and UI state, ensuring data consistency across client-side and hybrid applications.
Featured*
