Skip to main content
TrustRadius
DataGrip

DataGrip

Overview

What is DataGrip?

DataGrip, from JetBrains, is a database IDE that is tailored to suit the specific needs of professional SQL developers.

Read more

Learn from top reviewers

DataGrip is perfect for developers

Rating: 10 out of 10
November 20, 2024
IncentivizedVetted ReviewVerified User
I use DataGrip daily for simple queries and complex reporting. I use it map out new tables/columns and to create new indexes.
Continue reading
Jay Moore
C-Level Executive - Information Technology
CIO
The National Beta Club
DataGrip5 years of experience

A good and complete tool for db developers that comes with a price in terms of money and complexity.

Rating: 6 out of 10
November 4, 2024
Vetted ReviewVerified User
We use DataGrip as our main database client to connect to many different services and db engines. It has a good selection of connectors and for each of them enough granularity...
Continue reading
Verified user
Engineer
DataGrip10 years of experience

DataGrip is a great tool to work across platforms

Rating: 10 out of 10
June 27, 2024
IncentivizedVetted ReviewVerified User
Great tool for managing databases across platforms. Single UI for everything, and supports most DBMS out there. The UI can be customized in many ways.
Continue reading
Verified user
Professional
DataGrip4 years of experience

Transfer data and simplify it to a maximum level

Rating: 10 out of 10
July 14, 2021
IncentivizedVetted ReviewVerified User
It is effortless; it has adapted very well to the company's data processes with incredible strength. We want to know this program has it; it has been interesting to constitute...
Continue reading
Maria Pulenta
Executive - Finance and Accounting
Client Account Executive
Zetenta
DataGrip3 years of experience

A reliable and efficient tool for managing multiple databases at the same time

Rating: 10 out of 10
June 12, 2021
IncentivizedVetted ReviewVerified User
We have benefited from using DataGrip for database management and administration in our organization. It has simplified and saved us time to create and administer various data...
Continue reading
David Mendoza
Project Manager - Marketing
Digital Project Manager
Squareball Digital
DataGrip3 years of experience
Log in with LinkedIn to see content from your network
Return to navigation

Pricing

View all pricing

For Individuals

$99

On Premise
per year per user

For Organizations

$229

On Premise
per year per user

All Products Pack for Individuals

$289

On Premise
per year per user

Entry-level set up fee?

  • No setup fee
For the latest information on pricing, visithttps://www.jetbrains.com/store/#person…

Offerings

  • Free Trial
  • Free/Freemium Version
  • Premium Consulting/Integration Services

Starting price (does not include set up fee)

  • $9.90 per month per user
Return to navigation

Product Details

What is DataGrip?

An SQL editor and advanced database client tailored to meet the specific needs of professional database developers. It delivers a range of database tools packed together and running atop the IntelliJ Platform.

DataGrip Competitors

DataGrip Technical Details

Deployment TypesOn-premise
Operating SystemsWindows, Linux, Mac
Mobile ApplicationNo

Frequently Asked Questions

DataGrip, from JetBrains, is a database IDE that is tailored to suit the specific needs of professional SQL developers.

DataGrip starts at $9.9.

MySQL Workbench, dbForge SQL Tools, and DBeaver are common alternatives for DataGrip.

The most common users of DataGrip are from Enterprises (1,001+ employees).
Return to navigation

Comparisons

View all alternatives
Return to navigation

Reviews From Top Reviewers

Community Insights

TrustRadius Insights are summaries of user sentiment data from TrustRadius reviews and, when necessary, 3rd-party data sources. Have feedback on this content? Let us know!

DataGrip has proven to be a versatile tool for users across various industries, enabling them to centralize their database querying needs. This allows them to keep track of past queries and organize batches of queries and functions for different coworkers or clients. Users appreciate the convenience of being able to connect to multiple data sources at once, such as MS SQL, DB2, and MongoDB. By offering this capability, DataGrip eliminates the need for multiple database management applications, saving time and increasing productivity.

One standout feature of DataGrip is its autocomplete functionality and the ability to edit data in the results, which has significantly reduced database development time for users. Furthermore, the software's interface and query writing tools have been favorably compared with those found in BI systems, improving the overall experience for users. The visualization capabilities in DataGrip also deserve mention as they allow users to quickly retrieve the information they need without having to access a SQL instance. Additionally, the software's flexibility in customizing data exports has eliminated the need for custom arguments and modifiers in queries, making it easier to deliver output.

