Prisma

Prisma Databases API

Operations for provisioning and managing Prisma Postgres databases

GitHub OpenAPI

Operations 11

Each operation below carries the questions people ask an LLM about it and the instructions they give an agent to run it. Generated by API Evangelist overlay

GET /v1/databases List databases my token can access · List databases #
Ask an LLM
“Which databases can my token access across all projects?”
“Can I filter the database list by project or git branch?”
Tell an agent
List all my databases.
List databases filtered to project {projectId}.
POST /v1/databases Create a database by passing its project · Create database #
Ask an LLM
“Can I create a database and attach it to a git branch in one call?”
“How do I create a database by passing the project ID in the body?”
Tell an agent
Create a database named {name} with project ID {projectId} in the request body.
Create a database in {projectId} on branch {branchGitName} in region {region}.
GET /v1/databases/{databaseId} Get a database by ID (v1) · Get database #
Ask an LLM
“What does the v1 API return for a single database?”
“Can I look up one database by ID with the v1 endpoint?”
Tell an agent
Get database {databaseId}.
Fetch database {databaseId} from the v1 API.
PATCH /v1/databases/{databaseId} Rename a database or move it to a branch · Update database #
Ask an LLM
“Can I rename an existing database?”
“How do I move a database to a different git branch?”
Tell an agent
Rename database {databaseId} to {name}.
Move database {databaseId} to git branch {branchGitName}.
DELETE /v1/databases/{databaseId} Delete a database (v1) · Delete database #
Ask an LLM
“Can I delete a database by ID with the v1 API?”
“Is deleting a database through the v1 endpoint permanent?”
Tell an agent destructive · confirm first
Delete database {databaseId}.
Remove database {databaseId} using the v1 endpoint.
POST /v1/databases/{targetDatabaseId}/restore Overwrite a database with backup contents · Restore database (destructive) #
Ask an LLM
“Are connections and credentials kept when I restore data into an existing database?”
“Will data written since the backup be lost if I restore over my database?”
Tell an agent destructive · confirm first
Overwrite database {targetDatabaseId} with the data from {source}.
Replace the data in {targetDatabaseId} from backup source {source}.
GET /v1/projects/{projectId}/databases List the databases in a project · Get list of databases #
Ask an LLM
“Which databases belong to one specific project?”
“Can I paginate through a project's databases?”
Tell an agent
List the databases in project {projectId}.
Show {limit} databases from project {projectId}.
POST /v1/projects/{projectId}/databases Create a database under a project path · Create database #
Ask an LLM
“Can I create a new database in a project from an existing source?”
“Is there a way to make a new database the project's default?”
Tell an agent
Create a database named {name} under project {projectId}.
Add a default database to project {projectId} with isDefault {isDefault}.
POST /projects/{projectId}/databases Provision a Prisma Postgres database · Prisma Create a database in a project #
Ask an LLM
“How do I provision a Prisma Postgres database in a chosen region?”
“Which PostgreSQL version does a newly provisioned database run?”
Tell an agent
Provision a Prisma Postgres database in project {projectId} in region {region}.
Spin up a Postgres database called {name} in {region} for {projectId}.
GET /databases/{databaseId} Get a database's status and region · Prisma Get a database #
Ask an LLM
“What region and status is my Prisma Postgres database in?”
“Where can I see a database's connection details and status together?”
Tell an agent
Show status, region and connection details for database {databaseId}.
Check whether Prisma Postgres database {databaseId} is ready.
DELETE /databases/{databaseId} Delete a database with its backups · Prisma Delete a database #
Ask an LLM
“Does deleting a Prisma Postgres database also remove its backups and connection strings?”
“Can a deleted Postgres database be undone?”
Tell an agent destructive · confirm first
Permanently delete Prisma Postgres database {databaseId} and its backups.
Destroy {databaseId} along with all its connection strings.

Documentation

📖
Authentication
https://www.prisma.io/docs/rest-api/authentication
📖
GettingStarted
https://www.prisma.io/docs/console/getting-started
📖
Documentation
https://www.prisma.io/docs/accelerate
📖
GettingStarted
https://www.prisma.io/docs/accelerate/getting-started
📖
Documentation
https://www.prisma.io/docs/orm
📖
GettingStarted
https://www.prisma.io/docs/prisma-orm/quickstart/prisma-postgres
📖
GettingStarted
https://www.prisma.io/docs/query-insights

Specifications

⚙
OpenAPI
https://raw.githubusercontent.com/api-evangelist/prisma/refs/heads/main/openapi/prisma-databases-api-openapi.yml

Other Resources

🔗
Reference
https://www.prisma.io/docs/accelerate/reference/api-reference
🔗
FAQ
https://www.prisma.io/docs/accelerate/more/faq
🔗
SDKs
https://www.prisma.io/docs/rest-api/sdk
🔗
Reference
https://www.prisma.io/docs/orm/reference/prisma-client-reference
🔗
SDKs
https://www.npmjs.com/package/@prisma/client
🔗
SDKs
https://www.npmjs.com/package/@prisma/extension-optimize

Work with this as data

Every API 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 apis

7 MCP tools reach this
  • find_apisBrowse and filter every API in the catalog.
  • get_api_artifactsOne API's artifacts, grouped by type.
  • get_openapiThe primary OpenAPI for this API.
  • find_similar_apisAPIs that look like this one.
  • 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.
All 92 tools →

Call it yourself

curl for this page
This API 
curl "https://apis.io/api/v1/apis/prisma:prisma-databases-api"
All apis 
curl "https://apis.io/api/v1/apis?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.

GitHub Google LinkedIn

A second provider on the same verified email joins the account you already have.

OpenAPI Specification

prisma-databases-api-openapi.yml Raw ↑ 
openapi: 3.2.0
info:
  title: Prisma Databases API
  version: '1.0'
  description: 'Operations tagged Databases across 2 of this provider''s published API definitions: prisma-postgres-management-api-openapi.json, prisma-postgres-management-openapi.yml. Each path carries the servers of the definition it was published in.'
servers:
- url: https://api.prisma.io
- url: https://api.prisma.io/v1
  description: Prisma Management API production server
tags:


# --- truncated at 32 KB (99 KB total) ---
# Full source: https://raw.githubusercontent.com/api-evangelist/prisma/refs/heads/main/openapi/prisma-databases-api-openapi.yml