How to connect an Express app with Azure DB for PostgreSQL using Entra ID?

Question

We are trying to connect to our DB using Sequelize with the help of Entra ID and token as a password.

Is there any better way where we don't have to reset our DB connection every hour?

Currently we are using the API to get new token every 55 minutes and use it as password for DB connection which resets our DB connection

Answer 1

Hi @Shobhit , this document does a good job detailing possible solutions. You can also configure Microsoft Entra ID access for authentication with Azure Database for PostgreSQL flexible server: https://learn.microsoft.com/en-us/azure/postgresql/flexible-server/how-to-configure-sign-in-azure-ad-authentication

Please let me know if you have any questions and I can help you further.

If this answer helps you please mark "Accept Answer" so other users can reference it.

Thank you,

James