DataGrip

What is DataGrip?

Enjoy working with databases:

Learn about DataGrip, the new database IDE that is tailored to the specific needs of professional SQL developers.

Smart query console

Allows you to run queries in different modes and provide local history that tracks all your activity and protects you losing your work.

Efficient schema navigation:

Allows you to jump to any table, visualization or procedure by your name through the corresponding action, or directly its uses in SQL code.

Explain plan: Gives a detailed overview of how your queries work and the behavior of the database engine so that you can make your queries more efficient.

Smart code completion:

DataGrip provides context-sensitive code completion, helping you write SQL code faster. Completion is aware of the structure of tables, foreign keys, and even database objects created in the code you are editing.

Immediate analysis and quick solutions:

DataGrip detects likely errors in your code and suggests the best options for fixing them in real time. It will inform you immediately about unresolved objects, using keywords as identifiers and always offers the way to fix problems.

Refactoringthat works on SQL files and schemas: DataGrip correctly resolves all references in your SQL code and helps you restate them. When you rename a variable or alias, it updates its uses throughout the file. The names of the actual tables in the database are updated when you rename the references to your queries. There is even a preview of table usages/visualizations within other views, procedures and stored functions.

Version control integration:

We provide unified support for all major version control systems: Git, SVN, Mercurial and many others.

Features:

Exploring your databases: DataGrip is the multi-engine database environment. We support MySQL, PostgreSQL, Microsoft SQL Server, Oracle, Sybase, DB2, SQLite, HyperSQL, Apache Derby and H2. If the DBMS has a JDBC driver, you can connect to it through the DataGrip. For any of the supported engines, it provides database introspection and various tools for creating and modifying objects.

Database objects:

DataGrip introspects all objects in its databases and displays them grouped into folders by schemas. It also provides UI to add and edit tables, columns, indexes, constraints, etc.

Navigation:

Quick navigation brings you to any object, no matter if it has just been created in your code or has already been read a database. Navigating to the symbol action allows you to find objects by their name.

Table Editor:

The powerful table editor lets you add, remove, edit, and clone rows of data. Browse through the data by foreign keys and use text search to find anything in the data displayed in the table editor.

Smart coding assistance: Just like any decent IDE should, DataGrip provides intelligent code completion, code inspections, quick error resalts, and quick solutions and refactoring capabilities. It saves you time by making the process of writing SQL code more efficient.

Code completion:

DataGrip provides a context-sensitive, schema-aware code completion, helping you write code faster. Completion is aware of the structure of tables, foreign keys, and even database objects created in the code you are editing.

Code generation:

Forget to write typical code manually: DataGrip will do it for you. It generates code to change objects such as tables, columns, based on the UI. In addition, it helps you get DDL for tables and provides DML queries result sets.

Renaming and finding uses:

DataGrip correctly resolves all references in your SQL files. When you are renaming SQL database objects, they will also be renamed in the database. You can learn in which stored procedures, functions, or visualizations your table is used in.

Code analysis and quick solutions:

DataGrip detects likely errors in your SQL code and suggests the best options for fixing them in real time. It will immediately inform you about unresolved objects, use keywords as identifiers and always offers a way to fix the problem.

Smart Text Editor: Just like any IDE on the IntelliJ platform, DataGrip includes the code editor that helps you be more productive. Transform and move blocks of code, use multiple cursors to manage ion, format code according to specific style, and more.

Customize appearance:

DataGrip comes with clear and gloomy themes of appearance and appearance. Each of them can be fully customized, so you can create what suits you best. The same works for more than ten preconfigured mappings.

Running queries:

Writing queries is nothing without being able to execute them. The query console in DataGrip is the basic tool for any SQL developer. Create multiple consoles, each with its own schema and query options.

Query console: Specify the behavior of the console to run queries: Choose what you want to run - the smallest statement or the largest.

Local history:

Each console supports schema change and provides local history that tracks all your activity and protects you losing your job.

Diff Viewer: Use the difference viewer to compare two console snapshots in local history or two query results. DataGrip highlights differences and allows you to manage comparison criteria through the tolerance parameter.

Import/export options: Among other things, DataGrip comes with support user parameters, CSV editor, diagram builder, version control support, and many other features.

Import CSV:

Enjoy a dedicated UI to import CSV and TSV files into the database. You can map each column of the file being imported to a table column in your database, which can be an existing table or a new one created during the import process.

Export as text:

Any table or result set can be exported in various formats, including CSV, JSON, XML, and HTML. You can even create your own export format.

Export as queries:

Any table or result set can also be presented as a batch of UPDATE or INSERT statements, which can be useful for modifying data.

Diverse features:

Among other things, DataGrip comes with user parameter support, CSV editor, diagram builder, version control support, and many other features.

User parameters:

DataGrip supports the execution of parameterized SQL queries. Add your own parameter patterns using regular expressions and choose the SQL dialects to which those patterns will be applied.

Implementation plan:

An execution plan for claims visually represents the operations that the database performs to return the data required by your query. And it helps you optimize the query. Choose to view the plan graphically or in a table format.

Diagrams: Explore your tables and relationships in a insightful diagram. Database objects can also be modified directly it.

System requirements:

OS X 10.8 or higher

Microsoft Windows 7, 8, or 10 (including 64-bit)

GNOME or KDE desktop for Linux

1 GB of minimum RAM, 2 GB of RAM recommended