capabilities.work

What you can do with Prisma

Every task in plain language. Pick one, and we can help you get access.

187 things you can do

Prisma

Prisma gives TypeScript and Node.js teams a type-safe ORM, managed serverless Postgres, and Compute for deploying apps and AI agents next to their database. The product line is Prisma ORM, Prisma Postgres, Prisma Compute, Prisma Composer, Prisma Studio, Object Store buckets and Query Insights, wired together by one CLI, a REST Management API at api.prisma.io/v1, and a hosted MCP server at mcp.pris

Works with AI assistants 12 multi-step recipes

Recipes: multi-step jobs

Accelerate Cached Query then Invalidate
Execute a tagged cached query through Accelerate and then invalidate its cache tags.Client List and Count Records
Count records matching a filter and then list the first page of matches.Client Upsert a Record
Find a record by id and upsert it, creating when absent or updating when present.Data Platform Bootstrap a Project Environment
Create a project, an environment, and an API key in the Data Platform.Data Platform Rotate an Environment API Key
Create a new environment API key and revoke the previous key.Optimize Record and Analyze a Session
Create a recording session, fetch its slowest queries and recommendations, and stop it.Postgres Add a Database to a Project
Provision an additional Postgres database within an existing project and mint a connection string.Postgres Backup and Restore
Create a manual backup, wait for completion, and restore the database from it.Postgres Find and Delete a Project
Find a project by name in a workspace and delete it when a match is found.Postgres Provision a Project
Provision a project with a Postgres database, back it up, and create a connection string.Postgres Rotate a Database Connection String
Confirm a database, mint a new connection string, and revoke the previous one.Pulse Create and Resume a Named Stream
Create a named stream, read its cursor, and fetch the last persisted event by ULID.

Deployment Orchestration

Create an app (deprecated, use services)Delete an app (deprecated)Rename an app (deprecated)Promote a deployment on an app (deprecated)Roll an app back to a deployment (deprecated)Add a custom domain to an app (deprecated)Create a deployment for an app (deprecated)Create a compute serviceDelete a compute serviceRename a compute servicePromote a running deployment on a serviceRoll a service back to an earlier deploymentAdd a custom domain to a serviceCreate a deployment for a serviceCreate a branch in a projectSoft-delete a branchMake a branch the project defaultReport a build from CI or the CLIReport progress on a buildRecord a resource a build acted onRemove a custom domainRetry custom domain provisioningDelete a stopped deploymentStart a deployment's VMStop a deployment's VMAcquire an Alchemy deploy leaseRelease an Alchemy deploy leaseExtend an Alchemy deploy leaseSave one Alchemy resource's stateDelete one Alchemy resource's stateOverwrite an Alchemy stack's outputDelete all state for an Alchemy stackReplace a branch's application topologyCreate an environment variableDelete an environment variableChange an environment variable's valueExchange a GitHub Actions OIDC tokenStart installing the SCM appLink a repository to a projectDisconnect a source repositoryList apps (deprecated, use services)Get an app (deprecated)List an app's custom domains (deprecated)List an app's deployments (deprecated)List compute servicesGet a compute serviceList a service's custom domainsList a service's deploymentsList a project's branchesGet a branchList builds in my workspaceGet a build and the resources it touchedStream a build's logsGet a custom domainGet a deployment's statusGet a deployment's runtime logsGet the Alchemy state store versionList Alchemy stacks on a branchList stages of an Alchemy stackList resources in an Alchemy stageRead one Alchemy resource's stateList replaced Alchemy resources in a stageRead an Alchemy stack's outputGet a branch's application topologyList environment variablesGet an environment variable's metadataList a workspace's SCM installationsList repositories an SCM installation can seeList repositories linked to a projectGet a linked source repository

Developer Identity & Credential Management

Create a workspace service tokenRevoke a workspace service tokenList a workspace's service tokens

Disaster Recovery & Resilience

Take a manual database backupRestore a database from a backupList a database's backups (v1)List automatic and manual backups

Environment Management

Create an environment in a projectDelete an environment and its API keysList a project's environmentsGet an environment's configuration

IT Infrastructure Management

Create a database by passing its projectDelete a database (v1)Rename a database or move it to a branchOverwrite a database with backup contentsCreate a database under a project pathProvision a Prisma Postgres databaseDelete a database with its backupsList databases my token can accessGet a database by ID (v1)List the databases in a projectGet a database's status and region

Other things you can do

Execute a raw SQL write or DDL statementCreate a resumable event stream for a modelDelete 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 filterSubscribe to a model's change eventsSend query execution data to OptimizeCreate a new recordUpdate a record by its IDDelete one record by its IDCreate a record or update it if it existsCreate a connection string for a databaseRename a workspaceStart a query recording sessionStop a recording sessionCreate an API key for an environmentRevoke and delete an API keyRevoke an integration's tokens by IDRevoke integration tokens by client IDCreate an object-store bucketDelete a bucket and all its objectsCreate an access key for a bucketRevoke a bucket access keyCreate a project in a workspaceDelete a project and its environmentsCreate a project with a Postgres databaseDelete a project (v1)Rename a project or change its settingsTransfer a project to another workspaceCreate a named connection for a databaseDelete a connectionRotate a connection's credentialsGenerate a connection string for a databaseRevoke a database connection stringList query optimization recommendationsGet performance metrics for a sessionRun a raw SQL SELECT queryList active named event streamsConsume events from a named streamGet database usage metrics (v1)Get storage, query and compute usageRun a Prisma Client query through AccelerateList queries captured in a sessionGet SQL and execution plan for a queryFind records with filters, sorting and pagingGet one record by its unique IDGet the first record that matches a filterCount records that match a filterCompute sums, averages, min and max on a modelGroup records and aggregate each groupList a database's connectionsGet a database change event by IDList all my workspacesGet a workspace's billing and projectsList workspaces my token can access (v1)Get a workspace by ID (v1)Get a workspace's subscriptionList Optimize recording sessionsGet a recording session's detailsList API keys for an environmentShow who the current token belongs toList Prisma Postgres regionsList Prisma Accelerate regionsCheck Accelerate service healthList workspace members and rolesList integrations filtered by workspaceGet an integration by IDList a workspace's integrationsList configured third-party integrationsList object-store bucketsGet a bucket's detailsList a bucket's access keysList projects in a workspaceGet a project with its environmentsList projects my token can accessGet a project by ID (v1)List connections I have access toGet a connection by IDList a database's connection stringsList available regions across products