# JPA Console

> For the complete documentation index, see [llms.txt](https://www.jetbrains.com.cn/en-us/help/idea/2026.3/llms.txt).

The JPA Console lets you write, validate, and run queries in the following languages:

* [Jakarta Persistence Query Language](https://jakarta.ee/learn/docs/jakartaee-tutorial/current/persist/persistence-querylanguage/persistence-querylanguage.html) (JPQL)

* [Jakarta Data Query Language](https://jakarta.ee/specifications/data/1.0/jakarta-data-1.0.html#_jakarta_data_query_language) (JDQL)

* [Hibernate Query Language](https://docs.hibernate.org/orm/7.1/querylanguage/html_single/#basic-concepts) (HQL)

* [EclipseLink Query Language](https://eclipse.dev/eclipselink/documentation/4.0/jpa/extensions/jpa-extensions.html#java-persistence-query-language-extensions) (EQL)

![JPA Console with a JPQL query retrieving book authors with a specified nationality](https://resources.jetbrains.com.cn/help/img/idea/2026.3/jpa-console.png)

> **Note:**
> If your project uses the Hibernate [facet](adding-support-for-frameworks-and-technologies.html), JPA Console is replaced by [Hibernate Console](working-with-the-hibernate-console.html).

## Prerequisites

* The following plugins are enabled: * [Jakarta EE: Persistence (JPA)](https://plugins.jetbrains.com/plugin/20202) (bundled) * Database Tools and SQL (bundled) To check if the plugins are enabled, [open the Plugin settings](jetbrains://tool/settings?name=Plugins&tool=IU).

* Your project uses JDK 8 or later. [Learn how to change your project's JDK](sdk.html#set-up-jdk).

* Your build file includes at least one of the following dependencies: * Jakarta Persistence [Learn how to add Jakarta Persistence to your project](jakarta-persistence-jpa.html#add-to-existing-project). * Hibernate [Learn how to add Hibernate to your project](hibernate.html#add-to-existing-project). * EclipseLink * Spring Data JPA

* Your project files include at least one entity class.

* Your project is compiled. [Learn how to compile your project](compiling-applications.html#compile_module).

* The Database tool window lists at least one data source. [Learn how to create a data source](managing-data-sources.html#create_a_data_source).

## Open the console

Open the JPA Console manually if you want to run JPQL, JDQL, HQL, or EQL queries that are not present in your code or if you want the console to use custom JVM options.

> **Tip:**
> If you want to run queries that are already present in your code, you can do it [right from the editor](#run-queries-in-the-editor).

Procedure: Open the console with default settings

1. Open the [Persistence](persistence-tool-window.html) tool window (`View | Tool Windows | Persistence`).

2. Select a persistence unit.

3. In the tool window toolbar, click ![Console icon](https://resources.jetbrains.com.cn/help/img/idea/2026.3/intellij.database.icons.expui.consoleRun.svg) JPA Console.

![Location of the JPA Console icon in the Persistence tool window](https://resources.jetbrains.com.cn/help/img/idea/2026.3/jpa_console_icon.png)

* Alternatively, press `Ctrl+Shift+F10` (Windows), `⌘ ⇧ F10` (macOS), `⌘ ⇧ F10` (IntelliJ IDEA Classic (macOS)), `⌘ ⇧ F10` (macOS System Shortcuts), `Ctrl+Shift+F10` (XWin), `Ctrl+Shift+F10` (GNOME), `Ctrl+Shift+F10` (KDE), `Ctrl+Shift+F10` (Emacs), `Ctrl+Shift+F10` (Sublime Text), `⌘ ⇧ F10` (Sublime Text (macOS)), `Ctrl+Shift+F10` (Visual Studio), `⌘ ⇧ F10` (Visual Studio (macOS)), `Ctrl+Shift+F10` (NetBeans), `Ctrl+Shift+F10` (Eclipse), `⌘ ⇧ F10` (Eclipse (macOS)).

The JPA Console opens in a dedicated tool window. You can now [run queries](#run-queries).

![JPA Console tool window](https://resources.jetbrains.com.cn/help/img/idea/2026.3/jpa_console.png)

To learn what the icons in the console represent, refer to [Reference: JPA Console](#jpa-console-reference).

Procedure: Open the console with custom JVM options

The JPA Console runs in a separate Java process. You can run this process with custom JVM options by creating a [run
configuration](run-debug-configuration.html) and then selecting it when you open the console.

1. Open the Run/Debug Configurations dialog:

* In the main toolbar, click the [run widget](guided-tour-around-the-user-interface.html#toolbar) and select Edit Configurations….

* Alternatively, go to `Run | Edit Configurations…`.

2. On the left side of the dialog, select `![Add New Configuration icon](https://resources.jetbrains.com.cn/help/img/idea/2026.3/app.expui.general.add.svg) Add New Configuration | ![Application icon](https://resources.jetbrains.com.cn/help/img/idea/2026.3/app.expui.runConfigurations.application.png) Application`.

3. On the right side of the dialog, select `Modify options | Add VM options`.

4. In the VM options field, specify the options that you want to pass to the JVM when opening the JPA Console.

![VM options field in the Run/Debug Configurations dialog populated with -Xmx512m ](https://resources.jetbrains.com.cn/help/img/idea/2026.3/run_configuration_vm_options.png)

You can also set up other [run
configuration settings](run-debug-configuration-java-application.html), but it is not required for the console.

5. Click Apply and then OK.

6. Open the Persistence tool window (`View | Tool Windows | Persistence`).

7. Select a persistence unit.

8. In the tool window toolbar, select `![JPA Console icon](https://resources.jetbrains.com.cn/help/img/idea/2026.3/intellij.database.icons.expui.consoleRun.svg) JPA Console | ![Application icon](https://resources.jetbrains.com.cn/help/img/idea/2026.3/app.expui.runConfigurations.application.svg) <Your Configuration Name>`.

![Run configuration toolbar](https://resources.jetbrains.com.cn/help/img/idea/2026.3/jpa_console_run_configuration.png)

> **Note:**
> If the console is already running, your configuration will be available under `![Toolbar JPA Console icon](https://resources.jetbrains.com.cn/help/img/idea/2026.3/intellij.database.icons.expui.consoleRun.svg) JPA Console | ![Second-level JPA Console icon](https://resources.jetbrains.com.cn/help/img/idea/2026.3/intellij.java.ultimate.icons.icons.javaee.newui.jpaFacet.svg) JPA Console | ![Application icon](https://resources.jetbrains.com.cn/help/img/idea/2026.3/app.expui.runConfigurations.application.svg) <Your Configuration Name>`.

9. The JPA Console opens in a dedicated tool window with your JVM options applied. You can now [run queries](#run-queries).

To learn what the icons in the console represent, refer to [Reference: JPA Console](#jpa-console-reference).

## Run queries

You can run queries in the JPA Console from either the console itself or from the editor.

> **Note:**
> This feature cannot be used for queries that accept entities as parameters.

The JPA Console runs the queries against a data source from the [Database](database-tool-window.html) tool window. If there is more than one data source, the IDE

looks for a match in the following configurations (in this order): a running [Spring Debugger](spring-debugger.html) session, an explicit assignment in the Persistence tool window, or a data source URL in [Spring Boot](spring-boot.html) configuration files.

If IntelliJ IDEA cannot determine which data source to use, you will be prompted to select one.

> **Warning:**
> When you run a query in the JPA Console , it is immediately executed and committed to the database. You cannot preview the changes or roll them back.  Make sure to use a database where your queries are safe to run.

Procedure: Run a query from the JPA Console

1. [Open the JPA Console](#open-jpa-console).

2. Type or paste your query.

3. In the console toolbar, click ![Green triangle pointing right](https://resources.jetbrains.com.cn/help/img/idea/2026.3/app-client.expui.run.run.svg) Execute Query.

* Alternatively, press `Ctrl+Enter` (Windows), `⌘ ⏎` (macOS), `⌘ ⏎` (IntelliJ IDEA Classic (macOS)), `⌘ ⏎` (macOS System Shortcuts), `Ctrl+Enter` (XWin), `Ctrl+Enter` (GNOME), `Ctrl+Enter` (KDE), `Ctrl+Enter` (Emacs), `Ctrl+Enter` (Sublime Text), `⌘ ⏎` (Sublime Text (macOS)), `Ctrl+Enter` (Visual Studio), `⌘ ⏎` (Visual Studio (macOS)), `Ctrl+Enter` (NetBeans), `Ctrl+Enter` (Eclipse), `⌘ ⏎` (Eclipse (macOS)).

4. If the query accepts parameters, the [Parameters](#parameters-dialog) dialog opens. Specify their values and click Execute (or press `Enter` (Windows), `⏎` (macOS), `⏎` (IntelliJ IDEA Classic (macOS)), `⏎` (macOS System Shortcuts), `Enter` (XWin), `Enter` (GNOME), `Enter` (KDE), `Enter` (Emacs), `Enter` (Sublime Text), `⏎` (Sublime Text (macOS)), `Enter` (Visual Studio), `⏎` (Visual Studio (macOS)), `Enter` (NetBeans), `Enter` (Eclipse), `⏎` (Eclipse (macOS))).

The JPA Console executes the query and [displays its results](#jpa-console-reference) in a new tab .

Procedure: Run a query from the editor

1. Place the caret at a query in the editor.

2. Right-click the query and select `![Grey bulb icon](https://resources.jetbrains.com.cn/help/img/idea/2026.3/intellij.platform.ide.expui.codeInsight.intentionBulbGrey.svg) Show Context Actions | ![Console icon](https://resources.jetbrains.com.cn/help/img/idea/2026.3/intellij.database.icons.expui.consoleRun.svg) Run query in console`.

* Alternatively, press `Alt+Enter` (Windows), `⌥ ⏎` (macOS), `⌥ ⏎` (IntelliJ IDEA Classic (macOS)), `⌥ ⏎` (macOS System Shortcuts), `Alt+Enter` (XWin), `Alt+Enter` (GNOME), `Alt+Enter` (KDE), `Alt+Enter` (Emacs), `Alt+Enter` (Sublime Text), `⌥ ⏎` (Sublime Text (macOS)), `Alt+Enter` (Visual Studio), `⌥ ⏎` (Visual Studio (macOS)), `Alt+Enter` (NetBeans), `Ctrl+1` (Eclipse), `⌘ 1` (Eclipse (macOS)) and select ![Console icon](https://resources.jetbrains.com.cn/help/img/idea/2026.3/intellij.database.icons.expui.consoleRun.svg) Run query in console.

3. If the query accepts parameters, the [Parameters](#parameters-dialog) dialog opens. Specify their values and click Execute (or press `Enter` (Windows), `⏎` (macOS), `⏎` (IntelliJ IDEA Classic (macOS)), `⏎` (macOS System Shortcuts), `Enter` (XWin), `Enter` (GNOME), `Enter` (KDE), `Enter` (Emacs), `Enter` (Sublime Text), `⏎` (Sublime Text (macOS)), `Enter` (Visual Studio), `⏎` (Visual Studio (macOS)), `Enter` (NetBeans), `Enter` (Eclipse), `⏎` (Eclipse (macOS))).

The JPA Console executes the query and [displays its results](#jpa-console-reference)  .

Procedure: Run a Jakarta Data query method from the gutter

If your project uses

[Jakarta Data](jakarta-data.html) repositories,

you can run their query methods right from the editor gutter.

> **Note:**
> The following method types are supported:
>
>
>
> * Methods where the query is [derived from the method name](https://jakarta.ee/specifications/data/1.0/jakarta-data-addendum-1.0.html)
>
> * Methods annotated with `@Query` that define explicit JPQL or JDQL queries
>
> * Methods annotated with `@Find`

1. Open a Jakarta Data repository in the editor.

2. In the gutter, click  ![Console icon](https://resources.jetbrains.com.cn/help/img/idea/2026.3/intellij.database.icons.expui.consoleRun.svg) Run Query in Console

next to a query method.

3. If the query accepts parameters, the [Parameters](#parameters-dialog) dialog opens. Specify their values and click Execute (or press `Enter` (Windows), `⏎` (macOS), `⏎` (IntelliJ IDEA Classic (macOS)), `⏎` (macOS System Shortcuts), `Enter` (XWin), `Enter` (GNOME), `Enter` (KDE), `Enter` (Emacs), `Enter` (Sublime Text), `⏎` (Sublime Text (macOS)), `Enter` (Visual Studio), `⏎` (Visual Studio (macOS)), `Enter` (NetBeans), `Enter` (Eclipse), `⏎` (Eclipse (macOS))).

The JPA Console executes the query and [displays its results](#jpa-console-reference)  .

![Running a Jakarta Data repository method in the JPA Console using the gutter icon and filling out the parameter values](https://resources.jetbrains.com.cn/help/img/idea/2026.3/jakarta_data_run_query_in_jpa_console.gif)

Procedure: Run a Spring Data query method from the gutter

If your project uses

[Spring Data
repositories](https://docs.spring.io/spring-data/commons/reference/repositories.html),

you can run their query methods right from the editor gutter.

> **Note:**
> The following method types are supported:
>
>
>
> * Methods where the query is [derived from the method name](https://docs.spring.io/spring-data/jpa/reference/repositories/query-methods-details.html#repositories.query-methods.query-creation)
>
> * Methods annotated with `@Query` that define explicit JPQL or SQL queries
>
> * Methods annotated with `@NativeQuery` that define explicit SQL queries
>
> * Methods where the name references a `@NamedQuery` or a `@NamedNativeQuery` declared in the repository's entity class

1. Open a Spring Data repository in the editor.

2. In the gutter, click   ![Console icon](https://resources.jetbrains.com.cn/help/img/idea/2026.3/spring-data.icons.expui.springRepositoryRun.svg) Run a query in a console

next to a query method.

3. If the query accepts parameters, the [Parameters](#parameters-dialog) dialog opens. Specify their values and click Execute (or press `Enter` (Windows), `⏎` (macOS), `⏎` (IntelliJ IDEA Classic (macOS)), `⏎` (macOS System Shortcuts), `Enter` (XWin), `Enter` (GNOME), `Enter` (KDE), `Enter` (Emacs), `Enter` (Sublime Text), `⏎` (Sublime Text (macOS)), `Enter` (Visual Studio), `⏎` (Visual Studio (macOS)), `Enter` (NetBeans), `Enter` (Eclipse), `⏎` (Eclipse (macOS))).

If the query is written in JPQL or derived from the method name, the JPA Console executes the query and [displays its results](#jpa-console-reference).

![Running a Spring Data repository method in the JPA Console using the gutter icon and filling out the parameter values](https://resources.jetbrains.com.cn/help/img/idea/2026.3/spring_data_jpa_run_query_in_jpa_console.gif)

If the query is written in native SQL, a database-specific [query
console](query-consoles.html) executes it, and the Services tool window [displays its results](services-tool-window.html#db-sessions).

## Reference: JPA Console

![JPA Console with frames marking different parts that make up the console](https://resources.jetbrains.com.cn/help/img/idea/2026.3/jpa_console_reference.png)

The JPA Console contains the following tabs and toolbars:

1.  [Session tab](#toolbar)

2.  [Query toolbar](#toolbar)

3.  ![Console icon](https://resources.jetbrains.com.cn/help/img/idea/2026.3/app.expui.fileTypes.shell.svg) [Console
tab](#console-tab)

4.  ![Database table icon](https://resources.jetbrains.com.cn/help/img/idea/2026.3/intellij.database.icons.expui.table.svg) [Result tab](#result-tab)

When you run a query with parameters, the console opens the [Parameters](#parameters-dialog) dialog and prompts you to specify or review their values.

### Session tab and query toolbar

The session tab groups the query toolbar, console tab, and result tabs for a single JPA Console [session](managing-connection-sessions.html). The tab name is based on the persistence unit.

The query toolbar lets you run queries, configure query execution settings, and control the console session:

![](https://resources.jetbrains.com.cn/help/img/idea/2026.3/app-client.expui.run.run.svg)
: Execute Query (`Ctrl+Enter` (Windows), `⌘ ⏎` (macOS), `⌘ ⏎` (IntelliJ IDEA Classic (macOS)), `⌘ ⏎` (macOS System Shortcuts), `Ctrl+Enter` (XWin), `Ctrl+Enter` (GNOME), `Ctrl+Enter` (KDE), `Ctrl+Enter` (Emacs), `Ctrl+Enter` (Sublime Text), `⌘ ⏎` (Sublime Text (macOS)), `Ctrl+Enter` (Visual Studio), `⌘ ⏎` (Visual Studio (macOS)), `Ctrl+Enter` (NetBeans), `Ctrl+Enter` (Eclipse), `⌘ ⏎` (Eclipse (macOS)))
:
:
:
:
:
: Run the currently typed query.

![Settings](https://resources.jetbrains.com.cn/help/img/idea/2026.3/app.expui.general.settings.svg)
: Open Query Execution Settings…
:
:
:
:
:
: Open the [Query Execution](query-execution.html) page in the Settings dialog.

![Parameters](https://resources.jetbrains.com.cn/help/img/idea/2026.3/app.expui.nodes.parameter.svg)
: View Parameters
:
:
:
:
:
: Open the Parameters pane to view the parameters accepted by the query and set their values.

![History](https://resources.jetbrains.com.cn/help/img/idea/2026.3/app.expui.general.history.svg)
: Browse Query History (`Ctrl+Alt+E` (Windows), `⌘ ⌥ E` (macOS), `⌘ ⌥ E` (IntelliJ IDEA Classic (macOS)), `⌘ ⌥ E` (macOS System Shortcuts), `Ctrl+Alt+E` (XWin), `Ctrl+Alt+E` (GNOME), `Ctrl+Alt+E` (KDE), `Ctrl+Alt+E` (Emacs), `Ctrl+Alt+E` (Sublime Text), `⌘ ⌥ E` (Sublime Text (macOS)), `Ctrl+Alt+E` (Visual Studio), `⌘ ⌥ E` (Visual Studio (macOS)), `Ctrl+Alt+E` (NetBeans), `Ctrl+Alt+E` (Eclipse), `⌘ ⌥ E` (Eclipse (macOS)))
:
:
:
:
:
: Open the History dialog to view all the queries that you have run for this persistence unit and, optionally, copy a selected one to the console.

![Restore Layout](https://resources.jetbrains.com.cn/help/img/idea/2026.3/app.expui.general.layout.svg)
: Restore Default Layout
:
:
:
:
:
: Restore the original console layout.

![Terminate Process](https://resources.jetbrains.com.cn/help/img/idea/2026.3/app.expui.run.stop.svg)
: Terminate Process (`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)))
:
:
:
:
:
: Disconnect the console from the database but keep the session tab open.

![Close](https://resources.jetbrains.com.cn/help/img/idea/2026.3/app.expui.general.close.svg)
: Close (`Ctrl+Shift+F4` (Windows), `⌃ ⇧ F4` (macOS), `⌘ ⇧ F4` (IntelliJ IDEA Classic (macOS)), `⌃ ⇧ F4` (macOS System Shortcuts), `Ctrl+Shift+F4` (XWin), `Ctrl+Shift+F4` (GNOME), `Ctrl+Shift+4` (KDE), `Ctrl+Shift+F4` (Emacs), `Ctrl+Shift+F4` (Sublime Text), `⌃ ⇧ F4` (Sublime Text (macOS)), `Ctrl+Shift+F4` (Visual Studio), `⌃ ⇧ F4` (Visual Studio (macOS)), `Ctrl+Shift+F4` (NetBeans), `Ctrl+W` (Eclipse), `⌘ W` (Eclipse (macOS)))
:
:
:
:
:
: Disconnect the console from the database and close the currently open session tab.

### Console tab

The console tab lets you write queries, run them, and view the query log for the current console session. This tab uses the same name as the session tab.

The query log records the following information every time you run a query:

* The executed query.

* If the query ran successfully: * SQL statements sent to the database while the query was running, including statements that fetched related data. These are shown only in projects that use [Hibernate](hibernate.html) as the persistence provider. * The number of retrieved rows or, if the query modified data, of affected rows. * The total time it took to run the query, broken down into time spent executing the query and time spent retrieving the results.

* If the query failed: * Error messages that explain why the query failed. * A link that [compiles the project](compiling-applications.html#compile_module) and runs the query again. This is shown only for errors that suggest the project build is out of date.

In addition to the query log, this tab includes a toolbar that lets you navigate the log, print it, and format its entries:

![Wrapped text icon](https://resources.jetbrains.com.cn/help/img/idea/2026.3/intellij.platform.ide.expui.general.softWrap.svg)
: Soft-Wrap
:
:
:
:
:
: Wrap long lines in the query log.

![Scrolled down text icon](https://resources.jetbrains.com.cn/help/img/idea/2026.3/intellij.platform.ide.expui.general.scrollDown.svg)
: Scroll to End
:
:
:
:
:
: Jump to the bottom of the query log.

![Printer icon](https://resources.jetbrains.com.cn/help/img/idea/2026.3/intellij.platform.ide.expui.general.print.svg)
: Print…
:
:
:
:
:
: Open the [Print](print.html) dialog.

![Trash bin icon](https://resources.jetbrains.com.cn/help/img/idea/2026.3/intellij.platform.ide.expui.general.delete.svg)
: Clear All
:
:
:
:
:
: Clear the query log.

### Result tab

The result tab displays the data retrieved by your query. Each query run opens a separate tab, even when you run the same query multiple times.

> **Note:**
> Queries that modify data, such as `UPDATE` or `DELETE`, do not open a result tab.

In addition to the retrieved data, this tab includes a toolbar that lets you browse, filter, and export that data:

![Table icon](https://resources.jetbrains.com.cn/help/img/idea/2026.3/intellij.platform.ide.expui.nodes.dataTables.svg)
: Switch to Table
:
:
:
:
:
: View the result in the form of a database table.
:
:
:
: Learn more from [Explore values](tables-view-data.html#explore-values).

![Chart icon](https://resources.jetbrains.com.cn/help/img/idea/2026.3/intellij.charts.icons.chart.chart.svg)
: Switch to Chart
:
:
:
:
:
: View the result in the form of a chart.
:
:
:
: Learn more from [Visualize data](tables-view-data.html#visualize_data).

![Refresh icon](https://resources.jetbrains.com.cn/help/img/idea/2026.3/intellij.platform.ide.expui.general.refresh.svg)
: Reload Page (`Ctrl+F5` (Windows), `⌘ R` (macOS), `⌃ F5` (IntelliJ IDEA Classic (macOS)), `⌘ R` (macOS System Shortcuts), `Ctrl+F5` (XWin), `Ctrl+F5` (GNOME), `Ctrl+5` (KDE), `Ctrl+F5` (Emacs), `Ctrl+F5` (Sublime Text), `⌘ R` (Sublime Text (macOS)), `Ctrl+Alt+R` (Visual Studio), `⌘ ⌥ R` (Visual Studio (macOS)), `Ctrl+F5` (NetBeans), `Ctrl+F5` (Eclipse), `Ctrl+F5` (Eclipse (macOS)))
:
:
:
:
:
: Reload the data.

![Clock icon](https://resources.jetbrains.com.cn/help/img/idea/2026.3/intellij.platform.ide.expui.general.history.svg)
: Table Result Auto Refresh
:
:
:
:
:
: Select how often the data should auto-refresh.

![Pin icon](https://resources.jetbrains.com.cn/help/img/idea/2026.3/intellij.platform.ide.expui.general.pin.svg)
: Pin Tab
:
:
:
:
:
: Pin the currently open result tab.

![Magnifying glass icon](https://resources.jetbrains.com.cn/help/img/idea/2026.3/intellij.platform.ide.expui.general.search.svg)
: Find on Current Page
:
:
:
:
:
: Search the data on the currently displayed page for a specific value.

![Filter icon](https://resources.jetbrains.com.cn/help/img/idea/2026.3/intellij.grid.core.impl.icons.expui.columnFilter.svg)
: Table Result Local Filter
:
:
:
:
:
: Enable filtering for all columns or clear all filters.
:
:
:
: Learn more from [Use the local filter](tables-filter.html#use_the_local_filter).

![Single record icon](https://resources.jetbrains.com.cn/help/img/idea/2026.3/intellij.grid.core.impl.icons.expui.singleRecordView.svg)
: Record View
:
:
:
:
:
: Open a side pane to view the data in the selected record.
:
:
:
: Learn more from [Single record view](tables-view-data.html#single_record_view).

![Single record icon](https://resources.jetbrains.com.cn/help/img/idea/2026.3/intellij.grid.core.impl.icons.expui.tableHeatmap.svg)
: Table Coloring Options
:
:
:
:
:
: Configure color mapping for table cells.
:
:
:
: Learn more from [Apply a heatmap](tables-view-data.html#apply_a_heatmap).

![Web icon](https://resources.jetbrains.com.cn/help/img/idea/2026.3/intellij.platform.ide.expui.nodes.ppWeb.svg)
: Show Geo Viewer
:
:
:
:
:
: Open an interactive map where you can view geocoordinates from the result.
:
:
:
: > **Note:**
: > This icon is only available if the result contains latitude and longitude columns.
:
:
:
: Learn more from [View geographical data](tables-view-data.html#view_geographical_data).

![Data extractor](https://resources.jetbrains.com.cn/help/img/idea/2026.3/intellij.platform.ide.expui.general.chevronDown.svg)
: Data Extractor
:
:
:
:
:
: Select an output format for the data.
:
:
:
: Learn more from [Data extractors](data-extractors.html).

![Download icon](https://resources.jetbrains.com.cn/help/img/idea/2026.3/intellij.platform.ide.expui.general.download.svg)
: Export Data (table view)
:
:
:
:
:
: Open the [Export Data](export-data.html#methods-for-exporting-data) dialog.
:
:
:
:
:
: Export to PNG (chart view)
:
:
:
: Download the chart as a PNG image.

![Upload icon](https://resources.jetbrains.com.cn/help/img/idea/2026.3/intellij.platform.ide.expui.general.upload.svg)
: Import
:
:
:
:
:
: Open the [Import](import-data.html#import_dialogs) dialog.

![Diff icon](https://resources.jetbrains.com.cn/help/img/idea/2026.3/intellij.platform.ide.expui.vcs.diff.svg)
: Compare Data
:
:
:
:
:
: Compare this result with a result from a [query console](query-consoles.html).

![Eye icon](https://resources.jetbrains.com.cn/help/img/idea/2026.3/intellij.platform.ide.expui.general.show.svg)
: View as
:
:
:
:
:
: Select a data view mode.
:
:
:
: Learn more from [Data view modes](tables-view-data.html#data_view_modes).

![Gear icon](https://resources.jetbrains.com.cn/help/img/idea/2026.3/intellij.platform.ide.expui.general.settings.svg)
: Show Options Menu (table view)
:
:
:
:
:
: Open a list with the following options:
:
:
:
: * Show Value Editor: open the [value editor](tables-view-data.html#value-editor) to view the data from the selected cell.
:
: * Show Aggregate View: open the [aggregate view](tables-view-data.html#aggregate-view).
:
: * Manage Columns…: display a list of all columns in the table.
:
: * Paste Format: select how to format text pasted from the clipboard.
:
: * Reset View: restore the initial table layout.
:
: * View Query: view the query that generated the result.
:
: * Copy Query to Console: copy the query to the console.
:
: * Copy Query to Clipboard: copy the query to the clipboard.
:
: * Open Data Views Settings: open the [Data Editor and Viewer settings](settings-tools-database-data-views.html).
:
: * Open Data Views Appearance Settings: open the [Data Editor and Viewer appearance settings](settings-appearance-and-behavior-data-editor-and-viewer.html).
:
:
:
:
:
: Show Series Settings (chart view)
:
:
:
:
:
: Open the [Series Settings](tables-view-data.html#configure_a_chart_chunk) pane to configure the chart display options.

### Parameters dialog

The Parameters dialog lets you review and specify values for query parameters. Each row in the dialog represents one parameter: its name, the part of the query where it is used, and an input field for its value.

![Parameters dialog with an input field clicked, showing the accepted values of an enum parameter](https://resources.jetbrains.com.cn/help/img/idea/2026.3/jpa_console_parameters_dialog.png)

In addition to entering values, you can use the dialog in the following ways:

* Select a row to highlight the parameter in the console tab.

* Click an empty input field to display the parameter's expected format or accepted values.

* Press `Enter` (Windows), `⏎` (macOS), `⏎` (IntelliJ IDEA Classic (macOS)), `⏎` (macOS System Shortcuts), `Enter` (XWin), `Enter` (GNOME), `Enter` (KDE), `Enter` (Emacs), `Enter` (Sublime Text), `⏎` (Sublime Text (macOS)), `Enter` (Visual Studio), `⏎` (Visual Studio (macOS)), `Enter` (NetBeans), `Enter` (Eclipse), `⏎` (Eclipse (macOS)) to jump to the next empty input field.

After you specify all parameter values, you can run the query by clicking Execute or pressing `Enter` (Windows), `⏎` (macOS), `⏎` (IntelliJ IDEA Classic (macOS)), `⏎` (macOS System Shortcuts), `Enter` (XWin), `Enter` (GNOME), `Enter` (KDE), `Enter` (Emacs), `Enter` (Sublime Text), `⏎` (Sublime Text (macOS)), `Enter` (Visual Studio), `⏎` (Visual Studio (macOS)), `Enter` (NetBeans), `Enter` (Eclipse), `⏎` (Eclipse (macOS)).

> **Tip:**
> By default, this dialog appears every time you run a query with parameters, even if their values are already set. To show the dialog only when parameter values are missing, go to the [Query Execution](query-execution.html) settings and clear the Review parameters before execution option.
>
>
>
>
>
> [Open in the IDE](jetbrains://tool/settings?name=Tools--Database--Query+Execution&tool=IU)

## Productivity tips

Procedure: Retrieve all records from an entity's table

You can quickly retrieve all records from a database table by invoking a dedicated action in its entity class. This executes a `SELECT entity FROM <ClassName> entity` statement in the JPA Console.

1. Open an entity class in the editor.

2. In the gutter, select `![Database icon with a blue table icon in the lower-right corner](https://resources.jetbrains.com.cn/help/img/idea/2026.3/intellij.platform.ide.expui.javaee.persistenceEntity.svg) Show Entity actions | ![Console icon](https://resources.jetbrains.com.cn/help/img/idea/2026.3/intellij.database.icons.expui.consoleRun.svg) Run Query in JPA Console`.

* Alternatively, place the caret at the class name, press `Alt+Enter` (Windows), `⌥ ⏎` (macOS), `⌥ ⏎` (IntelliJ IDEA Classic (macOS)), `⌥ ⏎` (macOS System Shortcuts), `Alt+Enter` (XWin), `Alt+Enter` (GNOME), `Alt+Enter` (KDE), `Alt+Enter` (Emacs), `Alt+Enter` (Sublime Text), `⌥ ⏎` (Sublime Text (macOS)), `Alt+Enter` (Visual Studio), `⌥ ⏎` (Visual Studio (macOS)), `Alt+Enter` (NetBeans), `Ctrl+1` (Eclipse), `⌘ 1` (Eclipse (macOS)), and select ![Console icon](https://resources.jetbrains.com.cn/help/img/idea/2026.3/intellij.database.icons.expui.consoleRun.svg) Run Query in JPA Console.

Procedure: Navigate to an entity class from a query

You can quickly navigate to an entity class declaration or an entity field declaration from any JPQL, JDQL, HQL, or EQL query. This applies to queries in both the JPA Console and in the editor.

* Hold `Ctrl` (Windows), `Ctrl` (macOS), `Ctrl` (IntelliJ IDEA Classic (macOS)), `Ctrl` (macOS System Shortcuts), `Ctrl` (XWin), `Ctrl` (GNOME), `Ctrl` (KDE), `Ctrl` (Emacs), `Ctrl` (Sublime Text), `Ctrl` (Sublime Text (macOS)), `Ctrl` (Visual Studio), `Ctrl` (Visual Studio (macOS)), `Ctrl` (NetBeans), `Ctrl` (Eclipse), `Ctrl` (Eclipse (macOS)) and click an entity name or field name in the query.

* Place the caret at an entity name or field name in the query and press `Ctrl+B` (Windows), `⌘ B` (macOS), `⌘ B` (IntelliJ IDEA Classic (macOS)), `⌘ B` (macOS System Shortcuts), `Ctrl+B` (XWin), `Ctrl+B` (GNOME), `Ctrl+B` (KDE), `Ctrl+Alt+G` (Emacs), `F12` (Sublime Text), `F12` (Sublime Text (macOS)), `F12` (Visual Studio), `F12` (Visual Studio (macOS)), `Ctrl+B` (NetBeans), `F3` (Eclipse), `F3` (Eclipse (macOS)).

* Place the caret at an entity name or field name in the query. From the main menu, select `Navigate | Declaration or Usages`.

