capabilities.work

Execute a raw SQL write or DDL statement

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

Get something done

Execute a raw SQL write or DDL statement

with Prisma
Works with AI assistants

Use Prisma: its Prisma Client Raw API lets you execute a raw SQL write or DDL statement in a single step (POST /raw/execute). 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 run a raw INSERT, UPDATE, DELETE or DDL statement?
  • Does a raw SQL statement tell me how many rows it affected?
Say it to your AI assistant
  • Execute the SQL statement {query}.
  • Run write statement {query} with parameters {parameters} and report affected rows.
For your developer

POST /raw/execute in Prisma Client Raw 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 queryList 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 filterDelete every record that matches a filter