Can I connect Azure Database for PostgreSQL or MySQL to iDBQuery?

Azure Database for PostgreSQL and Azure Database for MySQL are managed versions of the standard open-source engines, so iDBQuery connects to them using its native PostgreSQL or MySQL connector — you just supply the Azure server hostname, database, and credentials.

With the database connected you can:

• Ask in plain language — 'active subscriptions by tier this month' — and iDBQuery writes and runs the SQL.
• Verify every number — each figure is cited back to the exact rows.
• Combine sources — join it with a warehouse, a spreadsheet, or an API in one answer, no pipeline required.

For security, create a read-only user and reach the server over Azure Private Link, a VNet, or an SSH tunnel so it isn't publicly exposed; deploying iDBQuery in the same Azure VNet keeps all traffic inside your network. Azure's firewall rules let you scope exactly which hosts can connect.

Example: a services firm runs its app on Azure Database for PostgreSQL. A partner asks 'which clients are over their contracted hours this quarter?' and gets a cited table in seconds. The semantic layer maps the app's technical column names to business terms, so non-engineers can ask directly without knowing the schema — and every answer stays traceable to source.