CLICKHOUSE

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

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

*****

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

g2 logo

*****

4.7 (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 Apple Silicon With Java
mac
macOS Intel 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
COLOR AND BORDER
sql editor
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 Apple Silicon With Java
mac
macOS Intel 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:

Eric F.

Role:

Business Intelligence Developer

*****

DbVisualizer Streamlines Data Gathering Needs into 1 Application DbVisualizer streamlines my query needs by making it a one-stop shop. I have MongoDB, T-SQL, Oracle, etc. connections set up so I can access everything from one simple query tool. I like how I can connect to multiple database types from on...read more

DbVisualizer Streamlines Data Gathering Needs into 1 Application DbVisualizer streamlines my query needs by making it a one-stop shop. I have MongoDB, T-SQL, Oracle, etc. connections set up so I can access everything from one simple query tool. I like how I can connect to multiple database types from one application. I also like being able to quickly view the data without having to write or wait for a default query to run. The export to CSV is so much faster and easier than your standard SSMS. show less

Capterra logo

Verified user.

Review from Capterra

Name:

Karl Nicoletti

*****

My DB Client of choice! DbVisualizer is the easiest, most straightforward database development and troubleshooting tool I have used in my 30+ years as a developer. I have been using the Pro edition for almost five years now. Some of the features I find MOST useful are: 1) View complete DDL including ...read more

My DB Client of choice! DbVisualizer is the easiest, most straightforward database development and troubleshooting tool I have used in my 30+ years as a developer. I have been using the Pro edition for almost five years now. Some of the features I find MOST useful are: 1) View complete DDL including all constraints, 2) Debug Window!, 3) Drill down into and view blob field contents, 4) Format SQL, 5) Stored proc editor, 6) Editing in the SQL Commander show less

G2 logo

Verified user.

Review from g2.com

*****

Reliable, versatile, helpful. DbVisualizer providing user-friendly access to helpful tools that work consistently and predicatbly for all RDBMS platforms and across macOS, Windows, and Linux.

Reliable, versatile, helpful. DbVisualizer providing user-friendly access to helpful tools that work consistently and predicatbly for all RDBMS platforms and across macOS, Windows, and Linux. show less

G2 logo

Verified user.

Review from g2.com

Name:

Nithinan T.

Role:

Senior Software Engineer

*****

DbVisualizer is the Best DB Management I have been using DbVisualizer since I started working, which is more than 10 years now. DbVisualizer is an easy-to-use tool designed to work with almost every database. The databases I use regularly are DB2 and MariaDB. I use the pro package, which has a variety o...read more

DbVisualizer is the Best DB Management I have been using DbVisualizer since I started working, which is more than 10 years now. DbVisualizer is an easy-to-use tool designed to work with almost every database. The databases I use regularly are DB2 and MariaDB. I use the pro package, which has a variety of capabilities. I usually use check cost of SQL for the most performance running in program. show less

Capterra logo

Verified user.

Review from Capterra

Name:

Elizabeth Jarvis

Role:

Business Analyst

*****

Great tool, been using for 6+ years. I use DBVisualizer frequently - practically daily - over several SQL Server databases. As a business analyst, I use it for doing production support, testing software modifications, etc. DB Visualizer is easy to use, does everything I ask of it. Connections are ea...read more

Great tool, been using for 6+ years. I use DBVisualizer frequently - practically daily - over several SQL Server databases. As a business analyst, I use it for doing production support, testing software modifications, etc. DB Visualizer is easy to use, does everything I ask of it. Connections are easy to set up and I really like being able to set the color for different connections - to provide a visual cue as to which environment I am working in (production vs test). DB Visualizer has lots of features that I haven't used but would like to explore. I like that DBVis is continually making improvements to the software. show less

G2 logo

Verified user.

Review from g2.com

Name:

Edward M.

Role:

Director of Software Development & Integration

*****

Great Product I have been using this product for over 5 years. I searched for a long time, tried many other products but once I found DbVisualizer my search was over. I even prefer and use this over MySQL’s Workbench. This is my go-to product for dealing with our MySQL instances which host our data ware...read more

Great Product I have been using this product for over 5 years. I searched for a long time, tried many other products but once I found DbVisualizer my search was over. I even prefer and use this over MySQL’s Workbench. This is my go-to product for dealing with our MySQL instances which host our data warehouse. It has everything I need and it is simple to use. show less

Capterra logo

Verified user.

Review from Capterra

Name:

James Taylor

*****

Extremely powerful multi-platform db client. Spanning many years as a consultant at many different client sites, I have been able to connect to all different database types (DB2, Oracle, MySQL, SqlServer, etc) using DbVisualizer.

Extremely powerful multi-platform db client. Spanning many years as a consultant at many different client sites, I have been able to connect to all different database types (DB2, Oracle, MySQL, SqlServer, etc) using DbVisualizer. show less

G2 logo

Verified user.

Review from g2.com

*****

Best DB software! Dark theme, supports many database types, i find it easy to create queries and run sql reports. It supports ssl tunnels so i dont have to allow outside sql connections. I use it daily.

Best DB software! Dark theme, supports many database types, i find it easy to create queries and run sql reports. It supports ssl tunnels so i dont have to allow outside sql connections. I use it daily. show less

G2 logo

Verified user.

Review from g2.com

*****

DBViz is the go-to for multi-database development. Multi-database development. Query results that can be searched. Connection highlighting to denote prod and dev environments. Link to your scripts folder and directly open them in the tool.

DBViz is the go-to for multi-database development. Multi-database development. Query results that can be searched. Connection highlighting to denote prod and dev environments. Link to your scripts folder and directly open them in the tool. show less

G2 logo

Verified user.

Review from g2.com

Role:

Database Administrator

Field:

Computer Software

*****

Very satisfied! DbVisualizer allows me to much more efficiently perform my duties as a DBA. For example providing an overview of database structure, allowing me to easily view procedure and table definitions, enabling easy export of result set data for report generation, and the fact that I can keep sev...read more

DbVisualizer allows me to much more efficiently perform my duties as a DBA. For example providing an overview of database structure, allowing me to easily view procedure and table definitions, enabling easy export of result set data for report generation, and the fact that I can keep several SQL Commander tabs open at once allows me to multitask well. I have tried many other similar products, but DbVisualizer is the only one I actually enjoy using.Pros: - Overview of and easy grouping of database connections - Wide variety of export options for result set data - Ability to view procedure definitions in an easy wayCons: - Being able to change the maximium heap space from within DbVisualizer would be very useful - There is a popup that appears when I hover over tabs for a moment, but after I move the cursor away and it disappears, it reappears immediately after I hover over the tab again which can get very annoying as it blocks whatever is behind it - The autofill feature is a little annoying as it will sometimes autofill every single column of a table when I press enter to make a new line in a query. It is still useful but I wish there was a way to more easily choose when or when not to autofill show less

TRUSTRADIUS logo

Verified user.

Review from TrustRadius

AWARDS

Used and rated
by the best

Recognized by industry leaders and honored
across top review platforms!

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 -