Properties
| Name | Type | Description |
|---|---|---|
| id | string | Unique identifier for the recorded query |
| sessionId | string | Identifier of the parent session |
| operation | string | The Prisma Client operation that was executed |
| model | string | The Prisma model the query operates on |
| sql | string | The generated SQL query |
| duration | number | Query execution time in milliseconds |
| timestamp | string | When the query was executed |
| params | object | Query parameters (sanitized) |
JSON Schema
{
"$schema": "https://json-schema.org/draft/2020-12/schema",
"$id": "#/components/schemas/RecordedQuery",
"title": "RecordedQuery",
"type": "object",
"description": "A query captured during a recording session",
"properties": {
"id": {
"type": "string",
"description": "Unique identifier for the recorded query"
},
"sessionId": {
"type": "string",
"description": "Identifier of the parent session"
},
"operation": {
"type": "string",
"description": "The Prisma Client operation that was executed",
"enum": [
"findUnique",
"findFirst",
"findMany",
"create",
"createMany",
"update",
"updateMany",
"upsert",
"delete",
"deleteMany",
"count",
"aggregate",
"groupBy",
"queryRaw",
"executeRaw"
]
},
"model": {
"type": "string",
"description": "The Prisma model the query operates on",
"examples": [
"User",
"Post"
]
},
"sql": {
"type": "string",
"description": "The generated SQL query"
},
"duration": {
"type": "number",
"format": "float",
"description": "Query execution time in milliseconds"
},
"timestamp": {
"type": "string",
"format": "date-time",
"description": "When the query was executed"
},
"params": {
"type": "object",
"description": "Query parameters (sanitized)",
"additionalProperties": true
}
},
"required": [
"id",
"sessionId",
"operation",
"duration",
"timestamp"
]
}
Work with this as data
Every JSON Schema here is available over the APIs.io API and to AI agents over MCP.
MCP server
One button, every client — Claude, Cursor, VS Code and the rest.
https://apis.io/mcp
Tools for schemas
4 MCP tools reach this
find_json_schemasBrowse and filter every JSON Schema in the catalog.apis_io_searchSTART HERE — APIs, providers and tags for one query, each with its total.resolveTurn a domain, URL or GitHub org into the provider it belongs to.find_cohortsEvery scored population of providers in the catalog.
Call it yourself
curl for this page
This JSON Schema
curl "https://apis.io/api/v1/json-schemas/prisma-recordedquery"
All schemas
curl "https://apis.io/api/v1/json-schemas?limit=25"
Discovery needs no key. Ratings and market analysis are Pro.
Get an API key
Free tier, no form to fill in. Signing in shares your email address with us — we store it to create your key and to recognise you if you sign in with another provider. See our Privacy Policy and Terms.
A second provider on the same verified email joins the account you already have.