DataGrip 2019.3 Help

Meet DataGrip

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.

Video introduction to DataGrip

To get a quick tour of basic DataGrip features, see the following introduction video.

First steps with DataGrip

These set of topics are focused on describing features, functionality, the application interface, and might help you to get started quickly.

Connect

Start working with your data source by creating a connection to it.

Run a query

Connect an SQL file to a data source and run your code.

View results

Connect an SQL file to a data source and run your code.

Export/Import

Import and export your data to and from various formats with or without special tools like mysqldump, pg_dump, pg_restore, or psql. Also, you can have a look at the How to export data in DataGrip tutorial in the Tutorials section.

LocalDB

Step-by-step tutorial how to create, connect, and start working with your SQL Server Express LocalDB instance.

Microsoft SQL server

Another tutorial that shows you how to start working with Microsoft SQL server and connect to its instance with Windows domain or SQL Server authentication.

Troubleshooting

Connectivity issue is a very common definition and might include many problems. This troubleshooting article will guide you through the most common steps to identify and fix the issue. If you could not find the answer, try to contact JetBrains and we can try to help you.

Setup

Learn how to install DataGrip and run it for the first time.

Diagrams

Generate diagrams for database objects, build query and execution plans, generate flame graphs for EXPLAIN statements.

Shortcuts

Speed up your performance in DataGrip with keyboard shortcuts.

Top plugin downloads

DataGrip supports different plugins. By installing a plugin, you can get a support for additional version control systems, integrations with different tools and frameworks, and editor enhancements.

BashSupportBashSupport
.​ignore
.​ignore
Markdown
Markdown

Adds Bash language support for the IntelliJ platform.

Adds support to work with .ignore files like .gitignore (Git), .hgignore (Mercurial), .npmignore (NPM), .dockerignore (Docker), and other.

Provides the capability to edit Markdown files within the IDE and see the rendered HTML in a live preview.

NodeJS
NodeJS
IdeaVim
IdeaVim
Grazie
Grazie

Edit CSV/TSV/PSV files with a table editor, syntax validation, structure highlighting, customizable coloring, new intention actions and inspections.

Emulates Vim for IDEs based on the IntelliJ platform.

Provides intelligent spelling and grammar checks for texts that you write in the IDE.

Find more plugins at plugins.jetbrains.com

Last modified: 23 January 2020