OriginChain docs
dashboard · queries

Queries in the dashboard.

Five query shapes from one tabbed panel: SQL, Vector, Full-text, Graph, and Ask. You'll need a running instance and the engine bearer token.

  1. 1. Open /app/query.
  2. 2. Pick the instance, paste the bearer.
  3. 3. Click the tab for the shape you want.
  4. 4. Fill the request fields, click Run →. Results render in the panel below the editor.

SQL tab

Standard SQL editor. The EXPLAIN checkbox routes the same query through the operation-backend proxy at /v1/instances/:id/query?explain=true and returns the chosen plan tree, the access path per table, and the row-count estimate at each node.

OriginChain Query Schema Backups Query playground ASK SQL VECTOR FULL-TEXT GRAPH SQL SELECT id, email, region FROM shop.customers WHERE region = 'us-east-1' LIMIT 50; EXPLAIN RUN → RESULT · 12 ROWS · 4.2 ms c_001 alice@acme.io us-east-1 A B
sql tab · A: explain toggle · B: run 
SELECT id, email, region
  FROM shop.customers
 WHERE region = 'us-east-1'
 LIMIT 50;

Vector tab

HNSW topk with optional metadata equality filter. Pick the table, the metric (cosine / dot / l2 / manhattan), and a mode. high_recall is the default; fast trades a small amount of recall for ~3× lower latency.

OriginChain Query Query playground ASK SQL VECTOR FULL-TEXT GRAPH TABLE shop.products METRIC cosine K 10 DIM 384 MODE FAST HIGH_RECALL recall@10 ≈ 0.96 at 100k · p99 ≈ 109 ms QUERY EMBEDDING 0.012, -0.481, 0.337, 0.108, -0.052, … RUN topK → M
vector tab · M: high_recall mode (default)

Full-text tab

BM25 / boolean / phrase modes over a per-tenant inverted index. Lucene defaults (k1=1.2, b=0.75). Pick the table, the field, and the mode; type the query.

OriginChain Query Query playground FULL-TEXT TABLE shop.products FIELD description MODE bm25 QUERY "distributed systems" lucene SEARCH → 7 HITS · 12 ms 2.84 p_044 Distributed systems primer …
full-text tab · bm25 mode

Graph tab

Pick a schema, an op (neighbors, reverse, bfs, path, dijkstra), and supply the source ids. Direction tags on the schema's relations decide whether reverse traversal is allowed.

OriginChain Query Query playground GRAPH SCHEMA shop.orders OP bfs DEPTH 3 FROM (id) o_017 RUN → REACHED 14 NODES · 5.1 ms o_017 → c_002 → o_039 → c_011 …
graph tab · bfs op

Ask tab

Type an English sentence. The first call compiles a Plan tree against your registered schemas; every repeat hits the cached plan and runs immediately.

OriginChain Query Query playground ASK QUESTION Show me every customer in us-east-1 created last week first touch compiles · every repeat is on the cached fast path RUN → RESULT · 2 ROWS · 1.7 ms (cache hit) c_018 bob@acme.io us-east-1 c_021 carol@acme.io us-east-1
ask tab · natural-language question 
Show me every customer in us-east-1 created last week

Common errors

  • addon required - vector / FTS / graph need their respective add-ons. The result panel surfaces a banner with a one-click Enable add-on link to /app/billing/addons.
  • 401 unauthorized - bearer paste is wrong; rotate from /app/keys.
  • 429 too many requests - your per-key rate limit hit; the response includes a Retry-After header.
  • instance not running - resume the instance from /app/instances.
  • no plan compiled on Ask - the rule grammar couldn't resolve the question. Either rephrase, or scope the catalog with the schemas request field (the SDK takes schemas=["..."]).