The CHOps SQL editor is more than a text box that runs queries. Here are features that make daily ClickHouse® database work faster.
Generate SQL from plain English
Type what you want in natural language and let AI generate the SQL. For example, "show me the top 10 tables by size" produces a query against system.parts with proper grouping and formatting. Useful when you know what you need but not the exact system table or syntax.
Visual EXPLAIN
Run EXPLAIN on any query and see an interactive tree diagram instead of raw text output. Each node shows its cost, rows processed, and time spent. Click any node to drill into the details. This makes query optimization visual instead of reading walls of text.
ClickHouse®-aware autocomplete
The editor knows your schema. It autocompletes table names, column names, ClickHouse® functions, and even suggests WHERE clause columns based on the table's primary key. This is not generic SQL autocomplete - it understands ClickHouse®-specific syntax like FINAL, PREWHERE, and engine-specific clauses.
Query history and bookmarks
Every query you run is saved in your history. Search through recent queries by text or date. Bookmark queries you run regularly and organize them by category. Bookmarks sync across devices, so you have them whether you are at your desk or on your laptop.
Export in multiple formats
Export results as CSV, JSON, or TSV with one click. For large result sets, the export streams directly to a file download instead of loading everything into the browser.
Kill running queries
See all currently executing queries across the cluster. If a query is consuming too many resources, kill it with one click instead of finding the query ID and running KILL QUERY.
Multi-tab editing
Open multiple query tabs to work on different tasks simultaneously. Each tab maintains its own history and connection settings. Compare results side by side.
Keyboard shortcuts
Power users live on keyboard shortcuts. Ctrl+Enter runs the query, Ctrl+S bookmarks it, Ctrl+/ toggles comments, and Ctrl+Shift+F formats the SQL. The shortcuts work consistently across browsers.
Format SQL automatically
Messy SQL from a colleague or a log file? Select the text and hit the format button. It indents, aligns, and structures the query for readability.
Connect to multiple clusters
Switch between clusters from the editor without opening a new tab. Run the same query against staging and production to compare results. The cluster selector shows connection status and version for each cluster.
