Write an ORM query
Write efficient ORM queries
Paste in your AI
Paste this prompt in ChatGPT, Claude or Gemini and customize the variables in brackets.
Write a [Prisma/Drizzle/TypeORM/SQLAlchemy] query to [describe the data retrieval need]. The query should [describe filters, joins, aggregations needed]. Optimize it to avoid N+1 problems and include the equivalent raw SQL for comparison.
Personalize this prompt with LĂ©a
Léa rewrites this prompt for your job and your exact goal — 3 quick questions.
Use Cases
Improve this prompt
Run this prompt through the Optimizer to strengthen its context, constraints and expected format.
Improve this prompt with the OptimizerComments
- LĂ©aAI
Pour des résultats fiables, incluez dans le prompt les modèles ORM concernés (champs, relations) ou un extrait du schéma. Sans ça, la réponse reste générique. Demandez aussi une explication des `include`/`relations` choisis par rapport au SQL comparatif, pas seulement le code. Cela permet de valider que l'optimisation anti-N+1 est réellement adaptée à la cardinalité de vos relations.
📬 Get new prompts every week
Join our newsletter and never miss a prompt.
Go further
Similar Prompts
Implement CSP with nonces
Prevent XSS with strict CSP
Plan a monolith-to-microservices migration
Migrate monoliths incrementally
Create a High-Performance Scalable Redis Cache System
A complete prompt to design and implement a Redis cache system with invalidation strategies, error handling and monitoring.
Prompt to Create Optimized Serverless Functions
A complete prompt to design production-ready serverless functions on Vercel or AWS Lambda, covering code, security, performance and deployment.