FAQ about DataGrip
- General questions
- Is there a DataGrip Community edition?
- How to get DataGrip for free or at a discount?
- Is DataGrip available via the JetBrains Toolbox as part of the All Products Pack?
- What is the difference between DataGrip and the Database plugin in other IntelliJ IDE products like IDEA, PyCharm, PhpStorm?
- What about version control systems?
- In addition to databases and SQL, which web technologies does DataGrip support?
- How to leave feedback or submit a bug?
- Are stored code debugging, administration tools, and NoSQL features planned?
- What about data visualization, like graphs or pie-charts?
- How can I help make the product better?
- Configuring connections
- Can I use DataGrip with SQL dialects that are not listed?
- I cannot connect to the database. What should I do?
- How should I connect to Microsoft SQL Server?
- MySQL shows NULL instead of '0000-00-00 00:00:00' in datetime field. Why?
- DataGrip shows time in the local time zone, I want it to be shown in UTC, what should I do?
- Working with data sources
- Export and import
- Working in the editor
Is there a DataGrip Community edition?
No, as there is no way to separate DataGrip functionality into free and paid tiers. You can still try DataGrip by using a free 30-day trial or Early Access Program (pre-release) versions as long as they are available.
How to get DataGrip for free or at a discount?
If you want to get a DataGrip license for free or at a discount, check out the offers on the following page: Toolbox Subscription - Special Offers. If you have any questions, contact our sales support.
Free individual licenses are available for students, faculty members, and core contributors to open source projects.
Free individual licenses for students and faculty members: see who can apply for free licenses and how you can do that.
Free Open Source Licenses: see application terms, license terms, and restrictions.
Is DataGrip available via the JetBrains Toolbox as part of the All Products Pack?
Yes, it is available both as a standalone IDE and as a part of the All Products Pack.
What is the difference between DataGrip and the Database plugin in other IntelliJ IDE products like IDEA, PyCharm, PhpStorm?
It is the same. DataGrip and the Database plugin for IntelliJ IDEA have the same functionality.
What about version control systems?
DataGrip supports Git, SVN, Mercurial, and other version control systems (VCS). This support is not bundled. It means that you need to install corresponding plugins to have VCS in DataGrip.
In addition to databases and SQL, which web technologies does DataGrip support?
In addition to tools for database management, DataGrip supports HTML, XML, Docker, Git, an HTTP client for testing web services, and other technologies.
How to leave feedback or submit a bug?
The Getting help topic describes how to leave feedback, report a bug, or submit a feature request.
Youtrack issues for DataGrip: log in to your JetBrains account and click New issue.
Requests in the JetBrains Support Center: click the Submit a request button that is at the top of the main page.
Twitter: tweet us about your problem. Mention @datagrip in your tweet.
firstname.lastname@example.org: email our team about your problem. Describe your problem, and attach all available materials that can speed up troubleshooting (code samples, screenshots, logs, animations, videos, and other materials).
Are stored code debugging, administration tools, and NoSQL features planned?
Yes, we are going to add this functionality in future versions. You can share your thoughts with us and add your vote for the NoSQL support in this Youtrack ticket.
What about data visualization, like graphs or pie-charts?
No, there is no data visualization in DataGrip yet.
How can I help make the product better?
The best way is to share your feedback. Feel free to report bugs and submit feature requests through our issue tracker.
Getting help: this help page lists various sources of information, ways to collect troubleshooting materials, and provide feedback.
Can I use DataGrip with SQL dialects that are not listed?
Yes, DataGrip can connect to any database that has a JDBC-driver. For example, with the 2019.3 version, you can connect to Firebird, SAP Hana, Athena, Teradata, and BigQuery.
With a JDBC-driver, you can connect to a database, view database objects, and run queries. Also, you will have some generic code completion and syntax highlighting (based on SQL92). Advanced features like enhanced code completion, database-specific syntax highlighting, and better retrieval of database objects (introspection) are not supported.
Create a connection to a database with a JDBC driver: see how to create a connection with a JDBC driver.
I cannot connect to the database. What should I do?
Try to follow the steps in the Troubleshooting tutorial. If you still experience problems,
Create a connection to a database with a JDBC driver: how to create a connection with a JDBC driver.
Cannot connect to MySQL 5.1: how to connect to MySQL 5.1.
How to connect to MS SQL server: how to connect to an instance of Microsoft SQL Server.
How to connect to SQL Server Express LocalDB: how to connect to SQL Server Express LocalDB.
How to connect to Heroku Postgres without SSL validation: how to connect to Heroku Postgres without SSL validation.
How to connect to Cassandra with SSL: how to connect to Cassandra with SSL.
How should I connect to Microsoft SQL Server?
See the How to connect to MS SQL server tutorial that shows how to establish an SQL Server connection.
We explicitly support MS SQL Server 10.50 2008 R2 and later. If you have earlier versions, go to the Options tab in data source settings and select Introspect using JDBC metadata.
MySQL shows NULL instead of '0000-00-00 00:00:00' in datetime field. Why?
Because of the
ZeroDateTimeBehavior driver option that is set to
CONVERT_TO_NULL in the data source settings.
To configure the
ZeroDateTimeBehavior option, open the Data Sources and Drivers dialog by pressing Ctrl+Shift+Alt+S, select the MySQL data source, and click the Advanced tab. In the options table, search for
ZeroDateTimeBehavior. To set other options, click the corresponding cell in the Value column and select the value from the drop-down list.
DataGrip shows time in the local time zone, I want it to be shown in UTC, what should I do?
On the Advanced tab in the data source settings, type
-Duser.timezone=UTC in the VM options field.
-Duser.timezone=UTC to VM options, open the Data Sources and Drivers dialog by pressing Ctrl+Shift+Alt+S, select the MySQL data source, and click the Advanced tab. In the VM options field, type
Working with data sources
Can I mark data sources as Production, Staging, or Test?
You can mark your data sources with colors.
In the Database tool window ( ), press Ctrl and click data sources that you want to mark. Right-click the selection and navigate to Color Settings. In the Database Color Settings dialog, configure color and appearance settings.
How to put data sources into folders?
In the Database tool window ( ), press F6, and create a new group. To add a data source to the existing group, click the data source, and press F6. Select the group in which you want to add the data source.
Group data sources: see what other actions with data source groups are available.
How can I share data sources between DataGrip and other IntelliJ IDE?
In the Database tool window ( ), press Ctrl and click data sources that you want to share. Right-click the selection and navigate to .
On another workstation, click Database tool window, click the New icon and select Import from Clipboard.. In the
Managing data sources: see how to create data sources, group data them in directories, import and export their settings.
Export and import
How do I export data to a format I need?
In DataGrip, you can create your own format of export. This format must be described as an extractor file. To know how to use custom extractors, see our tutorial: Export data in any way with IntelliJ-based IDEs.
My Clojure extractors do not work anymore. What should I do?
DataGrip does not bundle the Clojure engine. To enable Clojure extractors, install the
IntelliJ scripting: Clojure plugin.
Managing plugins: see how to install and delete plugins, work with custom plugin repositories, write your own plugins.
Working in the editor
Can I work with existing SQL files from my machine?
Yes, you need to attach your work directory.
In the Files tool window, right-click any area and select Attach directory. Navigate to the directory that you want to attach and click OK.
User files: see how to attach and detach a directory.
How to see the total row count of the result set?
In the tab with the result set, click the part of the page counter that displays of N+, where
N is the number of rows that is set by the Limit page size to option.
N updates and displays the total row count.
How to generate the SELECT * FROM query from the Database tool window?
You can double-click the table in the Database tool window ( ). The table opens in the table view. In the table view, you can edit cell values, use paging, sort columns, and do other table operations.
If you want to generate a template for the
SELECT * FROM table query, use the
sel live template. Open a console by pressing F4, type
sel, select the
sel template from the context menu, and press Enter.
Can I generate a diagram for database objects?
Yes, you can create a diagram for a data source, a schema, or a table.
In the Database tool window ( ), right-click a database object and select .
Creating diagrams: see how to generate diagrams, execution and query plans.