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.

Info

Why DataGrip?

Why Choose JetBrains DataGrip?

JetBrains DataGrip is a powerful IDE built specifically for professional database developers and analysts. Designed to support a wide range of databases, it provides smart, efficient, and reliable tools to simplify database development, querying, and management.

💡 Intelligent SQL Assistance

DataGrip understands your code. It offers context-aware suggestions, detects errors as you type, and provides instant fixes. With smart code completion, refactoring tools, and on-the-fly analysis, you write better SQL faster.

🧩 Broad Database Support

Whether you work with PostgreSQL, MySQL, Oracle, SQL Server, MongoDB, or others, DataGrip connects seamlessly. You can manage multiple data sources in one place with consistent tooling and UI.

🔍 Powerful Data Tools

Explore and edit data with a customizable grid, query result filtering, and smart pagination. Modify tables, track schema changes, and preview DDL before applying updates — all from within the IDE.

🔐 Secure & Efficient Connectivity

DataGrip ensures secure connections with SSH tunnels, SSL support, and integrated authentication methods. Fragmented introspection and caching keep performance smooth, even with large databases.

🤖 Built-in AI Assistance

Get AI-powered query explanations, error resolutions, and text-to-SQL suggestions. DataGrip’s AI Assistant accelerates your work while helping you learn and refine your SQL.

🛠 Built for Developers

From version control integration to smart navigation, custom formatting, and robust debugging, DataGrip is tailored for developers who demand more than just a query editor.

Please click here to discover all the features!

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

Licensing

License Options

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.

Alfasoft can supply JetBrains licenses including New Subscriptions, Subscription Renewals, Lapsed Subscription Renewals, and Additional Developer Licenses.

Commercial Annual Subscription includes

Free unlimited email access to technical support and online support resources for the period of the Business Subscription
Free access to all bug-fix updates, minor releases, and major releases of the licensed JetBrains product during the term 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

Support

Resources

We recommend these online support pages and resources to make the most of your product.

Support

We offer technical support to all Alfasoft customers. We recommend visiting our Help Centre and Knowledge Base, where you will find helpful resources, including solutions to frequently encountered issues and a wealth of additional information.

If you cannot find the answer, please submit a support ticket at the Help Centre and Knowledgebase. When creating your ticket, please provide as much detail as possible. This will help us better understand the issue and provide a more accurate solution. Always remember to provide information about your product version and operating system.