Databases and SQL
IntelliJ IDEA features for working with databases and SQL include:
Integration with the most popular database management systems such as Oracle, PostgreSQL, MySQL, SQL Server and others. To be able to work with your databases, you should define them as data sources. See Connecting to a database.
Database tool window for managing data structures in your databases ( ). See Customizing the database tree view.
Database consoles that let you compose and execute SQL statements as well as analyze and modify retrieved data (Ctrl+Shift+F10 in the Database tool window). See Working with database consoles.
Data editor that provides a GUI for working with table data (F4 in the Database tool window). See Working with tables.
- SQL code generation and editing features in the database consoles and the editor, e.g.
Predefined code snippets (a.k.a. live templates) such as for
UPDATEand other statements (Ctrl+J).
Auto-completion and highlighting of SQL keywords, and table and column names.
Data type prompts for columns (Ctrl+P).
Standardized and DBMS-specific SQL dialects are supported.
- Navigation capabilities, e.g.
From a table or column reference to its definition: Ctrl+B.
To the view of a table or column in the Database tool window: Alt+F1 .
By means of the navigation bar: Alt+Home.
By means of the Switcher: Ctrl+Tab.
Database diagrams (Ctrl+Alt+U or Ctrl+Shift+Alt+U in the Database tool window).