Server Explorer

Keep connections and their schema close at hand, organized for the way you think about your work.

Server Explorer is the tree on the left: connections at the top and a live view of schemas, tables, views, procedures, and more beneath each database. You decide how to group connections and arrange objects, while a local cache keeps the whole thing quick to open.

The header's overflow menu holds the grouping choices plus Manage Connections..., Collapse All, and Refresh. Most of the tree's organization is configured in Settings › Data Model › Server Explorer.

Finding your way around

PartWhat it does
FilterOpens a search field over the tree. Plain text matches object names; wrap a pattern in slashes for a regular expression (/^order/), and add c after the closing slash to make it case-sensitive (/^Order/c). Object-kind chips - Tables, Views, Routines, Columns, and more - narrow the match further.
Add serverOpens the connection editor for a new connection.
⋮ Explorer optionsGroup by (All, By client, By project, By environment, By server), then Manage Connections..., Collapse All, and Refresh, which re-reads the schema.
Server rowsA health dot - green connected, pulsing amber connecting, red failed, faded when it is only the last known state from a previous session - and a dot in the environment's color. Hover for the host and port, default database, sign-in method, environment, and connection state.

Right-click a server for Open in New Query, Connect and Disconnect, New Database…, a Connection submenu with Edit, Duplicate, or Delete Connection... and Add Server..., and a Tools submenu with the server tools. Databases, tables, and other objects have their own menus, and a Redis connection shows a key browser instead of a schema tree.

The larger menus keep the everyday actions at the top and group the rest into the same submenus everywhere. A database's menu always starts with New Query, followed by Browse Objects…, Search Database for Value… and Run SQL File...; its tools sit under Data (import, export, transfer, compare, backup), Schema (designers, schema compare, snapshots and history, models) and Tools (monitoring, security, maintenance). A table's menu starts with Select Top 1000, View Data, Filter Data... and Count Rows, then Design Query, Edit Structure…, Rename... and Delete (DELETE all rows, TRUNCATE, DROP TABLE); scripts are under Script As, exports and transfers under Data, dependencies under Dependencies, and models, maintenance, custom actions and the deploy cart under Tools. Copy Name and Copy Qualified Name are under Copy, next to Pin / Unpin, Refresh and Properties.

Keyboard

KeysAction
⌘B / CtrlBShow or hide the explorer (View › Toggle Object Explorer).
⌘⇧F / Ctrl⇧FJump to the explorer's filter.
↑ ↓ Home End Page Up Page DownMove through the tree.
→ / ←Expand or step into a node; collapse or step back to its parent.
EnterActivate the row - on a server, expand it and connect.
LettersType-ahead: jump to the next row whose name starts with what you type.
Space, ⇧ + arrowsAdd rows to a multi-selection for bulk operations.
⌘C / CtrlCCopy the selected object's name.
⇧F10 or the Menu keyOpen the selected row's context menu.
EscBack out one step: close the menu, then clear the filter, then the multi-selection, then the selection.

Shape the tree

These pages cover what you see. Start with grouping once your connection list outgrows one screen; tune the schema tree and system objects when a database's object list feels too noisy or too flat; read about the schema cache if the tree ever looks out of date.

Grouping views
See connections flat or grouped by client, project, environment, or server when a longer list needs a little order.
Schema tree
Learn how databases, schemas, and objects settle into a tree that stays easy to navigate.
System databases & schemas
Choose whether each engine's built-in objects are folded away, shown inline, or kept out of sight.
Schema cache
Keep the schema tree quick with a local cache that checks itself whenever you reconnect.

Act on what you find

These pages cover doing things from the tree: your own SQL templates on the right-click menu, the same action across many selected objects, and a cart that collects objects from several connections into one deployment script.

Custom actions
Turn your own SQL templates into right-click actions on tables, views, and routines.
Bulk operations
Multi-select objects in the tree and script, export, or maintain them all at once.
Deploy cart
Collect objects from any connection into a cart and generate one dependency-ordered script.