Compute sums, averages, min and max on a model
One step with Prisma. We can help you get access.
Look something up
Compute sums, averages, min and max on a model
with Prisma
Works with AI assistants
Use Prisma: its Prisma Client Aggregation API lets you compute sums, averages, min and max on a model in a single step (GET /{model}/aggregate). Prisma also has an MCP server, so an AI assistant like Claude or ChatGPT can do it for you. capabilities.work can help you get signed up and connected.
- What's the average and total of a numeric column across my records?
- Can I get the minimum and maximum value of a field in one call?
Say it to your AI assistant
- Get the average of {avg_fields} across all {model} rows.
- Sum {sum_fields} for {model} records matching {where}.
- Find the lowest {min_fields} and highest {max_fields} in {model}.
For your developer
GET /{model}/aggregate in Prisma Client Aggregation API. Full spec on APIs.io.