DataGrip
Tool for SQL and databases
What is DataGrip?
DataGrip is a database IDE from JetBrains that is tailored to suit specific needs of professional SQL developers.
— Intelligent query console Allows you to write queries with coding assistance, errors indicating. Code completion is fast and context-aware. Executes queries in different modes and provides the local history that keeps track of all your activity and protects you from losing your work.
— Efficient schema navigation 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.
— Data editor Supports multiple submit/delete, multiple copy-paste, local changes, paste from external sources (like Excel), navigation by foreign keys.
— Explain plan Gives you an extended insight into how your queries work and into database engine behavior so you can make your queries more efficient.
Supported database servers: MySQL, MariaDB, SQL Server, Oracle Database, PostgreSQL, AWS Redshift, MS Azure Database, SQLite, HyperSQL, Sybase, IBM DB2, H2, Exasol, Cassandra, ClickHouse.
DataGrip Screenshots
DataGrip Features
DataGrip information
Supported Languages
- English
Comments and Reviews
Tags
- SQL
- postgres
- sqlserver
- MySQL
- derby
- oracle-gui-tool
- Microsoft SQL Server
- sql-server-tool
- database-browser
- mysql-gui
- jdbc
- database-development
- postgresql-tool
- Database
- redshift
- postgresql
- hsqldb
- sybase
- database-applications
Category
DevelopmentLists containing DataGrip
Core, Development & Services • Softwares • Windows Dev Tools • ml softwarezzRecent user activities on DataGrip
vincent-koshiv thinks dbForge Studio for MySQL is an alternative to DataGrip- marek-fabian thinks dbForge Studio for MySQL is an alternative to DataGripFaster and more convenient
- kliff-tulip thinks dbForge Studio for MySQL is an alternative to DataGrip
First SQL database front end I've used that feels as pleasant as Microsoft's offerings, with the benefit of supporting many more databases. My other experience is with older versions of PgAdmin and a number of free/open source alternatives.
I started with PgAdmin3 on PostgreSQL in 2014. PgAdmin3 was basic, but fast and quite useful. When we got hit with PgAdmin4, I decided to stick with PgAdmin3; 4 was impossible to use (I have some 300+ functions and 500+ tables). But ultimately, with successive Postgres versions coming in, I had to leave PgAdmin3 behind in 2021. By that time, PgAdmin4 had the necessary features, but it was impossible to use because extremely clumsy and slow. I then decided to install Datagrip at a cost of €107 per year as a private user. What a difference! I should have done so years ago. If you spend more than 5 hours a week with PgAdmin4 instead of Datagrip, and you are not dirt poor, you are wasting your time, as I have done for years.
Very good high-end tool for data management - definitely right up there with the likes of Toad, Aqua, etc. A bit sluggish and slow to respond at times. But what a memory hog. Single DB connection and nothing else opened - 1.7 GB! Glad I have 16 GB on the machine...
Probably the best on it's category. Too bad closed source. So I've used it in some companies which licensed it, but for personal use cases I go with dbeaver.
Needed a tool to import csv's into a DB2 database and DbVisualiser free version wouldn't do it. Didn't find an alternative here.
DataGrip can do that: https://www.jetbrains.com/datagrip/features/importexport.html
Reply written ago