VisuaLeaf is one visual workspace for TimescaleDB, the PostgreSQL extension that turns a table into a time-series store: browse hypertables as ordinary tables, write time_bucket queries and continuous aggregates in SQL, auto-draw ER diagrams from your foreign keys, and chart what a time series actually looks like.
TimescaleDB keeps the Postgres front door and adds hypertables, chunks, compression and continuous aggregates behind it. VisuaLeaf gives you a workspace over both halves: browse hypertables like tables, build the bucketed query, and put the result on a chart where a time series is finally legible.
A hypertable presents as a single table and is stored as partitions by time, so what you query and what exists on disk are two different pictures.
The whole value of the data is its shape over time, and a terminal can only ever show you a few thousand rows of it in text.
Policies quietly compress old chunks and drop older ones, and none of that scheduled behaviour is visible from a plain SQL prompt.
Devices, sensors and tenants relate to a hypertable through constraints that no client turns into a picture, and that is the half you reason about.
Browse hypertables and their metadata, build time-bucketed SQL, map foreign keys into a diagram, and chart the series — all in one workspace.
Hypertables, continuous aggregates, time_bucket, JSONB, and foreign keys, explored, queried, and visualized instead of parsed from text.
Manage tables visually instead of hand-writing DDL. Add, rename, and edit columns with their types, defaults, primary keys, and foreign keys, then work across tabbed panels for indexes, constraints, and storage. Hit Show DDL to read the full CREATE TABLE statement any time.
Time-series rows carry payloads, and TimescaleDB is real PostgreSQL, so jsonb and array columns open as a nested tree. Inspect keys and arrays inline, filter with the ->, ->> and @> operators, and edit nested values without hand-writing jsonb_set.
Write a time_bucket query or read from a continuous aggregate, then turn the result into a line, area or bar chart in the same workspace and pin it to a dashboard — instead of exporting a CSV so that something else can draw the series for you.
VisuaLeaf connects the steps Timescale users usually handle separately: connect to any instance, explore hypertables and metadata, build bucketed SQL, and visualize the series.
Reach a self-hosted instance on port 5432 or a managed service on its own port and database, over SSL or an SSH tunnel.
Browse schemas, hypertables and views as ordinary tables, and expand JSONB and array columns in a tree.
Assemble filters, joins and grouping visually or write time_bucket SQL, then chart the result on the spot.
Whether you ingest metrics, tune retention and compression, analyse a series, or learn SQL, VisuaLeaf gives you a clearer way to work with TimescaleDB.
Model hypertables and their metadata, and debug the SQL your ingest and read paths run against real rows.
Review schemas, indexes and constraints across environments, and confirm what a policy or migration has actually changed.
Write time_bucket queries and window functions, and chart the series without a separate BI pipeline.
Learn time-series SQL visually, see foreign keys as ER diagrams, and read the SQL the query builder writes.
VisuaLeaf started as a MongoDB workspace and grew into a multi-database visual environment. One app, one workflow, across the databases your team actually uses.
And VisuaLeaf does not leave you staring at a wall of SQL and grids. It visualizes everything — TimescaleDB schemas become interactive diagrams, queries become visual builders, and results become charts and dashboards.
VisuaLeaf is made by an independent software studio that ships often and listens to the developers who use it every day.
Download VisuaLeaf Community Edition and browse hypertables, build time-bucketed SQL, draw ER diagrams from your foreign keys, and chart your time series in one visual workspace.
Download Free Community Edition