Favorites

The Favorites feature in DBCode lets you bookmark frequently accessed database objects, SQL files, and query snippets for quick access - all specific to your current VS Code workspace.

Overview

The Favorites panel provides a convenient way to save and organize:

  • Database objects (tables, views, procedures, etc.) from the DB Explorer
  • SQL files from your workspace
  • Selected SQL query snippets from your files

This makes it easy to quickly access items you use frequently without navigating through your entire database schema or file system.

Adding Items to Favorites

There are three ways to add items to your Favorites:

1. Drag from DB Explorer

You can add any database object directly from the DB Explorer:

  1. Find the item in the DB Explorer panel (table, view, stored procedure, etc.)
  2. Drag and drop it into the Favorites panel

2. Add SQL Files

To add SQL or other files to your Favorites:

  1. Locate the file in your VS Code Explorer, or as an open tab
  2. Drag and drop the file into the Favorites panel

3. Add Selected SQL Queries

To save a specific SQL query or code snippet:

  1. Open a .sql file
  2. Select the SQL query text you want to save
  3. Right-click on the selection
  4. Choose “Add to Favorites” from the context menu

Workspace-Specific Favorites

Your favorites are specific to your current VS Code workspace, allowing you to maintain different sets of favorites for different projects. When you switch workspaces, DBCode will display the favorites relevant to that workspace.

Usage Limits

  • Core Edition: Allows up to 2 favorites per workspace
  • Pro & Team Editions: Unlimited favorites per workspace

Having quick access to your most frequently used database objects and queries can significantly improve your productivity when working with databases in VS Code.