Add connection fails

[kryvoff]

Type: Bug

I added a new connection to an RDS Postgres by filling the parameters.

Clicking "Save & Connect" leads to infitite spinner - no connection created, no error message even after minutes.

The logs show that you have a schema problem with profileName.

2026-02-10 12:41:18,213 ERROR Failed to deserialize notification workspace/didChangeConfiguration: 1 validation error for Configuration
pgsql.connections.0.profileName
  Field required [type=missing, input_value={'id': 'C2E6382B-2A03-45A...': 0, 'sshPassword': ''}, 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 267, in _dispatch_message
  File "ossdbtoolsservice/hosting/message_server.py", line 60, 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.profileName
  Field required [type=missing, input_value={'id': 'C2E6382B-2A03-45A...': 0, 'sshPassword': ''}, input_type=dict]
    For further information visit https://errors.pydantic.dev/2.10/v/missing
2026-02-10 12:41:18,246 ERROR Failed to deserialize notification workspace/didChangeConfiguration: 1 validation error for Configuration
pgsql.connections.0.profileName
  Field required [type=missing, input_value={'id': 'C2E6382B-2A03-45A...': 0, 'sshPassword': ''}, 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 267, in _dispatch_message
  File "ossdbtoolsservice/hosting/message_server.py", line 60, 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.profileName
  Field required [type=missing, input_value={'id': 'C2E6382B-2A03-45A...': 0, 'sshPassword': ''}, input_type=dict]
    For further information visit https://errors.pydantic.dev/2.10/v/missing
2026-02-10 12:43:38,348 ERROR Failed to deserialize notification workspace/didChangeConfiguration: 2 validation errors for Configuration
pgsql.connections.0.profileName
  Field required [type=missing, input_value={'id': 'C2E6382B-2A03-45A...'azureAccountToken': ''}, input_type=dict]
    For further information visit https://errors.pydantic.dev/2.10/v/missing
pgsql.connections.1.profileName
  Field required [type=missing, input_value={'id': '18AE908D-4AF3-4CB...': 0, 'sshPassword': ''}, 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 267, in _dispatch_message
  File "ossdbtoolsservice/hosting/message_server.py", line 60, 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: 2 validation errors for Configuration
pgsql.connections.0.profileName
  Field required [type=missing, input_value={'id': 'C2E6382B-2A03-45A...'azureAccountToken': ''}, input_type=dict]
    For further information visit https://errors.pydantic.dev/2.10/v/missing
pgsql.connections.1.profileName
  Field required [type=missing, input_value={'id': '18AE908D-4AF3-4CB...': 0, 'sshPassword': ''}, input_type=dict]
    For further information visit https://errors.pydantic.dev/2.10/v/missing
2026-02-10 12:43:38,397 ERROR Failed to deserialize notification workspace/didChangeConfiguration: 2 validation errors for Configuration
pgsql.connections.0.profileName
  Field required [type=missing, input_value={'id': 'C2E6382B-2A03-45A...': 0, 'sshPassword': ''}, input_type=dict]
    For further information visit https://errors.pydantic.dev/2.10/v/missing
pgsql.connections.1.profileName
  Field required [type=missing, input_value={'id': '18AE908D-4AF3-4CB...': 0, 'sshPassword': ''}, 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 267, in _dispatch_message
  File "ossdbtoolsservice/hosting/message_server.py", line 60, 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: 2 validation errors for Configuration
pgsql.connections.0.profileName
  Field required [type=missing, input_value={'id': 'C2E6382B-2A03-45A...': 0, 'sshPassword': ''}, input_type=dict]
    For further information visit https://errors.pydantic.dev/2.10/v/missing
pgsql.connections.1.profileName
  Field required [type=missing, input_value={'id': '18AE908D-4AF3-4CB...': 0, 'sshPassword': ''}, input_type=dict]
    For further information visit https://errors.pydantic.dev/2.10/v/missing

Extension version: 1.16.0
VS Code version: Code - Insiders 1.110.0-insider (417deb3dba650effea67ad99c066713a969efd2f, 2026-02-10T05:03:45.254Z)
OS version: Darwin arm64 25.2.0
Modes:

System Info

Item	Value
CPUs	Apple M3 (8 x 2400)
GPU Status	2d_canvas: enabled GPU0: VENDOR= 0x106b [Google Inc. (Apple)], DEVICE=0x0000 [ANGLE (Apple, ANGLE Metal Renderer: Apple M3, Version 26.2 (Build 25C56))], DRIVER_VENDOR=Apple, DRIVER_VERSION=26.2 ACTIVE Machine model name: Mac Machine model version: 15.3 direct_rendering_display_compositor: disabled_off_ok gpu_compositing: enabled multiple_raster_threads: enabled_on opengl: enabled_on rasterization: enabled raw_draw: disabled_off_ok skia_graphite: disabled_off trees_in_viz: disabled_off video_decode: enabled video_encode: enabled webgl: enabled webgl2: enabled webgpu: enabled webnn: disabled_off
Load (avg)	5, 5, 6
Memory (System)	16.00GB (0.17GB free)
Process Argv	--crash-reporter-id 1764d7f9-e753-4f20-9625-47ec003ecdc1
Screen Reader	no
VM	0%

A/B Experiments

vsliv368:30146709
pythonvspyt551:31249597
nativeloc1:31118317
dwcopilot:31158714
dwoutputs:31242946
copilot_t_ci:31333650
g012b348:31231168
pythonrdcb7:31268811
pythonpcpt1:31399616
6518g693:31302842
6abeh943:31336334
envsactivate1:31349248
editstats-enabled:31346256
cloudbuttont:31366566
42190218_ostrepl:31403339
56b7f661:31457055
use-responses-api:31390341
je187915:31401257
cp_cls_c_966_ss:31454199
chatvisible:31417128
inlinechat_v2_hd992725:31445440
ge8j1254_inline_auto_hint_haiku:31426887
a5gib710:31434435
2984c849_gpt52_codex:31457542
7a04d226_do_not_restore_last_panel_session:31429685
31c7i317_no_change:31458090
406hc587_ask_agent:31428392
preserve_tokens:31444547
cp_cls_t_1081:31454832
copilot-nes-oct-trt:31432609
ia-use-proxy-models-svc:31446143
nes-slash-models-on:31441832
core-renderer-profiling-on:31440366
a43f0574a:31442822
e9c30283:31453065
c0ci8992_validated:31449878
h_5b0j5247:31457745
nes-trig-10:31449242
idci7584:31454084
edit_mode_hidden:31453871
nes-ftch-ctrl:31458523
nes_chat_context_disabled:31451402
showstats:31452402
e3e4d672:31454087
864ei723_large_tool_results_to_disk:31455802
showingstats:31457201
pp-44cc9697:31455969
nes-fast-add:31454624
i54ji102:31455230
b1f5h706:31455228
7ef87755:31455235
nes-extended-on:31455475
nes-sp-on:31458511
anthropic_alt_t:31459357

[cdeil]

This is how it looks if I don't open the extension output log - spinning wheel of death:

[cdeil]

Actually after closing VS Code Insiders and re-opening it I see the connection was created (twice).

The original issue happened in a VS Code session right after installing the Postgres extension.

[mmcfarland]

Thanks for the report! I've tracked this down to a bug when saving a new profile and not supplying a connection name. It is meant to autogenerate one on save, as it does when vscode is first loaded (which is why it appears after restarting). Will get a fix included for the next release.

[mmcfarland]

This has been resolved in the current pre-release, v1.17.0 -- and will be available in the stable release v1.18.0 due this week. Please check it out and let us know if it's resolved your issue.

The issue here was "connection name" wasn't giving a default value when it was left blank -- and it is not a required field. The regression was fixed, and the default name should be generated correctly now.