Quick Open

The Quick Open feature provides fast, keyboard-driven navigation through your database connections, schemas, and objects. Instead of clicking through the DB Explorer tree, you can use Quick Open to jump directly to tables, views, procedures, and other database objects.

Opening Quick Open

Use the keyboard shortcut to open Quick Open:

• Mac: Ctrl + Cmd + O
• Windows/Linux: Ctrl + Win + O

You can also access it via the Command Palette (Cmd/Ctrl + Shift + P) and search for “DBCode: Quick Open”.

How It Works

Quick Open opens a picker you can either drill through or search. Press Enter to step into a connection, database, schema or object type, or just start typing at any level to search every object DBCode has already loaded beneath it.

1. Connections - Your saved database connections
2. Databases - Available databases within a connection
3. Schemas - Schemas within a database (where applicable)
4. Containers - Object types like Tables, Views, Procedures, Functions
5. Objects - Individual tables, views, and other database objects

Navigation

• Use the arrow keys to move through the list
• Press Enter to select and drill down into an item
• Select the back arrow (Ctrl + - on Mac) to navigate up the hierarchy
• Press Escape to close Quick Open

Smart Starting Context

Quick Open intelligently determines where to start based on your recent activity and workspace settings:

Priority Order

1. Workspace Default Connection: If you’ve set a workspace default connection (via the “Set as Workspace Default” command), Quick Open starts there.

2. Zero Config Connection: If DBCode has discovered a connection from your workspace (e.g., from a .env file, SQLite database, or other configuration), it uses that as the starting point.

3. All Connections: Otherwise Quick Open starts at the root, showing all your connections.

Quick Open also remembers the connection and database of your last pick. It does not start you there, since that would narrow every later search to that connection, but when you type, matches from that place rank ahead of equal matches elsewhere.

Wherever it starts, you can begin typing straight away.

Searching

Start typing at any level. Quick Open flattens everything it knows beneath that level into one ranked list, so from the top you search every connection at once, inside a group or watched folder only its connections, inside a folder such as Tables only that object type, and each result shows where it lives, using the same separator as your tab titles (prod-pg/app/public/Tables). Every word you type has to match somewhere in the name or the path, so prod users finds users in the connection named prod. Explorer filters and the explorer search do not apply here, so an object they hide can still be found and opened.

Connections, databases and schemas whose name matches what you typed are listed with the results, so you can pick one and keep typing to search only inside it. Inside a connection, matching monitoring views such as sessions or locks are listed too, and open when picked.

Only objects DBCode has already loaded can be searched. Whatever is still unloaded at your level is listed with not loaded beside it, and the title says how many there are: connections and databases you have never opened, or, inside a database, schemas that have not been loaded. Pick one to load it, or inside a database use the Load 10 more button in the title bar to load the next ten. Nothing is loaded until you pick it. With an explorer layout that sets system schemas aside, those are listed only when you type their name, except inside the system schemas folder itself, where they are counted and loaded like any other. Loaded names are remembered between sessions, so each schema is only ever loaded once.

On a fresh start Quick Open reads those remembered names back in the background as soon as it opens, without connecting to anything, starting with the connections you have queried most recently on this machine. Results from the connection you started in come first, then ties between other connections go to the one you used last.

Running Commands

When you select a database object in Quick Open, it automatically executes the default command for that object type:

• Tables/Views: Opens the data viewer showing the table contents
• Stored Procedures/Functions: Opens the routine definition
• Other Objects: Performs the default action for that object type

Tips

• Repeated Access: Quick Open remembers the connection and database you last picked from and ranks their matches first, so the table you keep coming back to is usually the top result.
• Combine with Zero Config: Set up a .env file in your project with your database connection, and Quick Open will automatically start at that connection.
• Workspace Default: For projects where you always work with a specific connection, set it as the workspace default for instant access.

Related Features

• Zero Config - Automatic connection discovery from .env files
• Filter - Filter objects in the DB Explorer tree view