logging-best-practices

Prácticas recomendadas de registro centradas en eventos amplios (líneas de registro canónicas) para una depuración y análisis potentes

npx skills add https://github.com/neondatabase/mcp-server-neon --skill logging-best-practices

Logging Best Practices Skill

Version: 1.0.0

Purpose

This skill provides guidelines for implementing effective logging in applications. It focuses on wide events (also called canonical log lines) - a pattern where you emit a single, context-rich event per request per service, enabling powerful debugging and analytics.

When to Apply

Apply these guidelines when:

  • Writing or reviewing logging code
  • Adding console.log, logger.info, or similar
  • Designing logging strategy for new services
  • Setting up logging infrastructure

Core Principles

1. Wide Events (CRITICAL)

Emit one context-rich event per request per service. Instead of scattering log lines throughout your handler, consolidate everything into a single structured event emitted at request completion.

const wideEvent: Record<string, unknown> = {
  method: 'POST',
  path: '/checkout',
  requestId: c.get('requestId'),
  timestamp: new Date().toISOString(),
};

try {
  const user = await getUser(c.get('userId'));
  wideEvent.user = { id: user.id, subscription: user.subscription };

  const cart = await getCart(user.id);
  wideEvent.cart = { total_cents: cart.total, item_count: cart.items.length };

  wideEvent.status_code = 200;
  wideEvent.outcome = 'success';
  return c.json({ success: true });
} catch (error) {
  wideEvent.status_code = 500;
  wideEvent.outcome = 'error';
  wideEvent.error = { message: error.message, type: error.name };
  throw error;
} finally {
  wideEvent.duration_ms = Date.now() - startTime;
  logger.info(wideEvent);
}

2. High Cardinality & Dimensionality (CRITICAL)

Include fields with high cardinality (user IDs, request IDs - millions of unique values) and high dimensionality (many fields per event). This enables querying by specific users and answering questions you haven't anticipated yet.

3. Business Context (CRITICAL)

Always include business context: user subscription tier, cart value, feature flags, account age. The goal is to know "a premium customer couldn't complete a $2,499 purchase" not just "checkout failed."

4. Environment Characteristics (CRITICAL)

Include environment and deployment info in every event: commit hash, service version, region, instance ID. This enables correlating issues with deployments and identifying region-specific problems.

5. Single Logger (HIGH)

Use one logger instance configured at startup and import it everywhere. This ensures consistent formatting and automatic environment context.

6. Middleware Pattern (HIGH)

Use middleware to handle wide event infrastructure (timing, status, environment, emission). Handlers should only add business context.

7. Structure & Consistency (HIGH)

  • Use JSON format consistently
  • Maintain consistent field names across services
  • Simplify to two log levels: info and error
  • Never log unstructured strings

Anti-Patterns to Avoid

  1. Scattered logs: Multiple console.log() calls per request
  2. Multiple loggers: Different logger instances in different files
  3. Missing environment context: No commit hash or deployment info
  4. Missing business context: Logging technical details without user/business data
  5. Unstructured strings: console.log('something happened') instead of structured data
  6. Inconsistent schemas: Different field names across services

Guidelines

Wide Events (rules/wide-events.md)

  • Emit one wide event per service hop
  • Include all relevant context
  • Connect events with request ID
  • Emit at request completion in finally block

Context (rules/context.md)

  • Support high cardinality fields (user_id, request_id)
  • Include high dimensionality (many fields)
  • Always include business context
  • Always include environment characteristics (commit_hash, version, region)

Structure (rules/structure.md)

  • Use a single logger throughout the codebase
  • Use middleware for consistent wide events
  • Use JSON format
  • Maintain consistent schema
  • Simplify to info and error levels
  • Never log unstructured strings

Common Pitfalls (rules/pitfalls.md)

  • Avoid multiple log lines per request
  • Design for unknown unknowns
  • Always propagate request IDs across services

References:

Más skills de neondatabase

claimable-postgres
neondatabase
Bases de datos Postgres instantáneas para desarrollo local, demostraciones, prototipos y entornos de prueba. No se requiere cuenta. Las bases de datos caducan después de 72 horas a menos que se reclamen a una cuenta de Neon.
neon
neondatabase
Visión general de la plataforma Neon para aplicaciones y agentes, que abarca Postgres, Auth, Data API y los nuevos servicios: Object Storage, Compute Functions y AI Gateway. Úsalo siempre que se mencione "Neon" para obtener una visión general de cómo trabajar con Neon y cómo empezar. De lo contrario, las capacidades individuales son los desencadenantes: "object storage" o "almacenamiento compatible con S3", "funciones serverless", "trabajos en segundo plano" o "ejecutar código cerca de mi base de datos", "AI gateway", "proxy LLM", "enrutamiento de modelos" o "llamar a un LLM" →...
apidatabasedevelopment
plugin-manager
neondatabase
Gestiona la estructura y configuración de plugins para este repositorio tanto en Cursor como en Claude Code. Úsalo al crear, actualizar o revisar carpetas de plugins…
skill-creator
neondatabase
Guía para crear habilidades efectivas. Esta habilidad debe usarse cuando los usuarios quieran crear una nueva habilidad (o actualizar una existente) que extienda las capacidades de Claude…
using-neon
neondatabase
Guías y mejores prácticas para trabajar con Neon Serverless Postgres. Cubre cómo empezar, desarrollo local con Neon, elegir un método de conexión, Neon…
neon-js-react
neondatabase
Configura el SDK completo de Neon con autenticación Y consultas a la base de datos en aplicaciones React (Vite, CRA). Crea un cliente tipado, genera tipos de base de datos y configura…
postgres-best-practices
neondatabase
Mejores prácticas y pautas para trabajar con Postgres. Cubre diseño de esquemas, estrategias de indexación, optimización de consultas, migraciones y errores comunes. Use…
neon-postgres-egress-optimizer
neondatabase
Guiar al usuario en el diagnóstico y corrección de patrones de consulta del lado de la aplicación que causan una transferencia excesiva de datos (egress) desde su base de datos Postgres. La mayoría de las facturas altas por egress provienen de que la aplicación obtiene más datos de los que utiliza.