CtrlK
BlogDocsLog inGet started
Tessl Logo

azure-postgres-ts

Connect to Azure Database for PostgreSQL Flexible Server from Node.js/TypeScript using the pg (node-postgres) package.

52

Quality

59%

Does it follow best practices?

Run evals on this skill

Adds up to 20 points to the overall score

View guide

SecuritybySnyk

Passed

No findings from the security scan

Fix and improve this skill with Tessl

tessl review fix ./plugins/AI-Agents-Safe-Coding-Skills-claude/skills/azure-postgres-ts/SKILL.md

The canonical home for this skill is azure-postgres-ts in administrakt0r/AI-Agents-Safe-Coding-Skills

SKILL.md
Quality
Evals
Security

Quality

Content

53%Scale 1-5

Reviews the quality of instructions and guidance provided to agents. Good implementation is clear, handles edge cases, and produces reliable results.

The skill provides excellent, executable TypeScript code examples covering all major Azure PostgreSQL connection patterns with node-postgres. However, it is significantly over-long and repetitive, with connection configuration duplicated across multiple sections and several sections covering knowledge Claude already possesses (pool events, best practices list, key types). The content would benefit from aggressive trimming and splitting into separate reference files.

Suggestions

Reduce repetition by defining the connection config once and referencing it in subsequent examples, cutting at least 30-40% of the content.

Move Pool Events, Pool Sizing Guidelines, Best Practices list, Key Types, and Reference Links into a separate REFERENCE.md file, keeping SKILL.md focused on the core connection patterns and Entra ID specifics.

Remove sections that explain concepts Claude already knows well (e.g., parameterized queries, basic pool usage, TypeScript generics for query results) or reduce them to one-line reminders.

Add an explicit setup/verification workflow: 1) Set env vars, 2) Test connection with a simple query, 3) Verify SSL is working, 4) Confirm auth method before proceeding to application code.

DimensionReasoningScore

Conciseness

The skill is significantly verbose at ~350 lines. It repeats connection configuration across multiple sections (password auth, single client, pool all repeat the same config object). Pool events, pool sizing guidelines, best practices list, and key types sections add bulk that Claude already knows or could infer. The Entra ID token refresh class is useful but lengthy.

2 / 5

Actionability

All code examples are fully executable, copy-paste ready TypeScript with proper imports, error handling, and realistic patterns. Covers authentication, pooling, parameterized queries, transactions, typed queries, token refresh, and error handling with specific PostgreSQL error codes.

5 / 5

Workflow Clarity

The content presents individual patterns clearly but lacks explicit workflow sequencing with validation checkpoints. There's no step-by-step 'set up your Azure PostgreSQL connection' workflow with verification steps (e.g., test connection, verify SSL, confirm auth). For database operations, the transaction examples have proper error handling but there's no overall connection validation workflow.

3 / 5

Progressive Disclosure

Everything is inlined in a single monolithic file with no bundle files. The Entra ID token refresh class, pool events, error handling, and connection string format sections could easily be split into separate reference files. The reference links table at the end is helpful but the content itself would benefit greatly from being split across files.

2 / 5

Total

12

/

20

Passed

Description

64%Scale 1-5

Based on the skill's description, can an agent find and select it at the right time? Clear, specific descriptions lead to better discovery.

The description clearly identifies a narrow, specific technology combination (Azure PostgreSQL Flexible Server + Node.js/TypeScript + pg package), making it highly distinctive. However, it only describes one action ('Connect to') without covering additional capabilities, and it lacks an explicit 'Use when...' clause that would help Claude know when to select this skill.

Suggestions

Add a 'Use when...' clause, e.g., 'Use when the user needs to connect to Azure Database for PostgreSQL Flexible Server from a Node.js or TypeScript application, or mentions Azure Postgres with node-postgres/pg.'

Expand the capability list beyond just 'Connect to' — mention related actions like configuring SSL, setting up connection pooling, handling Azure AD authentication, or running queries.

DimensionReasoningScore

Specificity

Names the domain (Azure Database for PostgreSQL Flexible Server, Node.js/TypeScript, pg package) and describes one concrete action ('Connect to'), but doesn't list additional capabilities like querying, connection pooling, SSL configuration, or authentication methods.

3 / 5

Completeness

Has a clear 'what' (connect to Azure PostgreSQL Flexible Server from Node.js/TypeScript using pg), but there is no explicit 'when' clause or trigger guidance. Per rubric guidelines, missing 'Use when...' caps completeness at 3.

3 / 5

Trigger Term Quality

Includes strong natural keywords: 'Azure Database for PostgreSQL', 'Flexible Server', 'Node.js', 'TypeScript', 'pg', 'node-postgres'. Missing some variations users might say like 'Azure Postgres', 'database connection', '.ts', or 'connection string'.

4 / 5

Distinctiveness Conflict Risk

Highly specific niche combining Azure Database for PostgreSQL Flexible Server + Node.js/TypeScript + pg package. This is unlikely to conflict with other skills due to the very specific technology stack combination.

5 / 5

Total

15

/

20

Passed

Validation

90%

Checks the skill against the spec for correct structure and formatting. All validation checks must pass before discovery and implementation can be scored.

Validation10 / 11 Passed

Validation for skill structure

CriteriaDescriptionResult

frontmatter_unknown_keys

Unknown frontmatter key(s) found; consider removing or moving to metadata

Warning

Total

10

/

11

Passed

Repository
administrakt0r/AI-Agents-Safe-Coding-Skills
Reviewed

Table of Contents

Is this your skill?

If you maintain this skill, you can claim it as your own. Once claimed, you can manage eval scenarios, bundle related skills, attach documentation or rules, and ensure cross-agent compatibility.