Granule for ClickHouse

Tens of millions of rows, and Granule doesn't freeze. On a Mac, 30 million rows from a server arrive in under a second, then sort or search in under half a second.

Granule is a native client for ClickHouse on the Mac, iPad and iPhone, made for results of any size. Rows appear while the query still runs, and you can scroll them at once.

RESULTS
• Rows show as they arrive, with the rows read of those expected, the memory used and the server's own figures when the query ends. Stop ends the query on the server too.
• Sort by any column, search every column, and see totals.
• Values look the way ClickHouse writes them: times in their column's time zone, exact decimals, arrays, maps, tuples and JSON. NULL is shown apart from an empty string.
• Charts of a result: lines over time or bars by category, for millions of points.
• Number columns as data bars or a heatmap.
• Export to CSV, TSV, Parquet, Arrow or JSON Lines, written by the server, or the rows as shown to Excel or CSV.

THE EDITOR
• Highlighting, and completion from your server's functions, settings and formats and from your tables and columns.
• Statements are checked as you type by the server itself, so syntax, names and types follow your server's version, with the names a misspelled one may be.
• Query parameters, run all statements of a script in one session, saved queries and a history you can search.
• Format a statement, and see a run's time, rows and memory next to the run before it.

SAFEGUARDS
• On a production connection, a statement that drops, deletes or rewrites data runs only once you type the connection's name.
• Read-only connections write nowhere.
• A query the server estimates to read more than a billion rows asks first.

THE SERVER
• Health on one page: replicas behind, partitions with too many parts, failing mutations, disks nearly full, failed dictionaries and more.
• Running, recent, failed and heaviest queries; merges, mutations, replicas and their queue; errors, disks, settings and metrics. Live views refresh by themselves, and a query can be stopped from its row.
• On a cluster, every view can cover all of its servers at once.

EXPLAIN
• The plan as an outline that shows what the indexes skip, and the pipeline drawn as a graph.

CONNECTIONS
• HTTP and HTTPS, including ClickHouse Cloud.
• Pinned certificates, your own certificate authority, and client certificates.
• Servers behind an SSH bastion, with a key or a password.
• Import the connections clickhouse-client keeps. Passwords and keys stay in the Keychain.
• No server yet? Try it on ClickHouse's public playground, from the empty list.

Granule collects no data and has no tracking. It talks only to the servers you add.

English and Russian.

Granule is open source (MIT): github.com/d-polikhranidi/Granule. Its table is Gingham, our table engine for Mac, iPad and iPhone apps: github.com/digitalglobeby/Gingham

ClickHouse is a trademark of ClickHouse, Inc. Granule is an independent client and isn't affiliated with or endorsed by ClickHouse, Inc.