Skills azure-postgres-ts

📦

azure-postgres-ts

Name: azure-postgres-ts
Author: sickn33

Content revision r2 Safe ⚙️ External commands🌐 Network access📁 Filesystem access🔑 Env variables

Build Secure Azure PostgreSQL Clients in TypeScript

Connecting Node.js applications to Azure PostgreSQL requires secure authentication, pooling, and reliable query patterns. This skill provides focused TypeScript guidance for password and Microsoft Entra ID connections.

Supports: Claude Codex Code(CC)

🥉 78 Bronze

Install with my Agent

Copy this request to your Agent. It includes the canonical Skill page and manifest.

Agent request

Review the Skillstore skill "azure-postgres-ts" from https://skillstore.io/skills/sickn33-azure-postgres-ts.md and its manifest at https://skillstore.io/api/skills/sickn33-azure-postgres-ts/manifest. Verify the artifact. You may proceed after verification, subject to the environment's own policy.

Your Agent should still show its plan and request any confirmation required by the security policy.

Agent-readable resources

Use these links when an AI agent, crawler, or script needs clean context instead of reading the full page.

Markdown detail GET /skills/sickn33-azure-postgres-ts.md Signed manifest GET /api/skills/sickn33-azure-postgres-ts/manifest Signed lockfile GET /api/skills/sickn33-azure-postgres-ts/lockfile

Test it

Using "azure-postgres-ts". Create a production connection approach using Microsoft Entra ID for an API service.

Expected outcome:

Use DefaultAzureCredential with the Azure PostgreSQL token scope.
Create an SSL-enabled pool with bounded size and connection timeouts.
Refresh tokens before expiration and close replaced pools.

Using "azure-postgres-ts". Plan safe creation of a user and related order in one operation.

Expected outcome:

A transaction plan begins the operation, inserts both records with parameters, commits on success, rolls back on failure, and releases the client.

Using "azure-postgres-ts". Explain how to diagnose common PostgreSQL failures.

Expected outcome:

Map known database error codes to useful application outcomes.
Avoid exposing credentials, tokens, query parameters, or sensitive error details.
Re-throw unexpected failures after recording sanitized operational context.

Security Audit

Safe

v5 • 7/23/2026 Open versioned report

All 121 static findings are false positives caused by Markdown formatting, documentation URLs, standard process.env configuration, and illustrative parameterized SQL. The file contains guidance only, with no executable scripts, hidden-file access, credential exfiltration, system reconnaissance, or prompt injection.

Files scanned

487

Lines analyzed

Review items

False positives ignored

Risk Factors

⚙️ External commands (42)

🌐 Network access (8)

SKILL.md:72 SKILL.md:293 SKILL.md:429 SKILL.md:474 SKILL.md:475 SKILL.md:476 SKILL.md:477 SKILL.md:478

📁 Filesystem access (3)

SKILL.md:72 SKILL.md:293 SKILL.md:429

🔑 Env variables (42)

No confirmed security findings were detected by the latest completed static and semantic audit. This does not prove the skill has no side effects.

Audited by: codex View Audit History →

Share & cite this report

Share the versioned assessment report, neutral badge, embed card, and citations. Skillstore reports evidence without deciding whether this Skill is safe.

Open versioned report

Copy report link

https://skillstore.io/skills/sickn33-azure-postgres-ts/audits/5?utm_source=security_passport&utm_medium=share&utm_campaign=versioned_report

Markdown badge

