DataGrip 2023.1 Help

Show all databases or schemas

By default, DataGrip only shows the introspected schemas and databases in the Database Explorer. For the bigger data sources, this allows for saving the disk space and your time, as the introspection of larger amounts of schemas can be a long process. Also, you can hide the schemas or databases that are not required for your workflow.

You can either edit the list of schemas or databases to be introspected and shown, or enable the IDE to show all the data source schemas and databases but not introspect them.

Select schemas or databases

You can choose which schemas or databases will be introspected and shown by either selecting them in the Database Explorer, or editing the data source properties in Data Sources and Drivers dialog.

In the Database Explorer tool window

To select other databases or schemas that will be introspected and shown, do the following:

  1. In the Database Explorer ( View | Tool Windows | Database Explorer) tool window, click the N of M button next to the data source, database, or schema name.

    Select schemas or databases in data source properties
  2. Select the databases or schemas and press Enter.

In the data source properties

You can set the list of displayed databases and schemas in the Data Sources and Drivers dialog. Select the ones you need while setting up a connection to a new data source, or after the connection is established.

  1. Right-click the data source and select Properties. Alternatively, click the Data Source Properties icon (the Settings button), or press Control+Alt+Shift+S.

  2. In the Schemas tab of Data Sources and Drivers dialog, select the databases or schemas and press OK.

    Select schemas or databases in data source properties

Show all schemas and databases without introspection

If you need to see all the schemas and databases of your data source, enable the Show All Namespaces view mode.

  • Click the Options icon (the Show Options Menu icon) and select Show All Namespaces.

    the Show All Namespace setting

The grey color of schemas and databases names means that they are not introspected. To introspect either one of them, select it and click the Refresh icon (the Refresh icon).

Last modified: 11 January 2023