Ready to supercharge your AI agents?

Install any skill in seconds. Free to start, no credit card required.

Get Started Free →

Cte Query Builder · dicklesworthstone | DecimalAI

Registry skillby dicklesworthstone

Cte Query Builder

dicklesworthstone/cte-query-builder

Source dicklesworthstone/pi_agent_rust ↗License NOASSERTION

Build cte query builder operations. Auto-activating skill for Data Analytics.

SkillScore86Maintained

Automatic

Data Analyst pack

Last verified 8/30/2026

What it changes

Passed 19 of 22 test cases with the skill, and 18 of 22 without it.

Without skill82%

With skill86%

Checks it passed that the model alone missed

Applies DENSE_RANK() OVER partitioned by category_id within a CTE.

1 fixed18 passed either way3 still failing0 broke

Pass-rate lift: +5 pp
Tokens: +15%
Agent turns: 0%
Response time: +3%

Model gemini-3.6-flashMeasured 8/30/2026v119 of 22 cases passed with skill

Tokens, turns and time describe resource use, not a dollar price.

Use this skill

Save it into your project's skills folder. Claude Code picks it up in its next session.

curl -fsSL --create-dirs -o .claude/skills/dicklesworthstone-cte-query-builder/SKILL.md https://app.decimal.ai/s/dicklesworthstone-cte-query-builder/SKILL.md

Want it pinned and updatable? pip install "decimalai>=0.15", then decimalai skills add dicklesworthstone-cte-query-builder, and start Claude Code with claude --plugin-dir "$(git rev-parse --show-toplevel)/.agents"

1 · One-time — install the CLI (docs ↗)

pip install "decimalai>=0.15"

2 · Get the skill — writes .agents/skills/dicklesworthstone-cte-query-builder/ and pins it in .decimal/skills.lock

decimalai skills add dicklesworthstone-cte-query-builder

No CLI? Get the same file — curl · raw file

curl -fsSL --create-dirs -o .claude/skills/dicklesworthstone-cte-query-builder/SKILL.md https://app.decimal.ai/s/dicklesworthstone-cte-query-builder/SKILL.md

Raw file: /s/dicklesworthstone-cte-query-builder/SKILL.md ↗ · machine-readable summary at /s/dicklesworthstone-cte-query-builder.json ↗

Safety checks: 3 of 3 passed

Code scan CleanIntent PassedContent Clean

See it in action

A test case the skill fixed. Same model, same prompt, with and without the skill.

Prompt

We need a query against `products` and `sales_items` to find the top 3 highest revenue products within each product category, including ties if sales are equal. Developers frequently use correlated LIMIT queries or ROW_NUMBER() which silently drops tied 3rd place products. Provide a CTE query that properly handles sales ties when ranking.

What was checked, without and with the skill
Checked	Without skill	With skill
Applies DENSE_RANK() OVER partitioned by category_id within a CTE.	Missed	Passed
Filters the output where the rank grade is less than or equal to 3.	Passed	Passed

case-09 · gemini-3.6-flash · 8/30/2026 · answers are capped and redacted

What's inside

The instructions your model reads when the skill loads.

SKILL.md60 linessingle file

Cte Query Builder

Overview

This skill provides automated assistance for cte query builder tasks within the Data Analytics domain.

When to Use

This skill activates automatically when you:

Mention "cte query builder" in your request
Ask about cte query builder patterns or best practices
Need help with data analytics skills covering sql queries, data visualization, statistical analysis, and business intelligence.

Instructions

Provides step-by-step guidance for cte query builder
Follows industry best practices and patterns
Generates production-ready code and configurations
Validates outputs against common standards

Examples

Example: Basic Usage Request: "Help me with cte query builder" Result: Provides step-by-step guidance and generates appropriate configurations

Prerequisites

Relevant development environment configured
Access to necessary tools and services
Basic understanding of data analytics concepts

Output

Generated configurations and code
Best practice recommendations
Validation results

Track record

Benchmark

19 / 22

test cases passed, vs 18 / 22 without

Adoption

Users: 0
Times used: 0

Safety and source details

SkillSafety

✓ 3 of 3 passed

Code scan15 of 15 checks clean

0 critical · 0 warning · 0 info — scanner v4 — 8/10/2026

View 15 scanner checks

live_secretremote_code_executionreverse_shelldata_exfiltrationssrf_metadataagent_snoopinganti_refusaldestructive_commandsobfuscated_unicodeunicode_homoglyphopaque_blobsuspicious_urltool_overreachtrigger_abuseprompt_injection_phrasing

IntentSafe

LLM judge · does the skill do what it claims

ContentClean

LLM judge · policy & harmful-content review

Source

Imported

dicklesworthstone / pi_agent_rust

tests/ext_conformance/artifacts/plugins-community/skills/12-data-analytics/cte-query-builder/SKILL.md

View on GitHub ↗

License MITImported 8/10/2026Version v1

More skills from the same source and nearby in the registry, with their headline benchmark lift.

Ready to supercharge your AI agents?

See it in action

What's inside

Cte Query Builder

Overview

When to Use

Instructions

Examples

Prerequisites

Output

Track record

Benchmark

Adoption

SkillSafety

Source

Related skills