CLICKHOUSE
The ClickHouse client with all that you need to manage and visualize your data
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.
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.
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.
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.
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.
reviews
Our users love our product
Don’t take just our word for it. Our users are vocal fans of our product.
Dario Rigolin
CTO
DbVisualizer is my companion in all task about interacting with databases: mysql, clickhouse, mongodb, postgresql and sqlite.It's very easy to handle load of data from csv or xls and also export data from different databases. The...
DbVisualizer is my companion in all task about interacting with databases: mysql, clickhouse, mongodb, postgresql and sqlite.It's very easy to handle load of data from csv or xls and also export data from different databases. The new UI is very clean and easy to use. Testing query on different systems and have a single tool to interact with databases. By centralizing database interactions, DbVisualizer has reduced errors, accelerated troubleshooting, and show less
Verified user.
Review from TrustRadius
Mike V
Corporate Director of Information Systems
Pros: Easy to install and configure; use same interface across multiple database platforms. Quick and dirty use of SQL while still being able to do things like browse tables.Cons: Rough upgrade process, but the most recent major release fixed this with a more automatic process.Overall: We needed...
Pros: Easy to install and configure; use same interface across multiple database platforms. Quick and dirty use of SQL while still being able to do things like browse tables.Cons: Rough upgrade process, but the most recent major release fixed this with a more automatic process.Overall: We needed a tool to just be able to get data out of RDMS'. This fit the bill. It uses a JDBC common denominator to show less
Verified user.
Review from SourceForge
Eric F.
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 o...
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 show less
Verified user.
Review from Capterra
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 ...
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, show less
Verified user.
Review from g2.com
Joseph H
Consultant
Indispensable Tool for My Daily Work Pros: I have used DBVisualizer for more than 10 years. It has become an indispensable part of my daily workflow. It covers almost all known RDMBS and as long as you have a JDBC driver, you can use i...
Pros: I have used DBVisualizer for more than 10 years. It has become an indispensable part of my daily workflow. It covers almost all known RDMBS and as long as you have a JDBC driver, you can use it. I also like that they continue to improve the user experience by adding new features to it.Cons: DBVisualizer already has very good SQL editing features such as auto-complete, error highlighting, etc. show less
Verified user.
Review from SourceForge
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
Verified user.
Review from g2.com
Kauã T
Mid-Level Systems Analyst
DbVisualizer Review Pros: A very good tool — it connects to multiple databases, is stable, provides solid support, fully meets our needs, and includes features that help prevent mistakes in queries or unintended executions.Cons: No...
Pros: A very good tool — it connects to multiple databases, is stable, provides solid support, fully meets our needs, and includes features that help prevent mistakes in queries or unintended executions.Cons: Nothing to declare at this moment. For now!!!!!!!!Overall: A very good tool — it connects to multiple databases, is stable, provides solid support, fully meets our needs, and includes features that help prevent mistakes in queries or unintended show less
Verified user.
Review from SourceForge
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
Verified user.
Review from g2.com
Björn Gehlsen
Professor
DbVis has all we need What do you like best about DbVisualizer? DbVis brings a comfortable environment for students on every level and features both code editing and graphical modeling - all we need.What do you dislike about DbVisualizer? Nothing - DbVis brings all the functionality we needWhat problems is DbVisualizer solving and how is that benefiting you? Comfortable access to our training databases
What do you like best about DbVisualizer? DbVis brings a comfortable environment for students on every level and features both code editing and graphical modeling - all we need.What do you dislike about DbVisualizer? Nothing - DbVis brings all the functionality we needWhat problems is DbVisualizer solving and how is that benefiting you? Comfortable access to our training databases show less
Verified user.
Review from g2.com
Nithinan T.
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 of capabilities. I usually use check cost of SQL for the most performance running in program.
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
Verified user.
Review from Capterra
AWARDS
Used and rated
by the best
Recognized by industry leaders and honored
across top review platforms!
FAQs
ClickHouse is an open-source column-oriented database that can be used to generate analytical data reports in real-time using SQL queries.
A ClickHouse client is a tool for connecting to and manage your ClickHouse database from your OS.
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.
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.
DbVisualizer has deep support for specific ClickHouse functions and object types. For the full list, please see ClickHouse supported object types.
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.