Skip to content
OpenSmartRoute
Toolv1.0.0

Read-only SQL runner

Runs a single SELECT against your warehouse and returns rows; writes are refused.

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

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

See reviews

About

A guarded database tool: it executes exactly one read-only statement and returns the rows. INSERT, UPDATE, DELETE, DROP and ALTER are rejected before they reach the database. Pair it with the Safe SQL analyst prompt or the Data analyst agent.

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/read-only-sql-tool/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.

read-only-sql-tool.ocm.jsonjson
{
  "ocm": "1",
  "id": "tool:read-only-sql",
  "kind": "tool",
  "name": "Read-only SQL runner",
  "description": "Executes one read-only SQL query against a connected database and returns the result rows.",
  "publisher": "OpenSmartRoute",
  "version": "1.0.0",
  "capabilities": {
    "domains": [
      "data_analysis",
      "coding"
    ],
    "actions": [
      "retrieve",
      "compute"
    ],
    "tags": [
      "sql",
      "read-only",
      "safety"
    ]
  },
  "cost": {
    "usd_per_call": 0
  },
  "latency_ms": 120,
  "quality_prior": 0.9,
  "examples": [
    "Top 10 customers by revenue this year",
    "Count orders per status"
  ]
}

Fetch it by URL: GET /api/v1/registry/read-only-sql-tool/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.