LogoClawIndex
CasesSkillsAbout
LogoClawIndex

sql-pro-v3 - Optimize SQL for Cloud-Native OLTP/OLAP Systems

Optimizes complex SQL, schemas, and OLTP/OLAP workloads through access-path inspection, EXPLAIN validation, and provenance-aware workflow.

Tags

Updated: 2026-10-01
SQLquery optimizationdatabase designOLTPOLAPcloud-native databasesHTAPdata migrationprovenance

Capabilities

Define query goalsInspect schemas and statisticsOptimize complex SQLValidate queries with EXPLAIN

Typical Inputs

Query goals and constraintsExpected query outputsDatabase schema details

Typical Outputs

Optimized SQL queriesValidated execution plansPerformance verification results

What this skill does

  • Define query goals
  • Inspect schemas and statistics
  • Optimize complex SQL
  • Validate queries with EXPLAIN
  • Verify performance under load
  • Preserve workflow provenance
  • Load relevant support files
  • Route to related skills

Inputs

  • Query goals and constraints
  • Expected query outputs
  • Database schema details
  • Database statistics
  • Access paths
  • Workload and load context
  • Repository context
  • metadata.json
  • ORIGIN.md
  • Copied support files

Outputs

  • Optimized SQL queries
  • Validated execution plans
  • Performance verification results
  • Provenance-aware review notes
  • Explicit support-file selections
  • Handoff recommendations

Requirements

  • SQL database context
  • Schema access
  • Query plan access
  • Access to repository provenance files

Source

  • Spec: SKILL.md

ClawIndex

OpenClaw Skills & Use Case Index

ClawIndex is an ecosystem-driven index of OpenClaw skills and real-world use cases.

Index

Skills·
Cases

Meta

About·
Disclaimer·
Email·
GitHub
© 2026 ClawIndex All Rights Reserved.