DataGrip

DataGrip

JetBrains
+
+
Visit Website

About

Meet DataGrip, our new database IDE that is tailored to suit the specific needs of professional SQL developers. Allows you to execute queries in different modes and provides a local history that keeps track of all your activity and protects you from losing your work. Lets you jump to any table, view, or procedure by its name via the corresponding action, or directly from its usages in the SQL code. Gives you an extended insight into how your queries work and into the database engine behavior, so you can make your queries more efficient. DataGrip provides context-sensitive code completion, helping you to write SQL code faster. Completion is aware of the tables structure, foreign keys, and even database objects created in code you're editing. DataGrip detects probable bugs in your code and suggests the best options to fix them on the fly. It will immediately let you know about unresolved objects, using keywords as identifiers and always offers a way to fix the problems.

About

DbVisualizer is a universal database client for anyone who works with data, from solo developers and startups to professional teams managing complex environments, including developers, DBAs, analysts, and data engineers working with relational and NoSQL databases. It offers a graphical interface for database development, SQL querying, and data exploration. Key features: - SQL editor with autocomplete, visual query builders, variables, and execution tools - AI Assistant for questions, error explanations, and code analysis - Built-in Git integration for SQL scripts and collaboration - Customizable layouts, key bindings, and UI themes - Favorite scripts and database objects for quick access - Configurable security settings for organizations Connects to popular databases via JDBC, including MySQL, PostgreSQL, SQL Server, Oracle, Snowflake, SQLite, Cassandra, and BigQuery. Runs on Windows, macOS, and Linux. 7 million downloads, Pro users in 150 countries.

Platforms Supported

Windows Not Supported
Mac Not Supported
Linux Not Supported
Cloud Supported
On-Premises Not Supported
iPhone Not Supported
iPad Not Supported
Android Not Supported
Chromebook Not Supported

Platforms Supported

Windows Supported
Mac Supported
Linux Supported
Cloud Not Supported
On-Premises Not Supported
iPhone Not Supported
iPad Not Supported
Android Not Supported
Chromebook Not Supported

Audience

SQL developers looking for a database IDE software solution to execute queries and manage databases

Audience

Developers, analysts and DBAs in need of a universal database tool solution to manage, edit and customize databases

Support

Phone Support Supported
24/7 Live Support Not Supported
Online Supported

Support

Phone Support Not Supported
24/7 Live Support Not Supported
Online Supported

API

Offers API Not Supported

API

Offers API Not Supported

Screenshots and Videos

Screenshots and Videos

Pricing

$199 per year
Free Version Not Supported
Free Trial Supported

Pricing

Free
A DbVisualizer Pro license is perpetual - meaning that a one-time purchase at $199, will give the user perpetual access to all Pro versions of DbVisualizer released before the license expires.
To gain access to Pro versions released after a license expired a license renewal is offered. The renewal costs starts at $89/per year.
A volume discount is applied on all orders of 4+ licenses and the Pro license is offered for free to students and teachers.
Multi year terms are available and includes additional discounts.
Free Version Supported
Free Trial Not Supported

Reviews/Ratings

Overall 5.0 / 5
ease 4.5 / 5
features 4.5 / 5
design 5.0 / 5
support 5.0 / 5

Reviews/Ratings

Overall 4.9 / 5
ease 4.8 / 5
features 4.8 / 5
design 4.6 / 5
support 4.7 / 5

Pros & Cons from Real Users

Pros

  • It helps me excel in data and information performance backed up with analysis reflected in solid reports. The support is critical and has a very authentic deployment in terms of tools. The interface is straightforward and with a lot of security in its use of the system. It encourages data quality and has excellent graphics to represent your information through statistical processes.
  • I like DataGrip because I can count on an easy-to-use environment, managing both local and remote databases. I also love its extensive support for handling various database engines. It provides a platform that works quite well; the data visualization panels are very well organized, it allows me to manage several databases simultaneously easily.

Cons

  • It is exclusive and of excellent quality; I like it very much. I have nothing terrible to mention.
  • It takes a little more effort to customize it at first, especially for new users, although it should be noted that the concept of the application is fascinating, and it works well.

Pros from Real Users

