# Database Output tool window > For the complete documentation index, see [llms.txt](https://www.jetbrains.com/help/idea/2026.3/llms.txt). > **TL;DR** > `View | Tool Windows | Database Output` Procedure: Enable the Database Tools and SQL plugin This functionality relies on the Database Tools and SQL plugin, which is bundled and enabled in IntelliJ IDEA by default. If the relevant features are not available, make sure that you did not disable the plugin. > **Note:** > Database Tools and SQL functionality support is limited in IntelliJ IDEA without the Ultimate subscription. 1. Press `Ctrl+Alt+S` (Windows), `⌘ Comma` (macOS), `⌘ Comma` (IntelliJ IDEA Classic (macOS)), `⌘ Comma` (macOS System Shortcuts), `Ctrl+Alt+S` (XWin), `Ctrl+Alt+S` (GNOME), `Ctrl+Alt+S` (KDE), `Ctrl+Alt+S` (Emacs), `Ctrl+Alt+S` (Sublime Text), `⌘ Comma` (Sublime Text (macOS)), `Ctrl+Alt+S` (Visual Studio), `⌘ Comma` (Visual Studio (macOS)), `Ctrl+Alt+S` (NetBeans), `Ctrl+Alt+S` (Eclipse), `⌘ Comma` (Eclipse (macOS)) to open settings and then select `Plugins`. 2. Find the Database Tools and SQL plugin and click Enable. The Database Output tool window displays execution output, query results, and query execution plans. You can use it to switch between results from query consoles and SQL files, view the queries that produced them, and open result sets in separate editor tabs. The tool window opens automatically when you [run a query](run-a-query.html), a database [run configuration](run-debug-configuration.html#launch-run-configuration), an [SQL file](run-sql-files.html), or generate a [query execution plan](query-execution-plan.html). By default, it opens at the bottom of the IDE. ![Database Output tool window](https://resources.jetbrains.com/help/img/idea/2026.3/database_output_tool_window.png) You can switch from displaying query results in the Services tool window to displaying them in the Database Output tool window. To do this, press `Ctrl+Alt+S` (Windows), `⌘ Comma` (macOS), `⌘ Comma` (IntelliJ IDEA Classic (macOS)), `⌘ Comma` (macOS System Shortcuts), `Ctrl+Alt+S` (XWin), `Ctrl+Alt+S` (GNOME), `Ctrl+Alt+S` (KDE), `Ctrl+Alt+S` (Emacs), `Ctrl+Alt+S` (Sublime Text), `⌘ Comma` (Sublime Text (macOS)), `Ctrl+Alt+S` (Visual Studio), `⌘ Comma` (Visual Studio (macOS)), `Ctrl+Alt+S` (NetBeans), `Ctrl+Alt+S` (Eclipse), `⌘ Comma` (Eclipse (macOS)) to open settings and select Tools | Database | Query Execution | Output and Results . In Show results in, select Database Output tool window. [Session management](managing-connection-sessions.html) remains in the Services tool window. ## Contents overview The tool window contains the following elements: Output tab: ![Output tab of the Database Output tool window](https://resources.jetbrains.com/help/img/idea/2026.3/db_database_output_tw_contents_tab_output.png) Result tab: ![Result tab of the Database Output tool window](https://resources.jetbrains.com/help/img/idea/2026.3/db_database_output_tw_contents_tab_result.png) Query Plan tab: ![Result tab of the Database Output tool window](https://resources.jetbrains.com/help/img/idea/2026.3/db_database_output_tw_contents_tab_query_plan.png) 1. [Output tab](#output_tab). 2. [Result tab](#result_tab). 3. [Query Plan tab](#query_plan_tab). 4. [Session clients dropdown](#session_clients_dropdown). By default, the contents of the tool window follow the active editor tab, showing the corresponding output, query results, and query plan. When you switch to a query console that has no results, the tool window displays its Output tab. Running a query automatically selects the relevant result tab. Procedure: Open session details * To open session details for the selected query console or file, open the sessions dropdown on the right side of the toolbar and select Manage Sessions. IntelliJ IDEA opens the corresponding session details in the Services tool window. For more information about managing sessions and attaching clients to them, refer to [Sessions](managing-connection-sessions.html). ## Output tab The Output tab displays a log of executed SQL statements and database operations, including execution messages and errors. Depending on the operation and output settings, the log can also include timestamps, affected row counts, and execution times. The tab also displays output from queries that IntelliJ IDEA runs when you open a database table in the data editor. For output settings, refer to [Output and Results](output-and-results.html). ![Output tab of the Database Output tool window](https://resources.jetbrains.com/help/img/idea/2026.3/db_database_output_tw_tab_output.png) ### Toolbar `Tx` Transaction Mode and Transaction Isolation : Select the [isolation level](https://en.wikipedia.org/wiki/Isolation_(database_systems)) for database transactions and the way the transactions are committed. : : : : * Auto: the current transaction is committed automatically when you submit your local changes to the database server. : : * Manual: the changes submitted to the database server are accumulated in a transaction that can either be committed or rolled back explicitly by means of ![the Submit and Commit icon](https://resources.jetbrains.com/help/img/idea/2026.3/database-plugin.icons.expui.commit.svg) Submit and Commit or ![the Roll Back button](https://resources.jetbrains.com/help/img/idea/2026.3/database-plugin.icons.expui.rollback.svg) Roll Back buttons on the toolbar. : : : : For more information about database transaction modes and isolation, refer to [Submit changes to a database](submitting-and-reverting-changes.html). ![the Cancel Running Statements icon](https://resources.jetbrains.com/help/img/idea/2026.3/app-client.expui.run.stop.svg) Cancel Running Statements `Ctrl+F2` (Windows), `⌘ F2` (macOS), `⌘ F2` (IntelliJ IDEA Classic (macOS)), `⌃ ⇧ .` (macOS System Shortcuts), `Ctrl+F2` (XWin), `Ctrl+F2` (GNOME), `Ctrl+2` (KDE), `Ctrl+F2` (Emacs), `Ctrl+F2` (Sublime Text), `Ctrl+F2` (Sublime Text (macOS)), `Shift+F5` (Visual Studio), `⇧ F5` (Visual Studio (macOS)), `Shift+F5` (NetBeans), `Ctrl+F2` (Eclipse), `⌘ F2` (Eclipse (macOS)) : Terminate execution of the current statement or statements. ![the Restore General Layout icon](https://resources.jetbrains.com/help/img/idea/2026.3/app-client.expui.general.layout.svg) Restore Default Layout : Restore default positions of visual elements in the tab. ### Right toolbar ![the Soft-wrap icon](https://resources.jetbrains.com/help/img/idea/2026.3/app-client.expui.general.softWrap.svg) Soft-Wrap : Wrap long lines of text. ![the Scroll to End icon](https://resources.jetbrains.com/help/img/idea/2026.3/app-client.expui.general.scrollDown.svg) Scroll to End : Scroll the output log to the end. ![the Print icon](https://resources.jetbrains.com/help/img/idea/2026.3/app-client.expui.general.print.svg) Print… : Print a console file, a selected text, or all the files in a directory. ![the Clear All icon](https://resources.jetbrains.com/help/img/idea/2026.3/app-client.expui.general.delete.svg) Clear All : Clear the Output tab. ## Result tab Each Result tab displays a query result set in a data editor. You can browse the data and use the data editor controls to work with it. For more information about data editor and viewing and working with result sets, refer to [Data editor and viewer](data-editor-and-viewer.html) and [Query results](viewing-query-results.html). ![Result tab of the Database Output tool window](https://resources.jetbrains.com/help/img/idea/2026.3/db_database_output_tw_tab_result.png) ## Query Plan tab The Query Plan tab displays the execution plan generated by an Explain Plan or Explain Analyse action. For more information about generating plans and working with their tree, raw, and graphical representations, refer to [Query execution plan](query-execution-plan.html). ![Query Plan tab of the Database Output tool window](https://resources.jetbrains.com/help/img/idea/2026.3/db_database_output_tw_tab_query_plan.png) ## Session clients dropdown In the session clients dropdown, you can select a session client, such as a query console or SQL file, to view its output, query results, and query plans. Clients are grouped by data source. Selecting a client in this dropdown does not change the active editor tab. Select Manage sessions to open session details for the selected client in the Services tool window. For more information about sessions and session clients, refer to [Sessions](managing-connection-sessions.html).