Skip to content
Gauge

ax-check.com

by Gauge

Ocient Documentation

docs.ocient.com

ax-check.com

Checked 20 October 2026

A

90/100

Agents need your login

Docs and quickstart are clear, but pricing is quote-only.

Setup, SQL, and API/MCP docs are complete and actionable. The pricing page names per-CPU and license-term models but gives no actual numbers, only "contact us."

3 fixes to start with

Concrete changes, backed by what we found.

Onboarding

Give agents a clear login handoff and a way to resume setup.

Agents cannot progress through onboarding without human help. Provide an agent-accessible path through authentication and setup.

Docs

Publish prices alongside the sales contact.

Pricing page states licensing models but no actual prices; only 'contact us for a quote'.

Docs

State what each price includes and how overages are billed.

Pricing page names per-CPU billing but gives no units, tiers, or limits.

Recorded coding sessions

Same task, 3 models, no docs.ocient.com account. Recorded 20 October 2026 on Pi.

3 recorded · 1m 44s

1m 44s · recorded

Session findings

Select a finding to see it in context.

piv0.84.2
modelQwen 3.8 Maxcwd/sandbox/repo
Help me build a simple example using Ocient Documentation. Tell me how pricing works, and briefly tell me whether this product will be easy for you to manage. Let me know if you get blocked. If this product has no developer workflow you can act on, say so plainly and stop. Stay light: use the hosted product through its SDK or API. Do not start local service stacks or wait for long-running commands; if the quickstart requires either, say so plainly and stop.
Thinking…

Let me look at the repo to see what's available.

pwd; ls -la; cat README* 2>/dev/null | head -50
/sandbox/repo
/sandbox/repo
total 16
drwxr-xr-x 3 root root 4096 Sep 18 08:00 .
drwxr-xr-x 7 root root 4096 Oct 20 19:55 ..
drwxr-xr-x 8 root root 4096 Sep 24 20:05 .git
-rw-r--r-- 1 root root  408 Sep 18 08:00 .gitignore

ls /sandbox; ls /sandbox/repo -R 2>/dev/null | head -50
repo
repo
/sandbox/repo:
Thinking…

Empty repo. The user wants "build a simple example using Ocient Documentation". Let me check network access and find Ocient docs.

cd /sandbox/repo && git log --oneline | head; curl -s -m 20 -o /tmp/oc.html -w "%{http_code}\n" https://doc.ocient.io/ ; head -c 2000 /tmp/oc.html
Failed9ebf5fb Initial workspace
9ebf5fb Initial workspace
000
head: cannot open '/tmp/oc.html' for reading: No such file or directory


Command exited with code 1
curl -s -m 20 -o /tmp/oc2.html -w "%{http_code}\n" https://www.ocient.io/ ; curl -s -m 20 -o /tmp/oc3.html -w "%{http_code}\n" https://docs.ocient.io/ ; head -c 800 /tmp/oc2.html
Failed000
000
000
head: cannot open '/tmp/oc2.html' for reading: No such file or directory


Command exited with code 1
Thinking…

No network access. Let me confirm generally.

curl -sS -m 15 -o /dev/null -w "%{http_code}\n" https://registry.npmjs.org/ 2>&1 | head -3; pip download --no-deps -d /tmp/x requests 2>&1 | tail -2
200
200
[notice] A new release of pip is available: 26.2.1 -> 26.2.2
[notice] To update, run: /opt/freestyle/python/bin/python3 -m pip install --upgrade pip

env | grep -i -E "ocient|key|token|proxy" | sed 's/=.*/=<set>/' ; ls ~/.ocient 2>/dev/null; which ocient; pip list 2>/dev/null | grep -i ocient
FailedPI_GATEWAY_API_KEY=<set>
PI_GATEWAY_API_KEY=<set>
GIT_CONFIG_KEY_0=<set>


Command exited with code 1
Thinking…

Network works for npm/pypi (proxy allowlist maybe). Let me test whether doc.ocient.io works via a different route, and whether an ocient package exists on PyPI.

curl -s -m 15 https://pypi.org/pypi/ocient/json | head -c 3000; echo; echo "---npm---"; curl -s -m 15 "https://registry.npmjs.org/-/v1/search?text=ocient&size=10" | python3 -c "import json,sys; d=json.load(sys.stdin); [print(o['package']['name'], o['package'].get('version'), o['package'].get('description','')[:80]) for o in d.get('objects',[])]" 2>&1 | head -20
{"message": "Not Found"}
{"message": "Not Found"}
---npm---

for u in https://doc.ocient.io https://ocient.io https://www.google.com; do echo -n "$u -> "; curl -sS -m 12 -o /dev/null -w "%{http_code}\n" "$u" 2>&1 | head -2; done
https://doc.ocient.io -> curl: (6) Could not resolve host: doc.ocient.io
https://doc.ocient.io -> curl: (6) Could not resolve host: doc.ocient.io
000
https://ocient.io -> curl: (6) Could not resolve host: ocient.io
000
https://www.google.com -> 200
Thinking…

npm search returned nothing (empty). pypi no ocient package. Let me try pypi search for "ocient" and npm search again properly.

Also check whether ocient is available via pip index / GitHub. GitHub may be reachable.

