Database tool window
Enable the Database Tools and SQL plugin
This functionality relies on the Database Tools and SQL plugin, which is bundled and enabled in CLion by default. If the relevant features are not available, make sure that you did not disable the plugin.
Press Ctrl+Alt+S to open settings and then select
.Open the Installed tab, find the Database Tools and SQL plugin, and select the checkbox next to the plugin name.
Overview
In the Database tool window ( ) , you can work with databases and DDL data sources. You can view and modify data structures in your databases and perform other associated tasks.
The available data sources are shown as a tree of data sources, schemas, tables, and so on.
![the Database window the Database window](https://resources.jetbrains.com/help/img/idea/2024.2/db_database_tool_window.png)
If no data sources are currently defined, use the New command Alt+Insert to create a data source and connect to a database. For more information about data sources, refer to the Data sources topic.
Once CLion is connected to a database, Database tool window will display the introspected database objects. For more information about the objects viewing options, refer to the View Options chapter. For more information about working with database objects in CLion, refer to the Database objects section.
Most of the functions in this window are accessed by using the toolbar icons or context menu commands. Many of the commands have keyboard shortcuts. If the toolbar is hidden, the Refresh and Open Query Console commands can be access by using the header buttons ( and
respectively).
Title bar
Toolbar
You can right-click the window header and use the context menu to configure its viewing mode, associate the window with a different tool window bar, or resize and hide the window.
You can also use the toolbar buttons:
Item | Shortcut | Description |
---|---|---|
Automatically sets the focus on the object name in the Database tool window when the editor area is in focus. | ||
Ctrl+NumPad + | Expand all nodes in the current view. | |
Ctrl+NumPad - | Collapse all expanded nodes in the current view. | |
Shift+Escape | Hide the tool window . To hide all the tool windows, press Ctrl+Shift+F12. |
Context menu
Item | Description |
---|---|
Autoscroll from Editor | Makes the database object, that is opened in the editor, automatically selected in the Database tool window. Disables the |
| Opens the input field of the Speed Search in tool windows feature. |
Show Toolbar | Display the toolbar in the Database tool window. |
View Mode | This option lets you control general appearance and behavior of the tool window. For full information, refer to Viewing modes. |
Move to | To associate the tool window with a different tool window bar, select this command, and then select the destination tool window bar (Top, Left, Bottom or Right). For full information, refer to the Move tool windows chapter. |
Resize | To resize the tool window by moving one of its borders, select this command, and then select the necessary Stretch to option. Note that this command is not available for the floating mode. |
Remove from Sidebar | This command hides the tool window, removes the associated tool window button from the tool window bar, and removes the tool window from the quick access menu ( To open the tool window again (and restore the associated features), use the main menu: or press Alt+1. |
Help | This command opens the description of the Project tool window in the CLion online help. |
Toolbar controls
![Database tool window toolbar Database tool window toolbar](https://resources.jetbrains.com/help/img/idea/2024.2/database_tool_window_toolbar.png)
Icon | Command | Shortcut | Description | Available for |
---|---|---|---|---|
New | Alt+Insert | Create a new data source, role, database, schema, query console, table, column, index, or a primary or a foreign key. The list of options depends on which element is currently selected. | Data sources and their elements. If a DDL data source is selected, you can only choose to create another data source. | |
Data Source Properties | Open the Data Sources and Drivers dialog to manage your data sources and their settings. | All node types | ||
Refresh | Ctrl+F5 | Update the view of the selected element (that is to synchronize the view of the element with its actual state in the database). See also, Data Sources and Drivers dialog. | Data sources and their elements. | |
Deactivate Ctrl+F2 | Ctrl+F2 | Close the database connection for the selected data source or data sources. (The data sources with connected sessions are indicated with a green dot in the corner of their icon.) | Data sources with active connections and their elements | |
Jump to Query Console | Ctrl+Shift+F10 | Open the list of query consoles for the selected data source. | Data sources and their elements (tables and table columns) | |
Edit Data | F4 | Open a table view of the object in the data editor. This option works for tables, views, and materialized views. | Corresponding elements in data sources. | |
| Go to DDL | Ctrl+B | Open the DDL script of the selected object. For example, if you press this shortcut on a table's name in the ![]() | Corresponding elements in data sources. |
Compare Structure | Ctrl+D | Compare the structure of two database objects in the Migration dialog. | Two selected database objects of the same kind. | |
View Options | Open the list of database object tree viewing options, including the item filter. For more information about the options, refer to the View Options chapter. | All items. |
View Options
![Database tool window Options menu items Database tool window Options menu items](https://resources.jetbrains.com/help/img/idea/2024.2/database_tool_window_options_menu_items.png)
Context menu
Context-menu actions appear when you right-click an object in the Database tool window.
Command | Shortcut | Description | Available for |
---|---|---|---|
Properties | Open the Data Sources and Drivers dialog to manage your data sources and their settings. | Data source and DDL data source nodes. | |
New | Alt+Insert | Create a new data source, role, database, schema, query console, table, column, index, a primary, or a foreign key. The list of options depends on which element is currently selected. | Data sources and their elements. If a DDL data source is selected, you can only choose to create another data source. |
Rename | Shift+F6 | Rename the selected item. Specify the new name in the dialog that opens. | Data sources and their elements. |
Copy/Paste | Copy Reference | Ctrl+Alt+Shift+C | Copy the fully qualified name of the selected item to the clipboard. | Data sources and their elements. |
Copy/Paste | Duplicate | Ctrl+D | Create a copy of the selected data source. Specify the properties of the data source in the Data Sources and Drivers dialog that opens. | Data source and DDL data source nodes. |
Edit Data | F4 | Open a table view of the object in the data editor. This option works for tables, views, and materialized views. | Corresponding elements in data sources. |
Refresh | Ctrl+F5 | Update the view of the selected element (that is to synchronize the view of the element with its actual state in the database). See also, Data Sources and Drivers dialog. | Data sources and their elements. |
Deactivate Ctrl+F2 | Ctrl+F2 | Close the database connection for the selected data source or data sources. (The data sources with connected sessions are indicated with a green dot in the corner of their icon.) | Data sources with active connections and their elements |
Drop or Remove | Delete | Remove the selected item. | Data sources and their elements. |
Quick Documentation | Ctrl+Q | View basic information about the selected element. To close the documentation popup, press Escape. | Data sources and their elements. |
Navigation | Go to DDL | Ctrl+B | Open the DDL script of the selected object. For example, if you press this shortcut on a table's name in the ![]() | Corresponding elements in data sources. |
Navigation | Jump to Query Console | Ctrl+Shift+F10 | Open the list of query consoles for the selected data source. | Data sources and their elements (tables and table columns) |
Run Function or Run Procedure | Run the selected function or procedure. | Data source elements: functions, procedures. | |
(Oracle only) Introspection Level | Change the introspection level either for the whole database or for a particular schema. Children inherit a level that is set for a parent. | Oracle Data Source nodes. | |
SQL Scripts | SQL Generator | Ctrl+Alt+G | Generate data definition structures for database objects. For example, you can generate DDL files for a single table or for all the tables in the schema. Also, you can customize generation settings. For example, you can set what syntax to use for table creation: For more information, refer to the Generate DDL definitions for database objects and Change output settings of the SQL Generator chapters. | Data source elements. |
SQL Scripts | Generate DDL to Clipboard | Ctrl+Alt+Shift+G | Generate a DDL of the object and copy it to the clipboard. | Data sources and their elements. |
SQL Scripts | Truncate… | Remove all the rows in the selected table. | Data source elements: tables. | |
Tools | Manage Shown Schemas | Open a popup with available schemas for the current data source. See also, Show and hide schemas. | Data sources and their elements. | |
Tools | Compare Structure | Ctrl+D | Compare structures of two selected database objects (data sources, schemas, or tables). The comparison results are shown in the Diff Viewer. | Data sources and their elements. |
Tools | Full-text Search | Shift+Ctrl+Alt+F | Search for data in your databases or a group of databases without knowing the data's exact location. | Data sources and their elements. |
Tools | Set Color | Set or change the color for the selected element or elements. (The Database Color Settings dialog will open.) To set a color, right-click a data source and select Tools | Set Color. In the Database Color Settings dialog, select the dialog and coloring options. To have the data source color applied for query consoles and grids, select the In console editors and grids checkbox. See also, Assign a color to query consoles and grids. | Data sources and their elements. | |
Tools | Add Bookmark | F11 | Add the selected item to bookmarks. | Data sources and their elements. |
Tools | Scripted Extensions | Generate POJOs.clj | Generate a Java entity class for the selected table. In the dialog that opens, specify the directory in which the JAVA class file should be generated. | Data sources and their elements. | |
Tools | Scripted Extensions | Go To Scripts Directory | Switch to the directory where the Generate POJOs.clj example script file is located. | Data sources and their elements. | |
Import/Export | Export Data to File | Save data for the selected tables and views in files. Select the output format (for example, SQL Inserts, Tab-separated (TSV), JSON-Clojure.json.clj). | Data source elements: tables and views. | |
Import/Export | Import Data from File(s)… | Import a text file containing delimiter-separated values (CSV, TSV, and so on) into your database. If a schema is currently selected, CLion will create a new table for the data that you are importing. If a table is selected, CLion will try to add the data to the selected table. | Data source elements: tables. | |
Import/Export | Copy Table to | F5 | Create a copy of the selected table. You can create a copy in a different scheme or data source. For example, you can copy the | Database objects: tables and views. |
Import/Export | Dump to DDL Data Source | Create your DDL data source by dumping a regular data source to a root/repository folder. | Data sources and their elements. | |
Import/Export | Export with 'mysqldump' or Import/Export | Export with 'pg_dump' | Run mysqldump or pg_dump for the selected items. mysqldump and pg_dump are native MySQL and PostgreSQL tools. They are not integrated into CLion. You can read about them at dev.mysql.com and postgresql.org. | Data source nodes. | |
Import/Export | Restore with 'mysql' or Import/Export | Restore with 'psql' or Restore | Run mysql, pg_restore, or psql to restore a data dump. These tools are native for MySQL and PostgreSQL. They are not integrated into CLion. You can read about them at dev.mysql.com and postgresql.org. | Data source nodes. | |
Diagrams | Show Visualisation and Diagrams | Show Visualisation Popup | Ctrl+Alt+Shift+U and Ctrl+Alt+U | View a UML class diagram for the selected data source or table. You can select between the following options:
| Data sources and their elements. |
Diagnostics | Dump Model | Generate a diagnostic representation of the database in a CLion internal format. This information might be helpful for the support team if some database objects exist in the database but do not show up in the Database tool window. | Data sources and their elements. | |
Diagnostics | Diagnostic Refresh | Reload the metadata from the database and generate a detailed log file of the process. This information might be helpful for the support team when your introspection takes too much time. | Data sources and their elements. | |
Diagnostics | Prepare Introspector Diagnostics | Generate three files that include information about the following:
This information might be helpful when introspection works incorrectly. For example, when you see something outdated or do not see new objects. | Data sources and their elements. | |
Diagnostics | Force Refresh | Ctrl+Shift+F5 | Delete the data source information from cache and load it again. This action is available on the data source node only. | Data source nodes. |
Diagnostics | Forget This Schema Cache | Delete the information that CLion has accumulated about your database. This action is available on the data source node only. Use this command when you experience issues like wrong display of data structures or errors during synchronization. To check if this has eliminated the problem, use the Synchronize command. | Data source nodes. |
Icons
Data sources and their elements
Icon | Description |
---|---|
Access Method | |
Aggregate | |
Alias Type | |
Argument | |
Body | |
Check | |
Cluster | |
Collation | |
Collection Type | |
Column. For more information about column icon combinations, refer to Possible icon combinations for columns. | |
Data File | |
Database | |
Read-only status | |
DDL data source | |
Default | |
Exception | |
Extension | |
External Schema | |
Foreign Data Wrapper | |
Foreign Key | |
Foreign Table | |
Index | |
Key | |
Materialized Log | |
Materialized View | |
Object Attribute | |
Object Type | |
Operator | |
Package | |
Primary key | |
Projection | |
Data sources | |
Role | |
Routine | |
Rule | |
Scheduled Event | |
Schema | |
Sequence | |
Server | |
Stored procedure or function | |
Synonym | |
Table | |
Table Type | |
Tablespace | |
Trigger | |
User | |
User Mapping | |
Variable | |
View | |
Virtual column | |
Virtual foreign key | |
Virtual view | |
Virtual Table |
Possible icon combinations for columns
Icon | Foreign key | Primary key | Indexed | NOT NULL |
---|---|---|---|---|