Overall, DataGrip has been well-received for its ability to handle all databases in one application, eliminating the need to switch between different tools. Whether it's managing SQL databases or connecting to remote MariaDB databases, users have found DataGrip to be a powerful solution that surpasses the capabilities of other IDEs like Eclipse for certain tasks. Its seamless integration of various features and user-friendly interface make it an invaluable tool for professionals looking to streamline their database management processes.

Based on user reviews, there are three common recommendations for DataGrip:

  1. Explore all the features: Users recommend exploring all the features of DataGrip to get the most out of it. This includes navigating and doing work in a database as well as taking advantage of its SQL query and admin tools.

  2. Compare with other vendor tools: It is suggested to review other vendor tools and check compatibility with operating systems before making a decision. Users also recommend comparing DataGrip to specific tools like PGAdmin 4 during the 30-day trial period.

  3. Consider pricing and licenses: Before purchasing, users advise checking the list of supported databases and license prices. They appreciate the affordable pricing options and various license choices available in DataGrip.

Overall, users recommend giving DataGrip a try, exploring its features thoroughly, comparing it with other options, and considering pricing and licensing before making a decision.

View all reviews
(1-5 of 5)

DataGrip is perfect for developers

Rating: 10 out of 10
Incentivized
November 20, 2024
JM
Jay Moore
CIO
The National Beta Club (Non-Profit Organization Management, 11-50 employees)
Vetted Review
Verified User
DataGrip
5 years of experience
View profile
Use Cases and Deployment Scope
I use DataGrip daily for simple queries and complex reporting. I use it map out new tables/columns and to create new indexes.
Pros
  • Browse tables and the data
  • Export data
  • Create, modify tables
Cons
  • An easier way to have a pool saved queries that can opened quickly
Likelihood to Recommend
I am a software engineer mostly, but am the default DB admin/developer as well. This tool has been very helpful, especially since it is part of the jetbrains development tools. It makes creating/updating tables easy. Can create indexes especially easy. It allows us to browse filter and export data in a great interface that is easy to use.
Return on Investment
  • Less time to develop database structures
  • Easy to filter and find data
  • Export data for reporting purposes
Usability
9
Perfect other than a way to handle saving and re-using queries. A simple/better way of creating a pool of queries for each project or database connection would be very helpful. It is not bad now, just could be a better. I have used Navicat for MySQL in the past it had that feature. It could save all your queries to the cloud and you could use them on any device.
Alternatives Considered
I think it blows away MySQL Workbench hands down. Workbench does have more functionality when it comes managing the MySQL instance, viewing performance etc. Navicat is ok, it might be better for new database develoopers. I stumbled upon DataGrip cause it came with jetbrains development tools subscription. I tried it out and it has been my go to for several years. now.
Other Software Used

A good and complete tool for db developers that comes with a price in terms of money and complexity.

Rating: 6 out of 10
November 04, 2024
Verified User
Engineer in Engineering
Information Technology & Services Company, 10,001+ employees
Vetted Review
Verified User
DataGrip
10 years of experience
Use Cases and Deployment Scope
We use DataGrip as our main database client to connect to many different services and db engines. It has a good selection of connectors and for each of them enough granularity to configure the connection properties properly including ssh tunnelling and ssl certificates.
Pros
  • Connects to most of the db engines known
  • auto complete is powerful and db objects introspection is complete
  • one place for all your db connections
Cons
  • The resources footprint on your system is big
  • it is not just a db client, it is a db IDE and form most things, for most people, it is too much and overwhelming. Too many options have transformed a db client into another very complicated tool
  • Connections are grouped by project so just having a quick check to a database could require some change in the approach to the tool otherwise you end up with a single dummy project and tens of connections
  • introspection to browse db objects is slow and painful
  • It tries to be smart to help but it ends up to be in the way some time
  • Java based with all the pros (not many) and cons (bye bye memory)
Likelihood to Recommend
Company that uses specific db engines that don't have db clients easily available. It comes with a price all this flexibility.
If you are looking for a lightweight and easy db client for some of the most common dbs (like postgres, MySQL, SQLite etc), in my opinion, it is not worth the price, effort to learn to use it and system resources footprint wasted.
Return on Investment
  • centralise handling and re-allocation of license helps organisations to avoid wasting money on unused licenses.
  • One tool for multiple db engine could end up in less time and money spent on multiple cheaper tools
  • App well supported with continuos improvements and bug fixing
Usability
8
Usability has two aspects, being a complete tool and being easy... DataGrip has a lot of features but it is big, not clear how to use most of the things and most people won't need them. In my opinion, usability is good enough but not friendly.
Alternatives Considered
One place for all the connections and uniformity of use and interaction
Other Software Used

