datagrip is a database ide from jetbrains that is tailored to suit specific needs of professional sql developers.
— intelligent query consoleallows you to write queries with coding assistance, errors indicating. code completion is fast and contextaware. executes queries in different modes and provides local history that keeps track of all your activity and protects you from losing your work.
— efficient schema navigationlets 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 editorsupports multiple submit/delete, multiple copypaste, local changes, paste from extrenal sources (like excel), navigation by foreign keys.
— explain plangives 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, sql server, oracle database, postgresql, aws redshift, ms azure, sqlite, hypersql, sybase, ibm db2, h2, exasol
            
                
                
                    Links to official DataGrip sites
                    
                                            
                    
                        Features
                    
                    
                                            
                    
                        Categories
                    
                    
                                                    
                                Productivity                            
                                                    
                                Developer Tools                            
                                                    
                                Home and Family                            
                                            
                    Tags
                    
                                                    database
                                                    database-management
                                                    jdbc
                                                    mysql
                                                    sql
                                                    sql-server
                                                    sqlite
                                                    database-browser
                                                    postgresql
                                                    postgresql-tool
                                                    sqlserver
                                                    database-development
                                                    postgres
                                                    database-applications
                                                    derby
                                                    hsqldb
                                                    mysql-gui
                                                    oracle-gui-tool
                                                    redshift
                                                    sql-server-tool
                                                    sybase