azure-postgres-ts
Connect to Azure Database for PostgreSQL Flexible Server from Node.js/TypeScript using the pg (node-postgres) package. Use for PostgreSQL queries, connection pooling, transactions, and Microsoft Entra ID (passwordless) authentication. Triggers: "PostgreSQL", "postgres", "pg client", "node-postgres", "Azure PostgreSQL connection", "PostgreSQL TypeScript", "pg Pool", "passwordless postgres".
Target: Databases. Automatically collected · unverified.
Excerpt from the author’s documentation
Extracted from a fixed version of SKILL.md in its original language. This is the author’s documentation; installation, compatibility and runtime results have not been verified by this site.
Read the original English text
Topics in the source
- Azure PostgreSQL for TypeScript (node-postgres)
- Installation
- Environment Variables
- Authentication
- Option 1: Password Authentication
- Option 2: Microsoft Entra ID (Passwordless) - Recommended
- Core Workflows
- 1. Single Client Connection
Connect to Azure Database for PostgreSQL Flexible Server using the pg (node-postgres) package with support for password and Microsoft Entra ID (passwordless) authentication. For long-running applications, tokens expire and need refresh: | Setting | Value | Description | |---------|-------|-------------| | ssl.rejectUnauthorized | true | Always use SSL for Azure | | Default port | 5432 | Standard PostgreSQL port | | PgBouncer port | 6432 | Use when PgBouncer enabled | | Token scope | https://ossrdbms-aad.database.windows.net/.default | Entra ID token scope | | Token lifetime | 1 hour | Refresh before expiry | | Workload | max | idleTimeoutMillis | |----------|-------|---------------------| | Light (dev/test) | 5-10 | 30000 | | Medium (production) | 20-30 | 30000 | | Heavy (high concurrency) | 50-100 | 10000 | Note: Azure PostgreSQL has connection limits based on SKU. Check your tier's max connections. 1. Always use connection pools for production applications 2. Use parameterized queries - Never concatenate user input 3. Always close connections - Use try/finally or connection pools 4. Enable SSL - Required for Azure (ssl: { rejectUnauthorized: true }) 5. Handle token refresh - Entr
This is an excerpt. Refer to the complete source and its current requirements.
- Source repository
- microsoft/skills
- Source file
- .github/plugins/azure-sdk-typescript/skills/azure-postgres-ts/SKILL.md
- Fixed revision
- 9287b443662d2433c85621c7325ee72a0ce499b5
Sources and evidence
This record was collected automatically. Its documentation, suitability and runtime behavior have not been manually verified.
Author: Microsoft Skills · original repository metadata. Documentation review: Not reviewed. Last source check: 2026-11-10T19:02:06.584Z.
Categories are inferred from names, descriptions and paths. They do not establish compatibility.
License and attribution
MIT. Third-party content and copyright remain with their authors. Refer to the original license and terms.
Original license ↗Synchronization, copying and user-reported success do not mark a resource as runtime-tested.
Limitations and notes
- Collecting metadata does not mean this site has installed, adapted, runtime-tested or security-reviewed the resource.