Allow connection profiles to be declared in workspace settings.json for team sharing

[chirag127]

Problem

Connection profiles in the PostgreSQL extension are stored in VS Code's global secret storage and user settings — neither of which is committed to source control. In a team environment, every developer must manually re-enter connection details (host, port, database, username) for shared databases (dev/staging). There is no way to ship a pre-populated, non-secret connection profile as part of a repository.

Use Case

A team wants to commit a .vscode/settings.json that pre-declares non-secret connection attributes:

{
  "pgsql.connections": [
    {
      "name": "Dev DB (shared)",
      "host": "dev-db.internal.example.com",
      "port": 5432,
      "database": "myapp_dev",
      "user": "devuser",
      "passwordSource": "prompt" // or "pgpass" | "secretStorage"
    }
  ]
}

When a developer clones the repo and opens it, the connection appears pre-populated in the sidebar — they only need to supply the password.

Why This Is Safe

Passwords are never committed (the passwordSource field controls where the credential comes from). Only non-secret metadata (host, port, db name, user) is in the settings file. This mirrors how SQL Server extension (mssql) handles workspace-level connection profiles.

Proposed Change

1. Add pgsql.connections as a workspace-scope configuration key (array of connection descriptors, no password field).
2. On activation, merge connections from workspace settings into the connections tree (alongside secret-storage ones), displaying a source badge ("workspace" vs "personal").
3. Connecting a workspace connection that has no password triggers the normal password prompt and optionally stores it in secret storage for the session.

Environment

• VS Code: 1.89+, team sharing .vscode/settings.json via git
• Extension: ms-ossdata.vscode-pgsql latest

[mmcfarland]

Thanks @chirag127 -- great suggestion, we'll look into this.

[mmcfarland]

There is no way to ship a pre-populated, non-secret connection profile as part of a repository.

Hi @chirag127, I understand that the request also involves using a password-less connection profile (as reiterated in #275 ), but in case it wasn't clear, we do currently support workspace defined connection settings for just this case. If using a PW connection type, the user will have to enter that manually after cloning, but otherwise the connection should be present in the project as part of the repository.

See: https://learn.microsoft.com/en-us/azure/postgresql/development/vs-code-extension/connections?tabs=vscode#advanced-connection-settings