Can I connect CockroachDB to iDBQuery?

CockroachDB is a distributed SQL database that is PostgreSQL wire-compatible, which means iDBQuery connects to it the same way it connects to Postgres — through its native PostgreSQL connector, using your host, port, database, and credentials.

Once connected:

• Ask in plain language — 'orders per region in the last 7 days' — and iDBQuery writes the SQL, runs it read-only, and returns the answer.
• Every figure is cited back to the exact CockroachDB rows.
• One live model — blend CockroachDB with a spreadsheet, a warehouse, or an API in a single question, without building a pipeline.

Because CockroachDB is usually chosen for resilient, geo-distributed workloads, teams often run it as the operational store behind a global app. iDBQuery lets non-engineers ask questions of that store directly: 'which markets grew fastest this month?' returns a chart in seconds, each number traceable.

Give iDBQuery a read-only user (or point it at a follower/read replica) so analytics never touches your write path, and deploy iDBQuery in your own VPC so queries stay inside your network. Its semantic layer also helps when service databases have terse, developer-oriented column names — it maps them to the business terms your team searches for, so people don't need to know the schema to get an answer.