mission_statement
Phone - Australia: 1300 553 313
Hotline - New Zealand: 0800 450 168
JetBrains home

DataGrip

Many databases, one tool

DataGrip


DataGrip is an IDE for SQL tailored to suit the specific needs of professional database developers. Its functionality duplicates the official database plugins for IntelliJ IDEA, PhpStorm, PyCharm, and RubyMine. As a multi-engine database environment, DataGrip supports MySQL, PostgreSQL, Microsoft SQL Server, Oracle, Sybase, DB2, SQLite, HyperSQL, Apache Derby, and H2.

Intelligent query console

DataGrip

Allows you to execute queries in different modes and provides 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 corresponding action, or directly from its usages in the SQL code.

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.

Smart code completion

DataGrip 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-fixes

DataGrip 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 the way to fix problems.

Refactorings that work in SQL files and schemas

DataGrip 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 integration

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

 

Database management systems

DataGrip databases

 

DataGrip Features

Exploring your databases

DataGrip is a multi-engine database environment. It supports MySQL, PostgreSQL, Microsoft SQL Server, Microsoft Azure, Oracle, Amazon Redshift, Sybase, DB2, SQLite, HyperSQL, Apache Derby and H2. If the DBMS has a JDBC driver you can connect to it via DataGrip. For any of the supported engines it provides database introspection and various instruments for creating and modifying objects.

  • Database objects
    DataGrip introspects all objects in your databases and displays them grouped in folders by schemas. It also provides UI for adding and editing 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 from a database. Navigate to symbol action lets you find objects by their name.
  • Table editor
    Powerful table editor lets you add, remove, edit, and clone data rows. Navigate through the data by foreign keys and use the text search to find anything in the data displayed in the table editor.

 

 

Intelligent Coding Assistance

Just as any decent IDE should, DataGrip provides smart code completion, code inspections, on-the-fly error highlighting and quick-fixes, and refactoring capabilities. It saves your time by making the process of writing SQL code more efficient.

  • Code completion
    DataGrip provides context-sensitive, schema-aware code completion, helping you to write code faster. Completion is aware of the tables structure, foreign keys, and even database objects created in code you're editing.
  • Renaming and finding usages
    DataGrip correctly resolves all references in your SQL files. When you're renaming database objects from SQL, they will also be renamed in the database. You can learn in which stored procedures, functions or views your table is used.
  • Smart text editor
    Just as any IntelliJ platform IDE, DataGrip includes the code editor that helps you to be more productive. Transform and move blocks of code, use multi-cursors to manage selection, format code according to specific style, and much more.
  • Code generation
    Forget about writing typical code manually: DataGrip will do that for you. It generates code for changing objects like tables, columns, etc., based on UI. Moreover, it helps you to get DDL for tables and provides DML queries from result-sets.
  • Code analysis and quick-fixes
    DataGrip detects probable bugs in your SQL code and suggests the best options to fix them on the fly. It will immediately let you know about unresolved objects, the use of keywords as identifiers, and always offers a way to fix the problem.
  • Customise appearance
    DataGrip comes with light and dark look and feel themes. Each of them can be fully customized, so you can create the one that suits you best. Same works for more than ten pre-configured keymaps.

Running queries

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

  • Query console
    Specify console behavior for running queries: choose what you want to execute—the smallest statement or the largest one.
  • Diff viewer
    Use the diff viewer to compare two console snapshots in local history or two query results DataGrip highlights the differences and lets you manage the comparison criteria via the tolerance parameter.
  • Local history
    Each console support schema switching and provides local history that keeps track of all your activity and protects you from losing your work.

Import/export options

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

  • Import CSV
    Enjoy a dedicated UI for importing CSV and TSV files to the database. It's possible to map every column of the file being imported to a table column in your database, which can be either an existing table or a new one created during the import process.
  • Export as queries
    Any table or result-set can also be presented as a batch of UPDATE or INSERT statements, which can be helpful for modifying data.
  • Export as text
    Any table or result-set can be exported in a variety of formats including CSV, JSON, XML, and HTML. You can even create your own exporting format.

Miscellaneous features

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

  • User parameters
    DataGrip supports running parametrized SQL queries. Add your own parameter patterns using regular expressions and choose SQL dialects to which these patterns will apply.
  • Diagrams
    Explore your tables and their relationships on an insightful diagram. Database objects can be modified directly from it, too.
  • Execution plan
    An execution plan for statements visually represents the operations the database performs in order to return the data required by your query. and helps you optimise the query. Choose to view the plan graphically or in a table format.

* For more information or pricing call 1300 553 313 or email

 

 


For more information please contact the MicroWay sales team: buynow
Head Office
MicroWay Pty Ltd
PO Box 84,
Braeside, Victoria, 3195, Australia
Ph: 1300 553 313
Fax: 1300 132 709
email: sales@microway.com.au
ABN: 56 129 024 825
Sydney Sales Office
MicroWay Pty Ltd
PO Box 1733,
Crows Nest, NSW 1585, Australia
Tel: 1300 553 313
Fax: 1300 132 709
email: sales@microway.com.au
ABN: 56 129 024 825
New Zealand Sales Office
MicroWay Pty Ltd (NZ)
PO Box 912026
Victoria Street West
Auckland 1142, New Zealand
Tel: 0800 450 168
email: sales@microway.co.nz

International: call +61 3 9580 1333, fax +61 3 9580 8995

 
© 1995-2018 MicroWay Pty Ltd. All Rights Reserved. Terms and Privacy Policy.