--- title: DataGrip Reviews meta_title: 'DataGrip Reviews 2026: Details, Pricing, & Features | G2' meta_description: Filter 127 reviews by the users' company size, role or industry to find out how DataGrip works for a business like yours. aggregate_rating: rating_value: 4.6 review_count: 127 scale: '5' date_modified: '2026-07-13' parent_category: name: Database Software url: https://www.g2.com/categories/database-software --- # DataGrip Reviews **Vendor:** JetBrains **Category:** [Database Management Systems (DBMS)](https://www.g2.com/categories/database-management-systems-dbms) **Average Rating:** 4.6/5.0 **Total Reviews:** 127 ## About DataGrip This smart SQL editor and advanced database client is tailored to meet the specific needs of professional database developers. It delivers a range of database tools neatly packed together and running atop the IntelliJ Platform. ## DataGrip Pros & Cons **What users like:** - Users praise the **ease of use** in DataGrip, highlighting its intuitive interface and seamless database integration. (3 reviews) - Users value the **seamless support for multiple databases** , enhancing efficiency and project management in DataGrip. (2 reviews) - Users value the **effective database backup and restoration** features in DataGrip, enhancing their productivity significantly. (1 reviews) - Users appreciate the **easy integrations** with various databases and drivers, enhancing their efficiency and customization. (1 reviews) - Users love the **innovation** in DataGrip, especially the intuitive AI feature that enhances their data exploration experience. (1 reviews) - Navigation Ease (1 reviews) - Security (1 reviews) - Setup Ease (1 reviews) - Speed (1 reviews) - Time Saving (1 reviews) **What users dislike:** - Users miss the **removed keyboard shortcuts** in DataGrip, finding the lack of customization frustrating. (1 reviews) ## DataGrip Reviews ### 1. Very efficient **Rating:** 5.0/5.0 stars **Reviewed by:** Alexandre J. | Data Scientist, Small-Business (50 or fewer emp.) **Reviewed Date:** February 02, 2019 **What do you like best about DataGrip?** Very efficient auto-completion, very convenient to write and test queries live, previewing tables with some filtering is also cool. It has some limited support BigQuery which is good to have. **What do you dislike about DataGrip?** Unfortunately, some NoSQL databases like Mongo are not supported yet. **What problems is DataGrip solving and how is that benefiting you?** Faster to write SQL queries. It becomes easier to rewrite and make legacy queries faster. ### 2. Best DBMS client available **Rating:** 5.0/5.0 stars **Reviewed by:** Adam D. | Web Developer, Media Production, Small-Business (50 or fewer emp.) **Reviewed Date:** January 28, 2019 **What do you like best about DataGrip?** Works with a variety of DBMSs and operating systems **What do you dislike about DataGrip?** It can be daunting to learn every feature or to even realize they exist. It's a big product **What problems is DataGrip solving and how is that benefiting you?** I used it to connect to mysql and redshift. My favorite benefits are code completion on Redshift and the ability to easily import csv files into a table. ### 3. Decent **Rating:** 2.0/5.0 stars **Reviewed by:** Rae L. | Manager, Mid-Market (51-1000 emp.) **Reviewed Date:** February 23, 2019 **What do you like best about DataGrip?** This is good for keeping track of things you mind tend to forget. **What do you dislike about DataGrip?** It was a little hard to set up at first, but you eventually get the hang of it **What problems is DataGrip solving and how is that benefiting you?** Issues with projects not being done on time ### 4. Perfect for writing complex queries **Rating:** 4.5/5.0 stars **Reviewed by:** Verified User in Information Technology and Services | Mid-Market (51-1000 emp.) **Reviewed Date:** March 17, 2019 **What do you like best about DataGrip?** auto-completion of input; ability to connect to multiple databases in one project **What do you dislike about DataGrip?** Often after the launch of the app my first attempt to run query does not work (it just "wakes up" the console) and only the second attempt is successful **What problems is DataGrip solving and how is that benefiting you?** Writing queries before using them in BI systems. Much better interface and tools than in BI systems ### 5. DataGrip Review **Rating:** 4.5/5.0 stars **Reviewed by:** george h. | data analyst, Mid-Market (51-1000 emp.) **Reviewed Date:** November 27, 2018 **What do you like best about DataGrip?** Clean, modern looking text editor interface that is easy on the eyes (I use the default dark theme). Integrates well with wide variety of databases. Overall, improves my ability to work with databases and productivity. **What do you dislike about DataGrip?** I dislike the number of small buttons and options. Sometimes hard to tell what they're used for. May include tool tips. **What problems is DataGrip solving and how is that benefiting you?** Analyze data to provide insight for management. Datagrip is a IDE to work with databases and write SQL. ### 6. Very good for DB **Rating:** 5.0/5.0 stars **Reviewed by:** Bubby C. | Application Developer, Mid-Market (51-1000 emp.) **Reviewed Date:** February 14, 2019 **What do you like best about DataGrip?** Interface, The UI and how easy to use the product with minial complex design **What do you dislike about DataGrip?** Close to none. nothing i just love this product **What problems is DataGrip solving and how is that benefiting you?** Easy to search across DB tables and even across schemas ### 7. A great tool to use for any database. **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Computer Software | Mid-Market (51-1000 emp.) **Reviewed Date:** February 01, 2019 **What do you like best about DataGrip?** I enjoy the easy of use and support available for Data grip. **What do you dislike about DataGrip?** When using Datagrip with many projects or a large database it can take a few seconds to boot up. This isnt awful but it is slower to start then other database utilities i have used in the past. **What problems is DataGrip solving and how is that benefiting you?** We use datagrip to manage our local and cloud databases. It allows us to quickly make small changes and ensure everything is running smoothly. ### 8. Easy to use **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Information Technology and Services | Small-Business (50 or fewer emp.) **Reviewed Date:** February 18, 2019 **What do you like best about DataGrip?** DataGrip provides a lot of functionality without setting up plugins Easier to use than other IDEs Integration into other jetbrains products **What do you dislike about DataGrip?** Errors often tend to be hard to debug in the console Can't put databases into folders for organization Pricey subscription model **What problems is DataGrip solving and how is that benefiting you?** Datagrip easily allows any database user to get access quickly without a lot of hassle or technical setup. ### 9. Used to connect to my PostgreSQL Server **Rating:** 4.5/5.0 stars **Reviewed by:** Verified User in Research | Mid-Market (51-1000 emp.) **Reviewed Date:** February 13, 2019 **What do you like best about DataGrip?** This is better than pgAdmin. It has a better user interface and you can choose your own color scheme. **What do you dislike about DataGrip?** I don't have many dislikes on this product, maybe it has only a few choices to select a theme. **What problems is DataGrip solving and how is that benefiting you?** A graphical user interface to connect to the PostgreSQL database. ### 10. Overall useful tool **Rating:** 3.5/5.0 stars **Reviewed by:** Verified User in Internet | Mid-Market (51-1000 emp.) **Reviewed Date:** November 02, 2018 **What do you like best about DataGrip?** Datagrip can be used in many applications, I am currently using it as a SQL editor. It works ok for that purpose. It has predictive selective running, can export results, can update table definitions easily **What do you dislike about DataGrip?** Too many buttons, really crowded UI. Not easy to understand what everything means **What problems is DataGrip solving and how is that benefiting you?** Having a reliable SQL editor ### 11. The best IDE for PostgreSQL **Rating:** 4.5/5.0 stars **Reviewed by:** Verified User in Research | Mid-Market (51-1000 emp.) **Reviewed Date:** January 31, 2019 **What do you like best about DataGrip?** What I like best about this product is the easiness for managing database objects. **What do you dislike about DataGrip?** Database drivers are not automatically installed. You still need to install updated drivers to connect to database servers. **What problems is DataGrip solving and how is that benefiting you?** Thick client IDE for managing PostgreSQL servers. ### 12. All for SQL and one for SQL **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Higher Education | Mid-Market (51-1000 emp.) **Reviewed Date:** January 18, 2019 **What do you like best about DataGrip?** Data grip is the best SQL IDE i have ever used. It allows me to connect to multiple databases and do complex queries between databases. **What do you dislike about DataGrip?** The only thing i dislike is the lack of styling options. **What problems is DataGrip solving and how is that benefiting you?** Mostly making cross database queries. ### 13. My GOTO IDE for interacting with MySQL and Redshift **Rating:** 5.0/5.0 stars **Reviewed by:** Aaron S. | Senior Software Engineer, Mid-Market (51-1000 emp.) **Reviewed Date:** December 28, 2017 **What do you like best about DataGrip?** This is the database IDE I've been waiting for. Excellent navigation between different data sources, each with different underlying storage engines. The tab completion is excellent. Built in handy functionality like exporting queries to CSV, or easily importing CSVs to table. Output log with transaction time is helpful as well. Also love that my keyboard shortcuts form other JetBrains IDEs work here. **What do you dislike about DataGrip?** Sometimes it can take a while to start up on my computer. Also every now and then I encounter weird errors copy/pasting the data. For example copying a query from the slow query log may result in the hex (which I then convert) instead of the text, or values for really large numbers are showed with some precision dropped. Also consoles get left open and sometimes I may have a bunch of consoles I've forgotten about. **Recommendations to others considering DataGrip:** They have a 30 day trial--use all of it. There can be a bit of a learning curve but once you get there its a fantastic tool. **What problems is DataGrip solving and how is that benefiting you?** Interacting with multiple databases, including RedShift--which DataGrip has made really easy. ### 14. Excellent Database IDE **Rating:** 5.0/5.0 stars **Reviewed by:** Eric B. | Software Support Engineer, Computer Software, Mid-Market (51-1000 emp.) **Reviewed Date:** December 21, 2017 **What do you like best about DataGrip?** The data grip interface is very user friendly compared to Microsoft Sql Server Management Studio. The database object autofill is extremely helpful when writing queries, and I haven't found another database IDE with object autofill that is as fast. The ability to automatically generate database diagrams is extremely useful if you are a spacial-visual learner. I also really like the fact that I can search table names easily by clicking a table name from the list and just starting to type. **What do you dislike about DataGrip?** I've noticed that sometimes the object autofill doesn't automatically filter down to a specific database when you open a console for a specific database on an environment. Similarly, if you pick a database for a console in the upper right with the dropdown list, I find that I still need to type 'USE [database_name]' and run before the object autofill will work. This is a small gripe since this is something you would normally have to do anyway with SSMS and others. Also, finding database triggers is a little tricky since they are not categorized into folders - you must know the table they reside in and find them in the table list. **Recommendations to others considering DataGrip:** I highly recommend you try DataGrip. For users less technical than database admins or developers, DataGrip offers some user-friendly features that make quickly accessing data and writing queries very easy. My company's database admins also use DataGrip on their mobile machines when working remotely because it is battery efficient and easy to use. **What problems is DataGrip solving and how is that benefiting you?** Most of my client services and professional services team has switched to data grip because it is much easier to use than competitors like RazorSQL with the object autofill. We have to frequently query our databases to pull up information and sometimes write to the database. Most of us have SQL experience but not all are experts on the database structure. Furthermore, with different environments having different builds, DataGrip makes it easy to autofill things like tables and columns that might be different from one database build to the next (rather than remembering differences in our heads). ### 15. not a very intuitive tool **Rating:** 3.0/5.0 stars **Reviewed by:** Nasir Q. | Application Architect, Enterprise (> 1000 emp.) **Reviewed Date:** August 29, 2018 **What do you like best about DataGrip?** nice interface , simple and elegant and can do basic database work quite elegantly **What do you dislike about DataGrip?** theres a lot of good tools in this arena sqlyog toad which are free not sure why will anyone go for the paid version , **What problems is DataGrip solving and how is that benefiting you?** connecting to databases , easy and intelligent query panel ### 16. Great IDE for databases however, with some misses **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Information Technology and Services | Enterprise (> 1000 emp.) **Reviewed Date:** January 30, 2018 **What do you like best about DataGrip?** Goes well with other JetBrains products, therefore, minimal learning curve Consumes lesser memory in comparison to other SQL development tools Supports most of the relational DBs including H2 in-memory Overall look and feel and the ability to add community plugins **What do you dislike about DataGrip?** No query designer Table visualization is not great. It's fine if you have a few tables not really meant to see the entire modeling. No query optimization on the fly. There are explain plans available but nothing compared to what Toad will give you. **Recommendations to others considering DataGrip:** I think it's a great SQL development tool to get started especially if you are into JetBrains Suite, however, if you plan on using it for SQL heavy development, this may not be what you are looking for. Pricing is somewhat expensive but gets better if you plan on having a perpetual license. But I would want to see the roadmap for the product before I plan to invest in it. **What problems is DataGrip solving and how is that benefiting you?** Data modeling Stored procedures Executing general queries Importing of data ### 17. DataGrip for local and cloud **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Retail | Mid-Market (51-1000 emp.) **Reviewed Date:** October 23, 2018 **What do you like best about DataGrip?** connecting to local databases as well as cloud based such as Snowflake, RDS etc. **What do you dislike about DataGrip?** I can't think of anything for this so far. **Recommendations to others considering DataGrip:** It is a good sql query and admin tool. **What problems is DataGrip solving and how is that benefiting you?** direct connection to data sources for validation of data warehouse ### 18. Good workbench for querying **Rating:** 3.5/5.0 stars **Reviewed by:** Duncan H. | BI Engineer II, Insurance, Mid-Market (51-1000 emp.) **Reviewed Date:** April 26, 2018 **What do you like best about DataGrip?** The autofill feature is nice and works so much better than SQL server management studio. **What do you dislike about DataGrip?** The setup initially is a little tricky and could require some help from your server team. **Recommendations to others considering DataGrip:** If you have love for a way better intellisense, then this product will get the job done. If you are fine without that feature, whatever workbench you are using will be just fine. **What problems is DataGrip solving and how is that benefiting you?** Querying with this makes life a little easier when you have multiple servers that come from different database types. You can query from redshift, mysql, snowflake, etc. ### 19. Datagrip - A great tool for SQL **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Information Services | Mid-Market (51-1000 emp.) **Reviewed Date:** January 23, 2018 **What do you like best about DataGrip?** Datagrip has amazing features. It is very useful to connect to databases and write SQL code in datagrip. Its extremely user interactive and has intricate features which are really helpful. There are great features where you can just type the table name anywhere and it shows the various options **What do you dislike about DataGrip?** Better search features could be implemented. Not that many tools have it. But if integrated into DataGrip, it would be useful. **Recommendations to others considering DataGrip:** I would highly recommend the product for people who are looking for a software to play around with SQL. Extremely user friendly and compact! **What problems is DataGrip solving and how is that benefiting you?** It is used for data manipulation and data validation. Data sits in the database and Datagrip is used to access the data and get insights out of it. It is an extremely useful tool for quick data work. ### 20. Great for running SQL tests! **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Hospital & Health Care | Mid-Market (51-1000 emp.) **Reviewed Date:** May 02, 2018 **What do you like best about DataGrip?** I love the ease of this program and the suggestions when you have an error. **What do you dislike about DataGrip?** I would like more information on errors. **Recommendations to others considering DataGrip:** It's a bit of a learning curve if you've never used anything like it before, but once you learn it, it's a huge resource. **What problems is DataGrip solving and how is that benefiting you?** I use DataGrip to test my queries before writing reports, it's a good way to see small sections of code. ### 21. Great product for database management **Rating:** 5.0/5.0 stars **Reviewed by:** Angelic T. | Scheduler Solutions Manager, Computer Software, Mid-Market (51-1000 emp.) **Reviewed Date:** December 14, 2017 **What do you like best about DataGrip?** I really like the auto-complete options for tables and rows that are being referenced. This allows us to have inexperienced users feel more comfortable making simple and complex sql calls. I also like that I can have multiple endpoints configured and easily toggle between the two. Also, making updates in the results view saves my team from making additional calls to update records. **What do you dislike about DataGrip?** A few of our team members are on the trial version. I wish this allowed them to be logged in longer but I understand. **What problems is DataGrip solving and how is that benefiting you?** We are not relying on database management experts to make our simple calls and updates, I can empower our team to do these instead. ### 22. DataGrip Solid **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Computer Software | Enterprise (> 1000 emp.) **Reviewed Date:** June 26, 2018 **What do you like best about DataGrip?** Sees my databases (mostly via jdbc) and info needed **What do you dislike about DataGrip?** No current bigquery support, that'd be great once ready. **Recommendations to others considering DataGrip:** give it a try **What problems is DataGrip solving and how is that benefiting you?** running queries ### 23. Good tool for SQL data access **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Financial Services | Mid-Market (51-1000 emp.) **Reviewed Date:** January 10, 2018 **What do you like best about DataGrip?** Ability to connect to multiple databases and dialects and ease of switching between them **What do you dislike about DataGrip?** Can feel overengineered for more junior or less experienced users that are new to SQL/data analysis **What problems is DataGrip solving and how is that benefiting you?** Ability to retrieve data from various databases that are used (Postgres Production, Postgres ETL, Redshift). This allows me and my team to gain valuable insights into how our Product is functioning and where we can make improvements. ### 24. Incredibly efficient for building and reviewing databases **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Marketing and Advertising | Enterprise (> 1000 emp.) **Reviewed Date:** January 29, 2018 **What do you like best about DataGrip?** Integration with database platforms. I use this to interact with PostgreSQL and MySQL databases and it is incredibly easy for a beginner to setup tables and relationships. **What do you dislike about DataGrip?** No quick logins with AWS. It would be great to login with an AWS accounts and pull all RDS instances under the account. **Recommendations to others considering DataGrip:** It’s a great tool to use with AWS and for rapid prototyping. **What problems is DataGrip solving and how is that benefiting you?** The ability to modify and backup your database quickly in a GUI has made this more valuable than any other similar tools like MYSQL Workbench. ### 25. Works as Advertised **Rating:** 4.5/5.0 stars **Reviewed by:** Verified User in Hospital & Health Care | Mid-Market (51-1000 emp.) **Reviewed Date:** December 29, 2017 **What do you like best about DataGrip?** Connections allow you to filter what schemata you can explore. This filters out admin schemata if you do not want to explore them. This does simple data migration. Ssh tunnel settings are super easy to use. Familiar navigation for WebStorm or IntelliJ users. **What do you dislike about DataGrip?** I miss having advanced features like schema comparison and upgrade and complex test data generation features. I am comparing to RedGate and SQL Management Studio. **Recommendations to others considering DataGrip:** Compare this to PGAdmin 4 **What problems is DataGrip solving and how is that benefiting you?** We have moved from self hosted MongoDb and SQL Server to AWS hosted PostgreSQL. We needed a decent tool for SSH tunneling into our database to look at data. ### 26. DataGrip **Rating:** 4.5/5.0 stars **Reviewed by:** Verified User in Computer Software | Mid-Market (51-1000 emp.) **Reviewed Date:** March 07, 2018 **What do you like best about DataGrip?** It detects probable bugs in the code and suggests the best option to fix them **What do you dislike about DataGrip?** It has issue with auto complete and there is no. way to simplify database connection management in case you have more than connections. **What problems is DataGrip solving and how is that benefiting you?** DataGrip provides robust tools that streamline SQL code writing and make entire process more efficient ### 27. Very helpful product **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Computer Software | Mid-Market (51-1000 emp.) **Reviewed Date:** January 27, 2018 **What do you like best about DataGrip?** It’s ability to connect to all types of data souecws **What do you dislike about DataGrip?** It’s ability to operate on multi screens **What problems is DataGrip solving and how is that benefiting you?** DB maintainance ## DataGrip Discussions - [How does DataGrip connect to database?](https://www.g2.com/discussions/how-does-datagrip-connect-to-database) - 1 comment - [Does PyCharm include DataGrip?](https://www.g2.com/discussions/does-pycharm-include-datagrip) - 1 comment - [View DataGrip pricing details and edition comparison](https://www.g2.com/products/datagrip/reviews?page=3§ion=pricing&secure%5Bexpires_at%5D=2026-07-15+13%3A00%3A52+-0500&secure%5Bsession_id%5D=2187d61b-ff49-450c-b777-96a3a9b24910&secure%5Btoken%5D=0168196dd614ef4c8979fd8ce39892edc6795c1503711050c699c787bda594a1&format=llm_user) ## DataGrip Features **Management** - Data dictionary - Data Replication - Query Language - Data Modeling - Performance Analysis **Maintenance** - Data Migration - Backup and Recovery - Multi-User Environment **Security** - Data Encryption - User Access Control ## Top DataGrip Alternatives - [Toad For Oracle](https://www.g2.com/products/quest-software-toad-for-oracle/reviews) - 4.4/5.0 (281 reviews) - [DbVisualizer](https://www.g2.com/products/dbvisualizer/reviews) - 4.7/5.0 (263 reviews) - [SQL Developer](https://www.g2.com/products/sql-developer/reviews) - 4.3/5.0 (246 reviews)