Pre-introspected objects from system catalogs

A system catalog is a place where a relational database management system (DBMS) stores information about tables and columns, built-in functions, and other schema objects. The IDE uses data from this catalog for code completion and other coding assistance operations.

System schemas have the lightning icon in the schema selection dialog. If you do not select these schemas, DataSpell does not introspect them and does not show them in the Database tool window. Though information about schema objects is used in coding assistance. It is possible because DataSpell uses the internal data about schema objects that was introspected earlier (pre-introspected data).

To disable usage of pre-introspected data in DataSpell, open data source settings by pressing Shift+Enter, click the Options tab and deselect Use pre-introspected objects for system catalogs that are not introspected.

Examples of system catalogs in different DBMS:

PostgreSQL: pg_catalog, information_schema
Microsoft SQL Server: INFORMATION_SCHEMA
Oracle: SYS, SYSTEM
MySQL, MariaDB: information_schema
IBM Db2 LUW: SYSCAT, SYSFUN, SYSIBM, SYSIBMADM, SYSPROC, SYSPUBLIC, SYSSTAT, SYSTOOLS

Show objects from system catalogs in coding assistance

Introspect system catalogs for a data source

By default, DataSpell uses pre-introspected objects for system catalogs.

In the Database tool window ( Window | Tool Windows | Database) , right-click a data source and select Properties.
In the Data Sources and Drivers dialog, click the Options tab.
Clear the Use pre-introspected objects for system catalogs that are not introspected checkbox.
Click the N of M button near the database name to open the schema selection popup window.
In the schema selection popup window, select system catalogs that you want to introspect.

DataSpell introspects the selected system catalogs.

Use pre-introspected data for a certain system catalog

You can still use pre-introspected objects for a certain system catalog even if you disable the usage of such objects for a data source in its settings.

In the Database tool window ( Window | Tool Windows | Database) , right-click a data source and select Properties.
In the Data Sources and Drivers dialog, click the Options tab.
Clear the Use pre-introspected objects for system catalogs that are not introspected checkbox.
Click the N of M button near the database name to open the schema selection popup window.
In the schema selection popup window, click the system catalog name.
Clear the checkbox near system catalog name and click the lightning icon in the upper-right corner of the window.

DataSpell uses pre-introspected data only for the system catalog that you selected.

Last modified: 07 April 2025