Loading…
Chat with distributed SQL — Postgres-compatible, horizontally scaled.
CockroachDB speaks the Postgres wire protocol, and iDBQuery connects to it the same way it does any Postgres source. Whether you're running CockroachDB Serverless, Dedicated, or self-hosted clusters, paste the connection string and the schema across all your databases is introspected in seconds. Every chat question is translated to safe parametrized SQL, sharded across the cluster by Cockroach as usual, and returned as a chart, table, or dashboard. Cockroach-specific touches — multi-region tables, follower reads, AS OF SYSTEM TIME, JSONB, arrays — work because the AI writes standard Postgres-compatible SQL. The schema introspection picks up multiple databases and schemas, foreign keys, and indexes so the model has the context it needs to write correct queries the first time. Connection strings are encrypted at rest with strong symmetric encryption, decrypted only at query time, and never returned by any API. The free tier — 1M tokens per month, three sources, five reports, no credit card — lets a team prove the workflow on a real Cockroach cluster before paying. iDBQuery makes a globally distributed SQL database feel as conversational as a spreadsheet.
Everything iDBQuery's CockroachDB connector supports out of the box.
Project → Add source → PostgreSQL. CockroachDB is Postgres-wire compatible, so the Postgres connector handles it.
Cockroach Cloud console → your cluster → Connect → General connection string. For self-hosted, use the SQL endpoint your cluster exposes (default port 26257).
iDBQuery verifies the connection over SSL and pulls the schemas automatically.
Ask 'Show order volume per region for the last 30 days' — the AI writes the SQL and renders the chart.
Free tier covers most teams. No credit card.
No credit card required · 1M tokens / month free