CLICKHOUSE

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

+16
* EXTENDED SUPPORT
SUPPORT FOR VIEWS, DICTIONARIES & 16 MORE CLICKHOUSE SPECIFIC OBJECTS.
ClickHouse editor
g2 logo

*****
4.6 (100+ REVIEWS)
#1 HIGHEST RATED
IN DATABASE MANAGEMENT SYSTEMS

g2 logo

*****
4.6 (100+ REVIEWS)
#1 HIGHEST RATED
IN DATABASE MANAGEMENT SYSTEMS

A TOP-PERFORMING CLICKHOUSE EDITOR 

Download for free ↓
Recommended Installer
windows
Windows 64bit With Java
windows
Windows Arm64 With Java
linux
Linux Without Java
mac
macOS Intel With Java
mac
macOS Apple Silicon With Java

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.

Views

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

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

Dictionaries

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

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

DBA

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

DBA Object types to manage Users, Roles, Processes and TableEngines.
Views A virtual table of a predefined SQL query that doesn't store any data itself.
Dictionaries Provides a way to map one set of values to another.
DBA Object types to manage Users, Roles, Processes and TableEngines.

PROPERTIES

Specific properties for ClickHouse.

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
sql commander
SQL COMMANDER
query builder
QUERY BUILDER

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.

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.

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.

Sql queries

FREE TRIAL

Try DbVisualizer Pro
for free.

Start your free 21 day evaluation of DbVisualizer Pro

Download for free ↓
Recommended Installer
windows
Windows 64bit With Java
windows
Windows Arm64 With Java
linux
Linux Without Java
mac
macOS Intel With Java
mac
macOS Apple Silicon With Java

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.

clickhouse driver manager
Maven logo
Maven logo

reviews

Our users love our product.

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

Name:

Austin C

Role:

Systems Communication Engineer

*****

DbVisualizer is extremely easy to use. I love the interface.

DbVisualizer is extremely easy to use. I love the interface. show less

Capterra logo

Verified user.

Review from CAPTERRA

Name:

Niels C

Role:

Developer

*****

Tons of features. Most importantly great editor with autocomplete.

Tons of features. Most importantly great editor with autocomplete. show less

Capterra logo

Verified user.

Review from CAPTERRA

Name:

Dominik H

Role:

Senior Software Engineer

*****

Extremely helpful on a day to day base for typical software developments needs

Extremely helpful on a day to day base for typical software developments needs show less

Capterra logo

Verified user.

Review from CAPTERRA

Name:

Leandro L

Role:

Mid-Market(51-1000 emp.)

*****

Nice user interface, lightweight, inline edits allowed, being able to import and export my connections, great technical support

Nice user interface, lightweight, inline edits allowed, being able to import and export my connections, great technical support show less

G2 logo

Verified user.

Review from G2.com

Name:

Robert Y

Role:

Engineer / Developer

*****

One of the best things about DbVis (apart from the fact that it just works) is that the tech support team is always super responsive.

One of the best things about DbVis (apart from the fact that it just works) is that the tech support team is always super responsive. show less

Sourceforge logo

Verified user.

Review from SOURCEFORGE

Name:

Clark G

Role:

Director, Research Technology Services

*****

One of the best software products I've ever used. I have especially appreciated that there is a cli tool as well as an excellent IDE experience.

One of the best software products I've ever used. I have especially appreciated that there is a cli tool as well as an excellent IDE experience. show less

Sourceforge logo

Verified user.

Review from SOURCEFORGE

Name:

Michael B

Role:

Senior Backend Engineer

*****

Provides a common interface to many different databases. Easy to use.

Provides a common interface to many different databases. Easy to use. show less

Capterra logo

Verified user.

Review from CAPTERRA

Name:

Kunal G

Role:

Staff Software Engineer

*****

Ease of use, quick installation, ability to connect with so many databases and ability to play around with query results.

Ease of use, quick installation, ability to connect with so many databases and ability to play around with query results. show less

Capterra logo

Verified user.

Review from CAPTERRA

Name:

Robert H

Role:

Small-Business(50 or fewer emp.)

*****

The functionality of this software and the easiness to connect to the source systems that we are working on. Very easy to use for my developers.

The functionality of this software and the easiness to connect to the source systems that we are working on. Very easy to use for my developers. show less

G2 logo

Verified user.

Review from G2.com

Name:

Nilesh K

Role:

Data Architect

*****

Very easy to use and comes with several handy capabilities that are important in day-to-day life.

Very easy to use and comes with several handy capabilities that are important in day-to-day life. show less

G2 logo

Verified user.

Review from G2.com

G2 REVIEWS

Used and rated
by the best.

DbVisualizer is a G2 Leader among database management software.

G2 users love us
Most likely to recommend
G2 Best results

FAQs

QUESTION
Action
WHAT IS CLICKHOUSE?

ClickHouse is an open-source column-oriented database that can be used to generate analytical data reports in real-time using SQL queries.

View + Hide -
WHAT IS A CLICKHOUSE CLIENT?

A ClickHouse client is a tool for connecting to and manage your ClickHouse database from your OS.

View + Hide -
HOW DO I GET STARTED TO USE CLICKHOUSE WITH DBVISUALIZER?

Download DbVisualizer, https://www.dbvis.com/download/, and connect to ClickHouse. You can use the client for free with limited functionality, try the Pro version for 21 days or buy the Pro version to get the full function set.

View + Hide -
HOW DO I CONNECT TO CLICKHOUSE WITH DBVISUALIZER?

DbVisualizer has a driver manager built in, you just select your ClickHouse database from the list of available data sources, enter the credentials and DbVisualizer automatically sets up the connection.

View + Hide -
WHAT OBJECT TYPES ARE SUPPORTED IN THE DBVISUALIZER CLICKHOUSE CLIENT?

DbVisualizer has deep support for specific ClickHouse functions and object types. For the full list, please see ClickHouse supported object types.

View + Hide -
WHAT ARE THE BENEFITS OF USING CLICKHOUSE?

A lot of users like the fact that ClickHouse is built open source and that it is designed and built to be fast in filtering and aggregating data.

View + Hide -
Cookie policy

We use cookies to ensure that we give you the best experience on our website. However you can change your cookie settings at any time in your browser settings. Please find our cookie policy here ↗