Custom OIDC / SSO Provider

[remadisson]

Summary

Add support for generic OIDC / SSO providers through a custom or oidc option.

Problem

pgconsole currently supports only a limited set of OIDC providers, making it impossible to use self-hosted alternatives such as Authentik or VoidAuth.

This is particularly limiting for homelabs, small teams, and personal projects where self-hosted identity providers are commonly used for access control.

Proposed Solution

Add a generic OIDC provider that accepts an issuer URL and automatically uses OIDC discovery:

[[auth.providers]]
type = "oidc"
issuer_url = "https://auth.example.com"
client_id = "pgconsole"
client_secret = "..."

This would allow pgconsole to work with any standards-compliant OIDC provider without requiring a dedicated integration for each provider.

[tianzhou]

which identity provider od you use

[remadisson]

at the moment voidauth

[RainyPixel]

+1

BTW that product is HUGE! Thanks for work on it :)