Get SQL and execution plan for a query
One step with Prisma. We can help you get access.
Look something up
Get SQL and execution plan for a query
with Prisma
Works with AI assistants
Use Prisma: its Prisma Queries API lets you get SQL and execution plan for a query in a single step (GET /sessions/{sessionId}/queries/{queryId}). 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 SQL and execution plan did one recorded query produce?
- Where can I see the performance metrics of a single captured query?
Say it to your AI assistant
- Get details for query {queryId} in session {sessionId}.
- Show the full SQL and plan of {queryId} from {sessionId}.
For your developer
GET /sessions/{sessionId}/queries/{queryId} in Prisma Queries API. Full spec on APIs.io.