How does it handle SSL for Azure?

The skill configures the client to use 'ssl: { rejectUnauthorized: true }', ensuring that all connections to Azure Database for PostgreSQL are encrypted and secure.

What PostgreSQL driver does this skill use?

It is built around the popular and high-performance 'pg' (node-postgres) package, which is the standard driver for Node.js and TypeScript environments.

Does this skill support passwordless authentication?

Yes, it provides detailed implementations for Microsoft Entra ID authentication using @azure/identity, which is the recommended security practice for Azure.

Can it handle token expiration for Entra ID?

Yes, it includes a custom AzurePostgresPool class implementation that monitors token expiry and automatically refreshes the Entra ID access token before it expires.

Is it compatible with TypeScript interfaces?

Absolutely. The skill demonstrates how to use TypeScript Generics with the pg package to provide full type safety for query results and rows.

Azure PostgreSQL for TypeScript

Name: Azure PostgreSQL for TypeScript
Author: microsoft

bymicrosoft

•

1,777

•

Database Management

Connects Node.js and TypeScript applications to Azure Database for PostgreSQL with support for secure Entra ID authentication and high-performance connection pooling.

This skill provides standardized patterns for integrating Azure Database for PostgreSQL Flexible Server into Node.js and TypeScript environments using the industry-standard pg (node-postgres) package. It offers comprehensive implementation guidance for both traditional password-based and modern Microsoft Entra ID (passwordless) authentication, while emphasizing best practices like connection pooling, parameterized queries to prevent SQL injection, and robust transaction management. Whether building microservices or large-scale backend systems, this skill ensures secure, type-safe, and efficient database interactions within the Azure ecosystem.

Key Features

011,777 GitHub stars

02Type-safe query implementations using TypeScript interfaces and Generic types.

03High-performance connection pooling configuration for production-grade scalability.

04Microsoft Entra ID (passwordless) authentication with automatic token refresh logic.

05Standardized transaction patterns with robust rollback and error handling.

06Best practice guides for SSL enforcement and security-first parameterized queries.

Use Cases

01Migrating legacy PostgreSQL applications to Azure Flexible Server with modern authentication.

02Implementing high-concurrency data processing layers requiring efficient connection management.

03Building secure, enterprise-grade backend services on Azure using Node.js and TypeScript.

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add microsoft/skills azure-postgres-ts

For use in Claude.ai and ChatGPT

Download Skill