database client · JetBrains

DataGrip

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

81/100

#4 of 12 database clients
Facts checked 8 Oct 2026

In short

An individual subscription costs €109 for the first year, then €87 and €65 in later years².
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⁷.
Release 2026.2.6 is dated 29 September 2026⁵.

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². A perpetual fallback licence applies after 12 months of uninterrupted payments^3,4. The catch: the free version covers non-commercial use only¹.

Best for: Developers who write a lot of SQL and want an IDE-style editor.

Where the points come from

Systems6 of 6

Databases27 of 27

Connections and trust11 of 17

Tools26 of 29

Price11 of 21

Systems 6 of 6 points

Rule	What is published	Points
Other systems	macOS, LinuxInstallation guide lists Windows, macOS 15 and 26, and several Linux distributions⁶.	6 / 6

Databases 27 of 27 points

Rule	What is published	Points
Main SQL engines	PostgreSQL, MySQL or MariaDB, SQL Server, Oracle, SQLiteThe data sources docs list all five, with MariaDB and MySQL separate⁷.	15 / 15
NoSQL and cloud engines	MongoDB, Redis, BigQuery, SnowflakeThe data sources docs list MongoDB, Redis, Google BigQuery and Snowflake⁷.	8 / 8
JDBC or ODBC drivers	YesDocs say you can specify your own JDBC driver for a data source by adding a driver JAR⁸.	4 / 4

Connections and trust 11 of 17 points

Rule	What is published	Points
SSH tunnel	YesDocs say to select Use SSH tunnel on the SSH/SSL tab of a data source⁹.	8 / 8
Open-source apps	Not publishedNot published on the vendor's product page¹.	0 / 6
Recent release	YesJetBrains' release feed lists version 2026.2.6 dated 29 September 2026⁵.	3 / 3

Tools 26 of 29 points

Rule	What is published	Points
SQL code completion	YesThe SQL support page says DataGrip suggests JOIN statements and fills INSERT fields from the schema¹⁰.	4 / 4
Visual query builder	Not publishedNot published on the vendor's SQL support page¹⁰; it describes a visual table editor, not a query builder.	0 / 3
ER diagrams	YesDocs say database diagrams show tables and the relations between them, from a connected database¹¹.	4 / 4
Schema or data compare	YesDocs say you can compare two schemas, tables or routines and see differences¹².	4 / 4
Import from CSV or Excel	YesDocs describe importing CSV, TSV and other delimited text files into tables¹³.	4 / 4
Export formats	CSV, Excel, JSONExport docs list TXT, CSV, JSON, XML, Markdown, Excel and other formats¹⁴.	3 / 3
Query plan viewer	YesDocs show query plans as a tree and as a diagram¹⁵.	4 / 4
AI assistant	YesFeatures overview says the JetBrains AI Assistant helps you write SQL from natural language; no beta or preview label¹⁶.	3 / 3

Price 11 of 21 points

Rule	What is published	Points
Free edition	NoThe product page says free for non-commercial use, and otherwise offers a 30-day trial¹.	0 / 6
Perpetual licence	YesIndividual and organization plans include a perpetual fallback licence after 12 months of paid subscription^3,4.	5 / 5
Cheapest paid plan	$121.93/yrIndividual 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¹⁷.	6 / 10

The rule behind each line: how we score database clients.

Plans and prices

As the vendor lists them, before tax. Prices are in US dollars unless the plan shows euros; the points use US dollars, with euros converted at the ECB rate.

Plan	Price as listed	Per month	Notes
Non-commercial1 person	Free¹	$0	Free for non-commercial use only
Individual (yearly)1 person	€109 first year²	$10.16	Falls to €87 in year two and €65 from year three
Individual (monthly)1 person	€10.90/month^2,3	$12.19	For people paying with their own money
Organization (yearly)Companies and teams	€259/year^2,3	$24.14	Billed to a legal entity

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².

Strengths

Names all nine engine groups we count in its data-sources docs⁷.
Runs on Windows, macOS and Linux⁶.
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¹.
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².
The fallback licence needs 12 months of uninterrupted payments^3,4.

What JetBrains says

Vendor claims. We show them, but they earn no points.

JetBrains says DataGrip lets you connect to more than 50 supported databases¹⁶.

Other database clients

1
DBeaverDevelopers and analysts who work with many database engines
91/100
$113/yrcheapest paid plan
2
DbVisualizerDevelopers who connect to many engines and want a free edition for basic work
84/100
$199/yrcheapest paid plan
3
Beekeeper StudioDevelopers who want a multi-engine client with a free open-source edition
81/100
$108/yrcheapest paid plan
5
DbGateDevelopers who want a free open-source client, with paid tools for query design and compare
79/100
$120/yrcheapest paid plan

All 12 database clients

Sources

DataGrip: The Cross-Platform IDE for Databases & SQL, JetBrains. Accessed 8 Oct 2026.
Buy DataGrip: Pricing and Licensing, JetBrains. Accessed 8 Oct 2026.
Individual and organization licences compared, JetBrains. Accessed 8 Oct 2026.
What is a perpetual fallback license?, JetBrains. Accessed 8 Oct 2026.
DataGrip release feed, JetBrains. Accessed 8 Oct 2026.
Installation guide, JetBrains. Accessed 8 Oct 2026.
Data sources and drivers dialog, JetBrains. Accessed 8 Oct 2026.
JDBC drivers, JetBrains. Accessed 8 Oct 2026.
Connect to a database with SSH, JetBrains. Accessed 8 Oct 2026.
SQL support, JetBrains. Accessed 8 Oct 2026.
Diagrams, JetBrains. Accessed 8 Oct 2026.
Schema comparison and migration, JetBrains. Accessed 8 Oct 2026.
Import data, JetBrains. Accessed 8 Oct 2026.
Export data, JetBrains. Accessed 8 Oct 2026.
Query execution plan, JetBrains. Accessed 8 Oct 2026.
DataGrip features overview, JetBrains. Accessed 8 Oct 2026.
Euro foreign exchange reference rates: US dollar, European Central Bank. Accessed 8 Oct 2026.

Website: www.jetbrains.com/datagrip · Markdown version · We are not affiliated with JetBrains.