QueryDock for ClickHouse
Query, explore schemas, run DDL/DML, and monitor remote ClickHouse servers from Android.
About
QueryDock for ClickHouse is a native Android client for querying, exploring, running DDL/DML on, monitoring, operating, and managing access (RBAC) for remote ClickHouse servers. It ports the capabilities of desktop and web tools like DBeaver, DataGrip, Tabix, and the ClickHouse Cloud Console into a mobile-optimized experience, and adapts to the newest ClickHouse features through server-version detection. It talks to the ClickHouse HTTP interface and is built with Jetpack Compose and Material 3.
Features
- Multiple server profiles with instant switching and color labels; HTTP/HTTPS (TLS), connection testing, and credentials encrypted in the Android Keystore
- Explore databases and tables (rows/size/engine), with table details — columns, SHOW CREATE (DDL), partition/sort/primary key, and preview
- Table operations: OPTIMIZE [FINAL], lightweight DELETE, TRUNCATE, DROP, and disk backup, all guarded by confirmation dialogs
- SQL editor with syntax highlighting and run/cancel (KILL QUERY), a virtualized result grid with NULL handling, and execution stats (rows/bytes/elapsed)
- EXPLAIN (AST/SYNTAX/PLAN/PIPELINE/ESTIMATE), results-to-chart (bar/line) with a zero-dependency Canvas renderer, and export to CSV/TSV/JSON/Markdown with Share Sheet
- Query history and snippets, plus version-gated features surfaced only where supported
- Monitor running queries (system.processes) with KILL, browse query_log, and observe disks, merges, mutations, and tables
- Access control (RBAC): view, create, and delete users and roles, and GRANT roles
- Home dashboard with server health (version, uptime, running queries, DB/table count, disk usage), theming, Korean/English, and biometric app lock