Files
0d69e49081 Port @azure/postgresql-auth package from postgres-entra-auth repo (#37647)
## Description

Migrates the standalone
[azure-postgresql-auth](https://github.com/Azure/postgres-entra-auth/tree/main/javascript)
library into the monorepo as `@azure/postgresql-auth` - a new Azure SDK
client package providing Entra ID authentication for PostgreSQL
connections via both `pg` (node-postgres) and Sequelize clients.

### Key changes:
- **Source:** TypeScript implementation with full type safety
- `getEntraTokenPassword()` - acquires Entra ID token for use as
PostgreSQL password
- `configureEntraIdAuth()` - registers Sequelize `beforeConnect` hook
for automatic token-based auth
- **Build:** Uses `warp` build system with 4 targets (browser,
react-native, esm, commonjs)
- **Tests:** 19 unit tests with vitest (all passing)
- **Peer deps:** `pg` (>=8.0.0) and `sequelize` (>=6.0.0) as optional
peer dependencies
- **CI:** New `sdk/postgresql/ci.yml` data-plane pipeline
- **CODEOWNERS:** Updated

### References
- Standalone source:
https://github.com/Azure/postgres-entra-auth/tree/main/javascript
- .NET reference: https://github.com/Azure/azure-sdk-for-net/pull/55231
## Release Plan Details
- Release Plan:
https://web.powerapps.com/apps/821ab569-ae60-420d-8264-d7b5d5ef734c?release-plan-id=0213048b-d1f0-f011-8407-000d3a3b8d97
- Work Item Link:
https://dev.azure.com/azure-sdk/fe81d705-3c06-41e5-bf7c-5ebea18efe89/_workitems/edit/30201
- Spec Pull Request: 
- Spec API version: 1.0.0

---------

Co-authored-by: Copilot <[email protected]>
Co-authored-by: Matthew Boentoro <[email protected]>
Co-authored-by: Jeremy Meng <[email protected]>
2026-04-13 11:39:26 -07:00

53 lines
1.6 KiB
JavaScript

// Copyright (c) Microsoft Corporation.
// Licensed under the MIT License.
/**
* @summary Demonstrates how to connect to Azure Database for PostgreSQL using
* Entra ID authentication with Sequelize ORM.
*/
const { Sequelize } = require("sequelize");
const { DefaultAzureCredential } = require("@azure/identity");
const { configureEntraAuthentication } = require("@azure/postgresql-auth");
const dotenv = require("dotenv");
dotenv.config();
async function main() {
const credential = new DefaultAzureCredential();
// Create a Sequelize instance with PostgreSQL dialect
const sequelize = new Sequelize({
dialect: "postgres",
host: process.env.PGHOST,
port: Number(process.env.PGPORT || 5432),
database: process.env.PGDATABASE,
dialectOptions: { ssl: { rejectUnauthorized: true } },
pool: { min: 2, max: 10, idle: 30000 },
});
// Register the Entra ID `beforeConnect` hook.
// This automatically sets the username and password on each new connection.
configureEntraAuthentication(sequelize, credential);
try {
console.log("Connecting to Azure Database for PostgreSQL via Sequelize...");
await sequelize.authenticate();
console.log("Connected successfully with Entra ID!");
const [results] = await sequelize.query(
"SELECT current_user, now() AS server_time, pg_backend_pid() AS backend_pid",
);
console.log("Query result:", results[0]);
} finally {
await sequelize.close();
console.log("Connections closed.");
}
}
main().catch((error) => {
console.error("Error:", error.message);
process.exit(1);
});