Prisma

Prisma has an official @opentelemetry/instrumentation-prisma package. Use it directly with autotel.

Installation

npm install autotel @prisma/instrumentation @prisma/client

Setup

instrumentation.ts

import { init } from 'autotel';
import { PrismaInstrumentation } from '@prisma/instrumentation';

init({
  service: 'my-app',
  instrumentations: [new PrismaInstrumentation()],
  endpoint: process.env.OTLP_ENDPOINT,
});

tsx --import ./instrumentation.ts src/index.ts

Tracing Prisma Operations

import { trace, withTracing, type TraceContext } from 'autotel';
import { PrismaClient } from '@prisma/client';

const prisma = new PrismaClient();

export const createUser = withTracing({})(
  (ctx) => async (email: string, name?: string) => {
    ctx.setAttribute('user.email', email);

    const user = await prisma.user.create({
      data: { email, name },
    });
    // PrismaInstrumentation auto-creates child spans for the DB call

    return user;
  },
);

export const getUserWithPosts = withTracing({})(
  (ctx) => async (userId: number) => {
    ctx.setAttribute('user.id', userId);

    const user = await prisma.user.findUnique({
      where: { id: userId },
      include: { posts: true },
    });

    return user;
  },
);

What Gets Traced

PrismaInstrumentation automatically captures:

• prisma:client:operation: Full Prisma operation
• prisma:client:serialize: Query serialization
• prisma:engine:query: Query engine execution
• prisma:engine:connection: Database connection
• prisma:engine:db_query: Actual SQL query
• prisma:engine:serialize: Response serialization

Examples

• example-prisma: SQLite setup with User/Post models, nested queries, and transactions.