capabilities.work

Create a record or update it if it exists

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

Get something done

Create a record or update it if it exists

with Prisma
Works with AI assistants

Use Prisma: its Prisma Client CRUD API lets you create a record or update it if it exists in a single step (POST /{model}/upsert). 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.

  • Can I create a record only if it doesn't exist and update it otherwise?
  • What do I need to send for an upsert?
Say it to your AI assistant
  • Upsert a {model} where {where}, creating {create} or updating {update}.
  • If a {model} matches {where} apply {update}, else insert {create}.
For your developer

POST /{model}/upsert 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