DataGrip is a great tool to work across platforms

Rating: 10 out of 10
Incentivized
June 27, 2024
Verified User
Professional in Information Technology
Insurance Company, 1001-5000 employees
Vetted Review
Verified User
DataGrip
4 years of experience
Use Cases and Deployment Scope
Great tool for managing databases across platforms. Single UI for everything, and supports most DBMS out there. The UI can be customized in many ways.
Pros
  • Support for many DBMS platforms
  • Intuitive UI
  • Customizable UI
Cons
  • Can be a memory hog
  • No free community version with limited functionality
Likelihood to Recommend
DataGrip is an ideal tool for developing stored procedures because you can have multiple open at once and copy&paste between them. The syntax highlighting and other UI features make very easy to look at the code to find mistakes.
Return on Investment
  • Cost savings because we could use fewer database tools
  • Unfortunately, DataGrip isn't a 100% replacement for SSMS for SQL Server
Alternatives Considered
DataGrip provides a single UI for many DBMS platforms, instead of using one for each. Because of that, you can migrate things between platforms using the tool and "look across" all databases at once.
Other Software Used

Transfer data and simplify it to a maximum level

Rating: 10 out of 10
Incentivized
July 14, 2021
MP
Maria Pulenta
Client Account Executive
Zetenta (Marketing & Advertising, 11-50 employees)
Vetted Review
Verified User
DataGrip
3 years of experience
Use Cases and Deployment Scope
It is effortless; it has adapted very well to the company's data processes with incredible strength. We want to know this program has it; it has been interesting to constitute specific systems of data searches in a given time. It is the simplified data management software; you know what the company lacks, and it's too much. It is very suitable for the detailed analysis of customers and companies. It gives us the competitiveness we are looking for.
Pros
  • DataGrip helps me to move data between systems or devices.
  • It has helped me to encourage mass storage of information and filter information through authentic databases.
  • The interface is excellent and easy to understand.
  • The support is significant and has a very authentic deployment in terms of tools.
Cons
  • [I feel] this software has security issues; advertisements and spam are widely used on behalf of the software through email.
Likelihood to Recommend
You will like DataGrip; it is the best software to channel and influence data systems and efficiently. It will help you be more efficient and productive in exporting computer data; it is very effective. There are no errors, and you will feel comfortable using them. It promotes data quality and has excellent graphics to represent your information through statistical processes.
Most Important Features
  • It helps me stand out in terms of data and information performance backed up with analysis reflected in solid reports.
Return on Investment
  • It has been perfect for detailed analysis of clients and companies; it gives us the competitiveness we were always looking for.
Alternatives Considered
DataGrip is the most widely used software for simplified data management; we can know what is missing and what is leftover. The interface is straightforward and with a lot of security in its use of the system. All this has been its plus point.
Other Software Used
Intercom

A reliable and efficient tool for managing multiple databases at the same time

Rating: 10 out of 10
Incentivized
June 12, 2021
DM
David Mendoza
Digital Project Manager
Squareball Digital (Information Technology & Services, 11-50 employees)
Vetted Review
Verified User
DataGrip
3 years of experience
Use Cases and Deployment Scope
We have benefited from using DataGrip for database management and administration in our organization. It has simplified and saved us time to create and administer various databases and has made it practical and straightforward to use through its intuitive panels. We use it daily, and it has become an indispensable resource, mainly because of its extended support for multiple database engines.
Pros
  • I like and enjoy this tool because it is intuitive and straightforward; its interface and panels are for managing local and remote databases.
  • It is beneficial and powerful for database administration and has extensive support for handling multiple database engines.
  • DataGrip's features and functionalities are excellent; they make our work easier and faster.
  • We can manage several databases at the same time.
Cons
  • The consumption of my computer's resources that implies the use of this program is high, so it tends to slow down and decrease the performance.
Likelihood to Recommend
It is undoubtedly one of the best database management programs. It dramatically simplifies database management and administration. Its extensive support for various database engines is a point to highlight when we talk about DataGrip; you will like having such a powerful resource much as we do.
Most Important Features
  • It has tools that allow me to enter and manage local and remote databases quickly.
  • It is a safe and efficient platform, trusted for its best performance and database management capabilities.
Return on Investment
  • It is beneficial to have a program that saves a lot of time and simplifies the work when managing databases.
Alternatives Considered
DataGrip makes it easy to access and manage multiple databases locally and remotely, simplifies everything, and has powerful integrated features and resources that allow you to visualize and analyze data from a single platform.
Other Software Used
Return to navigation