---
title: DataGrip
canonical: https://saasranked.com/software/datagrip/
category: Database Client Software
points: 81
rank: 4 of 12
facts_checked: 2026-10-08
---

# DataGrip

Paid database IDE for Windows, macOS and Linux that is free only for non-commercial use.

81 points out of 100. #4 of 12 database clients. Vendor: JetBrains. Website: https://www.jetbrains.com/datagrip/

- An individual subscription costs €109 for the first year, then €87 and €65 in later years [2].
- The free offer covers non-commercial use only; commercial use needs a paid plan [1][3].
- After 12 months of uninterrupted paid subscription you get a perpetual fallback licence for the last major version available when you started [3][4].
- The data-sources docs name all nine engine groups we count, from PostgreSQL to Snowflake [7].
- Release 2026.2.6 is dated 29 September 2026 [5].

Verdict: DataGrip suits professionals who want SQL editing, diagrams, schema compare and query plans in one IDE [10][11][12][15]. The individual plan costs €109 in the first year and falls to €87 and €65 in later years [2]. A perpetual fallback licence applies after 12 months of uninterrupted payments [3][4]. The catch: the free version covers non-commercial use only [1]. Best for: Developers who write a lot of SQL and want an IDE-style editor.

## Points

| Criterion | Line | Value | Points | Note |
|---|---|---|---|---|
| Systems | Other systems | macOS, Linux | 6/6 | Installation guide lists Windows, macOS 15 and 26, and several Linux distributions [6]. |
| Databases | Main SQL engines | PostgreSQL, MySQL or MariaDB, SQL Server, Oracle, SQLite | 15/15 | The data sources docs list all five, with MariaDB and MySQL separate [7]. |
| Databases | NoSQL and cloud engines | MongoDB, Redis, BigQuery, Snowflake | 8/8 | The data sources docs list MongoDB, Redis, Google BigQuery and Snowflake [7]. |
| Databases | JDBC or ODBC drivers | Yes | 4/4 | Docs say you can specify your own JDBC driver for a data source by adding a driver JAR [8]. |
| Connections and trust | SSH tunnel | Yes | 8/8 | Docs say to select Use SSH tunnel on the SSH/SSL tab of a data source [9]. |
| Connections and trust | Open-source apps | Not published | 0/6 | Not published on the vendor's product page [1]. |
| Connections and trust | Recent release | Yes | 3/3 | JetBrains' release feed lists version 2026.2.6 dated 29 September 2026 [5]. |
| Tools | SQL code completion | Yes | 4/4 | The SQL support page says DataGrip suggests JOIN statements and fills INSERT fields from the schema [10]. |
| Tools | Visual query builder | Not published | 0/3 | Not published on the vendor's SQL support page [10]; it describes a visual table editor, not a query builder. |
| Tools | ER diagrams | Yes | 4/4 | Docs say database diagrams show tables and the relations between them, from a connected database [11]. |
| Tools | Schema or data compare | Yes | 4/4 | Docs say you can compare two schemas, tables or routines and see differences [12]. |
| Tools | Import from CSV or Excel | Yes | 4/4 | Docs describe importing CSV, TSV and other delimited text files into tables [13]. |
| Tools | Export formats | CSV, Excel, JSON | 3/3 | Export docs list TXT, CSV, JSON, XML, Markdown, Excel and other formats [14]. |
| Tools | Query plan viewer | Yes | 4/4 | Docs show query plans as a tree and as a diagram [15]. |
| Tools | AI assistant | Yes | 3/3 | Features overview says the JetBrains AI Assistant helps you write SQL from natural language; no beta or preview label [16]. |
| Price | Free edition | No | 0/6 | The product page says free for non-commercial use, and otherwise offers a 30-day trial [1]. |
| Price | Perpetual licence | Yes | 5/5 | Individual and organization plans include a perpetual fallback licence after 12 months of paid subscription [3][4]. |
| Price | Cheapest paid plan | $121.93/yr | 6/10 | Individual plan, €109 first year, from data embedded in the pricing page. Commercial work is allowed on individual plans [2][3]. Converted at €1 = $1.1186 [17]. |

