Install Jentic One Beta

Connect the CrateDB HTTP API to your agent

Jentic One is a self-hosted execution layer for AI agents. It lets your agent call the CrateDB HTTP API, or any other public or private API you need. You set the rules, the agent never sees your credentials, and every call is logged.

Two steps, two machines. Install the instance in a safe environment, then register your agent from wherever it runs.

Step 1: Jentic One Host machine

# On the machine that will host your Jentic One instance:
curl -fsSL "https://jentic.com/install.sh?src=apis&api=%2Fapis%2Fcratedb.com%2Fcratedb" | sh

Step 2: Agent machine

# On the machine where your agent runs (keep this separate from the instance):
curl -fsSL "https://jentic.com/install.sh?src=apis&api=%2Fapis%2Fcratedb.com%2Fcratedb" | sh
jentic register       # connects your agent to your Jentic One instance

Jentic One is in public beta. The setup above keeps your agent separate from the instance, which is what you want before using real credentials: an agent running as the same OS user as Jentic One can read its stored keys directly. Just evaluating? A single local install is fine to start. See the secure deployment guide for the tiers.

Capabilities

What an agent can do with CrateDB HTTP API.

Execute a single SQL statement against CrateDB and receive rows in JSON

Run parameterised SQL with bind variables to avoid string interpolation

Submit bulk inserts and updates as a single bulk_args payload

Upload a binary large object to a CrateDB blob table

Download or delete a BLOB by its SHA-1 digest

GET STARTED

Start building with CrateDB HTTP API

Explore with Jentic One

View OpenAPI Document

Use Cases

Patterns agents use CrateDB HTTP API for, with concrete tasks.

★ Real-Time Analytics on Time-Series Data

An IIoT platform writes millions of sensor readings into CrateDB and runs ad-hoc analytical queries through POST /_sql. Dashboards call the same endpoint with parameterised aggregation SQL and receive JSON rows. The single HTTP API works from any language without a JDBC driver, which simplifies polyglot deployments.

POST to /_sql with {stmt: 'SELECT avg(value) FROM sensors WHERE ts > now() - INTERVAL ?', args: ['1 hour']} and return the avg value to the dashboard.

Bulk Ingest from ETL Pipelines

An ETL job batches CDC events from a source database and posts them to CrateDB using bulk_args on /_sql. A single HTTP request inserts many rows in one network round-trip, keeping ingestion throughput high without per-row overhead. Failures are reported per row index so the pipeline can retry only the failed records.

POST to /_sql with stmt 'INSERT INTO events (id, payload, ts) VALUES (?, ?, ?)' and bulk_args of 5000 rows pulled from the upstream Kafka topic.

BLOB Storage Alongside Relational Data

An IoT image-capture pipeline stores small image frames as BLOBs in a CrateDB blob table while keeping the metadata (timestamp, device, classification) in a regular SQL table. PUT /_blobs/{table}/{digest} uploads each image and the response confirms persistence. Later, dashboards reference frames via GET /_blobs/{table}/{digest}.

PUT /_blobs/frames/{sha1} with the JPEG bytes from the camera, then INSERT a row into the frames metadata table referencing the same digest.

Agent-Driven SQL Querying

An AI data agent answers natural language questions over a CrateDB cluster by translating to SQL and calling /_sql. Through Jentic, the agent finds the right operation by intent and uses the database credentials from the vault, so it never holds the password in plain text. The four-endpoint surface keeps tool selection unambiguous.

Search Jentic for 'execute a sql statement on cratedb', execute POST /_sql with a generated SELECT, and return the JSON rows to the user.

Key Endpoints

4 endpoints — cratedb is a distributed sql database for real-time analytics, time-series, and iiot workloads, and the cratedb http api is its primary programmatic interface.

METHOD

PATH

DESCRIPTION

POST

/_sql

Execute a SQL statement, optionally with parameters or bulk_args

PUT

/_blobs/{table}/{digest}

Upload a BLOB to a CrateDB blob table

GET

/_blobs/{table}/{digest}

Download a stored BLOB by digest

DELETE

/_blobs/{table}/{digest}

Delete a stored BLOB by digest

POST

/_sql

Execute a SQL statement, optionally with parameters or bulk_args

PUT

/_blobs/{table}/{digest}

Upload a BLOB to a CrateDB blob table

GET

/_blobs/{table}/{digest}

Download a stored BLOB by digest

DELETE

/_blobs/{table}/{digest}

Delete a stored BLOB by digest

Why Jentic?

What agents get from Jentic-routed access to this vendor.

Setup