Pros

  • Very flexible. Came from a background a couple of years using Toad, but much prefer DB viz, and its a good price for such a comprehensive tool. I use with mysql, mariadb, postgres, mongo, clickhouse. Easy connection set up - good ssh tunnelling options etc. Good autocompletion in editor. Nice set of data export tools etc. Very stable, not had it crash on me even with dozens of sql editor tabs open.
  • Ease of use, support for many databases, intuitive, in grid editing. Settings export so I can easily move between laptop and desktop.
  • New features coming along the way each release. Company listen to customers support ticket on bug fix.
  • Ease of use and cross platform connections. I operate multiple database across windows and MacOS and DbVisualzer to manage all from the one platform
  • My favorite feature in DbVisualizer is Query Builder. Being able to drag and drop tables onto a canvas and visually join them together and the filter and choose the columns that I want to return from the query is a huge time savings for me
  • Easy to use and has many features. I have been using DBVisualizer for more than 7 years. I suggest to use the PRO version.
  • DBVisualizer is one of the most powerful and reliable database tools I have used. It supports a wide range of databases out of the box and provides a consistent, intuitive interface across all of them. The SQL editor is excellent, with strong auto-completion and performance even on large datasets. I especially appreciate the advanced features for query analysis, data visualization, and schema browsing. The tool is very stable, regularly updated, and works seamlessly across platforms. For professional use, it significantly improves productivity.
  • The visualization of table relationships is very easy to understand, as well as connecting to new databases and creating different projects within DBVisualizer.
  • DbVisualizer simplifies most aspects of DDL & DML by providing a simple, intuitive and user-friendly interface that just makes sense. The ability to connect to most databases, reach out to support that actually listens and helps are just the cherry on the top.
  • 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.

Training

Documentation Supported
Webinars Not Supported
Live Online Not Supported
In Person Supported

Training

Documentation Supported
Webinars Not Supported
Live Online Not Supported
In Person Not Supported

Company Information

JetBrains
Founded: 2000
Czech Republic
www.jetbrains.com/datagrip/

Company Information

DbVisualizer
Founded: 2003
Sweden
www.dbvis.com

Alternatives

Alternatives

Advanced Query Tool (AQT)

Advanced Query Tool (AQT)

Cardett Associates Ltd
Aqua Data Studio

Aqua Data Studio

AquaFold, an Idera, Inc. company
DBeaver Community

DBeaver Community

DBeaver Corp.
DBeaver Community

DBeaver Community

DBeaver Corp.
TablePlus

TablePlus

TablePlus InC
TablePlus

TablePlus

TablePlus InC

Categories

AI IDEs Supported
Code Editors Supported
Database Supported
Database Clients Supported
IDE Supported
MySQL GUI Clients Supported
SQL Editors Supported
SQL IDEs Supported

Categories

Data Analysis Supported
Data Visualization Supported
Database Supported
Database Clients Supported
IDE Supported
MySQL GUI Clients Supported
SQL Editors Supported
SQL IDEs Supported

Database Features

Backup and Recovery Not Supported
Creation / Development Supported
Data Migration Supported
Data Replication Supported
Data Search Supported
Data Security Supported
Database Conversion Not Supported
Mobile Access Not Supported
Monitoring Supported
NOSQL Supported
Performance Analysis Supported
Queries Supported
Relational Interface Supported
Virtualization Not Supported

IDE Features

Code Completion Supported
Compiler Not Supported
Cross Platform Support Supported
Debugger Supported
Drag and Drop UI Supported
Integrations and Plugins Not Supported
Multi Language Support Not Supported
Project Management Not Supported
Text Editor / Code Editor Supported

Data Analysis Features

Data Discovery Supported
Data Visualization Supported
High Volume Processing Supported
Predictive Analytics Not Supported
Regression Analysis Not Supported
Sentiment Analysis Not Supported
Statistical Modeling Not Supported
Text Analytics Not Supported

Data Visualization Features

Analytics Supported
Content Management Not Supported
Dashboard Creation Not Supported
Filtered Views Supported
OLAP Not Supported
Relational Display Supported
Simulation Models Not Supported
Visual Discovery Supported

Integrations

Amazon Redshift Supported
Apache Cassandra Supported
Apache Derby Supported
Apache Hive Supported
ClickHouse Supported
Exasol Supported
Greenplum Supported
H2 Supported
HyperSQL DataBase Supported
IBM Db2 Supported
JavaScript Supported
MariaDB Supported
Microsoft Azure Supported
MongoDB Supported
MySQL Supported
Python Supported
SQL Server Supported
SQLite Supported
Snowflake Supported
Vertica Supported

Integrations

Amazon Redshift Supported
Apache Cassandra Supported
Apache Derby Supported
Apache Hive Supported
ClickHouse Supported
Exasol Supported
Greenplum Supported
H2 Supported
HyperSQL DataBase Supported
IBM Db2 Supported
JavaScript Supported
MariaDB Supported
Microsoft Azure Supported
MongoDB Supported
MySQL Supported
Python Supported
SQL Server Supported
SQLite Supported
Snowflake Supported
Vertica Supported
Claim DataGrip and update features and information
Claim DataGrip and update features and information