DataGrip

Many Databases – One Tool

DataGrip is a database management environment for developers. It is designed to query, create, and manage databases. Databases can work locally, on a server, or in the cloud. Supports MySQL, PostgreSQL, Microsoft SQL Server, Oracle, and more. If you have a JDBC driver, add it to DataGrip, connect to your DBMS, and start working.

DataGrip also provides integration with version control systems and allows for easy management of multiple connections to different databases. It also included features like ER Diagrams, Data export/import, and it’s available for Windows, Linux and macOS.

Intelligent query console
Allows 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 navigation
Lets 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 plan
Gives you an extended insight into how your queries work and into the database engine behaviour, 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 the 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 immediately lets 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 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 usage 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 the usages of tables/views inside other views, stored procedures and functions.

Ohjelmasta

Why DataGrip?

Enjoy working with databases?

Meet DataGrip, our new database IDE tailored to suit professional SQL developers’ specific needs.

Please click here to discover all the features!

Uutta

What’s New in DataGrip 2023.1

Ominaisuudet

Snowflake
- The LIKE ALL operator is now supported.
- New aggregate functions are now supported.
- The functions MIN_BY and MAX_BY are now supported.
- Added support for string literals as a body for Snowflake Scripting procedures.

Please click here to see what’s new!

System

System requirements for Datagrip

Xcode 12.5-13.3
macOS 11 or higher
2 GB free RAM minimum, 8 GB of total system RAM recommended
2.5 GB hard disk space, SSD recommended
1024×768 minimum screen resolution

Lisensointi

Lisenssivaihtoehdot

JetBrains uses a subscription-based licensing model, allowing you to purchase yearly subscriptions that include all bug-fix updates. The new licensing model also includes perpetual fallback license grants. When purchasing an annual subscription, you will immediately get a perpetual fallback license for the exact version available at the time of your purchase.

Commercial Annual Subscription for legal entities, including companies and organizations (both for-profit and non-profit), requiring the software for general commercial use. A legal entity may use the software under the Business Subscription on any computer, operating system, and by any developer within a legal entity, provided that the total number of concurrent users never exceeds the number of subscriptions purchased by that legal entity.

Commercial Annual Subscription includes

Free unlimited email access to technical support and online support resources for the period of the Business Subscription
Free generally available bug fix upgrades, minor releases and major releases for the licensed JetBrains IntelliJ IDEA edition for the period of the Business Subscription
Available to any legal entity (companies and organizations, including non-profit and government)
The license is owned by the legal entity, not by an individual
Non-transferable restriction: Use of the software is restricted to the legal entity with no right to transfer. Companies and organizations can only transfer their licenses between employees and contractors
The licensed purpose of the use is general commercial usage
Multi-user license – the total number of concurrent software users cannot exceed the number of purchased subscriptions
The license term is time-limited, based on yearly subscription payments
Perpetual fallback license: Your license is NOT perpetual. The new licensing model includes perpetual fallback license grants. A perpetual fallback license is a license that allows you to use a specific version of the software after your Business Subscription expires. The specific version of the software you can fall back to using when your Business Subscription expires will be the exact version available at the time of your purchase.

Comparison of Commercial and Personal License

Commercial Licence (Business and Organizations)

Available to: Any legal entity (companies and organisations, including non-profit and government)
Multi-user license: Yes, the total number of concurrent software users cannot exceed the number of purchased subscriptions
License term: Time-limited, based on monthly and yearly subscription payments
Fallback License grant: Yes, 12 preceding months of uninterrupted subscription payments are required

Personal Licence (Individual)

Available to: Private individuals purchasing with their own funds. Cannot be purchased or reimbursed by companies
Multi-user license: No, the software can be used solely by the person who purchased a subscription
License term: Time-limited, based on monthly and yearly subscription payments
Fallback License grant: Yes, 12 preceding months of uninterrupted subscription payments are required

Tuki

Datagrip Support

In the subscription, the following Support and Maintenance with JetBrains is included.

Unlimited access to technical support via e-mail
Free upgrades to all minor and major releases, including bug fixes

Please click here to contact JetBrains support!