Ability to Pin Items in sidebar for SQL based databases

[rasyidrafi]

What

Add the ability to pin items in the DBCode left sidebar (DB Explorer), including:

• Pin Connection: Right-click a connection → Pin Connection.

  • Pinned connections are always shown at the top of the sidebar.
  • Display a visible pin icon to indicate pinned status.

• Pin Database: Right-click a database under a connection → Pin Database.

  • Pinned databases remain at the top within their parent connection.

• Pin Table: Right-click a table → Pin Table.

  • Pinned tables appear at the top of the table list for that database.

Pinned items should remain pinned across restarts.

---

Why (problem/use case)

When working with servers that contain many connections, databases, and tables, navigation becomes slow and repetitive. Frequently used connections or tables are often buried deep in long lists, requiring constant scrolling and expanding/collapsing nodes.

Pinning would:

• Reduce navigation time for commonly used resources
• Improve focus when working on a small subset of databases/tables
• Make large database environments significantly easier to manage
• Match usability patterns found in other developer tools (e.g., pinned files, favorites)

---

Additional Context

• Expected UX:

  • Right-click context menu actions (Pin / Unpin)
  • Pinned items visually separated or sorted above non-pinned items
  • Clear pin icon for discoverability

• This is especially useful for:

  • Multi-tenant database servers
  • Production + staging environments
  • Schemas with hundreds of tables (My Main Issues)

Screenshots for reference

Pin Connection

Pin Database

Pin Table

[mikeburgh]

Still thinking about make sense on this and if I want to introduce another concept like pining.. but in the meantime I added a favorites section to each data (if you have something from that data in favorites).

So now when you add something to favorites it will show up in that connections database at the top when you expand it.. so you can put all high priority items at the top.. does not solve pinning connections themselves, but you can drag to re order them already.

This has been released in 1.28.5

[rasyidrafi]

thanks this works, but i have some issue though, i think it didnt persist, sometimes its disappear and i had to re-add my tables to favorites, and also, did this persist after i logged out? eg change device, and did there's a way to make it workspace level instead? for example putting on .vscode/settings.json

[mikeburgh]

Did the the tables vanish from the connections area and favorites or just the connections area ?

The favorites are currently stored in settings.json so they will sync with your vscode settings if you have that enabled and change devices.

Workspace wise I will think about that.. I am also working on changes to favorites for team sharing and other things so may add a github backing config to it or something along those lines.. still need to work through it.

[mikeburgh]

Okay so I have finished re working the old favorites.. it's now library.. and I have moved favorites to be just items within the connection.. so you can right click them and choose to favorite something and it then goes to the top into favorites. They are also now stored in the connection configuration so they are portable.. old favorites were a bit of a nightmare as they were workspace scoped and easy to loose.

Library takes over storing snippets, file references, query builders and other stuff in either a project or personal scope (for now).

This has been released in 1.28.14

[rasyidrafi]

thanks, I've checked it, it working well 👍🏻 😄