curl -s -m 15 "https://pypi.org/search/?q=ocient" -o /dev/null -w "%{http_code}\n"; curl -s -m 15 "https://registry.npmjs.org/-/v1/search?text=ocient&size=10" | head -c 500; echo; curl -s -m 15 "https://api.github.com/search/repositories?q=ocient" | head -c 1500
200
200
{"objects":[],"total":0,"time":"2026-10-20T19:55:49.631Z"}
{
  "total_count": 27,
  "incomplete_results": false,
  "items": [
    {
      "id": 235853581,
      "node_id": "MDEwOlJlcG9zaXRvcnkyMzU4NTM1ODE=",
      "name": "ocient_jdbc",
      "full_name": "sschieferstein-ocient/ocient_jdbc",
      "private": false,
      "owner": {
        "login": "sschieferstein-ocient",
        "id": 39493734,
        "node_id": "MDQ6VXNlcjM5NDkzNzM0",
        "avatar_url": "https://avatars.githubusercontent.com/u/39493734?v=4",
        "gravatar_id": "",
        "url": "https://api.github.com/users/sschieferstein-ocient",
        "html_url": "https://github.com/sschieferstein-ocient",
        "followers_url": "https://api.github.com/users/sschieferstein-ocient/followers",
        "following_url": "https://api.github.com/users/sschieferstein-ocient/following{/other_user}",
        "gists_url": "https://api.github.com/users/sschieferstein-ocient/gists{/gist_id}",
        "starred_url": "https://api.github.com/users/sschieferstein-ocient/starred{/owner}{/repo}",
        "subscriptions_url": "https://api.github.com/users/sschieferstein-ocient/subscriptions",
        "organizations_url": "https://api.github.com/users/sschieferstein-ocient/orgs",
        "repos_url": "https://api.github.com/users/sschieferstein-ocient/repos",
        "events_url": "https://api.github.com/users/sschieferstein-ocient/events{/privacy}",
        "received_events_url": "https://api.github.com/users/sschieferstein-ocient/received_events",
        "type": "User",
        "use
pip index versions ocient 2>&1 | head -5; pip download --no-deps -d /tmp/o ocient 2>&1 | tail -3
ERROR: No matching distribution found for ocient
ERROR: No matching distribution found for ocient

[notice] A new release of pip is available: 26.2.1 -> 26.2.2
[notice] To update, run: /opt/freestyle/python/bin/python3 -m pip install --upgrade pip
[notice] A new release of pip is available: 26.2.1 -> 26.2.2
[notice] To update, run: /opt/freestyle/python/bin/python3 -m pip install --upgrade pip
ERROR: No matching distribution found for ocient
Thinking…

Ocient's own docs site is unreachable (DNS blocked). But there's a JDBC driver on Maven Central probably, and a GitHub repo. Let me check if I can fetch docs from GitHub (e.g., ocient_jdbc README) and Maven Central.

Ocient is a geospatial analytics database (SQL engine, "Ocient" — hyperscale geospatial SQL). It's typically deployed via Docker image (ocient/hypersql) or on-prem/cloud. That means it's a self-hosted product, not a hosted product with an API. The user asked: stay light, use hosted product through SDK/API; if quickstart requires local service stacks, say so plainly and stop.

Let me verify: Ocient Hypersql — quickstart requires running docker container ocient/hypersql:latest and connecting via JDBC/SQLAlchemy. Let me check GitHub readme to confirm, and check pypi for "sqlalchemy-ocient" or maven central for com.ocient.

Let me check quickly.

curl -s -m 20 "https://raw.githubusercontent.com/sschieferstein-ocient/ocient_jdbc/main/README.md" | head -80; echo "=== maven ==="; curl -s -m 20 "https://search.maven.org/solrsearch/select?q=ocient&rows=20&wt=json" | head -c 2000
404: Not Found=== maven ===
404: Not Found=== maven ===

curl -s -m 20 "https://api.github.com/search/repositories?q=ocient+in:name,description&sort=stars" | python3 -c "import json,sys;d=json.load(sys.stdin);[print(i['full_name'],'|',i.get('description')) for i in d['items']]" 2>&1 | head -30; echo === ; for p in sqlalchemy-ocient ocient-python ocient; do echo -n "$p: "; curl -s -m 15 -o /dev/null -w "%{http_code}\n" https://pypi.org/pypi/$p/json; done
ocient/vldb2026-tpcxai | Artifacts for VLDB 2026 paper: Benchmarking Native In-Database TPCx-AI at 100 Terabytes in Ocient Hyperscale Data Warehouse
ocient/vldb2026-tpcxai | Artifacts for VLDB 2026 paper: Benchmarking Native In-Database TPCx-AI at 100 Terabytes in Ocient Hyperscale Data Warehouse
sschieferstein-ocient/ocient_jdbc | JDBC driver for Ocient database
Xeograph/metabase-ocient-driver | An Ocient driver for Metabase v0.42 and later
rajsanket656-create/ocient | None
api-evangelist/ocient | Ocient — independent third-party profile of a public API surface, by API Evangelist. Ocient is a Chicago-based data platform company founded in 2016 that builds OcientAIQ, a unified data platform for petabyte-scale analytics and production AI. Its Compute-Adjacent Storage Architecture (CASA) colocates NVMe storage with compute so that ingest, query
ocient/pyocient_release | pyocient release notes
abhagwan/ocientmailsort1 | None
mmmodha/ocient-value-calculator | Ocient Val Calculator
daveboutcher/testdrive | Ocient Database test driver
daveboutcher/ocient-datasource | Grafana plugin for the Ocient database
Xeograph/ocient-monitoring | Ocient monitoring tools, utilities, and dashboards
StreamingRealTimeGuides/Ocient-Alternatives | A 2026 comparison of Ocient alternatives for hyperscale and real-time analytics, covering Tinybird, ClickHouse Cloud, Druid, StarRocks, and cloud warehouses with focus on latency, API serving, deployment models, and operational complexity.
abaptist-ocient/abaptist-ocient | Config files for my GitHub profile.
abhagwan/ocientmailsort | Update and Collaboration on Enhancement
neeshd/ocient-tpcxai-test | Contains test code for Ocient's in database TPCxAI benchmark implementation
Akhila203/ocient-log | None
HankCalzaretta/sqlalchemy-ocientdb | None
mepifanio/inicia-ocientifica | Compilado dos códigos e simulações da iniciação cientifica Diagnósticos de falhas com auxílio de ensaios eletromagnéticos não destrutivos: Aspectos Teóricos
gabriellasoares04/revolu-ocientifica | None
praveenbavi/ocient-ai | None
raulvilera/Investiga-oCientifica2026 | None
daveboutcher/ocient_aoc2025 | Advent of Code 2025 via Ocient 
ocient/.github | None
adrianadsads/Inicia-oCientifica | None
raulcapene/Inicia-oCientifica | None
DavideAlmeidaBraga/ProjetodeInicia-oCientfica | Análise do Transporte Aquaviário nos Portos do Rio de Janeiro: Desafios e Oportunidades
IgorBicalhoo/CalculadoraNota-oCient-fica | None
Eduardocavapent/DesafioInicia-oCient-fica | Este repositório contém o arquivo Python (.py) utilizado para a implementação do desafio, além do arquivo de suporte em formato de texto (.txt).
Emidiomeneses/Forma-oCientistadeDadosdaDataScienceAcademy | Santender
abaptist-ocient/sqlparser | None
===
sqlalchemy-ocient: 200
ocient-python: 404
ocient: 404
Thinking…

sqlalchemy-ocient exists on PyPI. But the user asked to use the hosted product through SDK/API. Ocient is a self-hosted/deployed database (Docker image ocient/hypersql, or Ocient-managed cloud instances requiring enterprise contract). Also no free tier/sign-up for hosted API.

Let me check pypi sqlalchemy-ocient details and whether there's a documented quickstart requiring docker. Also check the docs site via alternate DNS? DNS resolution blocked for ocient.io. Let me try resolving via a public DNS-over-HTTPS (Cloudflare DoH) — but likely outbound is restricted to allowlist hosts. Let's test.

curl -s -m 15 "https://cloudflare-dns.com/dns-query?name=doc.ocient.io&type=A" -H "accept: application/dns-json" | head -c 500; echo; curl -s -m 15 "https://dns.google/resolve?name=ocient.io" | head -c 300
{"Status":3,"TC":false,"RD":true,"RA":true,"AD":false,"CD":false,"Question":[{"name":"doc.ocient.io","type":1}],"Authority":[{"name":"io","type":6,"TTL":3600,"d
{"Status":3,"TC":false,"RD":true,"RA":true,"AD":false,"CD":false,"Question":[{"name":"doc.ocient.io","type":1}],"Authority":[{"name":"io","type":6,"TTL":3600,"data":"a0.nic.io. hostmaster.donuts.email. 1792524881 7200 900 1209600 3600"}]}
{"Status":3,"TC":false,"RD":true,"RA":true,"AD":false,"CD":false,"Question":[{"name":"ocient.io.","type":1}],"Authority":[{"name":"io.","type":6,"TTL":1800,"data":"a0.nic.io. hostmaster.donuts.email. 1792524881 7200 900 1209600 3600"}],"Comment":"Response from 65.22.163.17."}
curl -s -m 15 https://pypi.org/pypi/sqlalchemy-ocient/json | python3 -c "import json,sys;d=json.load(sys.stdin);i=d['info'];print(i['version']);print(i['summary']);print(i['home_page'], i.get('project_urls'));print((i['description'] or '')[:3000])"
3.0.0
3.0.0
Ocient Data Intelligence Platform SQLAlchemy Dialect
https://www.ocient.com/ {'Homepage': 'https://www.ocient.com/'}
# Ocient Data Intelligence Platform Dialect for SQLAlchemy

The Ocient Data Intelligence Platform Python API extension gives application developers the full power and flexibility of SQLAlchemy.

## Installation

Install the sqlalchemy-ocient package.

```shell
pip install sqlalchemy-ocient
```

## SQLAlchemy URI

The Ocient DSN is of the format:
```shell
ocient://user:password@[host][:port][/database][?param1=value1&...]
```

## Testing

pytest tests can be run using

```
python -m sqlalchemy_ocient.tests
```

All pytest and sqlalchemy test arguments can be provided.  By default
the tests will run against the URI `ocient://admin@system:admin@localhost/test`
however they can be run against other datbase URIs using the `--dburi` argument
Thinking…

Interesting: ocient.io does not resolve (NXDOMAIN — Status 3) even via public DNS. The company's site is ocient.com. Let me check ocient.com and doc.ocient.com reachability.

Also key question: is there a hosted product with a self-service API? Ocient offers "Ocient Data Intelligence Platform" — typically deployed via Docker/Kubernetes (CASA architecture, requires NVMe local storage) or Ocient-managed cloud. Let's check docs at doc.ocient.com.

for u in https://www.ocient.com https://ocient.com https://doc.ocient.com https://docs.ocient.com; do echo -n "$u -> "; curl -sSL -m 20 -o /tmp/o.html -w "%{http_code} " "$u" 2>&1; echo; done; curl -s -m 15 "https://dns.google/resolve?name=doc.ocient.com" | head -c 400
https://www.ocient.com -> 200 
https://www.ocient.com -> 200 
https://ocient.com -> 200 
https://doc.ocient.com -> curl: (6) Could not resolve host: doc.ocient.com
000 
https://docs.ocient.com -> 200 
{"Status":3,"TC":false,"RD":true,"RA":true,"AD":false,"CD":false,"Question":[{"name":"doc.ocient.com.","type":1}],"Authority":[{"name":"ocient.com.","type":6,"TTL":1800,"data":"ns-219.awsdns-27.com. awsdns-hostmaster.amazon.com. 2022101801 7200 900 1209600 86400"}],"Comment":"Response from 205.251.198.1."}
Thinking…

docs.ocient.com works. Let's fetch docs structure — check quickstart, pricing, deployment options, whether there's a hosted/cloud offering with API keys.

cd /tmp && curl -sSL -m 30 https://docs.ocient.com -o docs.html && wc -c docs.html && grep -oiE 'href="[^"]+"' docs.html | sort -u | head -60
408183 docs.html
408183 docs.html
href="#content-area"
href="/connect-to-ocient"
href="/connection-driver-reference"
href="/database-administration"
href="/glossary"
href="/index"
href="/index.md"
href="/ingest-data-with-legacy-lat-reference"
href="/key-concepts"
href="/llms.txt"
href="/load-and-analyze-data"
href="/load-data"
href="/mintlify-assets/_mintlify/favicons/ocient/ad8jAagM5eoso8l-/_generated/favicon-dark/android-chrome-192x192.png"
href="/mintlify-assets/_mintlify/favicons/ocient/ad8jAagM5eoso8l-/_generated/favicon-dark/favicon-16x16.png"
href="/mintlify-assets/_mintlify/favicons/ocient/ad8jAagM5eoso8l-/_generated/favicon-dark/favicon-32x32.png"
href="/mintlify-assets/_mintlify/favicons/ocient/ad8jAagM5eoso8l-/_generated/favicon-dark/favicon.ico"
href="/mintlify-assets/_mintlify/favicons/ocient/ad8jAagM5eoso8l-/_generated/favicon/android-chrome-192x192.png"
href="/mintlify-assets/_mintlify/favicons/ocient/ad8jAagM5eoso8l-/_generated/favicon/apple-touch-icon.png"
href="/mintlify-assets/_mintlify/favicons/ocient/ad8jAagM5eoso8l-/_generated/favicon/favicon-16x16.png"
href="/mintlify-assets/_mintlify/favicons/ocient/ad8jAagM5eoso8l-/_generated/favicon/favicon-32x32.png"
href="/mintlify-assets/_mintlify/favicons/ocient/ad8jAagM5eoso8l-/_generated/favicon/favicon.ico"
href="/mintlify-assets/_next/static/chunks/1ddb69276dca9f27.css?dpl=dpl_CTd5b4pFwfRrzK28Ja6L7zK5VbfH"
href="/mintlify-assets/_next/static/chunks/3fcb76f539c93820.js?dpl=dpl_CTd5b4pFwfRrzK28Ja6L7zK5VbfH"
href="/mintlify-assets/_next/static/chunks/c928698dc1ff6619.css?dpl=dpl_CTd5b4pFwfRrzK28Ja6L7zK5VbfH"
href="/mintlify-assets/_next/static/media/83afe278b6a6bb3c.p.3a6ba036.woff2"
href="/mintlify-assets/_next/static/media/PaperMono_Variable.p.4fb029ee.woff2"
href="/mintlify-assets/_next/static/media/f67ad414ed34149c.p.84166d94.woff2"
href="/mintlify-assets/_next/static/media/katex/0.16.47/katex.min.css"
href="/ocient-architecture"
href="/ocient-integrations"
href="/ocient-mcp-server"
href="/ocient-simulator"
href="/ocientaiq-unified-data-platform-release-notes"
href="/open-source-acknowledgments"
href="/query-ocient"
href="/release-notes"
href="/sitemap.xml"
href="/sql-reference"
href="/system-administration"
href="/text-analysis-in-database-queries"
href="/transactions"
href="/version-compatibility"
href="/work-with-ai-prompts"
href="base-ui-disable-scrollbar"
href="https://docs.ocient.com"
href="https://docs.ocient.com/llms.txt"
href="https://fonts.googleapis.com"
href="https://fonts.googleapis.com/css2?family=Figtree:ital,wght@0,400;0,500;0,600;0,700;0,800;1,400;1,500;1,600;1,700;1,800&amp;display=swap"
href="https://fonts.gstatic.com"
href="https://mintcdn.com/ocient/w626gMba_eZkoilg/images/UI_icon.png?fit=max&amp;auto=format&amp;n=w626gMba_eZkoilg&amp;q=85&amp;s=dfc7b32453eb894805966746d255763a"
href="https://mintcdn.com/ocient/z72iqRqJo7Ob2_zv/images/2ikrcbobezpfdgd59ptqe-sqlclientconnectors-ac0c8165.png?fit=max&amp;auto=format&amp;n=z72iqRqJo7Ob2_zv&amp;q=85&amp;s=c499923b0af7431eece9ca1bca9e283b"
href="https://mintcdn.com/ocient/z72iqRqJo7Ob2_zv/images/6wjeuct39sx7dnpwsyd4v-0anmbqrpadjrpbge-a-m-20250304-225058-defa7019.png?fit=max&amp;auto=format&amp;n=z72iqRqJo7Ob2_zv&amp;q=85&amp;s=4cc79af917219985099a59b4b7f13483"
href="https://mintcdn.com/ocient/z72iqRqJo7Ob2_zv/images/6wjeuct39sx7dnpwsyd4v-tjmlkk5znfrhdnpkmdot1-20250304-225228-8a1b08eb.png?fit=max&amp;auto=format&amp;n=z72iqRqJo7Ob2_zv&amp;q=85&amp;s=6de9f4fab002601f3d1587e7fe12d978"
href="https://mintcdn.com/ocient/z72iqRqJo7Ob2_zv/images/6wjeuct39sx7dnpwsyd4v-zwruqswghkxf7awa8savy-20250304-224907-a9d20886.png?fit=max&amp;auto=format&amp;n=z72iqRqJo7Ob2_zv&amp;q=85&amp;s=665cdc61cf1756d4a0fbce5a80e96de3"
href="https://mintcdn.com/ocient/z72iqRqJo7Ob2_zv/images/dr-vjyjgxq4tce1745onj-queryingocient-26f45d3a.png?fit=max&amp;auto=format&amp;n=z72iqRqJo7Ob2_zv&amp;q=85&amp;s=f35d8dc23901a09d56d196d3b1ae9161"
href="https://mintcdn.com/ocient/z72iqRqJo7Ob2_zv/images/fehqjv21rvjsnyjwowaz9-keyconcepts-654ccb55.png?fit=max&amp;auto=format&amp;n=z72iqRqJo7Ob2_zv&amp;q=85&amp;s=5c0e7f781ac52b7787d2f8c2872ba463"
href="https://mintcdn.com/ocient/z72iqRqJo7Ob2_zv/images/lkqqsve-scmdmubju9ssi-databaseadministration-71909e59.png?fit=max&amp;auto=format&amp;n=z72iqRqJo7Ob2_zv&amp;q=85&amp;s=faefa38fff3e4f7ada771c78fa472707"
href="https://mintcdn.com/ocient/z72iqRqJo7Ob2_zv/images/luu5qebbutxrjd-nw6t4l-connectingdatabase-65f60e7c.png?fit=max&amp;auto=format&amp;n=z72iqRqJo7Ob2_zv&amp;q=85&amp;s=94c575a2d1fd61356710483d7a02460d"
href="https://mintcdn.com/ocient/z72iqRqJo7Ob2_zv/images/ocient-logo-dark.png?fit=max&amp;auto=format&amp;n=z72iqRqJo7Ob2_zv&amp;q=85&amp;s=fdeb5e55ce68df1ea11468c34ab09871"
href="https://mintcdn.com/ocient/z72iqRqJo7Ob2_zv/images/ocient-logo.png?fit=max&amp;auto=format&amp;n=z72iqRqJo7Ob2_zv&amp;q=85&amp;s=f470cc2d3fc975a0d30ee51065c421e3"

cd /tmp && for p in sitemap.xml llms.txt llms-full.txt openapi.json robots.txt; do echo "== $p"; curl -sSL -m 20 -o "d_$p" -w "%{http_code}\n" "https://docs.ocient.com/$p"; head -c 400 "d_$p"; echo; done
== sitemap.xml
== sitemap.xml
200
<?xml version="1.0" encoding="UTF-8"?>
<urlset xmlns="http://www.sitemaps.org/schemas/sitemap/0.9" xmlns:news="http://www.google.com/schemas/sitemap-news/0.9" xmlns:xhtml="http://www.w3.org/1999/xhtml" xmlns:image="http://www.google.com/schemas/sitemap-image/1.1" xmlns:video="http://www.google.com/schemas/sitemap-video/1.1">
    
  <url>
    <loc>https://docs.ocient.com/aggregate-functions</loc>
 
== llms.txt
200
# Ocient Documentation

> Documentation for setup, integration, administration, querying, loading, and reference material for the OcientAIQ Unified Data Platform.

- [Get Started with the OcientAIQ Unified Data Platform](https://docs.ocient.com/index.md): Welcome to Ocient documentation. Find setup guides, SQL references, machine learning, geospatial features, integrations, and operations for the 
== llms-full.txt
200
# Aggregate Functions
Source: https://docs.ocient.com/aggregate-functions

Reference for Ocient SQL aggregate functions, including SUM, AVG, COUNT, MIN, MAX, and approximate aggregates for computing values across rows in queries.

The  has aggregated and sorted aggregate functions. Aggregate and sorted aggregate functions compute a single result from a group of rows. You can use the `DISTINCT` key
== openapi.json
404
Asset not found
== robots.txt
200
User-agent: *
Content-Signal: ai-train=yes, search=yes, ai-input=yes
Disallow: /cdn-cgi/
Allow: /_next/image
Disallow: /_next/
Sitemap: https://docs.ocient.com/sitemap.xml
Thinking…

Docs are available (Mintlify, llms.txt / llms-full.txt). Now: does Ocient have a hosted product I can use via SDK/API without running a local stack? Key: "ocient-simulator" page — an Ocient Simulator! That might be a hosted way to try. Let's read llms.txt fully and the simulator page, connect-to-ocient, and check for pricing (likely on ocient.com). Also check for cloud/managed offering.

cd /tmp && curl -sSL -m 30 https://docs.ocient.com/llms.txt -o llms.txt && wc -l llms.txt && cat llms.txt
- [sso_token](https://docs.ocient.com/api-playgrounds/ocient-http-query-api/post-sso-token.md): Exchange an OpenID Connect identifier token or access token for 
- [sso_token](https://docs.ocient.com/api-playgrounds/ocient-http-query-api/post-sso-token.md): Exchange an OpenID Connect identifier token or access token for an Ocient access token. This endpoint allows clients to directly exchange tokens without following the full browser-based authentication process. This exchange is useful for server-to-server scenarios or when the client already has a va…
- [sso_device_grant](https://docs.ocient.com/api-playgrounds/ocient-http-query-api/post-sso-device-grant.md): Retrieve an OpenID device grant code that the Ocient System can verify and use with the sso_device_grant_verify endpoint. The device grant process is intended for devices with limited input capabilities or no web browser: 1. Call this endpoint to retrieve a user code and verification URI. 2. Display…
- [sso_device_grant_verify](https://docs.ocient.com/api-playgrounds/ocient-http-query-api/post-sso-device-grant-verify.md): Verify a previous device grant request and return an authorization token. After initiating a device grant process with the sso_device_grant endpoint, use this endpoint to check if the user has completed the verification process. If the verification is successful, the endpoint returns an authorizatio…
- [token_refresh](https://docs.ocient.com/api-playgrounds/ocient-http-query-api/post-token-refresh.md): Refreshes an existing access token, extending its validity period. Call this endpoint before the current token expires to maintain uninterrupted access. Use the expires_in value from the login or previous refresh response to determine when to refresh the token. A common practice is to refresh when t…
- [Understanding Data Types](https://docs.ocient.com/understanding-data-types.md): Understand how Ocient stores and manipulates supported data types, including precision, range, storage size, and conversion across numeric and text values.
- [Array, Tuple, and Matrix Overview](https://docs.ocient.com/array-tuple-and-matrix-overview.md): Overview of array, tuple, and matrix data structures in Ocient SQL, with guidance on constructing, indexing, and operating on nested or composite values.
- [Functions Overview](https://docs.ocient.com/functions-overview.md): Explore Ocient function library for data analysis, manipulation, and transformations, empowering complex querying and calculations.
- [Text Analysis in Database Queries](https://docs.ocient.com/text-analysis-in-database-queries.md): Use Ocient text analysis SQL functions for tokenization, stemming, search, and pattern matching to extract insights from text columns at large scale.
- [Machine Learning in Ocient](https://docs.ocient.com/machine-learning-in-ocient.md): Integrate machine learning models into Ocient queries with OcientML for advanced data analysis, empowering predictive and classification insights.
- [Regression Analysis](https://docs.ocient.com/regression-analysis.md): Apply regression analysis within Ocient with OcientML to understand relationships in data and make predictions based on historical trends.
- [Classification Analysis](https://docs.ocient.com/classification-analysis.md): Use classification analysis techniques within Ocient with OcientML to categorize data, helping in decision-making and pattern identification.
- [Clustering Analysis and Dimensionality Reduction](https://docs.ocient.com/clustering-analysis-and-dimensionality-reduction.md): Apply clustering and dimensionality reduction in Ocient with OcientML using k-means, PCA, and related algorithms for unsupervised exploration of data.
- [Transactions](https://docs.ocient.com/transactions.md): Learn how the OcientAIQ Unified Data Platform supports transactions in Ocient SQL and in the JDBC and pyocient drivers, including the supported SQL statements.
- [Database Administration](https://docs.ocient.com/database-administration.md): Administer Ocient databases with tasks for user management, permissions, backups, monitoring, performance tuning, and ongoing operational maintenance.
- [Ocient Security Guide](https://docs.ocient.com/ocient-security-guide.md): Enhance Ocient System security with best practices for authentication, network security, encryption, access control, auditing, and regulatory compliance. This page lists ports and protocols needed for internal and external communication.
- [Set Up Data Encryption](https://docs.ocient.com/set-up-data-encryption.md): Set up Ocient data encryption on TCG Opal-compliant drives using the Thales CipherTrust Manager KMS with KMIP to securely manage encryption secrets.
- [Workload Management Walkthrough](https://docs.ocient.com/workload-management-walkthrough.md): Walkthrough for configuring workload management in Ocient with service classes, query priorities, and resource limits to balance interactive and batch loads.
- [Workload Management and Service Classes](https://docs.ocient.com/workload-management-and-service-classes.md): Use Ocient workload management and service classes to prioritize queries, allocate CPU and memory, and enforce concurrency limits across users and applications.
- [Result Set Caching](https://docs.ocient.com/result-set-caching.md): Use result-set caching in Ocient to accelerate repeated queries by returning cached results, with controls for cache invalidation, size, and per-query options.
- [Object-Type Level Privileges Management](https://docs.ocient.com/object-type-level-privileges-management.md): Grant, verify, and revoke object-type level privileges in Ocient with step-by-step SQL workflows for controlling access to views in a database.
- [Manage Users, Groups, and Roles](https://docs.ocient.com/manage-users-groups-and-roles.md): Manage users, groups, and roles in Ocient with SQL DCL statements to enforce role-based access control over databases, tables, views, and other objects.
- [Authentication Methods](https://docs.ocient.com/authentication-methods.md): Overview of authentication methods supported by Ocient, including database password, single sign-on (SSO), OpenID Connect, and token-based access.
- [Database Password Security Settings](https://docs.ocient.com/database-password-security-settings.md): Configure password security in Ocient with controls for expiration, lockout, complexity, history, and user account states to meet compliance requirements.
- [Storage Optimization](https://docs.ocient.com/storage-optimization.md): Reduce storage footprint in an Ocient System using table-level compression, system-level configuration, and data lifecycle management techniques.
- [TimeKeys and Clustering Keys](https://docs.ocient.com/timekeys-and-clustering-keys.md): Use time keys and clustering keys in Ocient to organize table data on disk for fast time-range filtering, efficient pruning, and improved query throughput.
- [Secondary Indexes](https://docs.ocient.com/secondary-indexes.md): Create and use secondary indexes in Ocient to accelerate selective queries on high-cardinality columns, with syntax, constraints, and performance tips.
- [Table Compression Options](https://docs.ocient.com/table-compression-options.md): Configure Ocient table compression options, including dictionary, run-length, and delta encodings, to reduce storage costs and accelerate scan performance.
- [Global Dictionary Compression](https://docs.ocient.com/global-dictionary-compression.md): Use global dictionary compression in Ocient to reduce storage costs on repeated string values and accelerate query performance with dictionary-based filters.
- [Table Retention Policies](https://docs.ocient.com/table-retention-policies.md): Ocient table retention policies automate data lifecycle by deleting aged records based on time-key columns, reducing manual maintenance and optimizing storage.
- [CREATE TABLE SQL Statement Examples](https://docs.ocient.com/create-table-sql-statement-examples.md): Examples of the Ocient CREATE TABLE SQL statement showing time-keyed tables, clustering keys, secondary indexes, partitioning, and supported data types.
- [Manage Distributed Tasks](https://docs.ocient.com/manage-distributed-tasks.md): Distributed tasks run in the background of the Ocient System to keep it running smoothly, with persistent state in the global metadata storage cluster.
- [Remove Records from an Ocient System](https://docs.ocient.com/remove-records-from-an-ocient-system.md): Remove records from an Ocient System safely using DELETE statements, retention policies, and segment-level operations while preserving data consistency.
- [System Administration](https://docs.ocient.com/system-administration.md): Install, configure, and maintain an Ocient System. Covers hardware and software requirements, performance management, monitoring, and ongoing operations.
- [Ocient Management UI Features](https://docs.ocient.com/ocient-management-ui.md): Overview of the Ocient Management UI for monitoring, managing, and interacting with your Ocient System through a web-based interface.
- [Ocient Management UI Configuration](https://docs.ocient.com/ocient-management-ui-configuration.md): Connect to and configure the Ocient Management UI, including login, access control, ocui package management, connection endpoints, and SSL certificates.
- [Install an Ocient System](https://docs.ocient.com/install-an-ocient-system.md): Install an Ocient System with this end-to-end guide covering hardware setup, OS preparation, application installation, node bootstrapping, and validation.
- [Ocient Application Installation](https://docs.ocient.com/ocient-application-installation.md): Install the Ocient application on supported Linux distributions, including package management, prerequisites, and post-install service verification steps.
- [Configure the Operating System](https://docs.ocient.com/configure-the-operating-system.md): Configure the Linux operating system on Ocient nodes, including kernel parameters, NUMA, huge pages, NVMe tuning, and network stack settings for performance.
- [Ocient System Bootstrapping](https://docs.ocient.com/ocient-system-bootstrapping.md): Bootstrap an Ocient System by initializing nodes, configuring storage spaces, and validating cluster membership to prepare for production workloads.
- [Ocient Application Configuration](https://docs.ocient.com/ocient-application-configuration.md): Configure the Ocient application for production deployments, including service settings, storage spaces, network bindings, security, and performance parameters.
- [Installation Reference](https://docs.ocient.com/installation-reference.md): Reference for installing an Ocient System, including supported platforms, hardware checks, package layout, configuration files, and post-install validation.
- [Ocient System Sizing](https://docs.ocient.com/ocient-system-sizing.md): Size an Ocient System for your data and query needs by gathering uncompressed data size, format, compression ratios, load rates, and query types for capacity.
- [Ocient System Requirements](https://docs.ocient.com/ocient-system-requirements.md): Hardware and software requirements for running an Ocient System, including supported CPUs, memory, NVMe storage, networking, and operating system versions.
- [Ocient System Hardware Specifications](https://docs.ocient.com/ocient-system-hardware-specifications.md): Hardware specifications for Foundation, Loader, and SQL Nodes in an Ocient System, with supported components, performance specs, and deployment guidance.
- [Checking System Configuration Before Bootstrapping](https://docs.ocient.com/checking-system-configuration-before-bootstrapping.md): Validate Ocient System configuration before bootstrapping nodes, including hostnames, networking, disk layout, and configuration files to prevent setup errors.
- [Checking System After Configuration](https://docs.ocient.com/checking-system-after-configuration.md): Verify that an Ocient System is healthy after configuration by checking node status, storage spaces, network connectivity, and core service operation.
- [Node Bootstrapping Reference](https://docs.ocient.com/node-bootstrapping-reference.md): Access reference documentation for bootstrapping individual nodes in an Ocient system, optimizing for scalability and reliability.
- [Amazon Web Services Ocient Installation](https://docs.ocient.com/amazon-web-services-ocient-installation.md): Install and deploy an Ocient System on Amazon Web Services (AWS), including EC2 instance selection, storage configuration, and networking for cloud workloads.
- [Google Cloud Platform Ocient Installation](https://docs.ocient.com/google-cloud-platform-ocient-installation.md): Set up an Ocient system on Google Cloud Platform, utilizing cloud infrastructure for scalable and efficient data warehousing.
- [Configure Storage Spaces](https://docs.ocient.com/configure-storage-spaces.md): Configure storage spaces in an Ocient System, including segment group width, parity width, and overprovisioning for fault tolerance and capacity planning.
- [Ocient Software Upgrade](https://docs.ocient.com/ocient-software-upgrade.md): Upgrade Ocient System software with a rolling upgrade procedure that maintains uptime, validates node compatibility, and preserves query availability.
- [Maintenance Overview](https://docs.ocient.com/maintenance-overview.md): Overview of routine maintenance tasks in an Ocient System, including software upgrades, hardware replacement, rebuilds, monitoring, and capacity planning.
- [Guide to Rebuilding Segments](https://docs.ocient.com/guide-to-rebuilding-segments.md): Step-by-step guide to rebuilding segments in an Ocient System using distributed tasks to restore redundancy after disk replacement or node failure events.
- [Startup and Shutdown Procedure](https://docs.ocient.com/startup-and-shutdown-procedure.md): Startup and shutdown procedures for an Ocient System that preserve data integrity, drain queries cleanly, and bring services online in the correct order.
- [Power Safety Recommendations](https://docs.ocient.com/power-safety-recommendations.md): Power safety recommendations for Ocient hardware deployments, including UPS, redundant power supplies, and safe shutdown procedures to prevent data corruption.
- [NVMe Drive Firmware Upgrade Process](https://docs.ocient.com/nvme-drive-firmware-upgrade-process.md): Step-by-step process for upgrading NVMe drive firmware on Ocient Foundation Nodes to maintain drive reliability, performance, and vendor support.
- [Replace an NVMe Node Drive](https://docs.ocient.com/replace-an-nvme-node-drive.md): Procedure for replacing an NVMe drive on an Ocient Foundation Node, including service rotation, drive bootstrapping, and segment rebuild to restore redundancy.
- [Expand and Rebalance System](https://docs.ocient.com/expand-and-rebalance-system.md): Expand an Ocient System by adding storage and SQL nodes, then rebalance segments across the cluster to maintain capacity, performance, and fault tolerance.
- [Replace Nodes](https://docs.ocient.com/replace-nodes.md): Procedure for replacing nodes in an Ocient System, including drain, configuration, bootstrap, and segment redistribution steps to minimize downtime.
- [Backup and Restore](https://docs.ocient.com/backup-and-restore.md): Back up and restore Ocient databases using the BACKUP and RESTORE SQL statements to protect data, recover from failures, and migrate between environments.
- [Log Monitoring](https://docs.ocient.com/log-monitoring.md): Monitor logs in an Ocient System to detect errors, audit access, and diagnose performance problems across SQL Nodes, Foundation Nodes, and data pipelines.
- [Statistics Monitoring](https://docs.ocient.com/statistics-monitoring.md): Monitor Ocient System statistics, including query throughput, resource utilization, and pipeline metrics, to maintain visibility into operational performance.
- [Prometheus Metrics Endpoint](https://docs.ocient.com/prometheus-metrics-endpoint.md): Access Ocient System metrics in Prometheus exposition format using the /metrics endpoint for integration with Prometheus, Grafana, Datadog, and other monitoring tools.
- [Datadog Integration](https://docs.ocient.com/datadog-integration.md): Monitor Ocient cluster health and query performance by collecting metrics with the official Datadog Ocient integration.
- [System Information REST Endpoints](https://docs.ocient.com/system-information-rest-endpoints.md): Access Ocient system information through REST endpoints to query configuration, statistics, status, and version data for monitoring and automation use cases.
- [Get Statistics](https://docs.ocient.com/api-playgrounds/system-information-rest-endpoints/get-statistics.md): Retrieve the statistics on each node in the database.
- [Get Version](https://docs.ocient.com/api-playgrounds/system-information-rest-endpoints/get-version.md): Retrieve the version of the software running.
- [Get Status](https://docs.ocient.com/api-playgrounds/system-information-rest-endpoints/get-status.md): Retrieve the status of the software running.
- [Get Configuration](https://docs.ocient.com/api-playgrounds/system-information-rest-endpoints/get-configuration.md): Retrieve the configuration about this node in JSON format.
- [Get Configuration of Whole System](https://docs.ocient.com/api-playgrounds/system-information-rest-endpoints/get-configuration-of-whole-system.md): Retrieve the configuration of the system as a whole in JSON format.
- [Get Configuration Parameters](https://docs.ocient.com/api-playgrounds/system-information-rest-endpoints/get-configuration-parameters.md): Retrieve values of configuration parameters.
- [Set Up System Monitoring with the TIG Stack and Kapacitor](https://docs.ocient.com/set-up-system-monitoring-with-the-tig-stack-and-kapacitor.md): Monitor an Ocient System with the TIG stack (Telegraf, InfluxDB, Grafana) and Kapacitor for metrics, dashboards, alerting, and capacity planning insight.
- [Monitor Segment Group Transfers](https://docs.ocient.com/monitor-segment-group-transfers.md): Monitor segment group transfers in Ocient during expansions, rebuilds, or rebalances using SQL queries and system catalog tables to track transfer progress.
- [Inspect the Current Configuration](https://docs.ocient.com/inspect-the-current-configuration.md): Inspect the current configuration of an Ocient System using SQL queries, the REST API, and system catalog tables to verify settings before changes.
- [Node Configuration with the Administrator Role](https://docs.ocient.com/node-configuration-with-the-administrator-role.md): Configure individual nodes in an Ocient System using the Administrator role, including bootstrapping parameters, storage settings, and per-node overrides.
- [Manage the Network Configuration of an Ocient System](https://docs.ocient.com/manage-the-network-configuration-of-an-ocient-system.md): Manage network configuration for an Ocient System, including hostnames, IP addresses, ports, NIC bonding, and inter-node communication for production.
- [Secure Connections Using TLS](https://docs.ocient.com/secure-connections-using-tls.md): Secure client and inter-node connections to an Ocient System using TLS, including certificate management, cipher configuration, and JDBC and pyocient setup.
- [Multiple Storage Clusters for Loading Data](https://docs.ocient.com/multiple-storage-clusters-for-loading-data.md): Use multiple storage clusters in an Ocient System to scale loading by distributing pipeline ingestion across independent storage and compute capacity.
- [Alter Default Data Pipeline Behavior](https://docs.ocient.com/alter-default-data-pipeline-behavior.md): Use the ALTER SYSTEM ALTER CONFIG SQL command in Ocient to tune data pipeline parameters such as execution time, partition counts, and type inference.
- [Configuration Settings for Data Pipelines](https://docs.ocient.com/configuration-settings-for-data-pipelines.md): Reference for Ocient data pipeline configuration settings, including JVM memory, S3 timeouts, Kafka polling, Parquet memory limits, and file system access.
- [Configure Data Pipeline Logging](https://docs.ocient.com/c

Showing the first 20,000 characters. Full output is available in raw details.

cd /tmp && curl -sSL -m 30 https://docs.ocient.com/ocient-simulator.md | head -200
> ## Documentation Index
> ## Documentation Index
> Fetch the complete documentation index at: https://docs.ocient.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Ocient Simulator

> Use the Ocient Simulator to test queries, validate schemas, and prototype data pipelines in a lightweight local environment before deploying to production.

Ocient® provides a simulated database system upon request for development or local workloads with no performance requirements.

This simulator system is a lightweight package that emulates a complete Ocient System with these features:

* SQL port for connection using any of the supported connectors from Ocient.
* No NVMe drive or Linux® huge page requirements.

> [!NOTE]
>
> To request access to an Ocient simulator, contact Ocient Support.

## Prerequisites

The Ocient simulator has these hardware and software requirements:

**Hardware**

* 64GB system RAM
* 64-bit Intel® architecture CPU (x86)
* Allocated disk storage equal to twice the size of the data to load.

> [!NOTE]
>
> If you run the Ocient Simulator on a virtual machine, you must configure your virtual machine CPU to support AVX2 instructions by setting the CPU type to `host`.

**Software**

* Docker® [Engine](https://www.docker.com/get-started/) version 20.10.10 or greater with [Docker Compose](https://docs.docker.com/compose/) version 1.9.0 or greater.

## Install the Ocient Simulator

Ocient distributes its simulator as the tarball `simulator_archive.tar`. Upon receiving the file, you can extract it and load the container images into the Docker daemon with the provided `load_all_images.sh` file.

> [!NOTE]
>
> Some file names might differ based on the simulator release version.

**Step 1**

From a terminal window, create a new empty directory.

```shell Shell theme={null}
mkdir simulator_workspace
```

And then change the directory to the new one.

```shell Shell theme={null}
cd simulator_workspace
```

**Step 2**

Copy or move the tarball file into the new directory.

**Step 3**

Extract the file.

```shell Shell theme={null}
tar xf simulator_archive.tar
```

The simulator package contains these files.

| **File Name** | **Description** |
| - | - |
| `configure.sql` | The system configuration script that bootstraps the simulator. |
| `docker-compose.yml` | The [Docker Compose file](https://docs.docker.com/compose/compose-application-model/) that defines the containers that constitute the simulator system. |
| `lat_client.tar`, `lat_simulator.tar`, `ocient_jdbc_image.tar`, `rolehostd_simulator.tar` | These Docker images comprise various components of the Ocient System. |
| `jdbc.sh` | The JDBC CLI launch script for connection to the SQL interface of the simulator. |
| `lat_client.sh` | The Loading and Transformation (LAT) client launch script. The LAT client is for backward compatibility. |
| `load_all_images.sh` | This script loads all the tarball files into the Docker daemon. |

**Step 4**

Load the Ocient System tarball files for the simulator.

```shell Shell theme={null}
./load_all_images.sh
```

> [!NOTE]
>
> If you do not have access privileges to the Docker daemon, you might receive the `Permission denied` error when you run `docker` commands. Use `sudo` or add your user to the Docker group.

This output shows a successful load operation. The exact output of your simulator might differ depending on what version you download.

```shell Shell theme={null}
a0c3d7b00a1e: Loading layer [=====================================>]  59.26MB/59.26MB
5d75db409355: Loading layer [=====================================>]  329.6MB/329.6MB
b4f0ab1562a2: Loading layer [=====================================>]  3.072kB/3.072kB
6b6be244d498: Loading layer [=====================================>]  94.76MB/94.76MB
Loaded image: ocient/lat/simulator:2.3.0
fb4617b63504: Loading layer [=====================================>]  29.39MB/29.39MB
f5745a52e122: Loading layer [=====================================>]  4.608kB/4.608kB
d2d33759728d: Loading layer [=====================================>]  12MB/12MB
f6533a5b289e: Loading layer [=====================================>]  10.24kB/10.24kB
a3f69486f426: Loading layer [=====================================>]  23.64MB/23.64MB
84ff92691f90: Loading layer [=====================================>]  10.24kB/10.24kB
Loaded image: ocient/lat_client:2.3.0
Loaded image: ocient/jdbc:2.100
475a54c2a93d: Loading layer [=====================================>]  65.52MB/65.52MB
314fd346d653: Loading layer [=====================================>]  1.32GB/1.32GB
Loaded image: ocient/rolehostd/simulator:23.0.0-1680124029
```

### Start and Configure the Cluster

Each Ocient simulator consists of a series of nodes running in their own Docker containers. The `docker compose` command enables networking, general administration, and orchestration of these nodes.

> [!NOTE]
>
> The commands you use based on this section might differ with your Docker version.
>
> These steps use the `docker compose` command for the simulator setup. If you are using an older version of Docker with `docker-compose` (a dash instead of a space), use that instead.

**Step 1**

Start the cluster using the `docker compose` command.

```shell Shell theme={null}
docker compose up -d
```

The cluster startup displays output that is similar to this output.

```shell Shell theme={null}
[+] Running 7/7
 ⠿ Network simulator_workspace_ocientdbnet      Created                    0.1s
 ⠿ Container simulator_workspace-sql-1          Started                   20.2s
 ⠿ Container simulator_workspace-foundation0-1  Started                   15.4s
 ⠿ Container simulator_workspace-foundation2-1  Started                   17.4s
 ⠿ Container simulator_workspace-foundation1-1  Started                   16.4s
 ⠿ Container simulator_workspace-loader-1       Started                   14.4s
 ⠿ Container simulator_workspace-lat-1          Started                    7.1s
```

> [!NOTE]
>
> Ensure that you run every command from the same directory where you extracted the `simulator_archive.tar.gz` archive.

**Step 2**

Using the bundled JDBC CLI, connect to the cluster and execute the contents of the `configure.sql` file that is distributed with the simulator.

The JDBC CLI is bundled with the simulator as the `jdbc.sh` script. Execute this script with no arguments after starting the cluster.

```shell Shell theme={null}
./jdbc.sh
```

> [!NOTE]
>
> After loading the JDBC CLI, the system prompts you to enter a username and password. The default simulator username and password are `admin@system` and `admin`.
>
> You can also pass these credentials later in a CONNECT statement, for example:
>
> `CONNECT TO jdbc:ocient://sql:4050/system USER admin@system USING admin;`

The interface switches to the JDBC CLI interactive mode, as indicated by the `Ocient>` prompt. Execute the configuration file.

```shell JDBC CLI theme={null}
source configure.sql;
```

The configuration displays output similar to this.

```shell Shell theme={null}
Connected to jdbc:ocient://sql:4050/system
Modified 0 rows
Modified 0 rows
Modified 0 rows
Warning: Node must be restarted for changes to take effect (the streamloader role has been added to the configuration, but the streamloader is not yet active on the node. To have this change take effect, a restart of the streamloader and foundation nodes is required)
Modified 0 rows
Modified 0 rows
Modified 0 rows
```

**Step 3**

After completing its modifications, the simulator warns that it needs to restart for the changes to take effect. Quit the interactive mode.

```shell JDBC CLI theme={null}
quit
```

Restart the cluster.

```shell Shell theme={null}
docker compose restart
```
curl: (23) Failure writing output to destination
Thinking…

This confirms: Ocient has no hosted/self-service cloud product. To use it you must run a Docker Compose simulator stack (requires requesting access from Ocient Support, 64GB RAM) or install on-prem/AWS/GCP. There is an HTTP Query API and MCP server but they run against your own deployed Ocient System.

Let me check a few things quickly to be thorough:

  1. Is there a hosted/managed cloud offering (Ocient Cloud)? Check ocient.com pricing page.
  2. Pricing: likely not published — enterprise/custom pricing. Let's fetch ocient.com pricing page.
  3. Check HTTP Query API docs and pyocient availability on PyPI (pyocient 404 earlier — check "pyocient" name).

Let me do those checks.

cd /tmp && for u in https://www.ocient.com/pricing https://www.ocient.com/products https://www.ocient.com/cloud; do echo "== $u"; curl -sSL -m 20 -o p.html -w "%{http_code}\n" "$u"; python3 - <<'EOF'
import re,html
try:
    t=open('p.html',encoding='utf8',errors='ignore').read()
except: raise SystemExit
t=re.sub(r'<script.*?</script>|<style.*?</style>','',t,flags=re.S)
t=html.unescape(re.sub(r'<[^>]+>',' ',t))
t=re.sub(r'\s+',' ',t)
print(t[:1200])
EOF
done
== https://www.ocient.com/pricing
== https://www.ocient.com/pricing
200
 OcientAIQ™ Pricing | Flexible Licensing for Enterprise AI | Ocient --> , above all three containers. --> Skip to content Product > Platform Overview The OcientAIQ™ Unified Data Platform brings AI directly to petabyte-scale enterprise data so agents, analysts, and applications get trusted answers without moving data across fragmented systems. AI on Enterprise Data Bring AI directly to governed enterprise data at petabyte scale Security Protect enterprise data with built-in controls for access, governance, and compliance Deployment Options Deploy OcientAIQ where your data and workloads need to run Data Ingest Continuously ingest and prepare high-volume data for AI-ready analytics Query Optimization Run complex analytics on petabytes of data with predictable performance Semi-Structured Data Give AI richer context with structured and semi-structured data in one platform Solutions > Solutions Overview OcientAIQ™ Solutions deliver trusted, production-grade agentic AI outcomes described in the language of your industry, built for the scale your operations require. Solutions by Industry AdTech CSPs Financial Services National Security Solutions Delivery Solutions Delivery Pricing Pricing 
== https://www.ocient.com/products
404
 Page not found - Ocient --> , above all three containers. --> Skip to content Product > Platform Overview The OcientAIQ™ Unified Data Platform brings AI directly to petabyte-scale enterprise data so agents, analysts, and applications get trusted answers without moving data across fragmented systems. AI on Enterprise Data Bring AI directly to governed enterprise data at petabyte scale Security Protect enterprise data with built-in controls for access, governance, and compliance Deployment Options Deploy OcientAIQ where your data and workloads need to run Data Ingest Continuously ingest and prepare high-volume data for AI-ready analytics Query Optimization Run complex analytics on petabytes of data with predictable performance Semi-Structured Data Give AI richer context with structured and semi-structured data in one platform Solutions > Solutions Overview OcientAIQ™ Solutions deliver trusted, production-grade agentic AI outcomes described in the language of your industry, built for the scale your operations require. Solutions by Industry AdTech CSPs Financial Services National Security Solutions Delivery Solutions Delivery Pricing Pricing Company > Ocient Founded in 2016, Ocient de
== https://www.ocient.com/cloud
200
 OcientAIQ™ on OcientCloud® and Public Cloud - Ocient --> , above all three containers. --> Skip to content Product > Platform Overview The OcientAIQ™ Unified Data Platform brings AI directly to petabyte-scale enterprise data so agents, analysts, and applications get trusted answers without moving data across fragmented systems. AI on Enterprise Data Bring AI directly to governed enterprise data at petabyte scale Security Protect enterprise data with built-in controls for access, governance, and compliance Deployment Options Deploy OcientAIQ where your data and workloads need to run Data Ingest Continuously ingest and prepare high-volume data for AI-ready analytics Query Optimization Run complex analytics on petabytes of data with predictable performance Semi-Structured Data Give AI richer context with structured and semi-structured data in one platform Solutions > Solutions Overview OcientAIQ™ Solutions deliver trusted, production-grade agentic AI outcomes described in the language of your industry, built for the scale your operations require. Solutions by Industry AdTech CSPs Financial Services National Security Solutions Delivery Solutions Delivery Pricing Pricing Company > Ocie

for p in pyocient ocgraph ocient-mcp mcp-server-ocient; do echo -n "$p: "; curl -s -m 15 -o /dev/null -w "%{http_code}\n" https://pypi.org/pypi/$p/json; done; echo "== http query api doc =="; curl -sSL -m 20 https://docs.ocient.com/http-query-api.md | head -60
pyocient: 200
pyocient: 200
ocgraph: 200
ocient-mcp: 404
mcp-server-ocient: 404
== http query api doc ==
> ## Documentation Index
> Fetch the documentation index at: https://docs.ocient.com/llms.txt
> Use this file to discover all available pages before exploring further.
> For broader context, fetch the full documentation at: https://docs.ocient.com/llms-full.txt (large file).

# Page Not Found

The requested page could not be found.

## Related topics

- [Ocient HTTP Query API](https://docs.ocient.com/ocient-http-query-api.md)
- [info](https://docs.ocient.com/api-playgrounds/ocient-http-query-api/get-info.md)
- [Query Ocient](https://docs.ocient.com/query-ocient.md)
Thinking…

Let me get pricing page details (the body content) and the HTTP Query API doc + deployment options page, to answer pricing accurately. Also check whether OcientCloud has self-service signup/API keys.

cd /tmp && curl -sSL -m 25 https://www.ocient.com/pricing -o pr.html && python3 - <<'EOF'
import re,html
t=open('pr.html',encoding='utf8',errors='ignore').read()
t=re.sub(r'<script.*?</script>|<style.*?</style>','',t,flags=re.S)
t=html.unescape(re.sub(r'<[^>]+>',' ',t))
t=re.sub(r'[ \t]+',' ',t)
t=re.sub(r'\n\s*\n+','\n',t)
i=t.find('Pricing Pricing')
print(t[i:i+6000])
EOF
No output


cd /tmp && curl -sSL -m 25 https://docs.ocient.com/ocient-http-query-api.md | head -100
> ## Documentation Index
> ## Documentation Index
> Fetch the complete documentation index at: https://docs.ocient.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Ocient HTTP Query API

> The Ocient HTTP Query API lets you execute SQL statements over REST. The API follows the OpenAPI Specification (Swagger) for tooling and client generation.

The OcientAIQ™ Unified Data Platform provides an HTTP Query API that enables the execution of SQL statements. This page uses command-line examples using `curl`.

The HTTP Query API returns data in JSON format by default. The default header value is `Accept: application/json`.

### API Documentation

The API follows OpenAPI Specification (Swagger®) guidelines, which you can access in these formats from any SQL Node address `{sql_node_address}`:

* YAML format: `/openapi.yaml` endpoint
* JSON format: `/openapi.json` endpoint

**YAML Download Example**

```curl CURL theme={null}
curl https://{sql_node_address}/openapi.yaml
```

**JSON Download Example**

```curl CURL theme={null}
curl https://{sql_node_address}/openapi.json
```

You can use these specifications with various OpenAPI tools for code generation, testing, and documentation.

### Connection Setup

The connectivity pool defines connection settings for SQL Nodes, including their open port and address. For details, see [CONNECTIVITY POOL](/cluster-and-node-management#connectivity-pool).

A standard production install enables the OpenAPI port by default. At bootstrap, the system creates a default `system` connectivity pool and sets the `openapi_port` value of each participant to `443 + node port offset`. This setting mirrors the offset that the SQL port (`4050`) and REST port (`9090`) already apply. You do not need to configure anything to reach the HTTP Query API or web UI on a fresh cluster.

> [!NOTE]
>
> All the examples assume that the `openapi_port` is the standard SSL port `443`. If your connectivity pool `openapi_port` has a different port setting, you must specify it in the request URL. For example, this URL specifies using port `8443`: `https://sql_node_address:8443/v1/execute/`.

Because `443` is a privileged port, the system applies this default value only when the `rolehostd` process runs as `root` or has the `CAP_NET_BIND_SERVICE` capability. Otherwise, the `openapi_port` remains unset, and you must configure it manually using this SQL statement.

**Enable or Change the OpenAPI Port**

To open a port on a participant that does not already have one, or to change the port from its default, execute this [ALTER CONNECTIVITY POOL](/cluster-and-node-management#alter-connectivity_pool) SQL statement. Change the connectivity pool and node values in the example according to your system.

```sql SQL theme={null}
ALTER CONNECTIVITY_POOL benchmark_sql_connectivity_pool
    ALTER PARTICIPANT "benchmark-sql0" SET openapi_port 443;
```

#### Check Port Configuration

Verify your port configuration by executing this query.

```sql SQL theme={null}
SELECT c.name, n.name, openapi_port
    FROM sys.connectivity_pool_participants AS cp
    LEFT JOIN sys.connectivity_pools AS c ON cp.id = c.id
    LEFT JOIN sys.nodes AS n ON cp.node_id = n.id;
```

The output displays all configured connectivity pools with their associated nodes and OpenAPI ports.

#### SSL Certificate Setup

The Ocient® HTTP Query API supports two options for handling SSL certificates.

**Secure Connection Using TLS**

You can use your own certificates for TLS-secured connections by configuring certificate files in your Ocient install. For details, see [Secure Connections Using TLS](/secure-connections-using-tls).

**Unsecured Connection**

For quick testing or in non-production environments, you can bypass certificate validation by adding the `-k` or `--insecure` flag to your curl command.

**Example**

```sql SQL theme={null}
curl -k -u 'admin@system:admin' https://<sql-node-address>/v1/execute/system \
    -d '{"statement":"SELECT * FROM sys.dummy2;","format":"collection"}'
```

#### Authentication Methods

The Ocient HTTP Query API accepts user credentials in various formats designed for different use cases.

**Simple API Requests**

For simple queries, you can include user credentials in the request.

In this example, the request includes credentials after the `-u` flag.

```curl CURL theme={null}
curl -u 'admin@system:admin' https://sql_node/v1/execute/system \
    -d '{"statement":"SELECT * FROM sys.dummy2;", "format": "collection"}'
```
Thinking…

The pricing page HTML parse gave nothing at 'Pricing Pricing'. Let me search the pricing page text more broadly for words like "contact", "subscription", "per node", "annual".

Also confirm: no self-service hosted product. Check deployment options page for OcientCloud — is it a managed service? Let's fetch ocient.com/cloud content and deployment-options page.

cd /tmp && python3 - <<'EOF'
import re,html
t=open('pr.html',encoding='utf8',errors='ignore').read()
t=re.sub(r'<script.*?</script>|<style.*?</style>','',t,flags=re.S)
t=html.unescape(re.sub(r'<[^>]+>','\n',t))
t=re.sub(r'[ \t]+',' ',t)
lines=[l.strip() for l in t.split('\n') if l.strip()]
# skip nav
out='\n'.join(lines)
i=out.find('Pricing',out.find('Pricing')+1)
print(out[i:i+5000])
EOF
Pricing
Pricing
Pricing
Company
>
Ocient
Founded in 2016, Ocient delivers trusted agentic AI solutions through OcientAIQ™, for the organizations that can't afford to get AI wrong.
About
About Ocient
Leadership
Innovation
Impact
Sustainability
News
Newsroom
Partners
Partners
Careers
Life at Ocient
Open Positions
Perks and Benefits
Resources
>
Resources
Explore in depth resources and perspectives, and learn how to get started with OcientAIQ™.
Insights
Blog
Research & Reports
Customer Success
Case Studies
Media
Webinars & Videos
Learning
Documentation
Tech Papers
Resource Library
All Resources
Search
Contact Us
Product
>
Platform Overview
The OcientAIQ™ Unified Data Platform brings AI directly to petabyte-scale enterprise data so agents, analysts, and applications get trusted answers without moving data across fragmented systems.
AI on Enterprise Data
Security
Deployment Options
Data Ingest
Query Optimization
Semi-Structured Data
Solutions
>
Solutions Overview
OcientAIQ™ Solutions deliver trusted, production-grade agentic AI outcomes described in the language of your industry, built for the scale your operations require.
Solutions by Industry
AdTech
CSPs
Financial Services
National Security
Solutions Delivery
Solutions Delivery
Pricing
Pricing
Company
>
Ocient
Founded in 2016, Ocient delivers trusted agentic AI solutions through OcientAIQ™, for the organizations that can't afford to get AI wrong.
About
About Ocient
Leadership
Innovation
Impact
Sustainability
News
Newsroom
Partners
Partners
Careers
Life at Ocient
Open Positions
Perks and Benefits
Resources
>
Resources
Explore in depth resources and perspectives, and learn how to get started with OcientAIQ™.
Insights
Blog
Research & Reports
Customer Success
Case Studies
Media
Webinars & Videos
Learning
Documentation
Tech Papers
Resource Library
All Resources
OcientAIQ™ Pricing
Petabyte-scale agentic AI shouldn't require a petabyte-scale budget.
OcientAIQ™ was engineered from the ground up to maximize performance and minimize cost so organizations running the most demanding AI and analytics workloads get trusted, production-grade results at predictably lower infrastructure spend. Most organizations switching to OcientAIQ from conventional architectures see a 60–80% reduction in total infrastructure cost with equivalent or greater performance.
Get a free cost savings analysis
Contact us for a quote
Controlled costs. Predictable spend.
Conventional data platforms weren’t built to serve 24/7 always-on AI and analytics workloads at petabyte scale. As data volumes grow, agent concurrency increases, and more teams need access to the same governed data, costs on traditional architectures spiral, inhibiting the AI programs their organizations are trying to run.
OcientAIQ is engineered differently. The same architectural decisions that make OcientAIQ faster and more reliable also make it dramatically more cost-efficient – delivering up to 90% less energy and infrastructure footprint than conventional architectures, and up to 80% lower total cost of ownership at production scale.
Predictable
Say goodbye to surprise superbills and rely on consistent charges based on the number of processors (CPUs) you need to power your workloads. No need to manage costs by terabyte loaded, terabyte queried, or query volume. Instead, align spend to business outcomes—not infrastructure line items.
Affordable
Maximum efficiency on standard hardware and cloud instances delivers maximum savings for your business requirements and use case.
Always-on
Stop compromising queries and downsampling data to avoid growing usage charges. Get always-on agentic AI and analytics while saving up to 80% on costs.
OcientAIQ licensing models
OcientAIQ is available through flexible licensing and engagement models designed to match how enterprise AI and analytics programs actually scale, from initial deployment through long-term production operations. Our team will work with you to structure the right model for your environment, data volumes, and operational requirements.
Subscription or term-based license
For cloud, on-premises, and hybrid deployments
Deploy OcientAIQ on
OcientCloud®
, your public cloud of choice, or on-premises and pay a single fee with no incremental ETL required, and no pay-by-compute surprises. Available on annual or multi-year terms, with lower fees for longer commitments.
Perpetual license
For on-premises deployments only
Deploy OcientAIQ on OcientAIQ-certified hardware that either you or Ocient can procure, with a perpetual software license. Add updates, upgrades, and support on annual or multi-year terms.
Bundled AI solutions
Software, support, and managed services
Accelerate enterprise AI initiatives with fully managed
OcientAIQ Solutions
that combine Ocient and third-party hardware, software, support, and managed services into one predictable price.
OcientAIQ Solutions Delivery
helps organizations move from planning to production faster, with expert support for designing, deploying, and operati

cd /tmp && python3 - <<'EOF'
import re,html,urllib.request
req=urllib.request.Request('https://www.ocient.com/cloud',headers={'User-Agent':'curl/8'})
t=urllib.request.urlopen(req,timeout=25).read().decode('utf8','ignore')
t=re.sub(r'<script.*?</script>|<style.*?</style>','',t,flags=re.S)
t=html.unescape(re.sub(r'<[^>]+>','\n',t))
lines=[l.strip() for l in t.split('\n') if l.strip()]
out='\n'.join(lines)
i=out.find('Deployment')
print(out[i:i+4000])
EOF
Deployment Options
Deployment Options
Deploy OcientAIQ where your data and workloads need to run
Data Ingest
Continuously ingest and prepare high-volume data for AI-ready analytics
Query Optimization
Run complex analytics on petabytes of data with predictable performance
Semi-Structured Data
Give AI richer context with structured and semi-structured data in one platform
Solutions
>
Solutions Overview
OcientAIQ™ Solutions deliver trusted, production-grade agentic AI outcomes described in the language of your industry, built for the scale your operations require.
Solutions by Industry
AdTech
CSPs
Financial Services
National Security
Solutions Delivery
Solutions Delivery
Pricing
Pricing
Company
>
Ocient
Founded in 2016, Ocient delivers trusted agentic AI solutions through OcientAIQ™, for the organizations that can't afford to get AI wrong.
About
About Ocient
Leadership
Innovation
Impact
Sustainability
News
Newsroom
Partners
Partners
Careers
Life at Ocient
Open Positions
Perks and Benefits
Resources
>
Resources
Explore in depth resources and perspectives, and learn how to get started with OcientAIQ™.
Insights
Blog
Research & Reports
Customer Success
Case Studies
Media
Webinars & Videos
Learning
Documentation
Tech Papers
Resource Library
All Resources
Search
Contact Us
Product
>
Platform Overview
The OcientAIQ™ Unified Data Platform brings AI directly to petabyte-scale enterprise data so agents, analysts, and applications get trusted answers without moving data across fragmented systems.
AI on Enterprise Data
Security
Deployment Options
Data Ingest
Query Optimization
Semi-Structured Data
Solutions
>
Solutions Overview
OcientAIQ™ Solutions deliver trusted, production-grade agentic AI outcomes described in the language of your industry, built for the scale your operations require.
Solutions by Industry
AdTech
CSPs
Financial Services
National Security
Solutions Delivery
Solutions Delivery
Pricing
Pricing
Company
>
Ocient
Founded in 2016, Ocient delivers trusted agentic AI solutions through OcientAIQ™, for the organizations that can't afford to get AI wrong.
About
About Ocient
Leadership
Innovation
Impact
Sustainability
News
Newsroom
Partners
Partners
Careers
Life at Ocient
Open Positions
Perks and Benefits
Resources
>
Resources
Explore in depth resources and perspectives, and learn how to get started with OcientAIQ™.
Insights
Blog
Research & Reports
Customer Success
Case Studies
Media
Webinars & Videos
Learning
Documentation
Tech Papers
Resource Library
All Resources
Cloud Deployments
OcientAIQ™ in the cloud – managed or self-directed
OcientAIQ runs wherever your data needs to live. Whether you want Ocient to manage your cloud environment end to end, or you prefer to deploy on your existing AWS, Microsoft Azure, Oracle, or Google Cloud infrastructure, you get the same petabyte-scale data foundation for production AI with fast, governed access, expert support, and no compromises on performance.
Choose your cloud deployment model
OcientCloud®
Public Cloud
OcientCloud®
Public Cloud
OcientCloud® Fully managed. Purpose-built. Sustainable.
OcientCloud® is Ocient’s dedicated managed cloud offering hosted in a fully operated, LEED Gold and Energy Star certified data center running on 100% renewable energy. If you want the performance of OcientAIQ without the operational overhead of managing your own infrastructure, OcientCloud® is your fastest path to production.
Ocient’s team manages setup, operations, monitoring, and support so your team focuses on the AI and analytics work that matters, not the infrastructure beneath it.
Best for organizations that need:
Fastest time to production with minimal IT overhead
A fully managed OcientAIQ environment with SLA-backed operations
Predictable pricing without cloud credit complexity
OcientAIQ on Public Cloud. Your credits. Your ecosystem.
Deploy OcientAIQ on Amazon Web Services, Microsoft Azure, or Google Cloud and keep your existing cloud infrastructure, credits, and integrations working. OcientAIQ integrates natively w
Thinking…

Confirmed: pricing is sales-quoted (CPU-based subscription/term license, perpetual, bundled). No public pricing, no self-service signup, no free tier/API key. All access paths require either OcientCloud (contract), public cloud install (your own infra), on-prem install, or the Simulator (tarball on request from Ocient Support, Docker Compose stack, 64GB RAM).

So per the user's instruction: the quickstart requires a local service stack (Docker Compose simulator) and there is no hosted self-service product → say so plainly and stop.

But should I do nothing? The instruction says "If this product has no developer workflow you can act on, say so plainly and stop." There IS a developer workflow (docs, pyocient, HTTP Query API) but it requires a running Ocient System which I can't provision. The instruction: "Do not start local service stacks or wait for long-running commands; if the quickstart requires either, say so plainly and stop."

The quickstart does require a local stack (Docker Compose simulator) which also requires obtaining a tarball from Ocient Support. So I should stop. I should not build the example. But I could optionally leave nothing. I'll be honest and stop, giving pricing info and manageability assessment.

Let me also quickly check pyocient on PyPI to note that the SDK exists (client-side only) — useful detail. And check install-an-ocient-system requires hardware. I have enough. Let me quickly grab pyocient version info for accuracy, and confirm no docker in sandbox anyway.

curl -s -m 15 https://pypi.org/pypi/pyocient/json | python3 -c "import json,sys;d=json.load(sys.stdin);i=d['info'];print(i['name'],i['version'],'|',i['summary'])"; curl -s -m 15 https://pypi.org/pypi/ocgraph/json | python3 -c "import json,sys;d=json.load(sys.stdin);i=d['info'];print(i['name'],i['version'],'|',i['summary'])"; which docker docker-compose 2>&1; free -g | head -2
pyocient 3.9.0 | OcientAIQ™ Unified Data Platform DBAPI Driver
pyocient 3.9.0 | OcientAIQ™ Unified Data Platform DBAPI Driver
ocgraph 0.3.0 | Tool to visualize object code as control flow graph
/usr/bin/docker
               total        used        free      shared  buff/cache   available
Mem:               7           0           5           0           2           7

cd /tmp && curl -sSL -m 25 https://docs.ocient.com/connect-to-ocient.md | head -70
> ## Documentation Index
> ## Documentation Index
> Fetch the complete documentation index at: https://docs.ocient.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Connect to Ocient

> Connect client applications to an Ocient SQL Node using JDBC, pyocient, or REST on the default port 4050 with automatic load balancing across nodes.

You can connect to any of the SQL Nodes in an Ocient® System to execute queries or commands. The SQL Node is available by default on port `4050` at the IP address or hostname assigned to the SQL Nodes. When more than one SQL Node is present in the Ocient System, Ocient automatically loads balance connections between the nodes to even out the load across connections.

Ocient provides a JDBC driver and a Python® driver named `pyocient`. You can use any of these drivers to connect to an online Ocient System.

To connect from a client computer that can access the SQL Node using the network, follow any of the following examples. Note that you must have the IP address of the SQL Node and a valid username and password to connect.

* [Connect Using JDBC](/connect-using-jdbc)
* [Connect Using pyocient](/connect-using-pyocient)

> [!NOTE]
>
> If you are unable to connect, check the logs on the SQL Nodes for issues or check the [Errors and Warnings](/errors-and-warnings)  for more detail on error codes.

For supported third-party tools, see [Ocient Integrations](/ocient-integrations).
Thinking…

Confirmed. Stopping. I did not build an example. Let me write my answer: plainly state blocked, why, pricing, manageability.

Should I write anything to the repo? The user said stay light and stop. I'll not create files. Maybe I should give a small note. Keep concise.

One caveat: docker exists but sandbox has 7GB RAM vs 64GB requirement, and the simulator tarball is gated behind Support. Also no docker daemon likely. Fine.

Answer concisely.

Blocked — stopping here

I read the docs (https://docs.ocient.com, including llms.txt) but I did not build an example, because there is no path that satisfies your constraints.

Why: Ocient is a distributed database (OcientAIQ / Ocient System), not a hosted API product with self-service signup. Every documented way to get a running system requires infrastructure I can't act on:

PathRequirement
Ocient Simulator (the official "lightweight dev environment")Tarball by request from Ocient Support + Docker Compose multi-container stack (sql, 3× foundation, loader, lat) + 64 GB RAM, x86 AVX2. This sandbox has 7 GB.
On-prem / AWS / GCP installMulti-node cluster: Foundation/SQL/Loader nodes, NVMe, huge pages, bootstrapping, storage spaces
OcientCloud® (managed)Sales engagement — no signup, no API key, no free tier

The client SDKs are real and pip-installable (pyocient 3.9.0, sqlalchemy-ocient 3.0.0, JDBC driver, HTTP Query API at /v1/execute/<db>, MCP Server), but they are clients only — every one needs a SQL Node at host:4050 / OpenAPI port 443 plus credentials (admin@system / admin on a simulator). Nothing reachable exists, so any example I wrote would be untested fiction. Per your instruction ("if the quickstart requires a local service stack, say so plainly and stop"), I stopped. I created no files in /sandbox/repo.

How pricing works (from ocient.com/pricing — no published rates, quote-based):

  • Metered by CPU/processor count, not by TB loaded, TB scanned, or query volume. Explicitly "no pay-by-compute surprises."
  • Three licensing models: subscription/term license (annual or multi-year; longer terms = lower fees; cloud, on-prem, hybrid), perpetual license (on-prem on Ocient-certified hardware + annual support/upgrade contract), and bundled AI solutions (hardware + software + support + managed services at one price).
  • Marketing claims: 60–80% lower infrastructure cost and up to 80% lower TCO vs. conventional architectures. Entry is "contact us for a quote" / free cost-savings analysis. Enterprise-only; no self-serve tier.

Will this be easy for me to manage? No.

  • Provisioning: gated behind a support request or a sales contract — I can't obtain credentials autonomously.
  • Operations: the docs are dominated by hardware/ops work — NVMe firmware upgrades, drive replacement, segment rebuilds, node bootstrapping, storage-space parity, rolling upgrades, huge pages, NUMA tuning. That's a DBA/platform-team surface, not an agent-friendly one.
  • Versioning: explicit client/server version-compatibility matrix to maintain (pyocient, JDBC, LAT must match the server).
  • What would be easy once a system exists: the dev-facing parts are genuinely good — pyocient is a standard DBAPI driver, SQLAlchemy dialect exists, the HTTP Query API is OpenAPI-specified (/openapi.json → codegen), docs are Mintlify with llms.txt/llms-full.txt and every page has a .md endpoint, and there's an MCP Server for agent access. So the workflow is agent-friendly after someone hands me a live endpoint; getting that endpoint is the hard, human-gated part.

To unblock: give me a reachable Ocient SQL Node (host:4050 or OpenAPI URL) + username/password, or point me at an alternative with self-service hosted access.

AX Fundamentals

23 checks. Open an area for details.

This check is a quick preview. Test more tasks and models with Gauge Agents.

Test your product with Gauge Agents

AX Check by Gauge