Loading skill
Install any skill in seconds. Free to start, no credit card required.
Get Started Free →datadrivenconstruction/sql-query-builder
Build SQL queries for construction databases. Generate optimized SQL queries for construction data retrieval
Passed 24 of 25 test cases with the skill, and 5 of 25 without it.
and 24 more in the full report
19 fixed5 passed either way1 still failing0 broke
Tokens, turns and time describe resource use, not a dollar price.
One of 19 test cases the skill fixed. Same model, same prompt, with and without the skill.
Write Python snippet using `OrderBy` dataclass to order a query by `budgeted_cost` in descending order on table alias `ci`.
| Checked | Without skill | With skill |
|---|---|---|
| Instantiates OrderBy with descending set to True. | Missed | Passed |
| Sets table alias parameter to ci. | Passed | Passed |
The instructions your model reads when the skill loads.
Based on DDC methodology (Chapter 2.1), this skill builds SQL queries for construction databases, supporting common construction data patterns like cost tracking, schedule management, and resource allocation.
Book Reference: "Типы данных в строительстве" / "Data Types in Construction"
from dataclasses import dataclass, field
from enum import Enum
from typing import List, Dict, Optional, Any, Union
from datetime import datetime, date
class QueryType(Enum):
"""Types of SQL queries"""
SELECT = "select"
INSERT = "insert"
UPDATE = "update"
DELETE = "delete"
AGGREGATE = "aggregate"
JOIN = "join"
class AggregateFunction(Enum):
"""SQL aggregate functions"""
SUM = "SUM"
AVG = "AVG"
COUNT = "COUNT"
MIN = "MIN"
MAX = "MAX"
GROUP_CONCAT = "GROUP_CONCAT"
class JoinType(Enum):
"""SQL join types"""
INNER = "INNER JOIN"
LEFT = "LEFT JOIN"
RIGHT = "RIGHT JOIN"
FULL = "FULL OUTER JOIN"
test cases passed, vs 5 / 25 without
More skills from the same source and nearby in the registry, with their headline benchmark lift.