capabilities.work

Get the first record that matches a filter

One step with Prisma. We can help you get access.

Look something up

Get the first record that matches a filter

with Prisma
Works with AI assistants

Use Prisma: its Prisma Client CRUD API lets you get the first record that matches a filter in a single step (GET /{model}/first). 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.

  • Which call returns just the first record that matches a filter?
  • Can I control which record counts as first by ordering?
Say it to your AI assistant
  • Find the first {model} where {where}.
  • Get the top {model} record when sorted by {orderBy}.
For your developer

GET /{model}/first in Prisma Client CRUD API. Full spec on APIs.io.

More you can do with Prisma

List query optimization recommendationsGet performance metrics for a sessionRun a raw SQL SELECT queryExecute a raw SQL write or DDL statementList active named event streamsCreate a resumable event stream for a modelConsume events from a named streamDelete a named event streamInvalidate cached queries by tagClear the entire cache for an environmentInsert many records at onceUpdate every record that matches a filter