Getting started with 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.
To get a quick tour of basic DataGrip features, see the following introduction video.
First steps with DataGrip | ||
---|---|---|
Install and run | Connect to a database | Run a query |
Learn how to install DataGrip, run DataGrip for the first time, and get a quick UI reference. | Connect to a database, use the SSH connection, connect to a cloud database. | Open a database console and run a query. |
Work with query results | Use keyboard shortcuts | Get help from JetBrains |
Review query results, save them to a file or copy to a clipboard, compare two result sets. | Speed up your performance in DataGrip with keyboard shortcuts. | Still feeling puzzled, let us know, and we will help. |
Improve your skills | ||
Share your data sources | Source code navigation | Working with a source code |
Share your data source settings between different projects, different computers, and IDE installations. | Navigate to newly-created or already-existed objects in your code. Use the Navigate to a symbol action to find objects by their name. | Generate and complete your code, quickly find usages, analyze received results. |
Smart editor | Search for everything | Language injections |
Transform and move blocks of code, use multi-cursors, format code according to a specific style, and much more. | Search for a usage of any object in DataGrip, replace object names with the help of regular expressions, and exclude and include found items in your refactoring. | Inject HTML, CSS, XML, RegExp, and other XML-like languages into your SQL code. |
Boost your IDE experience | ||
Extend DataGrip functionality | Tutorials | Fresh news about DataGrip |
Add the HTTP client for REST queries, version control systems (VCS), Upsource, or find a plugin to your liking. | Learn how to use search, export data, or connect to Microsoft SQL Server. Step-by-step instructions cover beginner basics and advanced techniques. | Learn the latest news, master the latest features, and always stay tuned to DataGrip development. |