DataGrip – a powerful Oracle GUI tool for Windows, macOS, and Linux.
JetBrains DataGrip is a cross-platform IDE for working with SQL, which supports Oracle and many other databases. DataGrip helps Oracle developers increase their productivity by automating routine tasks, highlighting and fixing errors, and providing the benefits of smart code completion, a debugger, and many other features.
DataGrip provides accurate Oracle syntax highlighting and supports all of the important types of objects in your Oracle database.
Coding is what most developers spend the bulk of their time doing in an IDE. DataGrip’s smart features like auto-completion, code snippets, formatter, refactorings, and various intention actions help you code faster. Concentrate on the logic, not on what you need to type!
DataGrip provides a smart data editor with the ability to add, delete, and change data. All of the queries DataGrip runs during data updates can later be found in its SQL log, so you can perform the same changes against another database.
DataGrip’s data extractor supports many formats, including SQL INSERTS, SQL UPDATES, CSV, JSON, XML, and others. The mechanism is customizable, so you can create your own formats such as Markdown or plaintext.
If you work with SQL files stored on your computer, then you might already have a working directory with tons of scripts. DataGrip provides a handy interface for that. Attach folders from your computer, associate them with data sources, run scripts against several databases, or even use built-in Git integration!
There are many ways to customize the DataGrip interface. You can choose from any of the default color schemes or create your own, mark data sources with different colors, and even customize or set up your own keyboard scheme.
The debugger helps you find errors in your code by investigating its runtime behavior. With DataGrip’s debugger, you can go through your code line by line, step into and out of called routines, evaluate expressions, and watch variables as their values change.
The debugger is based on the Oracle Probe which uses the API from the DBMS_DEBUG package, and it works on Oracle servers 9.0 and later. In Oracle, you can debug anonymous blocks, packages, procedures, functions, and triggers.
DataGrip lets you quickly navigate through package sources. You can navigate from the declaration of the function to its implementation and vice versa.
DataGrip displays Database links in the Database Explorer. You can map your database link in an Oracle database to any existing data source so that code completion and resolution will work for queries using those external objects.
utPLSQL is a popular framework for testing PL/SQL code in Oracle databases. DataGrip has built-in support for utPLSQL, meaning that you can run tests and test packages without having to leave the code editor. Just click the small green play button in the left-hand pane.
DataGrip uses a JDBC driver to connect to your Oracle database, which will be downloaded automatically when testing the connection. In addition to the main credentials you’ll need in order to connect (such as port, user, and password), you can set several options for the new Oracle data source:
Once you’re connected to your Oracle database, you’ll see the list of objects in the left-hand pane, called the Database Explorer. Here you can filter objects and choose which schemas should be shown.
DataGrip can help you detect bugs and problems that may arise in your SQL code before you compile and run it. Here are just a few examples of DataGrip catching mistakes and bringing them to your attention.