improve: verify PostgreSQL plugin completion cancellation and cleanup (#201018)

* test(agents): qualify PostgreSQL plugin completion lifecycle

* test(agents): isolate direct completion auth from stored profiles