DbGate is a modern and user friendly database client, besides ClickHouse it supports a wide range of databases, including SQL and NoSQL. It is available for Windows, Linux, Mac, and as a web application. DbGate is designed to simplify database management tasks, making it easier for developers and database administrators to work with their data.
Powerful ClickHouse data browser & editor
Many filtering and sorting options. Edit data with batch-updates and macros. Preview changes before save.
More about ClickHouse data browser
ClickHouse Query console with code-completion
Execute queries against ClickHouse database with parameters support, keep queries in query history and use auto-complete suggestions.
More about ClickHouse query console
Cloud storage for ClickHouse connections
Safe online storage for your ClickHouse connections and queries. Share connections with your team, access your connections from any device.
More about DbGate for ClickHouse Cloud
Import and export from ClickHouse database
Import and export multiple tables/collections in one batch. Many supported formats, such as SQL, CSV, JSON, XML, NDJSON, Excel, DBF or YAML.
More about ClickHouse import/export
Modern ClickHouse UI with themes
Easy to use modern UI with tabs. Light and dark builtin themes + 3rd party themes available as plugins. Customizable keyboard shortcuts.
More about ClickHouse interface
Advanced ClickHouse data visualisation
Query designer, able to make joins between SQL tables, MongoDB collections and CosmosDB containers. Display charts, show GEO data on map. Export charts,maps and diagrams as HTML page.
More about ClickHouse visualisation