How is iDBQuery used in legal and law firms?
In legal, iDBQuery lets law firms and in-house teams ask plain-language questions about matters, billable hours, realisation and matter costs across practice-management, billing and document data, returning cited answers while confidential client data stays inside the firm's own desktop, VPC or air-gapped deployment.
Law firms run on practice-management, billing and a vast store of documents, and confidentiality means that data cannot be moved lightly. iDBQuery joins the systems into one live model, reads documents with OCR, and keeps everything inside the firm's environment.
Questions a legal or in-house team asks iDBQuery: - What is realisation and utilisation by practice group this quarter? - Which matters are over budget or have unbilled time ageing beyond 60 days? - How many active matters does each partner have, and what is the WIP?
iDBQuery connects to the practice-management system, billing and the document store, writes the SQL, and returns a chart, table or shareable report. A financial or matter-status question that would normally require a report request becomes a plain-language ask answered in seconds, with contract PDFs made queryable through OCR.
The differentiator: every figure is cited back to its source, so a realisation number or a WIP figure taken into a partner meeting can be traced to the exact time entries and invoices behind it.
Because privileged client data must stay protected, architecture leads: iDBQuery queries in place and can run in your own VPC, on a desktop app, or fully air-gapped, with role-based access and encryption in transit and at rest, so nothing leaves the firm and your data is never used to train an AI model. It supports your confidentiality obligations rather than claiming a certification it does not hold.
Updated 2026-06-22