Skip to content
OpenSmartRoute
Skillv1.0.0

SQL skill

Generates and validates SQL against the warehouse schema.

by OpenSmartRoute(0) 0 installs
Free
Sign in to install

Free account. Installing gives you the manifest plus copy-paste snippets.

See reviews

About

Part of the example catalogue (examples/targets.yaml).

Generates and validates SQL against the warehouse schema.

Use it

Copy one of these into your project. Installing also returns the manifest and these snippets.

yaml
targets:
  - https://api.opensmartroute.ai/api/v1/registry/skill-sql/manifest   # or paste the manifest below

Manifest

An Open Capability Manifest: the router reads it to know what this does, what it costs and when to pick it.

skill-sql.ocm.jsonjson
{
  "ocm": "1",
  "id": "skill-sql",
  "kind": "skill",
  "name": "SQL skill",
  "description": "Generates and validates SQL against the warehouse schema.",
  "capabilities": {
    "domains": [
      "data_analysis",
      "coding"
    ],
    "actions": [
      "code_generation",
      "extract",
      "qa"
    ],
    "languages": [
      "en"
    ],
    "modalities": [
      "text"
    ],
    "max_complexity": 1,
    "min_complexity": 0,
    "supports_tools": false,
    "supports_streaming": true
  },
  "constraints": {
    "data_boundary": "public",
    "pii_allowed": true
  },
  "cost": {
    "usd_per_1k_tokens": 0.001
  },
  "latency_ms": 700,
  "quality_prior": 0.8,
  "examples": [
    "Write a SQL query for monthly active users by region.",
    "Aggregate revenue per product for Q3 from the orders table."
  ],
  "instructions": "Write ANSI SQL for the analytics warehouse. Always qualify table names with\nthe schema, never SELECT *, and add a one-line comment above each CTE.\n",
  "publisher": "OpenSmartRoute",
  "version": "1.0.0"
}

Fetch it by URL: GET /api/v1/registry/skill-sql/manifest?version=1.0.0

Reviews

Star ratings from people who tried it. One review per account; edit yours any time.

No reviews yet. Install it, try it, and be the first to rate it.