How do I explore a database I have never seen before?

To explore an unfamiliar database, connect it to iDBQuery and just start asking questions. iDBQuery introspects the schema, uses its semantic layer to decode cryptic table and column names, and answers in plain language — so you understand what's in there without reading documentation or reverse-engineering joins.

Opening a database you've never seen — inherited, undocumented, full of abbreviations — normally means hours of poking at tables. iDBQuery turns it into a conversation.

  • It maps the schema for you — on connection, iDBQuery introspects every table, column, and relationship, so you can ask "what's in this database?" and get a real overview.
  • Cryptic names get decoded — a column called `cust_st_cd` or a table named `tbl_trx_h` is interpreted by the semantic layer, which infers meaning and lets you annotate it once so it stays clear for everyone.
  • Ask without knowing the structure — "Show me sample orders," "how many active accounts," "what links customers to invoices?" iDBQuery figures out the right tables and joins.
  • See the data, not just the shape — sample rows and quick stats reveal what each field actually contains.

Instead of reading an ER diagram and guessing at foreign keys, you learn the database by querying it. The autonomous Analyst can go further, profiling tables and surfacing how they relate. By the time you've asked a handful of questions, you understand the data well enough to work with it confidently — and the semantic annotations you add along the way make the next person's exploration faster.

Updated 2026-06-22