# Cannot find a database object in Database tool window

If you see no objects below the schema level, cannot find changes in objects, experience broken tables or any other visualization problems, collect the diagnostic information and try the troubleshooting steps to resolve the problem.

## Collect diagnostic information

> **Warning:**
> Collecting diagnostic information is necessary for resolving problems. It has to be performed prior to following the troubleshooting steps given in this topic.

To profile the introspection and diagnose possible issues, IntelliJ IDEA can generate   three files that include information about the following:

* `dataSource.txt`: the data source.

* `introspector.txt`: a module that was used to load the metadata from the database.

* `model.xml`: a part of the database model.

This information is helpful when introspection works incorrectly.

Procedure:

1. Right-click a data source and navigate to `Diagnostics | Generate Introspector Diagnostic Files`.

2. IntelliJ IDEA will generate three files with the introspector diagnostic info.

![Notification message with a link to introspection diagnostic files](https://resources.jetbrains.com.cn/help/img/idea/2026.2/db_introspection_info_files_location.png)

Click the link in the Diagnostic information collected notification message to navigate to the directory with generated files.

![Introspection diagnostic files in the file browser window](https://resources.jetbrains.com.cn/help/img/idea/2026.2/db_introspection_info_files.png)

The following screenshots show the example output of these three files.

* `dataSource.txt` ![Example of the dataSource.txt file](https://resources.jetbrains.com.cn/help/img/idea/2026.2/db_introspection_info_data_source_file.png)

* `introspector.txt` ![Example of the introspector.txt file](https://resources.jetbrains.com.cn/help/img/idea/2026.2/db_introspection_info_introspector_file.png)

* `model.xml` ![Example of the model.xml file](https://resources.jetbrains.com.cn/help/img/idea/2026.2/db_introspection_info_model_file.png)

## Perform troubleshooting steps

> **Note:**
> If steps 1, 2, 3, and 4 did not resolve your problem, inform JetBrains of your situation by creating a [YouTrack](https://youtrack.jetbrains.com/issues/DBE) ticket. After you have created the ticket, try step 5 as a workaround.

### Step 1. Refresh the database state

If someone changed the remote database data or view, the local view of the database might differ from the actual state of the database.

Procedure:

* To synchronize the database state automatically, in the   Database   tool window  ( `View  | Tool Windows |  Database` ), click the  Data Source Properties  button ![the Data Source Properties button](https://resources.jetbrains.com.cn/help/img/idea/2026.2/database-plugin.icons.expui.manageDataSources.svg) and select the data source that you want to change. On the  Options  tab, select the  Auto sync  checkbox.

If the  Auto sync  checkbox is cleared, the view of the data source in the   Database   tool window  ( `View  | Tool Windows |  Database` ) is synchronized with the actual state of the database only when you click the Refresh icon ![the Refresh icon](https://resources.jetbrains.com.cn/help/img/idea/2026.2/app-client.expui.general.refresh.svg) or press `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+F5` (NetBeans), `Ctrl+Alt+R` (Visual Studio), `⌘ ⌥ R` (Visual Studio (macOS)), `Ctrl+F5` (Eclipse), `Ctrl+F5` (Eclipse (macOS)).

![Refresh the database state](https://resources.jetbrains.com.cn/help/img/idea/2026.2/db_syncronize_database_state.png)

### Step 2. Verify that the necessary schemas are selected

> **Note:**
> If you see no schemas in the popup, check whether a connection to a data source is available. For more information, refer to [this troubleshooting article](connectivity-problems.html) or [report the situation to us](getting-help.html#contact-support).

When you create a data source, the data source is created with no schemas selected. You need to select schemas with which you plan to work.

To select the schemas, do one of the following:

Procedure:

* In the   Database   tool window ,  right-click a data source and navigate to `Tools | Manage Shown Schemas…`. Select or clear checkboxes of schemas that you want to display or hide. 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` (NetBeans), `Enter` (Visual Studio), `⏎` (Visual Studio (macOS)), `Enter` (Eclipse), `⏎` (Eclipse (macOS)).

* Click the N of M link near the data source name. In the database and schema selection window, select or clear checkboxes of schemas that you want to display or hide. 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` (NetBeans), `Enter` (Visual Studio), `⏎` (Visual Studio (macOS)), `Enter` (Eclipse), `⏎` (Eclipse (macOS)).

![Show and hide schemas and databases](https://resources.jetbrains.com.cn/help/img/idea/2026.2/show_and_hide_dbs_schemas.png)

The Default schema or Default database is a schema or a database that will be current in connection to a data source. The current schema is a schema that is current in a session. You can change the current schema by using `SET CURRENT_SCHEMA`. The default schema depends on database settings and data source settings that you set in the JDBC URL.

You can change this default in connection settings of a data source. To change the default, click the Data Source Properties icon ![The Data Source Properties icon](https://resources.jetbrains.com.cn/help/img/idea/2026.2/database-plugin.icons.expui.manageDataSources.svg) in the   Database   tool window  ( `View  | Tool Windows |  Database` ). From the list of data sources, select your data source. In the Database field, type the name of a schema or a database that you want to use as a default.

### Step 3. Ensure that the required introspection level is selected

The amount of metadata loaded for a database or a schema depends on the introspection level selected for it. To make sure enough metadata is loaded, do the following:

Procedure:

1. Check the current introspection level selected for your schema. To do this, right-click the schema in   Database   tool window  and navigate to the Introspection Level submenu.

The currently selected level is marked with a check mark. Use the [introspection levels description](introspection-levels.html#introspection_levels_description_table) to check whether the amount of metadata provided by this level is enough.

2. If the currently selected level is Default (Auto select), select Level 3: Everything.

For more information about the levels, refer to  the [Introspection levels](introspection-levels.html) topic.

![The introspection level selected currently for a database schema](https://resources.jetbrains.com.cn/help/img/idea/2026.2/current_introspection_level.png)

### Step 4. Verify that the tree filter is off

If the items of the object kind are filtered out from the view, the objects wil be hidden in the   Database   tool window .

To make sure the database object is not filtered out from the view, do the following:

Procedure:

1. In the   Database   tool window  toolbar, click ![the View Options icon](https://resources.jetbrains.com.cn/help/img/idea/2026.2/app.expui.general.show.svg) View Options.

2. Select ![the Filter icon](https://resources.jetbrains.com.cn/help/img/idea/2026.2/app-client.expui.general.filter.svg) Filter.

3. Navigate to the database object kind and make sure that the checkbox is ticked.

The green dot in the corner of filter icon indicates that the filter is on and some objects are filtered out.

Filtered:

Everything is filtered out except views and tables

![Only views and tables are selected to view in Database tool window](https://resources.jetbrains.com.cn/help/img/idea/2026.2/database_tool_window_items_filter_on.png)

Not filtered:

Nothing is filtered out

![All items are selected to view in Database tool window](https://resources.jetbrains.com.cn/help/img/idea/2026.2/database_tool_window_items_filter_off.png)

### Step 5. Force refresh schema information

The Force Refresh action clears the data source information from cache and loads it again from scratch.

Procedure:

* In the   Database   tool window ,  right-click a data source and select `Diagnostics | Force Refresh`.

![Force refresh schema information](https://resources.jetbrains.com.cn/help/img/idea/2026.2/db_force_refresh_schema_information.png)

### Step 6. Clear and synchronize the schema cache

Procedure:

* Clear the IntelliJ IDEA schema cache (right-click a schema and select `Diagnostics | Forget This Schema Cache` ). Synchronize the view (refer to [Step
1. Synchronize the database state](#refresh-the-database-state)).

### Switch to the JDBC-based introspector

> **Warning:**
> Switch to the JDBC-based introspector with caution and when requested by the JetBrains support team. This step may lead to problems with code generation because some objects and properties become unavailable or return wrong values.

Consider this step as a temporary workaround. If you cannot see objects in the   Database   tool window , you might have a bug. [Collect troubleshooting
materials](#collect-information-by-using-diagnostic-tools) and [send them to our support team]().

Procedure: Temporarily enable introspection with JDBC metadata

1. Open data source properties by doing one of the following:

* On the Database tool window toolbar, click ![The Data Sources icon](https://resources.jetbrains.com.cn/help/img/idea/2026.2/database-plugin.icons.expui.manageDataSources.svg) Data Sources.

* Press `Shift+Enter` (Windows), `⌘ I` (macOS), `⇧ ⏎` (IntelliJ IDEA Classic (macOS)), `⌘ I` (macOS System Shortcuts), `Shift+Enter` (XWin), `Shift+Enter` (GNOME), `Shift+Enter` (KDE), `Shift+Enter` (Emacs), `Shift+Enter` (Sublime Text), `⌘ I` (Sublime Text (macOS)), `Shift+Enter` (NetBeans), `Shift+Enter` (Visual Studio), `⌘ I` (Visual Studio (macOS)), `Shift+Enter` (Eclipse), `⌘ I` (Eclipse (macOS)) .

![Open the Data Source and Drivers dialog](https://resources.jetbrains.com.cn/help/img/idea/2026.2/open_data_sources_and_drivers_dialog.png)

2. On the Data Sources tab, select the data source that you want to modify.

3. Open the Advanced tab.

4. From the Expert options list, select the Introspect using JDBC metadata checkbox.

5. Synchronize the view (see [Step 1. Synchronize the database state](#refresh-the-database-state)).

![The Introspect using JDBC metadata option in the Expert options menu of the Data Source and Drivers dialog Advenced tab](https://resources.jetbrains.com.cn/help/img/idea/2026.2/db_advanced_data_source_settings_expert_introspect_jdbc_metadata.png)