A beautiful, enhanced logger for Drizzle ORM that transforms your SQL queries into visually appealing, color-coded output with syntax highlighting, icons, and detailed formatting.

See the dramatic difference! The enhanced logger transforms plain SQL output into beautifully formatted, color-coded queries with syntax highlighting, icons, and structured parameter display.

• 🎨 Beautiful formatting with box-drawing characters and colors
• 🔍 SQL syntax highlighting with keyword colorization
• 📊 Query type detection with specific colors and icons
• 🏷️ Table name extraction and highlighting
• 📝 Parameter formatting with type-specific colors
• ⏰ Timestamps for each query
• 🔢 Query numbering to track execution order
• ⚙️ Configurable logging output

npm install drizzle-query-logger

yarn add drizzle-query-logger

pnpm add drizzle-query-logger

bun add drizzle-query-logger

import Database from 'better-sqlite3';
import { drizzle } from 'drizzle-orm/better-sqlite3';
import { EnhancedQueryLogger } from 'drizzle-query-logger';

const client = new Database(':memory:');
export const db = drizzle(client, {
  logger: new EnhancedQueryLogger(),
});

// Your queries will now be beautifully logged!
const users = await db.select().from(usersTable);

import { EnhancedQueryLogger } from 'drizzle-query-logger';

const logger = new EnhancedQueryLogger({
  log: (message) => {
    // Send to your preferred logging service
    console.log(message);
    // or use your custom logger
    // winston.info(message);
    // pino.info(message);
  }
});

export const db = drizzle(client, { logger });

The logger automatically detects and styles different query types:

interface LoggerOptions {
  log?: (message: string) => void;
}

• log: Custom logging function (default: console.log)

const logger = new EnhancedQueryLogger({
  log: (message) => {
    // Custom logging logic
    if (process.env.NODE_ENV === 'development') {
      console.log(message);
    } else {
      // Send to logging service in production
      yourLoggingService.debug(message);
    }
  }
});

The logger uses a carefully chosen color scheme for optimal readability:

• Keywords: Blue (SELECT, FROM, WHERE, etc.)
• Strings: Green
• Numbers: Cyan
• Booleans: Yellow
• Objects: Magenta
• Null values: Dimmed
• Table names: Yellow
• Framework elements: Gray with cyan accents

This package is written in TypeScript and provides full type definitions. It implements Drizzle's Logger interface:

import type { Logger } from 'drizzle-orm/logger';

export class EnhancedQueryLogger implements Logger {
  logQuery(query: string, params: unknown[]): void;
}

• Node.js: 16+
• TypeScript: 5+ (peer dependency)
• Drizzle ORM: Compatible with all recent versions

Contributions are welcome! Please feel free to submit a Pull Request.

MIT License - see the LICENSE file for details.

Built for the Drizzle ORM ecosystem.