Prisma

Prisma Databases API

Operations for provisioning and managing Prisma Postgres databases

GitHub OpenAPI
Business capability
IT Infrastructure Management BC-600.50

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://artifacts.apis.io/prisma/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"

Calls without X-API-Key need no key. Calls with it need a paid plan — get a key.

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://artifacts.apis.io/prisma/openapi/prisma-databases-api-openapi.yml