Can I connect TimescaleDB to iDBQuery?
Yes. TimescaleDB is built on PostgreSQL, so iDBQuery connects to it directly through its PostgreSQL connector. Point iDBQuery at your Timescale database and you can ask time-series questions in plain language and get answers cited back to the exact rows.
TimescaleDB is a time-series database implemented as a PostgreSQL extension, which means it speaks Postgres and iDBQuery connects to it with its native PostgreSQL connector — no export or workaround needed. You supply the host, port, database, and credentials, and iDBQuery introspects the schema, including hypertables.
With Timescale connected you can:
- Ask time-series questions in plain language — 'average power draw per hour last week' or 'peak concurrent sessions by day this month' — and iDBQuery writes and runs the SQL.
- Get cited answers — every figure traces back to the exact rows.
- Blend with relational data — join your Timescale metrics with a devices or customers table (in Timescale or another database) in one live model.
Because Timescale often powers dashboards for IoT, infrastructure, or financial ticks, iDBQuery is a fast way to let non-engineers ask questions of that data without learning SQL or time-bucketing functions. Point it at a read-only user and a replica so analytics never affects ingestion.
Example: an energy company stores meter readings in TimescaleDB. An operations lead asks 'which sites exceeded their load threshold yesterday?' and gets a cited, ranked list in seconds. If you're evaluating time-series stores, Timescale's Postgres compatibility is exactly why it's a first-class, native connection for iDBQuery.
Updated 2026-06-22