Can I connect PlanetScale to iDBQuery?

PlanetScale is a serverless, MySQL-compatible database, so iDBQuery connects to it using its native MySQL connector. You supply the PlanetScale host and credentials (PlanetScale requires TLS, which iDBQuery uses), and it introspects your schema.

With PlanetScale connected you can:

• Ask in plain language — 'orders and revenue by day this month' — and iDBQuery generates and runs the MySQL query.
• Trust the result — every figure is cited back to the exact rows.
• Blend sources — combine PlanetScale with a warehouse, a CSV, or an API in a single cited answer.

For safe analytics, create a read-only password for iDBQuery, and point it at a branch or a replica if you keep production writes isolated. Because PlanetScale enforces TLS on every connection, your query traffic is encrypted in transit by default.

Example: a fast-growing app runs on PlanetScale. Rather than adding a BI tool and a pipeline, the team asks iDBQuery 'which cohorts have the best 30-day retention?' and gets an instant, source-linked chart. The semantic layer maps developer-oriented table names to plain business terms, so product and growth folks can ask without knowing the schema — and every number stays verifiable back to the data.