Can I connect Amazon Aurora to iDBQuery?

Amazon Aurora comes in MySQL-compatible and PostgreSQL-compatible editions, and iDBQuery connects to whichever you run using its standard MySQL or PostgreSQL connector — you just provide the Aurora endpoint, port, database, and credentials.

With Aurora connected you can:

• Ask in plain English — 'signups by plan this quarter' — and iDBQuery writes and runs the SQL for you.
• Trust the numbers — every figure is cited back to the exact Aurora rows.
• Combine sources — join Aurora with a CSV, a warehouse, or a REST API in a single answer, with no ETL.

Best practice is to point iDBQuery at an Aurora reader endpoint with a read-only user, so analytics load never touches your primary write instance. Because Aurora usually lives in a private subnet, deploy iDBQuery inside the same AWS VPC (or reach the database over an SSH tunnel or private link) so traffic stays inside your network.

Example: a SaaS company runs its app on Aurora PostgreSQL. Support leadership asks 'which accounts have the most open tickets and lowest usage?' and gets a ranked table instantly, each row traceable to Aurora. The semantic layer bridges developer-named tables to plain business terms, so people who don't know the schema can still get a cited answer in seconds.