Loading…
Chat with Oracle DB in plain English — on-prem, OCI, or Autonomous.
iDBQuery's Oracle connector handles Oracle Database 12c, 18c, 19c, and 21c — whether you're running on-prem, on Oracle Cloud Infrastructure, or on Autonomous Database (Shared or Dedicated). Provide host, port (default 1521), service name (or SID for older instances), and credentials, and schema introspection runs immediately across the schemas your user has access to. The AI sees tables, views, columns, data types, primary and foreign keys, indexes, and synonyms, and uses that to write correct PL/SQL-compatible SELECT statements. Every chat question becomes a safe parametrized SELECT, executed read-only, and returned as a chart, table, or dashboard. Oracle specifics — `ROWNUM`, `FETCH FIRST n ROWS ONLY`, analytic/window functions, hierarchical `CONNECT BY` queries, JSON support via `JSON_VALUE`/`JSON_TABLE`, and Oracle Spatial — are all in the model's repertoire. For Autonomous Database, a wallet (mTLS) is required and is uploaded once during setup; the wallet bytes are encrypted at rest and used only to establish the connection. For on-prem, SSH tunneling through a bastion host keeps the connection private. The free tier — 1M tokens per month, three sources, five reports, no credit card — lets you validate the workflow before committing. iDBQuery makes Oracle data accessible to your whole team without anyone needing to write PL/SQL.
Everything iDBQuery's Oracle Database connector supports out of the box.
Project → Add source → Oracle. The connector speaks the Oracle Net protocol.
Provide host, port (default 1521), service name (or SID), user, and password.
For Autonomous Database, download the client credentials wallet from the OCI console and upload the zip file. iDBQuery uses it to establish a mutual TLS connection.
Ask 'Show top 25 invoices by amount this fiscal year' — 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