DataGrip: The Cross-Platform IDE for Databases & SQL by JetBrains

WhyDataGripEnjoy workingwith databasesMeet DataGrip, our new database IDE that is tailored to suit the specific needs of professional SQL developers.Intelligent query consoleAllows 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.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.Explain planGives you an extended insight into how your queries work and into the database engine behavior, so you can make your queries more efficient.Smart code completionDataGrip 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.On-the-fly analysis and quick-fixesDataGrip 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.Refactorings that work in SQL files and schemasDataGrip correctly resolves all references in your SQL code and helps you refactor them. When you rename a variable or an alias, it will update their usages throughout the entire file. The actual table names in the database are updated when you rename references to them from your queries. There is even a preview of usages of tables/views inside other views, stored procedures and functions.Version control integrationWe provide unified support for all major version control systems: Git, SVN, Mercurial and many others.Discover all featuresJoin Our CustomersCompanies all over the world use DataGrip. Join them and get the best development experience.Is your favourite database missing?Help us support it!PostgreSQLMySQLOracle DatabaseSQL ServerAzureAmazon RedshiftSQLiteDB2H2SybaseExasolApache DerbyMariaDBHyperSQLClickHouseCassandraVerticaGreenplumApache HiveSnowflake