prisma-query-log

Log prisma query event. Currently works only for SQLite, MySQL.

Features:

• Substitute parameters
• Remove backticks and database prefix

Install

npm install --save-dev prisma-query-log

Usage

import { createPrismaQueryEventHandler } from 'prisma-query-log';
import { PrismaClient } from '@prisma/client';

const prisma = new PrismaClient({
  log: [
    {
      level: 'query',
      emit: 'event',
    },
  ],
});

const log = createPrismaQueryEventHandler();

prisma.$on('query', log);

API

function createPrismaQueryEventHandler(
  options?: CreatePrismaQueryEventHandlerArgs,
): (event: PrismaQueryEvent) => void;

const defaultOptions = {
  /**
   * Boolean of custom log function,
   * if true `console.log` will be used,
   * if false noop - logs nothing.
   */
  logger: true as boolean | ((query: string) => unknown),
  /**
   * Remove backticks.
   */
  unescape: true,
  /**
   * Color of query (ANSI escape code)
   */
  colorQuery: undefined as undefined | string,
  /**
   * Color of parameters (ANSI escape code)
   */
  colorParameter: undefined as undefined | string,
  /**
   * Format SQL query,
   * colorQuery/colorParameter will be ignored.
   */
  format: false,

  /**
   * Formatter options
   * https://github.com/mtxr/vscode-sqltools/tree/master/packages/formatter#options
   */

  /**
   * Show Query Duration, default is false
   */
  queryDuration: false as boolean,

  /**
   * Query language, default is Standard SQL
   */
  language: undefined as 'sql' | 'n1ql' | 'db2' | 'pl/sql' | undefined,
  /**
   * Characters used for indentation
   */
  indent: '    ',
  /**
   * How to change the case of reserved words
   */
  // eslint-disable-next-line unicorn/no-null
  reservedWordCase: null as 'upper' | 'lower' | null,
  /**
   * How many line breaks between queries
   */
  linesBetweenQueries: 1 as number | 'preserve',
};

Other projects

https://github.com/unlight/nestolog - Logger for NestJS, implements LoggerService

Screenshots

Before

After

Development

docker run -it -p 5432:5432 -e POSTGRES_PASSWORD=postgres -e POSTGRES_USER=user postgres
docker run -it -p 3306:3306 -e MYSQL_ROOT_PASSWORD=password -e MYSQL_DATABASE=query_log_example_db mysql