LogoClawIndex
CasesSkillsAbout
LogoClawIndex

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.

query-builder - Build Protheus SQL and Workarea code

Build safe, optimized SQL for Protheus tables with mandatory filters, index suggestions, Workarea and Embedded SQL variants, and pitfall warnings.

Tags

Updated: 2026-10-04

Capabilities

Typical Inputs

Typical Outputs

What this skill does

  • Build safe Protheus SQL queries
  • Apply deletion and branch filters
  • Suggest indexes from SIX patterns
  • Generate Workarea access code
  • Generate Embedded SQL code
  • Warn about SQL pitfalls
  • Choose Workarea or Embedded SQL

Inputs

  • Protheus table aliases
  • Query requirements
  • Filter criteria
  • Index definitions
  • Database compatibility concerns

Outputs

  • SQL query code
  • Workarea code
  • Embedded SQL code
  • Index recommendations
  • SQL pitfall warnings

Requirements

    Source

    • Spec: SKILL.md
    Protheus
    SQL
    AdvPL
    TLPP
    Workarea
    Embedded SQL
    SIX indexes
    Query generation
    Build safe Protheus SQL queries
    Apply deletion and branch filters
    Suggest indexes from SIX patterns
    Generate Workarea access code
    Protheus table aliases
    Query requirements
    Filter criteria
    SQL query code
    Workarea code
    Embedded SQL code