Feature request: filter visible databases by pattern in a single MSSQL connection

[alissoneloi]

I'm using DBCode with a MSSQL connection to a server that hosts many databases. The database field works well to pre-select a default catalog, but the DB Explorer still shows all accessible databases on the server.

I would like to be able to filter which databases appear in the explorer for a given connection, while keeping the default database pre-selected.

Example use case:

Server: my-server
User: my-user
Databases on server: APP_PROD, APP_HMG, APP_DEV, OTHER_DB, master, etc.
Desired behavior: connect and list only APP_* databases, with APP_PROD as the default/pre-selected catalog.
Proposed setting:

json
{
  "database": "APP_PROD",
  "databaseFilter": {
    "include": ["APP_*"],
    "exclude": ["OTHER_DB", "master"]
  }
}

Is this something that could be supported?

[mikeburgh]

This is already supported, right-click the connection in the DB Explorer (or the Databases container under it) and pick "Filter". You can either tick the specific databases you want, or type a SQL-style pattern into the input box and press Enter without ticking anything. For your case like APP_% will show APP_PROD, APP_HMG and APP_DEV and drop OTHER_DB and master.

not like works too, so not like %_DEV would hide just the dev ones.

The filter is stored on the connection config, so it syncs and shares along with everything else, and it doesn't touch the database field. APP_PROD stays your pre-selected catalog.

There are some docs on it here https://dbcode.io/docs/db-explorer/filter

Does that work for you ?