"pgsql.serverGroups" entries are unusable

[nanderLP]

Describe the bug

I can't use server groups that I define using the project settings.json in connections defined in the same file.

To Reproduce

.vscode/settings.json

{
  "pgsql.serverGroups": [
    {
      "id": "foobar",
      "name": "foobar Local Servers",
      "color": "#248aff"
    }
  ],
  "pgsql.connections": [
    {
      "id": "supabase-local",
      "groupId": "foobar",
      "profileName": "Supabase Local",
      "server": "127.0.0.1",
      "user": "postgres",
      "emptyPasswordInput": true,
      "password": "",
      "database": "postgres"
    }
  ]
}

Expected behavior

The server group and connection should show up in the side panel

VS Code version

Version: 1.104.0-insider
Commit: 82ffae12bf43ec6e469c3ebbc7140cc93cd03006
Date: 2025-08-11T19:22:05.105Z
Electron: 37.2.3
ElectronBuildId: 12035395
Chromium: 138.0.7204.100
Node.js: 22.17.0
V8: 13.8.500258-electron.0
OS: Linux x64 6.15.9-arch1-1

Extension Logs
Output Logs:

[3:26:27 PM] [ObjectExplorerService] [Error]: Unable to find server group foobar for node with ID: supabase-local
[3:26:27 PM] [ObjectExplorerService] [Error]: Unable to find server group foobar for node with ID: supabase-local
[3:26:27 PM] [ObjectExplorerService] [All]: Getting root OE nodes
[3:26:27 PM] [PgToolsService Initialization] [Verbose]: readAllConnections: 2 connections; excluded recent)

PGSQL Logs:

2025-08-12 15:30:01,285 INFO Received notification method=$/setTraceNotification
2025-08-12 15:30:01,286 WARNING Notification method $/setTraceNotification is unsupported
2025-08-12 15:30:01,286 INFO Received notification method=workspace/didChangeConfiguration
2025-08-12 15:30:01,286 ERROR Failed to deserialize notification workspace/didChangeConfiguration: 1 validation error for Configuration
pgsql.connections.0.authenticationType
  Field required [type=missing, input_value={'id': 'supabase-local', ... 'database': 'postgres'}, input_type=dict]
    For further information visit https://errors.pydantic.dev/2.10/v/missing
Traceback (most recent call last):
  File "ossdbtoolsservice/hosting/message_server.py", line 253, in _dispatch_message
  File "ossdbtoolsservice/hosting/message_server.py", line 54, in deserialize_params
  File "ossdbtoolsservice/serialization/serializable.py", line 26, in from_dict
  File "ossdbtoolsservice/serialization/serializable.py", line 89, in convert_from_dict
  File "pydantic/main.py", line 627, in model_validate
pydantic_core._pydantic_core.ValidationError: 1 validation error for Configuration
pgsql.connections.0.authenticationType
  Field required [type=missing, input_value={'id': 'supabase-local', ... 'database': 'postgres'}, input_type=dict]
    For further information visit https://errors.pydantic.dev/2.10/v/missing

[mmcfarland]

Thanks for the report, @nanderLP. Unfortunately, the project settings.json file isn't fully supported right now (entries will get merged into the user setting.json, and can create duplicates as a result).

In this particular case, as the error indicates, you are also missing an authenticationType attribute and value. You likely want authenticationType": "SqlLogin" -- was this entry hand crafted?

[swimming-otter]

Hi @mmcfarland -- thanks for all the efforts on this extension! Can you say how much of a priority proper support for project settings.json is? Or if its on the medium-term roadmap at all? We are thinking of switching to this extension from something else and knowing whether we can expect that at some point would be of great help.

[mmcfarland]

Hi @swimming-otter -- yes, this is actually being actively developed now. It won't make the Sept release, so I would expect this to land in the 1-2 month time frame. It'll be published as a pre-release first, and I'll update this thread when that's available for folks to try out and give feedback. Thanks for your interest!

[mmcfarland]

Hi @nanderLP, @swimming-otter we've added multi-scope connection settings in v1.19.0 (pre-release), which should fix this. Server groups and connections defined in your .vscode/settings.json should now be correctly loaded and displayed in the sidebar. Could you give it a try and let us know if it's working?

We've also just released support for project settings support for connections, see the comment here. We'd love your feedback on that as well.