Can I connect an Amazon RDS database to iDBQuery?

Yes. Amazon RDS runs standard engines like PostgreSQL, MySQL, and MariaDB, so iDBQuery connects to your RDS instance through its matching database connector. Provide the RDS endpoint and a read-only user, and you can query it in plain language with cited answers.

Amazon RDS is managed hosting for standard database engines — PostgreSQL, MySQL, MariaDB, and others — so iDBQuery connects to it exactly as it would to a self-hosted version, using the matching connector and the RDS endpoint, port, and credentials.

Once connected:

  • Ask questions in plain language and iDBQuery writes the SQL, runs it read-only, and returns a number, chart, table, or live dashboard.
  • Every figure is cited to the exact RDS rows.
  • One live model — blend RDS data with spreadsheets, a warehouse, or an API in a single answer, no pipeline needed.

Recommended setup: create a read-only user and, if you have one, point iDBQuery at an RDS read replica so reporting never competes with production writes. Since RDS instances typically sit in a private VPC subnet, deploy iDBQuery in the same VPC, or connect over an SSH tunnel or bastion host, so the database is never exposed publicly.

Example: an e-commerce team runs its store on RDS MySQL. Operations asks 'which SKUs sold out this week and how much revenue did we miss?' and gets an instant answer, each figure traceable to the source rows. iDBQuery's semantic layer maps cryptic column names to business terms, so anyone can ask without knowing the schema.

Updated 2026-06-22