# mishat/ssmsautoconnect architecture

> Architecture diagram of the GitHub repository mishat/ssmsautoconnect, generated by GitDiagram from its file tree, README and a sample of source files (last updated 2026-10-04). It is an AI-made overview: check details against the source.

- Interactive diagram: https://gitdiagram.com/mishat/ssmsautoconnect
- Repository: https://github.com/mishat/ssmsautoconnect

## Overview

SsmsAutoConnect is an SSMS 18 extension that loads saved server/login choices at startup, validates connections, and adds them to Object Explorer with their configured database and color. Its second workflow lets a user save a selected database connection from the Object Explorer context menu. Configuration and credentials are stored separately; SQL-login passwords use current-user DPAPI. The bridge isolates SSMS-specific connection behavior, while the package coordinates startup and menu registration. Relationships are based on the excerpts and README; PasswordProtector’s implementation was not excerpted.

Main entry points: [`src/SsmsAutoConnect/StartupMenu.cs`](https://github.com/mishat/ssmsautoconnect/blob/main/src/SsmsAutoConnect/StartupMenu.cs) (Startup menu), [`src/SsmsAutoConnect/SsmsAutoConnectPackage.cs`](https://github.com/mishat/ssmsautoconnect/blob/main/src/SsmsAutoConnect/SsmsAutoConnectPackage.cs) (Extension package), [`src/SsmsAutoConnect/AutoConnector.cs`](https://github.com/mishat/ssmsautoconnect/blob/main/src/SsmsAutoConnect/AutoConnector.cs) (Auto connector), [`src/SsmsAutoConnect/Log.cs`](https://github.com/mishat/ssmsautoconnect/blob/main/src/SsmsAutoConnect/Log.cs) (Logger)

## Diagram (Mermaid)

```mermaid
flowchart TD

subgraph group_startup["Startup connections"]
  node_package["Extension package"]
  node_connector["Auto connector<br/>[AutoConnector.cs]"]
end

subgraph group_config["Configuration and credentials"]
  node_config["Connection config"]
  node_password["Password protection"]
  node_protect["Password CLI<br/>[Program.cs]"]
end

subgraph group_explorer["Object Explorer integration"]
  node_menu["Startup menu<br/>[StartupMenu.cs]"]
  node_bridge["Explorer bridge"]
end

subgraph group_observability["Logging"]
  node_log["Logger<br/>[Log.cs]"]
  node_logfile["Activity and file logs"]
end

node_user(("SSMS user"))
node_ssms["SSMS host"]
node_sql["SQL Server"]
node_oe["Object Explorer"]

node_ssms -->|"loads extension"| node_package
node_package -->|"loads entries"| node_config
node_package -->|"creates bridge"| node_bridge
node_package -->|"registers menu"| node_menu
node_package -->|"starts connections"| node_connector
node_connector -->|"validates and attaches"| node_bridge
node_connector -->|"decrypts passwords"| node_password
node_connector -->|"validates connection"| node_sql
node_connector -->|"adds server nodes"| node_oe
node_bridge -->|"uses connection API"| node_oe
node_user -->|"selects menu item"| node_menu
node_menu -->|"adds context command"| node_oe
node_menu -->|"adds or updates entry"| node_config
node_menu -->|"reads connection color"| node_bridge
node_menu -->|"protects password"| node_password
node_protect -->|"protects or verifies"| node_password
node_package -->|"records startup"| node_log
node_connector -->|"records outcomes"| node_log
node_menu -->|"records changes"| node_log
node_bridge -->|"records errors"| node_log
node_config -->|"records sample creation"| node_log
node_log -->|"writes logs"| node_logfile

click node_package "https://github.com/mishat/ssmsautoconnect/blob/main/src/SsmsAutoConnect/SsmsAutoConnectPackage.cs"
click node_connector "https://github.com/mishat/ssmsautoconnect/blob/main/src/SsmsAutoConnect/AutoConnector.cs"
click node_config "https://github.com/mishat/ssmsautoconnect/blob/main/src/SsmsAutoConnect/ConnectionConfig.cs"
click node_password "https://github.com/mishat/ssmsautoconnect/blob/main/src/SsmsAutoConnect/PasswordProtector.cs"
click node_protect "https://github.com/mishat/ssmsautoconnect/blob/main/src/SsmsAutoConnect.Protect/Program.cs"
click node_menu "https://github.com/mishat/ssmsautoconnect/blob/main/src/SsmsAutoConnect/StartupMenu.cs"
click node_bridge "https://github.com/mishat/ssmsautoconnect/blob/main/src/SsmsAutoConnect/ObjectExplorerBridge.cs"
click node_log "https://github.com/mishat/ssmsautoconnect/blob/main/src/SsmsAutoConnect/Log.cs"

classDef toneNeutral fill:#f8fafc,stroke:#334155,stroke-width:1.5px,color:#0f172a
classDef toneBlue fill:#dbeafe,stroke:#2563eb,stroke-width:1.5px,color:#172554
classDef toneAmber fill:#fef3c7,stroke:#d97706,stroke-width:1.5px,color:#78350f
classDef toneMint fill:#dcfce7,stroke:#16a34a,stroke-width:1.5px,color:#14532d
classDef toneRose fill:#ffe4e6,stroke:#e11d48,stroke-width:1.5px,color:#881337
classDef toneIndigo fill:#e0e7ff,stroke:#4f46e5,stroke-width:1.5px,color:#312e81
classDef toneTeal fill:#ccfbf1,stroke:#0f766e,stroke-width:1.5px,color:#134e4a
class node_package,node_connector,node_user toneBlue
class node_config,node_password,node_protect toneAmber
class node_menu,node_bridge,node_sql toneMint
class node_log,node_logfile toneRose
class node_ssms,node_oe toneIndigo
```

## Components

### Startup connections

- [Extension package](https://github.com/mishat/ssmsautoconnect/blob/main/src/SsmsAutoConnect/SsmsAutoConnectPackage.cs): `src/SsmsAutoConnect/SsmsAutoConnectPackage.cs`
- [Auto connector](https://github.com/mishat/ssmsautoconnect/blob/main/src/SsmsAutoConnect/AutoConnector.cs): `src/SsmsAutoConnect/AutoConnector.cs`

### Configuration and credentials

- [Connection config](https://github.com/mishat/ssmsautoconnect/blob/main/src/SsmsAutoConnect/ConnectionConfig.cs): `src/SsmsAutoConnect/ConnectionConfig.cs`
- [Password protection](https://github.com/mishat/ssmsautoconnect/blob/main/src/SsmsAutoConnect/PasswordProtector.cs): `src/SsmsAutoConnect/PasswordProtector.cs`
- [Password CLI](https://github.com/mishat/ssmsautoconnect/blob/main/src/SsmsAutoConnect.Protect/Program.cs): `src/SsmsAutoConnect.Protect/Program.cs`

### Object Explorer integration

- [Startup menu](https://github.com/mishat/ssmsautoconnect/blob/main/src/SsmsAutoConnect/StartupMenu.cs): `src/SsmsAutoConnect/StartupMenu.cs`
- [Explorer bridge](https://github.com/mishat/ssmsautoconnect/blob/main/src/SsmsAutoConnect/ObjectExplorerBridge.cs): `src/SsmsAutoConnect/ObjectExplorerBridge.cs`

### Logging

- [Logger](https://github.com/mishat/ssmsautoconnect/blob/main/src/SsmsAutoConnect/Log.cs): `src/SsmsAutoConnect/Log.cs`
- **Activity and file logs**

### Other components

- **SSMS user**
- **SSMS host**
- **SQL Server**
- **Object Explorer**

## Connections

- SSMS host → Extension package: loads extension (evidence: `README.md`)
- Extension package → Connection config: loads entries (evidence: `src/SsmsAutoConnect/SsmsAutoConnectPackage.cs`)
- Extension package → Explorer bridge: creates bridge (evidence: `src/SsmsAutoConnect/SsmsAutoConnectPackage.cs`)
- Extension package → Startup menu: registers menu (evidence: `src/SsmsAutoConnect/SsmsAutoConnectPackage.cs`)
- Extension package → Auto connector: starts connections (evidence: `src/SsmsAutoConnect/SsmsAutoConnectPackage.cs`)
- Auto connector → Explorer bridge: validates and attaches (evidence: `src/SsmsAutoConnect/AutoConnector.cs`)
- Auto connector → Password protection: decrypts passwords (evidence: `src/SsmsAutoConnect/AutoConnector.cs`)
- Auto connector → SQL Server: validates connection
- Auto connector → Object Explorer: adds server nodes (evidence: `src/SsmsAutoConnect/AutoConnector.cs`)
- Explorer bridge → Object Explorer: uses connection API (evidence: `src/SsmsAutoConnect/ObjectExplorerBridge.cs`)
- SSMS user → Startup menu: selects menu item (evidence: `README.md`)
- Startup menu → Object Explorer: adds context command (evidence: `src/SsmsAutoConnect/StartupMenu.cs`)
- Startup menu → Connection config: adds or updates entry (evidence: `src/SsmsAutoConnect/StartupMenu.cs`)
- Startup menu → Explorer bridge: reads connection color (evidence: `src/SsmsAutoConnect/StartupMenu.cs`)
- Startup menu → Password protection: protects password (evidence: `src/SsmsAutoConnect/StartupMenu.cs`)
- Password CLI → Password protection: protects or verifies (evidence: `src/SsmsAutoConnect.Protect/Program.cs`)
- Extension package → Logger: records startup (evidence: `src/SsmsAutoConnect/SsmsAutoConnectPackage.cs`)
- Auto connector → Logger: records outcomes (evidence: `src/SsmsAutoConnect/AutoConnector.cs`)
- Startup menu → Logger: records changes (evidence: `src/SsmsAutoConnect/StartupMenu.cs`)
- Explorer bridge → Logger: records errors (evidence: `src/SsmsAutoConnect/ObjectExplorerBridge.cs`)
- Connection config → Logger: records sample creation (evidence: `src/SsmsAutoConnect/ConnectionConfig.cs`)
- Logger → Activity and file logs: writes logs (evidence: `src/SsmsAutoConnect/Log.cs`)