[![Skillstore security assessment](https://skillstore.io/badges/skills/sickn33-azure-postgres-ts/security.svg)](https://skillstore.io/skills/sickn33-azure-postgres-ts?utm_source=security_passport_badge)

HTML badge

<a href="https://skillstore.io/skills/sickn33-azure-postgres-ts?utm_source=security_passport_badge"><img src="https://skillstore.io/badges/skills/sickn33-azure-postgres-ts/security.svg" alt="Skillstore security assessment" loading="lazy"></a>

Embed card

<iframe src="https://skillstore.io/embed/skills/sickn33-azure-postgres-ts.html" title="Skillstore Security Assessment" sandbox="allow-popups allow-popups-to-escape-sandbox" loading="lazy" referrerpolicy="no-referrer" width="420" height="180"></iframe>

Academic citations (APA · BibTeX · CFF)

APA citation

sickn33. (2026). azure-postgres-ts security audit report (audit version 5) [Author version unspecified]. Skillstore. https://skillstore.io/skills/sickn33-azure-postgres-ts/audits/5

BibTeX citation

@techreport{sickn33-sickn33-azure-postgres-ts-2026,
  author = {sickn33},
  title = {azure-postgres-ts security audit report (audit version 5)},
  institution = {Skillstore},
  year = {2026},
  number = {5},
  url = {https://skillstore.io/skills/sickn33-azure-postgres-ts/audits/5},
  note = {Author version unspecified}
}

CITATION.cff

cff-version: 1.2.0
message: "If you use this Skill, cite its author and this versioned security audit report."
title: "azure-postgres-ts security audit report (audit version 5)"
version: "unspecified"
type: report
authors:
  - name: "sickn33"
date-released: "2026-07-23"
url: "https://skillstore.io/skills/sickn33-azure-postgres-ts/audits/5"
identifiers:
  - type: other
    value: "skillstore:sickn33-azure-postgres-ts:audit:5"
    description: "Skillstore immutable audit report identifier"

Skillstore Score

Why this score Evidence Confidence: High

Architecture

Maintainability

Content

Community

Spec Compliance

What You Can Build

Create a service connection

Build a first TypeScript connection with password authentication, SSL verification, and reliable cleanup.

Adopt passwordless authentication

Replace stored database passwords with Microsoft Entra ID tokens and managed identity configuration.

Harden production data access

Review pooling, transactions, parameterized queries, token refresh, and database error handling.

Try These Prompts

Connect with a password

Create a TypeScript Azure PostgreSQL client using node-postgres, password authentication, SSL verification, environment variables, and guaranteed cleanup.

Create a connection pool

Build a reusable node-postgres pool with sensible limits, timeouts, parameterized queries, error handling, and graceful shutdown.

Add managed identity

Convert my Azure PostgreSQL configuration to DefaultAzureCredential, explain required environment values, and implement token refresh without logging secrets.

Design production data access

Design a typed TypeScript data layer using pooling, transaction helpers, parameterized queries, Entra ID token renewal, metrics, and structured database errors.

Best Practices

Prefer Microsoft Entra ID and managed identities when the deployment environment supports them.
Use parameterized queries, verified SSL, bounded pools, explicit timeouts, and graceful shutdown.
Test token renewal, transaction rollback, connection exhaustion, and database outages before production release.

Avoid

Do not concatenate user input into SQL statements.
Do not embed database passwords, access tokens, or complete connection strings in source code or logs.
Do not create an unbounded pool or leave clients checked out after failures.

Frequently Asked Questions

Which PostgreSQL library does this skill use?

It uses pg, also called node-postgres, with TypeScript type definitions.

Which authentication methods are covered?

It covers password authentication and Microsoft Entra ID tokens obtained through DefaultAzureCredential.

Does it require encrypted connections?

Yes. The examples enable SSL certificate verification for Azure PostgreSQL connections.

Does it provision Azure infrastructure?

No. You must create the server, network access, identities, roles, and database separately.

Can it replace schema-specific testing?

No. Adapt queries and types to your schema, then test authentication, permissions, failures, and performance in your environment.

Does the skill execute commands automatically?

No. It provides guidance and examples. Tool execution remains governed by your coding agent and approval policies.

Developer Details

Author

sickn33

License

MIT

Skillstore revision

Version notice

The author did not declare a version.

Repository

https://github.com/sickn33/antigravity-awesome-skills/tree/main/skills/azure-postgres-ts

Ref

f9e2c34b4f19c7f3e6b0a1e93227b5f77cc12526

Maintenance freshness

7/26/2026

Usage

7 downloads · 116 views

File structure

📄 SKILL.md

More from sickn33

View all

📦

content-creator

Create Brand-Consistent Marketing Content

Marketing teams need content that stays consistent across channels. This skill helps plan, write, analyze, and optimize content for brand voice and SEO.

Writing & Content View

📦

prompt-engineering-patterns

Improve LLM Prompts With Proven Patterns

Inconsistent prompts waste time and make AI outputs hard to trust. This skill guides prompt design with reusable patterns, examples, evaluation steps, and optimization workflows.

Productivity View

📦

senior-architect

Review Architecture Workflows and Project Paths

Architecture reviews need a consistent starting point and clear project boundaries. This skill provides workspace-scoped tool templates, command examples, and generic design references.

Coding & Development View

📦

senior-fullstack

Review Fullstack Project Foundations

Fullstack project setup can require many tools and checks. This skill provides basic local wrappers, common commands, and general engineering guidance.

Coding & Development View

📦

prompt-engineer

Optimize AI Prompts With Prompt Engineer

Writing clear prompts is hard when goals are vague or complex. This skill turns rough requests into structured prompts using proven prompt frameworks.

Productivity View

📦

product-manager-toolkit

Prioritize Product Work With Research Insights

Product teams need faster ways to rank features, synthesize interviews, and document decisions. This skill provides RICE scoring, interview analysis, and PRD templates for structured planning.

Productivity View

View all

📦

playwright-testing

Build Reliable Playwright Tests

by C0ntr0lledCha0s

Playwright test suites can become flaky, slow, and difficult to maintain. This skill provides practical patterns for locators, fixtures, page objects, debugging, mocking, and configuration.

Coding & Development View

📦

nestjs-code-audit

Audit NestJS Code with Evidence-Backed Findings

by amirtaherkhani

NestJS repositories can hide boundary flaws and runtime risks that lint results alone cannot reveal. This skill combines local evidence collection and semantic review into one prioritized report.

Coding & Development View

📦

starknet-js

Build Starknet Apps with starknet.js

by internet-court

Starknet integrations require precise provider, account, transaction, and fee handling across several APIs. This skill provides focused starknet.js v9.x patterns for reliable TypeScript applications.

Coding & Development View

📦

vue-best-practices

Improve Vue 3 Code Quality

by vuejs-ai

Vue projects often collect reactivity, component, and performance mistakes over time. This skill gives targeted Vue 3 guidance for safer patterns and clearer code.

Coding & Development View

📦

senior-backend

Build Reliable Backend APIs

by alirezarezvani

Backend projects often need consistent planning across APIs, databases, security, and deployment. This skill gives Claude, Codex, and Claude Code structured backend guidance with simple helper scripts and references.

Coding & Development View

📦

react-dev

Build Type-Safe React Components

by softaworks

React TypeScript work often needs precise event, hook, and route types. This skill provides focused patterns for typed components, React 19 APIs, and routing.

Coding & Development View

azure-postgres-ts

Install with my Agent

Agent-readable resources

Test it

Security Audit

Risk Factors

Copy report link

Markdown badge

HTML badge

Embed card

APA citation

BibTeX citation

CITATION.cff

Skillstore Score

What You Can Build

Create a service connection

Adopt passwordless authentication

Harden production data access

Try These Prompts

Best Practices

Avoid

Frequently Asked Questions

Developer Details

More from sickn33

content-creator

prompt-engineering-patterns

senior-architect

senior-fullstack

prompt-engineer

product-manager-toolkit

Related Skills

playwright-testing

nestjs-code-audit

starknet-js

vue-best-practices

senior-backend

react-dev