# Quick start with database functionality

This quick start guide will introduce you to the key concepts and help you with your first steps in  working with databases in IntelliJ IDEA.

## Before you start

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:**
> The Database Tools and SQL plugin is not available 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` (NetBeans), `Ctrl+Alt+S` (Visual Studio), `⌘ Comma` (Visual Studio (macOS)), `Ctrl+Alt+S` (Eclipse), `⌘ Comma` (Eclipse (macOS)) to open settings and then select `Plugins`.

2. Open the Installed tab, find the Database Tools and SQL plugin, and select the checkbox next to the plugin name.

Now you can set up a connection configuration for your database.

## Step 1. Create a data source

Depending on a database vendor (MySQL, PostgreSQL, Oracle, and so on), you need to create a corresponding data source to use it to connect to the database.

Data source
: Data source is a connection configuration. It stores a list of connection details that are used to establish connection to a database. For example, host, port, database name, driver, SSH and SSL configuration settings, and so on. In data source settings, you can also select databases and schemas for introspection and display in   Database   tool window , and change the driver for your connection.
:
: Find more information about data sources in [Data sources](managing-data-sources.html).

In this tutorial, you will set up a demo data source and connect to a demo database. To do this, you can either use the PostgreSQL or MySQL sample databases deployed remotely or download and use the SQLite sample database file.

> **Note:**
> The demo data sources discussed in this topic are also available for one-click creation in the   Database   tool window  as quick actions when there are no existing data sources in the project.

You can also set up this demo data source using the connection credentials of a database you have setup and running somewhere else. To do this and connect to your database, enter the credentials or its JDBC URL in the corresponding fields of Data Source and Drivers dialog that is described in this tutorial.

Procedure:

PostgreSQL:

1.  In IntelliJ IDEA, go  to    Database   tool window  ( `View  | Tool Windows |  Database`  or `⌘ 1` (Windows), `⌘ 1` (macOS), `⌘ 1` (IntelliJ IDEA Classic (macOS)), `⌘ 1` (macOS System Shortcuts), `⌘ 1` (XWin), `⌘ 1` (GNOME), `⌘ 1` (KDE), `⌘ 1` (Emacs), `⌘ 1` (Sublime Text), `⌘ 1` (Sublime Text (macOS)), `⌘ 1` (NetBeans), `Ctrl+Alt+3` (Visual Studio), `⌘ ⌃ 3` (Visual Studio (macOS)), `⌘ 1` (Eclipse), `⌘ 1` (Eclipse (macOS))) .

2.  Click ![the New icon](https://resources.jetbrains.com.cn/help/img/idea/2026.2/app.expui.general.add.svg) New on the toolbar.

3.

Navigate to Data Source and select PostgreSQL   .

![Select the $postgresql% data source](https://resources.jetbrains.com.cn/help/img/idea/2026.2/tutorial_db_select_new_data_source_postgresql.png)

IntelliJ IDEA will open a Data Source and Drivers dialog with the settings of your new data source.

![The new data source settings](https://resources.jetbrains.com.cn/help/img/idea/2026.2/db_qsg_select_new_data_source_settings_postgresql.png)

MySQL:

1.  In IntelliJ IDEA, go  to    Database   tool window  ( `View  | Tool Windows |  Database`  or `⌘ 1` (Windows), `⌘ 1` (macOS), `⌘ 1` (IntelliJ IDEA Classic (macOS)), `⌘ 1` (macOS System Shortcuts), `⌘ 1` (XWin), `⌘ 1` (GNOME), `⌘ 1` (KDE), `⌘ 1` (Emacs), `⌘ 1` (Sublime Text), `⌘ 1` (Sublime Text (macOS)), `⌘ 1` (NetBeans), `Ctrl+Alt+3` (Visual Studio), `⌘ ⌃ 3` (Visual Studio (macOS)), `⌘ 1` (Eclipse), `⌘ 1` (Eclipse (macOS))) .

2.  Click ![the New icon](https://resources.jetbrains.com.cn/help/img/idea/2026.2/app.expui.general.add.svg) New on the toolbar.

3.

Navigate to Data Source and select  MySQL  .

![Select the mysql% data source](https://resources.jetbrains.com.cn/help/img/idea/2026.2/tutorial_db_select_new_data_source_mysql.png)

IntelliJ IDEA will open a Data Source and Drivers dialog with the settings of your new data source.

![The new data source settings](https://resources.jetbrains.com.cn/help/img/idea/2026.2/db_qsg_select_new_data_source_settings_mysql.png)

SQLite:

1.

Prepare the SQLite sample database file by downloading from a [GitHub repository](https://github.com/rmitish/datagrip_demo/blob/main/SQLite_Sakila_DB.sqlite), then copy the downloaded file to clipboard.

2.

In IntelliJ IDEA, paste the SQLite database file to the IDE project root directory.

To do that, in the   Project tool window  ( `View  | Tool Windows | Project`  or `Alt+1` (Windows), `⌘ 1` (macOS), `⌘ 1` (IntelliJ IDEA Classic (macOS)), `⌘ 1` (macOS System Shortcuts), `Alt+1` (XWin), `Alt+1` (GNOME), `Alt+1` (KDE), `Alt+1` (Emacs), `Alt+1` (Sublime Text), `⌘ 1` (Sublime Text (macOS)), `Ctrl+1` (NetBeans), `Ctrl+Alt+L` (Visual Studio), `⌘ ⌥ L` (Visual Studio (macOS)), `Alt+1` (Eclipse), `Alt+1` (Eclipse (macOS))) , click any area and press `Ctrl+V` (Windows), `⌘ V` (macOS), `⌘ V` (IntelliJ IDEA Classic (macOS)), `⌘ V` (macOS System Shortcuts), `Ctrl+V` (XWin), `Ctrl+V` (GNOME), `Ctrl+V` (KDE), `Shift+Insert` (Emacs), `Ctrl+Shift+V` (Sublime Text), `⌘ ⇧ V` (Sublime Text (macOS)), `Ctrl+V` (NetBeans), `Ctrl+V` (Visual Studio), `⌘ V` (Visual Studio (macOS)), `Ctrl+V` (Eclipse), `⌘ V` (Eclipse (macOS)). In the Copy dialog that appears, click OK.

![Paste the database file to the Project tool window](https://resources.jetbrains.com.cn/help/img/idea/2026.2/tutorial_db_paste_database_file_sqlite.png)

3.   Go to    Database   tool window  ( `View  | Tool Windows |  Database`  or `⌘ 1` (Windows), `⌘ 1` (macOS), `⌘ 1` (IntelliJ IDEA Classic (macOS)), `⌘ 1` (macOS System Shortcuts), `⌘ 1` (XWin), `⌘ 1` (GNOME), `⌘ 1` (KDE), `⌘ 1` (Emacs), `⌘ 1` (Sublime Text), `⌘ 1` (Sublime Text (macOS)), `⌘ 1` (NetBeans), `Ctrl+Alt+3` (Visual Studio), `⌘ ⌃ 3` (Visual Studio (macOS)), `⌘ 1` (Eclipse), `⌘ 1` (Eclipse (macOS))) .

4.  Click ![the New icon](https://resources.jetbrains.com.cn/help/img/idea/2026.2/app.expui.general.add.svg) New on the toolbar.

5.

Navigate to Data Source and select   SQLite .

![Select the sqlite% data source](https://resources.jetbrains.com.cn/help/img/idea/2026.2/tutorial_db_select_new_data_source_sqlite.png)

IntelliJ IDEA will open a Data Source and Drivers dialog with the settings of your new data source.

![The new data source settings](https://resources.jetbrains.com.cn/help/img/idea/2026.2/db_qsg_select_new_data_source_settings_sqlite.png)

Then, set up your new data source with the connection settings of your database.

Procedure:

PostgreSQL:

1.

In the Name field of the dialog, enter your new data source's name. For example, `Demo DB`.

2.

If there is a ![the Warning icon](https://resources.jetbrains.com.cn/help/img/idea/2026.2/expui.status.warning.svg) Download missing driver files link at the bottom of the connection settings area, click it to download the JDBC driver.

![The new data source settings](https://resources.jetbrains.com.cn/help/img/idea/2026.2/db_qsg_select_new_data_source_download_driver_postgresql.png)

3.

In the Host field, enter the following server address:

```
postgresql.datagrip-dbs.intellij.net
```

4.

Make sure that the Port field contains the PostgreSQL  default value: `5432`  .

5.

In the User field, enter the demo user name: `datagrip`.

6.

In the Password field, enter the password: `datagrip`.

7.

In the Database field, enter the database name: `datagrip`.

8.

To make sure that the connection can be successfully established, click the Test Connection link at the bottom of the connection details area.

![Successful connection to the database](https://resources.jetbrains.com.cn/help/img/idea/2026.2/db_test_connection_link_qsg_postgresql.png)

9.

In the Schemas tab, make sure that the   `datagrip` databasethat you will work with is selected.

![Selecting schemas to display in the Data Source and Drivers dialog](https://resources.jetbrains.com.cn/help/img/idea/2026.2/db_qsg_select_schema_postgresql.png)

10.

Click OK to create the data source.

![Settings of a new data source in the Data Source and Drivers dialog](https://resources.jetbrains.com.cn/help/img/idea/2026.2/db_qsg_create_data_source_postgresql.png)

Once the data source is created, it appears in the   Database   tool window .

![New data source in Database Explorer](https://resources.jetbrains.com.cn/help/img/idea/2026.2/tutorial_db_created_data_source_postgresql.png)

MySQL:

1.

In the Name field of the dialog, enter your new data source's name. For example, `Demo DB`.

2.

If there is a ![the Warning icon](https://resources.jetbrains.com.cn/help/img/idea/2026.2/expui.status.warning.svg) Download missing driver files link at the bottom of the connection settings area, click it to download the JDBC driver.

![The new data source settings](https://resources.jetbrains.com.cn/help/img/idea/2026.2/db_qsg_select_new_data_source_download_driver_mysql.png)

3.

In the Host field, enter the following server address:

```
mysql.datagrip-dbs.intellij.net
```

4.

Make sure that the Port field contains the  MySQL default value:  `3306` .

5.

In the User field, enter the demo user name: `datagrip`.

6.

In the Password field, enter the password: `datagrip`.

7.

In the Database field, enter the database name: `datagrip`.

8.

To make sure that the connection can be successfully established, click the Test Connection link at the bottom of the connection details area.

![Successful connection to the database](https://resources.jetbrains.com.cn/help/img/idea/2026.2/db_test_connection_link_qsg_mysql.png)

9.

In the Schemas tab, make sure that the  `datagrip`  databasethat you will work with is selected.

![Selecting schemas to display in the Data Source and Drivers dialog](https://resources.jetbrains.com.cn/help/img/idea/2026.2/db_qsg_select_schema_mysql.png)

10.

Click OK to create the data source.

![Settings of a new data source in the Data Source and Drivers dialog](https://resources.jetbrains.com.cn/help/img/idea/2026.2/db_qsg_create_data_source_mysql.png)

Once the data source is created, it appears in the   Database   tool window .

![New data source in Database Explorer](https://resources.jetbrains.com.cn/help/img/idea/2026.2/tutorial_db_created_data_source_mysql.png)

SQLite:

1.

In the Name field of the dialog, enter your new data source's name. For example, `Demo DB`.

2.

If there is a ![the Warning icon](https://resources.jetbrains.com.cn/help/img/idea/2026.2/expui.status.warning.svg) Download missing driver files link at the bottom of the connection settings area, click it to download the JDBC driver.

![The new data source settings](https://resources.jetbrains.com.cn/help/img/idea/2026.2/db_qsg_select_new_data_source_download_driver_sqlite.png)

3.

In the File field, enter the path to your database file in the project root: `demo_db.sqlite`.

ALternatively, click ![the OPen icon](https://resources.jetbrains.com.cn/help/img/idea/2026.2/app-client.general.ellipsis.svg) Open and navigate to the file.

4.

To make sure that the connection can be successfully established, click the Test Connection link at the bottom of the connection details area.

![Successful connection to the database](https://resources.jetbrains.com.cn/help/img/idea/2026.2/db_test_connection_link_qsg_sqlite.png)

5.

In the Schemas tab, make sure that the `main`   databasethat you will work with is selected.

![Selecting schemas to display in the Data Source and Drivers dialog](https://resources.jetbrains.com.cn/help/img/idea/2026.2/db_qsg_select_schema_sqlite.png)

6.

Click OK to create the data source.

![Settings of a new data source in the Data Source and Drivers dialog](https://resources.jetbrains.com.cn/help/img/idea/2026.2/db_qsg_create_data_source_sqlite.png)

Once the data source is created, it appears in the   Database   tool window .

![New data source in Database Explorer](https://resources.jetbrains.com.cn/help/img/idea/2026.2/tutorial_db_created_data_source_sqlite.png)

## Step 2. Write and run SQL queries

With the Database Tools and SQL plugin , you can write SQL and NoSQL code in query consoles that are attached to data sources. When you create a new data source, the IDE creates a default query console for that data source.

Query console
: Query consoles are SQL files in which you can compose and execute SQL statements. Unlike the usual SQL files, they are attached to your data source by default.
:
:
:
: For more information about query consoles, refer to  the [Query consoles](query-consoles.html) topic.

In this tutorial, we will run simple queries in the default query console that IntelliJ IDEA creates and opens upon the new data source creation.

Procedure:

PostgreSQL:

> **Tip:**
> In case you have closed the default query console, open it. To do that, in the   Database   tool window , select your data source, click ![the Jump to Query Console icon](https://resources.jetbrains.com.cn/help/img/idea/2026.2/database-plugin.icons.expui.sqlScript.svg) Jump to Query Console on the toolbar, then select your query console from the list.
>
>
>
> ![Open the data source's default query console](https://resources.jetbrains.com.cn/help/img/idea/2026.2/tutorial_db_open_default_console_postgresql.png)

1.

In the default query console, enter the following SQL query:

```SQL
SELECT * FROM actor;
```

2.

To run the query, click ![the Execute icon](https://resources.jetbrains.com.cn/help/img/idea/2026.2/app-client.expui.run.run.svg) Execute on the editor toolbar.

IntelliJ IDEA will run the query and display query result set in the data editor tab of  Services tool window (`View  | Tool Windows | Services` or `Alt+8` (Windows), `⌘ 8` (macOS), `⌘ 8` (IntelliJ IDEA Classic (macOS)), `⌘ 8` (macOS System Shortcuts), `Alt+8` (XWin), `Alt+8` (GNOME), `Alt+8` (KDE), `Alt+8` (Emacs), `Alt+8` (Sublime Text), `⌘ 8` (Sublime Text (macOS)), `Alt+8` (NetBeans), `Alt+8` (Visual Studio), `Alt+8` (Visual Studio (macOS)), `Alt+8` (Eclipse), `⌘ 8` (Eclipse (macOS)))  for you to analyze.

At this step, no schema is selected as the current one in the <schema> dropdown on the query console toolbar. However, the query can still be executed because IntelliJ IDEA will use the default schema of the data source.

For more information about how to set a default schema, refer to  the [Schemas](schemas.html#set_the_default_schema) topic.

[Video](https://resources.jetbrains.com.cn/help/img/idea/2026.2/tutorial_db_write_run_queries_postgresql.mp4)

MySQL:

> **Tip:**
> In case you have closed the default query console, open it. To do that, in the   Database   tool window , select your data source, click ![the Jump to Query Console icon](https://resources.jetbrains.com.cn/help/img/idea/2026.2/database-plugin.icons.expui.sqlScript.svg) Jump to Query Console on the toolbar, then select your query console from the list.
>
>
>
> ![Open the data source's default query console](https://resources.jetbrains.com.cn/help/img/idea/2026.2/tutorial_db_open_default_console_mysql.png)

1.

In the default query console, enter the following SQL query:

```SQL
SELECT * FROM actor;
```

2.

To run the query, click ![the Execute icon](https://resources.jetbrains.com.cn/help/img/idea/2026.2/app-client.expui.run.run.svg) Execute on the editor toolbar.

IntelliJ IDEA will run the query and display query result set in the data editor tab of  Services tool window (`View  | Tool Windows | Services` or `Alt+8` (Windows), `⌘ 8` (macOS), `⌘ 8` (IntelliJ IDEA Classic (macOS)), `⌘ 8` (macOS System Shortcuts), `Alt+8` (XWin), `Alt+8` (GNOME), `Alt+8` (KDE), `Alt+8` (Emacs), `Alt+8` (Sublime Text), `⌘ 8` (Sublime Text (macOS)), `Alt+8` (NetBeans), `Alt+8` (Visual Studio), `Alt+8` (Visual Studio (macOS)), `Alt+8` (Eclipse), `⌘ 8` (Eclipse (macOS)))  for you to analyze.

At this step, no schema is selected as the current one in the <schema> dropdown on the query console toolbar. However, the query can still be executed because IntelliJ IDEA will use the default schema of the data source.

For more information about how to set a default schema, refer to  the [Schemas](schemas.html#set_the_default_schema) topic.

[Video](https://resources.jetbrains.com.cn/help/img/idea/2026.2/tutorial_db_write_run_queries_mysql.mp4)

SQLite:

> **Tip:**
> In case you have closed the default query console, open it. To do that, in the   Database   tool window , select your data source, click ![the Jump to Query Console icon](https://resources.jetbrains.com.cn/help/img/idea/2026.2/database-plugin.icons.expui.sqlScript.svg) Jump to Query Console on the toolbar, then select your query console from the list.
>
>
>
> ![Open the data source's default query console](https://resources.jetbrains.com.cn/help/img/idea/2026.2/tutorial_db_open_default_console_sqlite.png)

1.

In the default query console, enter the following SQL query:

```SQL
SELECT * FROM actor;
```

2.

To run the query, click ![the Execute icon](https://resources.jetbrains.com.cn/help/img/idea/2026.2/app-client.expui.run.run.svg) Execute on the editor toolbar.

IntelliJ IDEA will run the query and display query result set in the data editor tab of  Services tool window (`View  | Tool Windows | Services` or `Alt+8` (Windows), `⌘ 8` (macOS), `⌘ 8` (IntelliJ IDEA Classic (macOS)), `⌘ 8` (macOS System Shortcuts), `Alt+8` (XWin), `Alt+8` (GNOME), `Alt+8` (KDE), `Alt+8` (Emacs), `Alt+8` (Sublime Text), `⌘ 8` (Sublime Text (macOS)), `Alt+8` (NetBeans), `Alt+8` (Visual Studio), `Alt+8` (Visual Studio (macOS)), `Alt+8` (Eclipse), `⌘ 8` (Eclipse (macOS)))  for you to analyze.

At this step, no schema is selected as the current one in the <schema> dropdown on the query console toolbar. However, the query can still be executed because IntelliJ IDEA will use the default schema of the data source.

For more information about how to set a default schema, refer to  the [Schemas](schemas.html#set_the_default_schema) topic.

[Video](https://resources.jetbrains.com.cn/help/img/idea/2026.2/tutorial_db_write_run_queries_sqlite.mp4)

## Step 3. Explore the database

Now you can explore your database and database objects in a tree view and also open the objects to view their data.  With the Database Tools and SQL plugin , you can do this in   Database   tool window .

Database Explorer
: Database   tool window  is a tool window that displays the database structure as a tree with nodes. You can create folders and move data sources to them, assign colors to data sources, filter the database objects, and so on.
:
:
:
: For more information about the tool window, refer to  the [Database tool window](database-tool-window.html) topic.  For more information about the tree icons, refer to  the [Data sources and their elements](database-tool-window.html#icons-for-data-sources-and-their-elements) chapter.

For example, let us navigate to the actor table and its columns.

Procedure:

PostgreSQL:

1.   In the    Database   tool window   ,  double-click the Demo_DB data source name to expand the list of introspected databases .

2.

Then, double-click the nodes or click the ![the Expand icon](https://resources.jetbrains.com.cn/help/img/idea/2026.2/app.actions.arrowExpand.svg) arrow icon near them to expand the list of items: `datagrip | public | tables | actor | columns`   .

3.  To view the actor table data, double-click its name.

IntelliJ IDEA will open the actor table in a data editor tab.

[Video](https://resources.jetbrains.com.cn/help/img/idea/2026.2/tutorial_db_explore_database_postgresql.mp4)

MySQL:

1.   In the    Database   tool window   ,  double-click the Demo_DB data source name to expand the list of introspected  schemas.

2.

Then, double-click the nodes or click the ![the Expand icon](https://resources.jetbrains.com.cn/help/img/idea/2026.2/app.actions.arrowExpand.svg) arrow icon near them to expand the list of items:  `datagrip | tables |  actor | columns`  .

3.  To view the actor table data, double-click its name.

IntelliJ IDEA will open the actor table in a data editor tab.

[Video](https://resources.jetbrains.com.cn/help/img/idea/2026.2/tutorial_db_explore_database_mysql.mp4)

SQLite:

1.   In the    Database   tool window   ,  double-click the Demo_DB data source name to expand the list of introspected  . schemas

2.

Then, double-click the nodes or click the ![the Expand icon](https://resources.jetbrains.com.cn/help/img/idea/2026.2/app.actions.arrowExpand.svg) arrow icon near them to expand the list of items:   `main | tables | actor | columns` .

3.  To view the actor table data, double-click its name.

IntelliJ IDEA will open the actor table in a data editor tab.

[Video](https://resources.jetbrains.com.cn/help/img/idea/2026.2/tutorial_db_explore_database_sqlite.mp4)

## Step 4. View, sort, and filter the data

With the Database Tools and SQL plugin , you can view and edit the data of database tables and views in the data editor and viewer.

Data editor and viewer
: The data editor and viewer, or data editor, provides a user interface for working with data. In the data editor, you can sort, filter, add, edit, and remove the data as well as perform other associated tasks.
:
:
:
: For more information about data editor, refer to  the [Data editor and viewer](data-editor-and-viewer.html) topic.

In this tutorial, we will sort the first_name column of actor table alphabetically and will also filter the last_name column to see the last names that start with `JO`.

Procedure:

PostgreSQL:

1.

To sort the data, in the data editor tab, click the arrows icon in the first_name column header. IntelliJ IDEA will send the `ORDER BY` query to the database and display its result in the editor.

For more information about sorting data on the database side and on the client side, refer to  the [Sort data](tables-sort.html) topic.

2.

To filter the data, in the data editor tab, click ![the Filter icon](https://resources.jetbrains.com.cn/help/img/idea/2026.2/app.expui.general.filter.svg) Local Filter in the last_name column header. Enter `JO` in the search field and select the Value checkbox, then click any area in the data editor.

IntelliJ IDEA will filter the data and display the result.

For more information about filtering data in the IDE, refer to  the [Filter data](tables-filter.html) topic.

[Video](https://resources.jetbrains.com.cn/help/img/idea/2026.2/tutorial_db_filter_sort_data_postgresql.mp4)

MySQL:

1.

To sort the data, in the data editor tab, click the arrows icon in the first_name column header. IntelliJ IDEA will send the `ORDER BY` query to the database and display its result in the editor.

For more information about sorting data on the database side and on the client side, refer to  the [Sort data](tables-sort.html) topic.

2.

To filter the data, in the data editor tab, click ![the Filter icon](https://resources.jetbrains.com.cn/help/img/idea/2026.2/app.expui.general.filter.svg) Local Filter in the last_name column header. Enter `JO` in the search field and select the Value checkbox, then click any area in the data editor.

IntelliJ IDEA will filter the data and display the result.

For more information about filtering data in the IDE, refer to  the [Filter data](tables-filter.html) topic.

[Video](https://resources.jetbrains.com.cn/help/img/idea/2026.2/tutorial_db_filter_sort_data_mysql.mp4)

SQLite:

1.

To sort the data, in the data editor tab, click the arrows icon in the first_name column header. IntelliJ IDEA will send the `ORDER BY` query to the database and display its result in the editor.

For more information about sorting data on the database side and on the client side, refer to  the [Sort data](tables-sort.html) topic.

2.

To filter the data, in the data editor tab, click ![the Filter icon](https://resources.jetbrains.com.cn/help/img/idea/2026.2/app.expui.general.filter.svg) Local Filter in the last_name column header. Enter `JO` in the search field and select the Value checkbox, then click any area in the data editor.

IntelliJ IDEA will filter the data and display the result.

For more information about filtering data in the IDE, refer to  the [Filter data](tables-filter.html) topic.

[Video](https://resources.jetbrains.com.cn/help/img/idea/2026.2/tutorial_db_filter_sort_data_sqlite.mp4)

## Next steps

After going through this tutorial, you can create a connection configuration and connect to a database using its JDBC URL, explore the connected database, run SQL queries in query consoles, and view the query results. Also, you can view, sort, and filter database object data.

To learn more about the IDE, consider the following topics and sections:

|     [Create a data source](managing-data-sources.html#create_a_data_source)     |     Use the instructions for various database vendors to create data sources for your databases.     |
|  [Data editor and viewer](data-editor-and-viewer.html)  |  Learn about the features you can use for viewing and managing data of database objects, query result sets, and DSV files.  |
|  [Query consoles](query-consoles.html)  |  This topic gives an idea of what the query console is and how to work with it in the IDE.  |
|  [Query results](viewing-query-results.html)  | This topic describes the ways of viewing query results. |
|  [Write and edit source code](working-with-source-code.html)  |  Find descriptions of the code editor features that you can use in query consoles, SQL files, and scratch files.  |
| [Export](export-data.html) | Learn how to export data and database objects. |
| [Database diagrams](creating-diagrams.html) | Learn how to view diagrams of your databases and schemas. |