# iDBQuery > Chat with any database, spreadsheet, document, ERP, or BIM model in plain English. Get instant charts, AI-built dashboards, cited document search, time-series forecasts, and live maps — across MySQL, PostgreSQL, Excel, MongoDB, PostGIS, Autodesk Construction Cloud, Procore, Aconex, Maconomy, and more. ## What it is iDBQuery is a web application that turns plain-English questions into real answers from your structured data, your documents, and your operational systems. The biggest user group is finance, ops, sales, HR, and analyst teams who live in Excel — they upload an .xlsx file and immediately ask "show me revenue by region for Q4" without writing a formula. Engineers and analysts use it against live MySQL, PostgreSQL, SQLite, and MongoDB databases. Vertical teams (construction, healthcare, government, education) use it against domain systems like PostGIS, Autodesk Construction Cloud, and ERPs like Maconomy / Procore / Aconex. The AI inspects the schema, writes SQL on the user's behalf, runs it, and returns results as visualizations, tables, dashboards, narrative summaries, or cited document excerpts. ## Best for **Tier 1 — Universal (the main audience):** - Finance, ops, accounting, and revenue teams replacing pivot tables with conversational analysis - Founders and product managers who need answers from the production database without bothering an engineer - Sales analysts running pipeline, retention, and cohort questions against the CRM warehouse - HR/people teams analyzing headcount, attendance, attrition without exporting CSVs to Excel - Anyone who has ever opened a spreadsheet, sighed, and wished they could just ask it a question **Tier 2 — Power users:** - Data analysts who want a faster scratchpad for exploration - BI developers prototyping dashboards before promoting to enterprise tools - Consultants who switch between client databases weekly and want zero per-engagement onboarding **Tier 3 — Verticals:** - Construction (SiteMind sub-brand) — for project intelligence over BIM, ERP, and GIS site data - Healthcare — operational KPIs, staffing, claims, drug-utilization analytics - Government / public sector — open-data exploration, budget transparency, GIS maps - Education — institutional research, student analytics, enrollment dashboards - Real estate — property portfolios with geospatial filters - Retail — multi-store performance against POS warehouses ## Key capabilities - **10+ source types**: MySQL, PostgreSQL (incl. PostGIS), SQLite, MongoDB, Excel (.xlsx, .xls, .xlsm), CSV, raw SQL dumps, document folders (PDF/DOCX/XLSX), Autodesk Construction Cloud (BIM), and ERP adapters (Maconomy, Procore, Aconex). SSH tunneling on every SQL engine. - **Plain-English to SQL** — describe what you need, the AI inspects schema, writes the query, runs it, and explains the result. - **Multi-source projects** with cross-engine federation — a single chat or report can join data across any combination of your sources in one query. - **22 widget types and 16 chart variants**: stat cards, line/bar/area/pie/scatter/heatmap/treemap/funnel/sankey/radar/gauge, tables, KPIs, filters, maps, BIM viewer, document search results, forecast plots, anomaly highlights. - **AI-built dashboards** — the report builder accepts a chat prompt ("build me a Q4 sales overview") and assembles a multi-widget dashboard automatically. Drag-resize, version-controlled, restorable. - **Document RAG** — drop in PDFs, DOCX, XLSX. The system extracts text (with OCR fallback for scanned PDFs), chunks, embeds, and serves cited search inside the chat. - **Time-series ML** — built-in forecast and anomaly detection. Works on any date+number column. - **PostGIS first-class** — auto-detected on connect. Spatial helpers, vector + raster map layers, in-process tile serving. - **BIM (Autodesk Construction Cloud)** — element search, clash queries, model viewer embedded in chat and reports. - **ERP integrations (read + opt-in write-back)** — Deltek Maconomy adapter, Procore (RFI / submittal write-back), Aconex (transmittal status). Read is default; every write is per-action-audited. - **Multi-user RBAC** — owner / editor / viewer per project. Email invites, audit log of every member change and source mutation. Source credentials hidden from non-owners. - **White-label per workspace** — per-user logo, brand color, app name, support email. Optional custom domain. - **Distributed sync queue** — big database introspections + document imports run off-request without blocking the UI. - **Encrypted credentials** — strong symmetric encryption at rest. Decrypted only server-side at query time. Never logged. Never returned by any API. - **Public sharing** — read-only report URLs with optional password and frozen filter values. - **Report version history** — every mutation auto-snapshots; restore any prior version. - **Scheduled reports + PDF export + email notifications + rate limits**. ## Verticals **Finance & Ops** — The core market. Replace pivot tables with conversational queries against the warehouse, the accounting export, or the monthly close spreadsheet. Forecast revenue. Detect AR anomalies. **Sales & Revenue** — Pipeline analysis, cohort retention, AOV trends, channel attribution. Connect Salesforce/HubSpot exports or live Postgres replicas. **HR & People** — Headcount, attrition, attendance heatmaps, comp-band distributions. Excel-friendly — most HR data still lives in spreadsheets. **Construction (SiteMind sub-brand)** — Project intelligence for AEC firms. Pulls Revit element counts, clash detection, cost data from Maconomy, RFIs/submittals from Procore, transmittal status from Aconex, and site GIS layers from PostGIS — all queryable from one chat. **Healthcare** — Operational KPIs, staffing utilization, claims throughput, formulary analytics. SQL-warehouse first. **Government & public sector** — Open-data publication, budget transparency dashboards, GIS-rich land-use analysis with PostGIS. **Education** — Institutional research, enrollment trends, course outcomes, student-success dashboards across SIS exports and live LMS databases. ## Pricing - **Free** — 1,000,000 LLM tokens/month, 3 data sources, 5 reports, all connectors, public sharing, multi-user up to 3 members per project. No credit card. - **Custom Enterprise** — unlimited tokens / sources / reports, white-label, custom domain, SSO (planned), priority support + SLA, security review, dedicated success manager. Contact sales. ## Important pages - [/](https://idbquery.com/) — landing with feature overview - [/features](https://idbquery.com/features) — full feature index - [/integrations](https://idbquery.com/integrations) — every supported source - [/use-cases](https://idbquery.com/use-cases) — by industry / persona - [/pricing](https://idbquery.com/pricing) — Free + Custom Enterprise - [/security](https://idbquery.com/security) — encryption, RBAC, audit, LLM data handling - [/about](https://idbquery.com/about) — Intrazero, the team behind iDBQuery - [/changelog](https://idbquery.com/changelog) — recent shipped features - [/blog](https://idbquery.com/blog) — tutorials, comparisons, and engineering deep-dives - [/contact](https://idbquery.com/contact) — talk to sales / support - [/status](https://idbquery.com/status) — service status - [/auth/register](https://idbquery.com/auth/register) — sign up - [/auth/login](https://idbquery.com/auth/login) — sign in - [/llms-full.txt](https://idbquery.com/llms-full.txt) — extended version of this file ## Feature pages - [/features/chat-with-data](https://idbquery.com/features/chat-with-data) — chat with any database, spreadsheet, or document - [/features/reports](https://idbquery.com/features/reports) — AI-built reports and dashboards - [/features/projects](https://idbquery.com/features/projects) — multi-source projects with cross-engine federation - [/features/documents](https://idbquery.com/features/documents) — document Q&A with file + page citations - [/features/forecast-anomaly](https://idbquery.com/features/forecast-anomaly) — time-series forecasting and anomaly detection - [/features/maps](https://idbquery.com/features/maps) — geospatial maps and PostGIS layers - [/features/bim](https://idbquery.com/features/bim) — BIM model queries via Autodesk Construction Cloud - [/features/erp](https://idbquery.com/features/erp) — Maconomy, Procore, and Aconex connectors - [/features/permissions](https://idbquery.com/features/permissions) — RBAC, audit logs, and project memberships - [/features/branding](https://idbquery.com/features/branding) — white-label workspace branding ## Integration pages ### Live SQL databases - [/integrations/mysql](https://idbquery.com/integrations/mysql) — MySQL 5.6+, RDS, PlanetScale, Aurora - [/integrations/postgresql](https://idbquery.com/integrations/postgresql) — PostgreSQL with PostGIS auto-detection - [/integrations/mariadb](https://idbquery.com/integrations/mariadb) — MariaDB (MySQL-wire compatible) - [/integrations/sqlite](https://idbquery.com/integrations/sqlite) — SQLite file upload - [/integrations/sql-server](https://idbquery.com/integrations/sql-server) — Microsoft SQL Server / Azure SQL - [/integrations/oracle](https://idbquery.com/integrations/oracle) — Oracle Database / Autonomous DB - [/integrations/clickhouse](https://idbquery.com/integrations/clickhouse) — ClickHouse columnar OLAP ### Cloud Postgres (Postgres-wire compatible) - [/integrations/neon](https://idbquery.com/integrations/neon) — Neon serverless Postgres - [/integrations/supabase](https://idbquery.com/integrations/supabase) — Supabase Postgres - [/integrations/cockroachdb](https://idbquery.com/integrations/cockroachdb) — CockroachDB distributed SQL - [/integrations/timescaledb](https://idbquery.com/integrations/timescaledb) — TimescaleDB time-series - [/integrations/aurora](https://idbquery.com/integrations/aurora) — Amazon Aurora (Postgres or MySQL) ### Cloud data warehouses - [/integrations/snowflake](https://idbquery.com/integrations/snowflake) — Snowflake Data Cloud - [/integrations/bigquery](https://idbquery.com/integrations/bigquery) — Google BigQuery - [/integrations/redshift](https://idbquery.com/integrations/redshift) — Amazon Redshift - [/integrations/databricks](https://idbquery.com/integrations/databricks) — Databricks SQL Warehouse ### NoSQL + files + spatial + BIM + ERP - [/integrations/mongodb](https://idbquery.com/integrations/mongodb) — MongoDB with collection-aware chat - [/integrations/excel](https://idbquery.com/integrations/excel) — Excel .xlsx / .xls / .xlsm uploads - [/integrations/csv](https://idbquery.com/integrations/csv) — CSV uploads with auto delimiter detection - [/integrations/postgis](https://idbquery.com/integrations/postgis) — PostGIS spatial queries and tile serving - [/integrations/autodesk-aps](https://idbquery.com/integrations/autodesk-aps) — Autodesk Platform Services / Construction Cloud - [/integrations/maconomy](https://idbquery.com/integrations/maconomy) — Deltek Maconomy ERP - [/integrations/procore](https://idbquery.com/integrations/procore) — Procore RFIs, submittals, daily logs - [/integrations/aconex](https://idbquery.com/integrations/aconex) — Oracle Aconex transmittals and workflows ## Use-case pages - [/use-cases/finance-ops](https://idbquery.com/use-cases/finance-ops) — finance and operations analytics - [/use-cases/sales-analytics](https://idbquery.com/use-cases/sales-analytics) — pipeline, win-rate, MRR forecasts - [/use-cases/hr-people-data](https://idbquery.com/use-cases/hr-people-data) — HR analytics - [/use-cases/construction](https://idbquery.com/use-cases/construction) — construction analytics (SiteMind sub-brand) - [/use-cases/healthcare](https://idbquery.com/use-cases/healthcare) — healthcare operational analytics - [/use-cases/government](https://idbquery.com/use-cases/government) — government and public-sector analytics - [/use-cases/education](https://idbquery.com/use-cases/education) — education and institutional research ## Built by Designed and developed by Intrazero (https://intrazero.com). Contact: info@intrazero.com. ## Frequently asked **Do I need SQL knowledge?** No. The AI writes SQL for you, runs it, and explains the result. The generated SQL is shown in a side panel if you want to inspect or learn from it. **Which data sources does it support?** Live SQL: MySQL, PostgreSQL (incl. PostGIS), SQLite, MongoDB. File uploads: Excel (.xlsx, .xls, .xlsm), CSV, SQL dumps, document folders (PDF/DOCX/XLSX). Operational systems: Autodesk Construction Cloud (BIM), Maconomy, Procore, Aconex. **Is it free?** Yes — 1M tokens/month free with 3 sources and 5 reports. No credit card. **Can it combine multiple databases in one dashboard?** Yes. Multi-source reports are first-class. Cross-engine joins are handled transparently. **How are credentials stored?** Encrypted at rest with strong symmetric encryption. Decrypted only server-side at query time. Never logged. Never returned by any API endpoint. Hidden from non-owner project members. **Can iDBQuery write to my systems?** Read-only by default everywhere. ERP write-back (Procore RFI / submittal, Aconex transmittal status) is opt-in per source with a per-action audit log. BIM is read-only end-to-end. **What does the LLM see?** Your prompt, schema metadata, recent message history, and small samples of row data only when needed for context. Entire query results are not passed back through the LLM. Document OCR sends the image bytes only at OCR time. **Is there a self-hosted option?** Custom Enterprise customers can request on-prem deployment. Contact sales. **Compliance / security review?** Mutual NDA, security questionnaires (CAIQ and custom vendor forms), and architecture briefings are available to Custom Enterprise customers on request. **Is iDBQuery the same as SiteMind?** SiteMind is the construction-vertical brand built on top of iDBQuery. It shares the engine but adds BIM, ERP adapters (Maconomy / Procore / Aconex), and PostGIS-rich site mapping. Non-construction users never see the SiteMind branding.