Prisma Lens.
Visual query analyzer and schema relationship visualizer for Prisma ORM databases.
system architecture & goal.
Prisma Lens inspects Prisma query logs in real time, detecting N+1 query patterns, indexing bottlenecks, and generating interactive ER diagrams directly from schema.prisma definitions.
Core Architectural Highlights
Real-time query execution flamegraphs.
Automated N+1 detection with instant fix recommendations.
Interactive canvas graph visualization powered by React Flow.
challenges & engineering solutions.
Rendering Massive ER Diagrams
Schemas with 100+ relations caused severe canvas lag and frame drops.
Implemented level-of-detail viewport culling and WebGL hardware acceleration.
Graph visualization requires spatial index partitioning for large datasets.
future improvements.
Support for Drizzle and Kysely ORM schema analysis.
AI-driven index suggestion generator based on slow query logs.