Can I connect Google Cloud SQL to iDBQuery?
Yes. Google Cloud SQL runs standard PostgreSQL, MySQL, and SQL Server engines, so iDBQuery connects to it through its matching database connector. Provide the Cloud SQL connection details and a read-only user, and you can query it in plain language with cited answers.
Cloud SQL is Google Cloud's managed service for PostgreSQL, MySQL, and SQL Server, and iDBQuery connects to whichever engine you run using its standard connector — you supply the instance connection details and credentials.
With Cloud SQL connected you can:
- Ask in plain language — 'monthly recurring revenue by plan, last six months' — and iDBQuery generates and runs the SQL.
- Get cited answers — every figure traces back to the exact Cloud SQL rows.
- Blend sources — combine Cloud SQL with BigQuery, a spreadsheet, or an API in one answer, with no ETL step.
For a secure setup, use a read-only user and reach the instance over Google's private IP / VPC, an authorized network, or an SSH tunnel, so it's never publicly exposed. Deploying iDBQuery inside the same GCP VPC keeps all query traffic inside your network.
Example: a startup runs its app on Cloud SQL for PostgreSQL and its analytics in BigQuery. A founder asks 'which acquisition channel produced the highest-retaining users?' and iDBQuery joins the two in one cited answer, no pipeline required. The semantic layer decodes terse schema names so non-technical teammates can ask directly and still get a trustworthy, source-linked result in seconds.
Updated 2026-06-22