DataGrip: the power of SQL IDE
2025TL; DR
This talk by Max Sobolevskiy introduces DataGrip, a database IDE by JetBrains. It covers advanced IntelliSense, AI-powered SQL assistance, editing result sets, data import/export, navigation tools, and other productivity-boosting features. DataGrip's goal is to automate repetitive tasks for developers, and this session explores how well it achieves that goal.
Session Details
In this talk Max Sobolevskiy is going to show what DataGrip is about. From basics — how to write a simple query faster to some more complicated stuff: using multiple cursors, transposing tables.
What will be covered:
— Various types of intellisense, code snippets, expanding wildcards, working with subqueries.
— Data editor. Editable result-sets, bulk submit, multiple submit, transposing data.
— Data import/export. Import from CSV file, export to JSON or UPDATES, INSERTS. Export to other databases.
— Navigation. Searching for database objects, data, SQL code, files, settings etc.
— AI Assistant: Text-to-SQL, Fix with AI, AI-based export.
— Other features. Diagrams, user parameters, diff tool.
There is the only target DataGrip is made for: relieve the developer from repetitive work. From this talk you will know if JetBrains made success with it.
What will be covered:
— Various types of intellisense, code snippets, expanding wildcards, working with subqueries.
— Data editor. Editable result-sets, bulk submit, multiple submit, transposing data.
— Data import/export. Import from CSV file, export to JSON or UPDATES, INSERTS. Export to other databases.
— Navigation. Searching for database objects, data, SQL code, files, settings etc.
— AI Assistant: Text-to-SQL, Fix with AI, AI-based export.
— Other features. Diagrams, user parameters, diff tool.
There is the only target DataGrip is made for: relieve the developer from repetitive work. From this talk you will know if JetBrains made success with it.
3 things you'll get out of this session
– How to wite SQL x times faster
– How to deal with your database data like you work in Excel
– AI for databases: how it can be useful