## Plans

| Plan | Price | Per month (USD) |
|---|---|---|
| Non-commercial | Free [1] | $0 |
| Individual (yearly) | €109 first year [2] | $10.16 |
| Individual (monthly) | €10.90/month [2][3] | $12.19 |
| Organization (yearly) | €259/year [2][3] | $24.14 |

The pricing page shows euros for the region it detected; dollar figures are converted at the ECB rate. Prices exclude VAT. Individual plans fall from €109 to €87 and €65 in years two and three [2].

## Strengths

- Names all nine engine groups we count in its data-sources docs [7].
- Runs on Windows, macOS and Linux [6].
- Includes schema comparison, ER diagrams and a graphical query plan [11][12][15].
- Exports to CSV, JSON, Excel and more, and imports delimited files [13][14].
- A perpetual fallback licence applies after 12 months of uninterrupted paid subscription [3][4].

## Limits

- Free use is limited to non-commercial work; there is only a 30-day trial otherwise [1].
- Individual subscriptions cannot be bought by companies; organizations need the €259 plan [2][3].
- The pricing page shows euros, so the dollar cost depends on the exchange rate [2].
- The fallback licence needs 12 months of uninterrupted payments [3][4].

## Vendor claims (not scored)

- JetBrains says DataGrip lets you connect to more than 50 supported databases [16].

## Sources

1. [DataGrip: The Cross-Platform IDE for Databases & SQL](https://www.jetbrains.com/datagrip/), JetBrains, accessed 2026-10-08
2. [Buy DataGrip: Pricing and Licensing](https://www.jetbrains.com/datagrip/buy/), JetBrains, accessed 2026-10-08
3. [Individual and organization licences compared](https://www.jetbrains.com/store/comparison.html), JetBrains, accessed 2026-10-08
4. [What is a perpetual fallback license?](https://sales.jetbrains.com/hc/en-gb/articles/207240845-What-is-a-perpetual-fallback-license), JetBrains, accessed 2026-10-08
5. [DataGrip release feed](https://data.services.jetbrains.com/products/releases?code=DG&latest=true&type=release), JetBrains, accessed 2026-10-08
6. [Installation guide](https://www.jetbrains.com/help/datagrip/installation-guide.html), JetBrains, accessed 2026-10-08
7. [Data sources and drivers dialog](https://www.jetbrains.com/help/datagrip/data-sources-and-drivers-dialog.html), JetBrains, accessed 2026-10-08
8. [JDBC drivers](https://www.jetbrains.com/help/datagrip/jdbc-drivers.html), JetBrains, accessed 2026-10-08
9. [Connect to a database with SSH](https://www.jetbrains.com/help/datagrip/connect-to-a-database-with-ssh.html), JetBrains, accessed 2026-10-08
10. [SQL support](https://lp.jetbrains.com/sql-support/), JetBrains, accessed 2026-10-08
11. [Diagrams](https://www.jetbrains.com/help/datagrip/creating-diagrams.html), JetBrains, accessed 2026-10-08
12. [Schema comparison and migration](https://www.jetbrains.com/help/datagrip/schema-comparison-and-migration.html), JetBrains, accessed 2026-10-08
13. [Import data](https://www.jetbrains.com/help/datagrip/import-data.html), JetBrains, accessed 2026-10-08
14. [Export data](https://www.jetbrains.com/help/datagrip/export-data.html), JetBrains, accessed 2026-10-08
15. [Query execution plan](https://www.jetbrains.com/help/datagrip/query-execution-plan.html), JetBrains, accessed 2026-10-08
16. [DataGrip features overview](https://lp.jetbrains.com/features-overview/), JetBrains, accessed 2026-10-08
17. [Euro foreign exchange reference rates: US dollar](https://www.ecb.europa.eu/stats/policy_and_exchange_rates/euro_reference_exchange_rates/html/eurofxref-graph-usd.en.html), European Central Bank, accessed 2026-10-08