VisuaLeaf is one visual workspace for CrateDB, the distributed SQL database built on a Lucene storage layer: browse the doc schema and your own, expand OBJECT and ARRAY columns in a tree instead of a cramped cell, build SQL against a shared-nothing cluster, and chart what comes back.
CrateDB speaks the PostgreSQL wire protocol over a distributed Lucene index, which buys you SQL over semi-structured data and costs you the assumptions that come with a relational database. VisuaLeaf gives you a workspace that treats it as what it is.
A single column can carry a nested object with dynamically added sub-columns, and printing it as text collapses the structure you needed to see.
CrateDB does not enforce relationships between tables, so the model lives entirely in convention and in whoever wrote the ingest pipeline.
Tables are split across nodes and replicated, and a plain client gives you no sense of that layout even while it decides your query time.
The queries worth running return a handful of grouped rows whose whole value is their shape, and a terminal throws that away.
Browse schemas and tables, expand OBJECT and ARRAY columns, build SQL, and chart the result — all in one workspace.
Distributed tables, OBJECT and ARRAY columns, standard-looking SQL, and results that want to be charts, explored and visualized instead of parsed from text.
Read and manage table definitions visually. Inspect columns with their types and defaults, including nested object sub-columns, review indexes and constraints, and hit Show DDL to read the full CREATE TABLE with its clustering and replication settings.
Expand an OBJECT column into a nested tree and read arrays as lists rather than as one long line, so a document stored in a column can be inspected the way a document deserves — before you write the query that reaches into it.
Run an aggregate across a distributed table, then turn the result into a bar, line or pie chart in the same workspace and pin it to a dashboard — instead of exporting a CSV so that something else can draw it for you.
VisuaLeaf connects the steps CrateDB users usually handle separately: connect to the cluster, explore schemas and object columns, build SQL, and visualize the answer.
Reach a local, Docker, self-hosted or cloud cluster on the PostgreSQL wire port 5432, over SSL or an SSH tunnel.
Browse the doc schema and your own, open tables and views, and expand OBJECT and ARRAY columns in a tree.
Assemble filters, joins and grouping visually or write SQL directly, then chart the result on the spot.
Whether you ingest machine data, model semi-structured records, analyse a large cluster, or learn SQL, VisuaLeaf gives you a clearer way to work with CrateDB.
Inspect the object columns your pipelines write, and debug the SQL that reaches into them against real rows.
Review schemas, column types and table settings across environments, and see what an ingest change actually produced.
Write aggregates and window functions across distributed tables, and chart the answer without a separate BI pipeline.
Learn SQL over semi-structured data visually, 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 — nested columns become trees, 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 distributed tables, expand OBJECT and ARRAY columns in a tree, build SQL, and chart your results in one visual workspace.
Download Free Community Edition