Filter

The filter feature gives you precise control over which database objects appear in your explorer view, helping you focus on just the objects that matter for your current work.

How It Works

Right-click on any container item in the DB Explorer (databases, schemas, tables, views, etc.) and select Filter to control which child items are displayed.

This includes the connection itself. Right-click a connection to choose which databases appear beneath it. Filtering databases does not change the connection’s default database, so the catalog you connect to stays selected either way.

Filters are saved with the connection, so they persist across restarts and travel with the connection when it is synced or shared. Once a filter is applied, the container is labelled “filtered”, and you can adjust it by choosing Filter again or remove it with Clear Filter.

Filter Methods

Selection List

When you activate the filter, a list of available items will be presented, allowing you to:

• Select specific items to display
• Quickly include or exclude multiple items at once

SQL-like Pattern Matching

For more advanced filtering, type a SQL-style pattern into the input box instead of picking items. The pattern must begin with like or not like:

Pattern	Matches
like api%	Items starting with “api”
like %api	Items ending with “api”
like %api%	Items containing “api”
not like %temp%	Everything except items containing “temp”

A few details worth knowing:

• The like or not like keyword is required. A bare pattern such as %api% is treated as ordinary search text, not as a filter.
• Matching is case-insensitive, so like API% and like api% behave the same.
• If you leave off the trailing %, one is assumed. like api is the same as like api%.
• Quotes are optional. not like '%temp%' and not like %temp% are equivalent.

As you type, the list narrows to preview what the pattern matches. To save the pattern itself, press Enter without selecting any items. If you do select items, the filter is saved as that explicit list rather than as the pattern.

A filter is either a list of items or a single like / not like pattern. You cannot combine an include list with an exclude pattern, or apply more than one pattern to the same container.

Benefits

• Reduced Clutter: Hide rarely-used objects that get in your way
• Better Focus: Display only relevant objects for your current task
• Faster Navigation: Find what you need without scrolling through long lists
• Context-Specific Views: Create different filtered views for different projects or tasks

This feature is particularly useful when working with large databases that contain hundreds of tables, views, or other objects.