ClickHouse

The ClickHouse client with all
that you need to manage and visualize your data.

* EXTENDED SUPPORT
support for Views, DICTIONARIES & 16 MORE CLICKHOUSE SPECIFIC OBJECTS.
Clickhouse Editor
g2
***** *****
4.6 (100+ reviews)
#1 Highest rated
In database management systems
A top-performing ClickHouse editor

A fully featured ClickHouse client.

DbVisualizer allows you to connect, manage and analyse your ClickHouse databases. With extended support for ClickHouse specific object types you can enjoy the full suite of smart features that DbVisualizer has to offer.

OBJECT TYPES AND ACTIONS

ClickHouse object specific support.

DbVisualizer gives you maximum control over your ClickHouse database, with custom support for specific object types and actions.

See all supported object types and actions ->

Views

A virtual table of a predefined SQL query that doesn't store any data itself.

ClickHouse Views

Dictionaries

Provides a way to map one set of values to another.

ClickHouse dictionaries

DBA

Object types to manage Users, Roles, Processes and TableEngines.

Clickhouse DBA
PROPERTIES

Specific properties for ClickHouse.

SEE DOCUMENTATION ->

In DbVisualizer you will be able to specify properties specifically for your ClickHouse database, so that you can make it perfectly match your preferences. Do you want User ID and password to be prompted to the user? Scripts to be pre-processed? Disable auto-commit? You got it.

The properties below and many more can be configured directly in the ClickHouse GUI to match how you want to work.

AUTHENTICATION AUTHENTICATION
DELIMITED IDENTIFIERS DELIMITED IDENTIFIERS
QUALIFIERS QUALIFIERS
PHYSICAL CONNECTION PHYSICAL CONNECTION
TRANSACTION TRANSACTION
ENCODING ENCODING
SQL STATEMENTS SQL STATEMENTS
CONNECTION HOOKS CONNECTION HOOKS
COLOR AND BORDER COLOR AND BORDER
SQL COMMANDER SQL COMMANDER
QUERY BUILDER QUERY BUILDER
SQL Editor

The universal
database tool.

DbVisualizer is meticulously engineered to handle objects and properties specific to ClickHouse - and most of our features work across almost any data source.

features overview ->
VISUALIZATION

Automatic visualizations.

You’ll be able to automatically generate visual Entity Relationship Diagrams (ERDs) for your ClickHouse database. It allows you to understand dependencies and opportunities, directly in the client.

READ MORE ABOUT VISUALIZATION ->
Automatic visualizations
Editor

A powerful editor for ClickHouse.

Writing SQL for ClickHouse is similar, but not exactly the same as for other databases. DbVisualizer understands these nuances and makes relevant suggestions, making SQL coding simpler.

READ MORE ABOUT THE EDITOR ->
powerful ClickHouse editor
Free trial

Try DbVisualizer Pro
for free.

Start your free 21 day evaluation of DbVisualizer Pro
Maven

JDBC driver management via Maven.

DbVisualizer has the most up-to-date JDBC drivers for ClickHouse included. In fact, it has full JDBC driver management built right in that points to the latest releases as well as historical versions for the drivers.

Driver manager
Maven driver manager
Reviews

Our users love our product.

Don’t take just our word for it. Our users are vocal fans of our product.

Read MORE reviews and stories ->

Name: {{ review.name }}

Role: {{ review.title }}

***** *****
{{ review.quote }}
Verified {{ review.dbs }} user.
Review from {{ (review.source == 'g2') ? 'g2.com' : 'Capterra' }}
G2 Reviews

Used and rated
by the best.

DbVisualizer is a G2 Leader among database management software.

G2 badge
G2 badge
G2 badge
G2 badge
G2 badge
G2 badge

FAQs

Question
Action
Notify me when new features are announced