JetBrains DataGrip is a universal tool for dealing with databases. It supports PostgreSQL, MySQL, SQL Server, Oracle, MongoDB, and many other databases. DOWNLOAD A 30-DAY TRIAL FOR DATAGRIP When you work with databases, you’re exploring the data contained in them. And there are times you’ll want to manipulate that data without having to write queries. DataGrip has your needs covered with its smart data editor, a mini spreadsheet right inside your IDE. Let’s take a closer look at some of the data viewing and editing perks inside DataGrip. 1. Data search When working with a table, ent

We’re pleased to introduce DataGrip 2019.3. This is the third major update of 2019, and it’s packed with various enhancements. Let’s take a look at what it has to offer! MongoDB support The day has finally come for us to start adding MongoDB support. Since the request received more than 400 votes, we decided that the time was ripe to begin including basic functionality for it. Here’s a quick overview of the MongoDB features that work in this version: Introspection: You can observe collections and fields in the database explorer. Data viewer: Open any collection or observe th

Hello! We’ve just released DataGrip 2019.2. In this post, we’ll highlight the new features briefly. For detailed descriptions, please visit the What’s new page. Services tool window — Observe and manage all the connections — Manage Docker services — Query live timer Full-text search — Search for data everywhere — SQL preview — Search in columns that don’t support the LIKE operator Data editor — The page size is easy to change — The results tabs can be named Database tree view — Quick table backup — Quick group creation — Force Refresh action — Table comment

Hello! No long preamble, we have begun our DataGrip 2019.2 EAP! Let’s look at what’s inside. Services tool window All our IDEs now have a new tool window called Services. In DataGrip, you can observe and manage all the connections there. Here is how it looks: Every connection has its own node under the corresponding data source. If the small green light on the icon is on, it means that the connection is alive. You can close any of them. You can view all the service types as nodes, or you can alter the view to see them as tabs. Use the Show in New Tab action from the toolbar or

Hello everybody! We are excited to release DataGrip 2019.1 today! As usual, we thank all our early adopters who have helped us make the IDE better during this release cycle. If you wish to see the detailed overview of this update, please visit our What’s new page. Read on for a list of all the enhancements waiting for you in 2019.1. Support for new databases In this release cycle, we focused a lot on supporting several new databases. Greenplum is an analytics database based on PostgreSQL. It is currently developed by Pivotal and the open source community. Vertica is column-or

DataGrip is a universal tool for dealing with databases. It supports PostgreSQL, MySQL, SQL Server, Oracle, and many other databases. DOWNLOAD A 30-DAY TRIAL FOR DATAGRIP One of the most important activities for anyone working with databases is writing SQL. Built on IntelliJ Platform, DataGrip makes coding an enjoyable experience by automating repetitive tasks: as an SQL developer, you probably have many! Let’s have a closer look at some of the nice SQL-related perks inside DataGrip. 1. Live Templates DataGrip has code snippets called Live Templates. Use them to generate repetitive pa

For those eager to try the newest things, we invite you to join our Early Access Program for DataGrip 2019.1. As you may know, these builds don’t require a license – we just want everybody to try the new features out before the official release. Let’s go! New databases: Greenplum, Vertica, and Apache Hive In this release cycle, we focused a lot on supporting several new databases. Greenplum is an analytics database based on PostgreSQL. It is currently developed by Pivotal and the open source community. For now, we have only SQL support for Greenplum; native database introspection

All IDEs based on the IntelliJ Platform have Version Control System integration. DataGrip is no exception! But because database developers usually do things a little differently from other developers and because DataGrip’s project model has its own specific workflow, the integration between the IDE and VCS support isn’t quite as straightforward as with other JetBrains IDEs. We’ll cover two general use cases: — Cloning an existing GitHub repository with SQL scripts and other files — Sharing a user scripts directory on GitHub In DataGrip, VCS support doesn’t come out of the box. To hav

With just a few weeks since the last minor update, we're in hurry again to bring you a fresh portion of improvements. Please welcome DataGrip 2018.2.2. One of the highlights in this update is added support for ClickHouse (an open-source analytic DBMS for big data from Yandex). The update offers a dedicated driver, and allows you to browse the tables, views, table data, run queries, and pretty much everything (except exporting data and modifying tables). Also, the update addresses the following issues: The default row height in the Modify Table dialog is equal to the biggest row i

Please welcome DataGrip 2017.3, the third big update of 2017, packed with various enhancements. Let’s have a look what it has to offer! — Database tree view — SQL — Executing queries — Connectivity — Data editor — Navigation Database tree view Group data sources Closing an old outstanding ticket with a number less than 100 is not a situation that we frequently find ourselves in; especially when it’s for such a long-awaited feature. We are happy to introduce you to our new feature: group data sources. Press F6 or choose Move to group… from the context menu. Group is the attribut

In DataGrip, as well as all other JetBrains IDEs that feature database support, there is a powerful engine to export data in many formats. You can even create your own export format. Let’s look closer at this engine. Export directions Any table/view or result-set can be exported to a file or copied to the clipboard. To export to file:       — Context menu on a table/view and → Dump data to file.       — Context menu on a query and → Execute to file.       — In the toolbar of the result-set or data editor, select Dump data button → To File... To export to the clipboard:

Search and navigation tips When you work with a software tool, you often need to find something or other. In DataGrip, you could be looking for things like: — Database objects: tables, views, procedures, columns and so on. — Data: enough said. — Code: for example a piece of code in a big script or the source code for a database object. — Lots of other things: files, settings, IDE actions, etc. Finding what you need easily is crucial to user experience, which is why we focus heavily on making search and navigation intuitive in DataGrip. Let’s look closer at how not to get lost in the