SQL Editor
Query the ClickHouse® database from your browser
Stop switching between terminals and SSH sessions. CHOps gives your entire team a browser-based SQL editor designed specifically for the ClickHouse® database.
What you can do
Write queries with ClickHouse® database-aware syntax highlighting. Generate SQL from plain English using AI (e.g., "show me the top 10 largest tables by disk usage"). Open multiple query tabs for parallel work. Search your recent queries and re-run them instantly. Save frequently used queries as bookmarks (synced across devices). Export results as CSV, JSON, or TSV. See query stats: rows returned, rows scanned, bytes read, execution time. Visualize EXPLAIN output as interactive tree diagrams. Readonly mode for users who should query but not modify data.
AI SQL generation
Describe what you want in plain English and let AI write the ClickHouse® SQL for you. The AI understands your schema, system tables, and ClickHouse® database-specific syntax. Useful for analysts and engineers who work with the ClickHouse® database occasionally but do not write queries daily.
Multiple tabs and history
The editor supports multiple tabs for parallel query sessions, visual EXPLAIN with AST and pipeline tree rendering, and a stats bar showing rows returned, rows scanned, bytes read, and elapsed time. No ClickHouse® database client installation is required.
Who it's for
Anyone on your team who needs to query the ClickHouse® database, from data analysts to backend engineers. The AI SQL feature means even team members who do not write SQL can get answers from the data.