Node.js LTS and backend patterns

VerifiedSafe

Node.js 20 LTS runtime with Express and TypeScript for backend services. Covers async operations, PostgreSQL, buffer handling, and crypto patterns.

Sby Skills Guide Bot
DevelopmentIntermediate
306/2/2026
Claude Code
#nodejs#backend#esm#typescript#express

Recommended for

Our review

This skill provides Node.js 20 LTS patterns for backend development with Express, TypeScript, ESM, PostgreSQL, and Sharp.

Strengths

  • Modern ESM and TypeScript usage
  • Efficient PostgreSQL connection pooling
  • Robust async patterns with transactions and rollback
  • Support for Node.js crypto and Buffer handling

Limitations

  • Specific to INVOOPAY environment, may need adaptation
  • Does not cover advanced Sharp or other library configurations
  • Relies on pg for PostgreSQL, not suitable for other databases
When to use it

When developing Node.js backend services with Express, TypeScript, and PostgreSQL in the INVOOPAY context.

When not to use it

For projects using CommonJS or other frameworks like Fastify or NestJS.

Security analysis

Safe
Quality score85/100

The skill provides educational Node.js backend patterns and configuration examples. No dangerous system commands, external payloads, or data exfiltration is instructed.

No concerns found

Examples

Set up database connection pool
Create a PostgreSQL connection pool with pg using ES modules, with environment variables for host, max connections, timeout settings, and error handling.
Implement async service method
Write an async service method in TypeScript that queries a PostgreSQL table using parameterized queries and returns null if no result.
Database transaction with rollback
Implement a database transaction using pg client that inserts and updates rows, with proper rollback on error and release of client.

name: node description: | Node.js LTS runtime and server-side JavaScript patterns for INVOOPAY backend. Use when: working with backend services, async operations, crypto, Buffer handling, or Node.js APIs. allowed-tools: Read, Edit, Write, Glob, Grep, Bash

Node Skill

Node.js 20 LTS runtime powering Express + TypeScript backend. Uses ES modules ("type": "module") with tsx for development. PostgreSQL via pg with connection pooling. Sharp for image processing.

Quick Start

Module System (ESM)

// backend/src/server.ts - Entry point
import app from './app.js';           // .js extension required for ESM
import { env } from './config/env.js';

app.listen(env.port, () => {
  console.log(`Backend listening on port ${env.port}`);
});

Environment Configuration

// backend/src/config/env.ts - Validated env with defaults
import dotenv from 'dotenv';
dotenv.config();

const required = (value: string | undefined, fallback?: string) => {
  if (value) return value;
  if (fallback !== undefined) return fallback;
  throw new Error('Missing required environment variable');
};

export const env = {
  port: Number(process.env.PORT ?? 4000),
  dbHost: process.env.DB_HOST ?? 'localhost',
  jwtSecret: required(process.env.JWT_SECRET, 'dev-only-secret'),
  nodeEnv: process.env.NODE_ENV ?? 'development',
};

Database Connection Pool

// backend/src/db/client.ts
import pg from 'pg';
const { Pool } = pg;

export const pool = new Pool({
  host: env.dbHost,
  max: 20,                    // Max connections
  idleTimeoutMillis: 30000,   // Close idle after 30s
  connectionTimeoutMillis: 2000,
});

pool.on('error', (err) => {
  console.error('Unexpected error on idle client', err);
  process.exit(-1);           // Crash on pool errors
});

Key Concepts

| Concept | Usage | Example | |---------|-------|---------| | ESM imports | Always use .js extension | import { x } from './mod.js' | | __dirname | Use import.meta.url | path.dirname(fileURLToPath(import.meta.url)) | | Async/await | All I/O operations | await pool.query(...) | | Buffer | Binary data handling | Buffer.from(data, 'hex') | | crypto | Encryption/hashing | crypto.randomBytes(32) |

Common Patterns

Async Service Method

export const productService = {
  async get(id: number, language: string = 'en') {
    const result = await pool.query(
      'SELECT * FROM products WHERE id = $1', [id]
    );
    if (!result.rows[0]) return null;
    return mapProduct(result.rows[0]);
  }
};

Transaction with Rollback

const client = await pool.connect();
try {
  await client.query('BEGIN');
  await client.query('INSERT ...', [...]);
  await client.query('UPDATE ...', [...]);
  await client.query('COMMIT');
} catch (error) {
  await client.query('ROLLBACK');
  throw error;
} finally {
  client.release();  // Always release!
}

See Also

  • patterns - Async patterns, error handling
  • types - TypeScript integration
  • modules - Project structure, imports
  • errors - Error handling patterns

Related Skills

For Express routes and middleware, see the express skill. For database queries, see the postgresql skill. For TypeScript patterns, see the typescript skill.

Related skills