logger-multi-db

Universal logging library for Node.js - One API, multiple databases, pure ESM

Log to MongoDB, PostgreSQL, MySQL, Firebase, or any database with a unified, simple API using modern ES Modules.

✨ Features

• 🎯 Universal API - One interface for all databases
• 📦 Multiple Adapters - MongoDB, PostgreSQL, MySQL, Firebase + more
• 🔒 Auto Sanitization - Masks passwords, tokens, emails automatically
• 🎨 Pure ESM - Modern ES Modules (import/export)
• 🎨 TypeScript - Full type safety
• ⚡ Lightweight - Zero dependencies (adapters are peer deps)
• 📊 5 Log Levels - ERROR, WARN, INFO, DEBUG, TRACE
• 🔍 Powerful Queries - Filter by user, date, level, text search
• 🌍 Environment Aware - dev/staging/production
• 🎭 Console Output - Beautiful colored console logs
• 📈 Production Ready - Battle-tested

📦 Installation

# npm
npm install logger-multi-db

# yarn
yarn add logger-multi-db

# pnpm
pnpm add logger-multi-db

Then install your database adapter:

# MongoDB
npm install mongodb

# PostgreSQL
npm install pg
npm i --save-dev @types/pg

# MySQL
npm install mysql2

# Firebase
npm install firebase-admin

🚀 Quick Start

MongoDB

import { createLogger, createMongoDBAdapter } from "logger-multi-db";

const logger = createLogger({
  adapter: createMongoDBAdapter({
    uri: "mongodb://localhost:27017",
    dbName: "myapp",
    collectionName: "logs",
    ttlDays: 30,
  }),
  service: "api",
  environment: "production",
});

await logger.init();

logger.info("User logged in", { userId: "123", email: "[email protected]" });
logger.error("Payment failed", { amount: 50 }, new Error("Stripe timeout"));

PostgreSQL

import { createLogger, createPostgreSQLAdapter } from "logger-multi-db";

const logger = createLogger({
  adapter: createPostgreSQLAdapter({
    host: "localhost",
    database: "myapp",
    user: "postgres",
    password: "password",
  }),
  service: "web",
});

await logger.init();

logger.info("Order created", { orderId: "456", amount: 99.99 });

MySQL

import { createLogger, createMySQLAdapter } from "logger-multi-db";

const logger = createLogger({
  adapter: createMySQLAdapter({
    host: "localhost",
    database: "myapp",
    user: "root",
    password: "password",
  }),
  service: "backend",
});

await logger.init();

logger.warn("Low stock", { productId: "789", stock: 5 });

Firebase

import { createLogger, createFirebaseAdapter } from "logger-multi-db";

const logger = createLogger({
  adapter: createFirebaseAdapter({
    serviceAccount: "./serviceAccountKey.json",
    collectionName: "logs",
  }),
  service: "mobile-app",
});

await logger.init();

logger.info("User signup", { userId: "123", provider: "google" });

📖 API Reference

createLogger(config)

import { createLogger } from "logger-multi-db";

const logger = createLogger({
  adapter, // Database adapter (required)
  environment: "prod", // Environment
  service: "api", // Service name
  enableConsole: true, // Console logging
  minLevel: "info", // Minimum level
  sanitize: true, // Auto-sanitize
});

Log Methods

// Log levels
logger.error(message, context?, error?)
logger.warn(message, context?)
logger.info(message, context?)
logger.debug(message, context?)
logger.trace(message, context?)

// Initialize
await logger.init()

// Query logs
const logs = await logger.query({
  level: 'error',
  userId: 'user123',
  startDate: new Date('2024-01-01'),
  limit: 100
})

// Close
await logger.close()

🔒 Automatic Data Sanitization

Sensitive data is automatically masked:

logger.info("Login attempt", {
  email: "[email protected]", // → jor***@example.com
  password: "supersecret123", // → ***REDACTED***
  apiKey: "sk_live_12345", // → ***REDACTED***
  userId: "user123", // ✅ Not masked
});

Default masked fields:

• password, token, apiKey, secret
• creditCard, ssn, bankAccount
• privateKey, accessToken, refreshToken
• email (partially masked)

📊 Examples by Use Case

Request Tracing

import { randomUUID } from "crypto";

const requestId = randomUUID();

logger.info("Request started", { requestId, url: "/api/users" });
// ... processing ...
logger.info("Request completed", { requestId, duration: 150 });

// Find all logs for this request
const logs = await logger.query({ requestId });

E-commerce Platform

// Track orders
logger.info("Order created", {
  orderId: order.id,
  userId: user.id,
  amount: order.total,
});

// Track payments
logger.info("Payment processed", {
  orderId: order.id,
  transactionId: payment.id,
});

Error Tracking

try {
  await processPayment(data);
} catch (error) {
  logger.error(
    "Payment error",
    {
      userId: user.id,
      amount: data.amount,
    },
    error
  );
}

🔄 Switching Databases

Switch from MongoDB to PostgreSQL? Just change the adapter:

// Before: MongoDB
const adapter = createMongoDBAdapter({ uri: "..." });

// After: PostgreSQL
const adapter = createPostgreSQLAdapter({ host: "..." });

// Your logging code stays the same!
logger.info("Works!", { userId: "123" });

📝 TypeScript

Full TypeScript support:

import {
  createLogger,
  LogLevel,
  LogEntry,
  LogContext,
  LogFilter,
  type MongoDBAdapterConfig,
} from "logger-multi-db";

const config: MongoDBAdapterConfig = {
  uri: "mongodb://localhost:27017",
  dbName: "myapp",
};

🎨 Console Output

Beautiful colored console logs:

🔴 [ERROR] 2024-11-29T10:30:00.000Z [api] Payment failed {"userId":"123"}
❌ Stripe timeout

Disable in production:

const logger = createLogger({
  adapter,
  enableConsole: process.env.NODE_ENV !== "production",
});

🤝 Contributing

Contributions welcome! See CONTRIBUTING.md

📄 License

MIT © [Jordan (Trenderz)]

🔗 Links

• npm package
• GitHub
• Documentation

Made with ❤️ using modern ES Modules