Wiring CrateDB's HTTP API by hand means pointing at your own cluster host, and picking either Basic auth or a JWT bearer per request, then framing SQL and BLOB calls yourself. Through Jentic you install once, import CrateDB from the API Directory, store the credential once, and your agent calls it.

Permission scoping

CrateDB puts the table name in the BLOB URL path (/_blobs/{table}/{digest}), so a rule can pin the agent to one BLOB table for reads and writes. You choose the operations it may call, so BLOB deletion is not included unless you add it.

Credential isolation

Your CrateDB password or JWT is stored once, encrypted, by your own Jentic One instance and applied as the Basic or Bearer header at execution time. It never enters the agent's prompt, logs, or context.

Intent-based discovery

Agents search Jentic by intent such as 'run a SQL query on CrateDB' or 'upload a blob to CrateDB', and Jentic returns the matching CrateDB operation with its input schema so the agent calls the right endpoint without browsing the reference docs.

FAQs

Specific to using CrateDB HTTP API through Jentic.

What authentication does the CrateDB HTTP API use?

CrateDB supports HTTP Basic authentication with a configured database user and password, or Bearer token authentication when JWT auth is enabled on the cluster. Through Jentic, credentials are stored encrypted in the vault and added to the request automatically.

Can I run parameterised SQL through the CrateDB HTTP API?

Yes. POST /_sql accepts a JSON body with `stmt` and an `args` array for parameter placeholders, and `bulk_args` for batches of arguments. This avoids string interpolation and keeps queries safe from injection.

How do I bulk insert rows into CrateDB through Jentic?

Search Jentic for 'execute sql on cratedb with bulk args', load POST /_sql, and execute with `stmt` set to your INSERT statement and `bulk_args` set to the array of value arrays. CrateDB returns one result per row index.

How do I store binary data in CrateDB?

Create a blob table in CrateDB, then PUT /_blobs/{table}/{digest} with the binary body. The digest is the SHA-1 of the content. Use GET /_blobs/{table}/{digest} to read it back and DELETE to remove it.

What are the rate limits for the CrateDB HTTP API?

CrateDB itself does not impose API-level rate limits - capacity is a function of the cluster's CPU, memory, and disk. Self-hosted clusters can serve millions of statements per second; CrateDB Cloud applies plan-based throughput caps. Production integrations should pool connections and use bulk_args for heavy ingest.

Is the CrateDB HTTP API free?

CrateDB itself is open-source under the Apache 2.0 license - the HTTP API costs nothing on a self-hosted cluster. CrateDB Cloud is a paid managed offering with usage-based pricing; the same HTTP API is exposed on each cluster.

Can I limit what my agent is allowed to do with the CrateDB HTTP API?

Yes. Because you run Jentic One yourself, your own rules decide which CrateDB operations the agent may call, so you can allow POST /_sql for queries and bulk inserts while withholding DELETE /_blobs/{table}/{digest} so the agent cannot remove stored objects. CrateDB puts the table name in the BLOB path (/_blobs/{table}/{digest}), so a rule can pin the agent to a single BLOB table for reads and writes. The database password or JWT is held only by your self-hosted instance and added at call time, never exposed to the agent.

CrateDB HTTP API

Name: CrateDB HTTP API
Brand: CrateDB HTTP API
Availability: InStock

Official vendor OpenAPI document · agent-readyStorageDatabasebasic, bearer4 EndpointsREST

For Agents

Run SQL queries and bulk inserts against a CrateDB cluster and read or write BLOBs through HTTP. Use when an agent needs to query a distributed analytics or time-series database directly without a driver.

Use for: Run a SQL query against the CrateDB cluster, Insert one million rows in bulk into the events table, Upload an image BLOB to CrateDB, Find the average sensor reading for the last 24 hours

Not supported: Does not handle cluster provisioning, user management, or backup orchestration - use for executing SQL statements and managing BLOBs via HTTP only.

CrateDB is a distributed SQL database for real-time analytics, time-series, and IIoT workloads, and the CrateDB HTTP API is its primary programmatic interface. The API accepts SQL statements as JSON over HTTP at /_sql, including parameterised queries and bulk operations, and returns results in JSON. A separate /_blobs endpoint family handles binary large object storage with PUT, GET, and DELETE operations on a table-and-digest path. Authentication uses HTTP Basic with a CrateDB user and password, or Bearer token where a JWT is configured.

Jentic One on Github View OpenAPI Document

Connect the CrateDB HTTP API to your agent

Capabilities

Start building with CrateDB HTTP API

Use Cases

Key Endpoints

Why Jentic?

Related APIs

FAQs

CrateDB HTTP API