Skip to content
OpenSmartRoute
All models
skill

SQL skill

skill-sql

Generates and validates SQL against the warehouse schema.

Decision and plan target (no provider attached) PII allowed
Price per 1M tokens
$1.00
$0.0010 per 1k
Requests · 30d
1
new
Latency
95.6 ms
measured · declared 700 ms
Success rate
100.0%
quality prior 0.80

Traffic over 30 days

Requests per day this target answered on this deployment, with the cost line.

  • requests (peak 1)
  • failed
Tokens
0
Spend
$0
Previous window
0 req

Routed for

Domains the signal layer detected on requests that ended here.

  • Coding1 · 100%

Capabilities

DomainsData Analysis, Coding
ActionsCode Generation, Extract, Qa
Complexity band0.00 - 1.00
Languagesen
Context windowundeclared
Streamingyes

Policy constraints

Hard stops enforced before scoring.

Data boundaryPublic
Regionsanywhere
PIIallowed
Max input tokensunlimited
Tenantsall

Representative prompts

Examples the similarity strategy matches against.

  • Write a SQL query for monthly active users by region.
  • Aggregate revenue per product for Q3 from the orders table.

Route to it

This skill is not executed by the platform. Ask the router for a decision restricted to kinds=["skill"] and dispatch the winner in your own stack; send feedback afterwards so the learners improve.

curlbash
curl https://api.opensmartroute.ai/api/v1/route \
  -H "Authorization: Bearer $OSR_API_KEY" \
  -H "Content-Type: application/json" \
  -d '{"text": "Write a SQL query for monthly active users by region.", "kinds": ["skill"], "top_k": 3}'

# Returns the chosen target, confidence, the ranked alternatives and the
# per-strategy trace. Execution of skill targets happens in your stack.
httpxpython
import httpx

r = httpx.post(
    "https://api.opensmartroute.ai/api/v1/route",
    headers={"Authorization": "Bearer osr_live_..."},
    json={"text": "Write a SQL query for monthly active users by region.", "kinds": ["skill"]},
)
d = r.json()
print(d["target"]["id"], d["confidence"])
print([t["id"] for t in d["ranked"]])  # e.g. skill-sql first when it fits