跳转到主要内容
此内容尚未提供您的语言版本,正在以英文显示。

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".

目的

To enable developers to reliably connect and interact with Azure Database for PostgreSQL from Node.js and TypeScript applications, leveraging secure authentication methods.

功能

  • Connect to Azure Database for PostgreSQL Flexible Server
  • Use node-postgres (pg) package
  • Support password authentication
  • Support Microsoft Entra ID (passwordless) authentication
  • Connection pooling for production
  • Parameterized queries to prevent SQL injection
  • Transaction management
  • Typed queries with TypeScript generics

使用场景

  • Connecting Node.js/TypeScript applications to Azure PostgreSQL.
  • Implementing secure authentication using Entra ID.
  • Managing database connections efficiently with connection pooling.
  • Executing complex queries and transactions safely.

非目标

  • Providing a full ORM solution.
  • Managing Azure infrastructure deployment.
  • Performing advanced database administration tasks beyond connection and querying.

安装

请先添加 Marketplace

/plugin marketplace add microsoft/skills
/plugin install azure-sdk-typescript@skills

质量评分

已验证
100 /100
1 day ago 分析

信任信号

最近提交1 day ago
星标2.3k
许可证MIT
状态
查看源代码

类似扩展

Senior Backend Engineer

100

Designs and implements backend systems including REST APIs, microservices, database architectures, authentication flows, and security hardening. Use when the user asks to "design REST APIs", "optimize database queries", "implement authentication", "build microservices", "review backend code", "set up GraphQL", "handle database migrations", or "load test APIs". Covers Node.js/Express/Fastify development, PostgreSQL optimization, API security, and backend architecture patterns.

技能
alirezarezvani

Hybrid Cloud Networking

100

Configure secure, high-performance connectivity between on-premises infrastructure and cloud platforms using VPN and dedicated connections. Use when building hybrid cloud architectures, connecting data centers to cloud, or implementing secure cross-premises networking.

技能
wshobson

Azure Servicebus Py

100

Azure Service Bus SDK for Python messaging. Use for queues, topics, subscriptions, and enterprise messaging patterns. Triggers: "service bus", "ServiceBusClient", "queue", "topic", "subscription", "message broker".

技能
microsoft

Azure Monitor Query Py

100

Azure Monitor Query SDK for Python. Use for querying Log Analytics workspaces and Azure Monitor metrics. Triggers: "azure-monitor-query", "LogsQueryClient", "MetricsQueryClient", "Log Analytics", "Kusto queries", "Azure metrics".

技能
microsoft

Azure Container Registry SDK for Python

100

Azure Container Registry SDK for Python. Use for managing container images, artifacts, and repositories. Triggers: "azure-containerregistry", "ContainerRegistryClient", "container images", "docker registry", "ACR".

技能
microsoft

Azure App Configuration SDK for Python

100

Azure App Configuration SDK for Python. Use for centralized configuration management, feature flags, and dynamic settings. Triggers: "azure-appconfiguration", "AzureAppConfigurationClient", "feature flags", "configuration", "key-value settings".

技能
microsoft