Agent skill
prisma-expert
Senior specialist in Prisma 7, Rust-free query engines, and Edge-first database architecture. Use when optimizing queries, configuring TypedSQL, or deploying to serverless/edge environments in 2026.
Install this agent skill to your Project
npx add-skill https://github.com/YuniorGlez/gemini-elite-core/tree/main/skills/prisma-expert
SKILL.md
💎 Skill: prisma-expert
Description
Senior specialist in Prisma 7, focused on the revolutionary TypeScript-based query engine (Rust-free) that drastically reduces cold starts and memory overhead. Expert in Edge-first database architecture, TypedSQL, and high-performance Postgres patterns in 2026.
Core Priorities
- Rust-free Engine: Leveraging the WASM/TS engine for sub-50ms cold starts in serverless.
- TypedSQL Integration: Replacing raw strings with type-safe SQL files for complex queries.
- Connection Efficiency: Mandatory use of HTTP-based connection pooling (Accelerate) or specific DB adapters.
- Schema Quality: Enforcing strict relations, indexes, and mapped enums for PostgreSQL excellence.
🏆 Top 5 Gains in Prisma 7 (2026)
- 90% Smaller Bundle: The removal of the Rust engine binary makes Prisma viable for even the most restricted edge runtimes.
- TypedSQL: Full type safety for hand-written SQL queries, bridging the gap between ORM and raw SQL.
- Prisma Accelerate & Pulse: Native caching and Change Data Capture (CDC) integrated directly into the client.
- Edge-Ready Adapters: Direct support for Neon, PlanetScale, and Cloudflare D1 with zero configuration friction.
- Native Distinct & Query Compiler: Groundbreaking performance for complex analytical queries.
Table of Contents & Detailed Guides
1. Query Optimization & TypedSQL — CRITICAL
- Indexing strategies and
nativeDistinct - TypedSQL: Safe raw queries
- Avoiding N+1 with
includeandselect
2. Serverless & Edge Deployment — CRITICAL
- Using the Rust-free WASM engine
- Prisma Accelerate (Connection Pooling & Caching)
- Regional execution best practices
3. Advanced Schema Patterns — HIGH
- Mapped Enums and Postgres-native types
- Complex Relations (m:n, self-referencing)
- Prisma Pulse (Real-time CDC)
4. Prisma Studio & Telemetry — MEDIUM
- Advanced usage of the 2026 Prisma Studio
- Telemetry and performance monitoring
- Migration workflows (CLI 2026)
Quick Reference: The "Do's" and "Don'ts"
| Don't | Do |
|---|---|
prisma.$queryRaw (raw strings) |
Use TypedSQL (.sql files) |
Large fetches with select * |
Use explicit select: { ... } |
| Direct DB connection in Serverless | Use Prisma Accelerate or Adapters |
Heavy node_modules in Edge |
Enable the WASM/TS Engine |
| Manual indexing in production | Trust the Index Advisor and DB logs |
| Ignore Prisma Pulse | Use it for real-time event-driven logic |
Optimized for Prisma 7.1+ and Postgres 17+. Updated: January 22, 2026 - 15:07
Recommended Agent Skills
Expand your agent's capabilities with these related and highly-rated skills.
YuniorGlez/gemini-elite-core
filesystem-context
Uso del sistema de archivos como extensión de la ventana de contexto, persistencia de planes, comunicación entre sub-agentes y carga dinámica de habilidades.
YuniorGlez/gemini-elite-core
git-flow
Senior Workflow Architect. Master of Trunk-Based Development, Stacked Changes, and 2026 Branching Strategies.
YuniorGlez/gemini-elite-core
track-master
Senior Progress Analyst & Conductor Strategist. Expert in Predictive Project Tracking and Agentic Milestone Management for 2026.
YuniorGlez/gemini-elite-core
artifact-janitor
Senior Build Cleanup & System Optimization Specialist. Expert in reclaiming disk space and resolving build corruption in 2026 ecosystems.
YuniorGlez/gemini-elite-core
openapi-pro
Senior API Architect & Integration Engineer for 2026. Specialized in Type-Safe API contracts using OpenAPI 3.1, Zod-First schema derivation, and automated TypeScript client generation. Expert in bridging the gap between Hono backends and Next.js 16 frontends using `openapi-fetch`, `orval`, and unified monorepo type-sharing.
YuniorGlez/gemini-elite-core
seo-pro
Senior SEO Architect & Content Strategist. Expert in SGE Optimization, E-E-A-T Standards, and Semantic Entity SEO for 2026.
Didn't find tool you were looking for?