--- title: Create, Back Up And Restore Your Postgres Databases... description: Prisma exposes database creation, backups and restores through a REST API, a CLI, and a hosted MCP server for AI assistants. You can create or delete databases... canonical: https://daily.dev/posts/create-back-up-and-restore-your-postgres-databases-automatically-with-prisma-eaflfnomy twitter:card: summary_large_image twitter:site: @dailydotdev og:type: website og:site_name: daily.dev og:title: Create, Back Up And Restore Your Postgres Databases Automatically With Prisma | daily.dev og:description: Prisma exposes database creation, backups and restores through a REST API, a CLI, and a hosted MCP server for AI assistants. You can create or delete databases... og:url: https://daily.dev/posts/create-back-up-and-restore-your-postgres-databases-automatically-with-prisma-eaflfnomy og:image: https://api.daily.dev/og/posts/EaFLfnOmY.png og:image:alt: Create, Back Up And Restore Your Postgres Databases Automatically With Prisma og:image:width: 1200 og:image:height: 630 og:locale: en --- > ## Documentation Index > Fetch the complete documentation index at: https://daily.dev/llms.txt > Use this file to discover all available pages before exploring further. # Create, Back Up And Restore Your Postgres Databases Automatically With Prisma **[API Evangelist](https://daily.dev/sources/apievangelist)** · 5 min read · 0 upvotes · 0 comments ## Summary Prisma exposes database creation, backups and restores through a REST API, a CLI, and a hosted MCP server for AI assistants. You can create or delete databases with a single call, take manual backups, and restore a database from a chosen backup, though Prisma marks the restore endpoint as destructive. APIs.io catalogs 12 Prisma workflows, including one that takes a backup, waits for completion, then restores it. Environment and service-token endpoints let you script staging setups and revoke access per tool. Prisma is freemium with self-serve signup. ## Full article daily.dev links to this article rather than hosting it. Read it at the original source: ## Questions this post answers ### How do I automatically back up and restore a Prisma Postgres database via API? Use the Prisma REST Management API: POST a manual backup with POST /databases/{databaseId}/backups, list existing backups with GET /databases/{databaseId}/backups, then restore with POST /databases/{databaseId}/backups/{backupId}/restore. A separate endpoint, POST /v1/databases/{targetDatabaseId}/restore, overwrites a database directly from a backup and is labeled destructive. A cataloged workflow chains backup, wait, and restore into one sequence. _Developers scripting Postgres recovery flows can track Prisma's API changes on daily.dev._ ### Does Prisma offer an MCP server for database management? Yes, Prisma ties its tooling together with a command line tool, a REST Management API, and a hosted MCP server, the connector standard AI assistants use to call tools. This lets an AI assistant or script create databases, trigger backups, manage environments, and rotate service tokens without a human performing each step manually. _Those wiring AI assistants into database operations can follow MCP tooling updates on daily.dev._ ### How do I give an automated tool its own credentials to access a Prisma database without affecting other integrations? Create a dedicated service token for that tool using POST /v1/workspaces/{workspaceId}/service-tokens, then revoke it independently with DELETE /v1/workspaces/{workspaceId}/service-tokens/{serviceTokenId} if the tool is retired or a contractor leaves. Because each tool gets its own token, revoking one does not break any other integration. _Teams managing credential sprawl across integrations can track token rotation practices on daily.dev._ ## Similar posts on daily.dev - [Prisma Postgres on Stripe Projects](https://daily.dev/posts/prisma-postgres-on-stripe-projects-nkqbhmz7j) · Prisma Blog · 2 upvotes · 0 comments - [From Local Development to Production with Prisma Postgres](https://daily.dev/posts/from-local-development-to-production-with-prisma-postgres-3vyh7ogqp) · Prisma Blog · 0 upvotes · 0 comments - [Manage a Next.js Monorepo with Prisma](https://daily.dev/posts/manage-a-next-js-monorepo-with-prisma-mfa24in4j) · AppSignal · 3 upvotes · 0 comments - [Zero-Downtime Postgres Migration from RDS to Prisma Postgres](https://daily.dev/posts/zero-downtime-postgres-migration-from-rds-to-prisma-postgres-mrtqze7k5) · Prisma Blog · 0 upvotes · 0 comments - [npx create-db: Instant Postgres for Your Coding Agent](https://daily.dev/posts/npx-create-db-instant-postgres-for-your-coding-agent-jo83ylhow) · Prisma Blog · 1 upvotes · 0 comments --- Tags: [#postgresql](https://daily.dev/tags/postgresql), [#mcp](https://daily.dev/tags/mcp), [#rest-api](https://daily.dev/tags/rest-api), [#prisma](https://daily.dev/tags/prisma) [View this post on daily.dev](https://daily.dev/posts/create-back-up-and-restore-your-postgres-databases-automatically-with-prisma-eaflfnomy) ```json {"@context":"https://schema.org","@graph":[{"@type":"Organization","@id":"https://daily.dev/#organization","name":"daily.dev","url":"https://daily.dev","logo":{"@type":"ImageObject","url":"https://daily.dev/apple-touch-icon.png","width":180,"height":180},"sameAs":["https://twitter.com/dailydotdev","https://github.com/dailydotdev","https://www.linkedin.com/company/daily-dev-ltd"]},{"@type":"WebSite","@id":"https://daily.dev/#website","url":"https://daily.dev","name":"daily.dev","publisher":{"@id":"https://daily.dev/#organization"},"potentialAction":{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https://daily.dev/search?q={search_term_string}"},"query-input":"required name=search_term_string"}}]} {"@context":"https://schema.org","@type":"TechArticle","headline":"Create, Back Up And Restore Your Postgres Databases Automatically With Prisma","url":"https://daily.dev/posts/create-back-up-and-restore-your-postgres-databases-automatically-with-prisma-eaflfnomy","mainEntityOfPage":{"@type":"WebPage","@id":"https://daily.dev/posts/create-back-up-and-restore-your-postgres-databases-automatically-with-prisma-eaflfnomy"},"datePublished":"2026-10-31T14:17:34.292Z","dateModified":"2026-10-31T14:18:00.916Z","description":"Prisma exposes database creation, backups and restores through a REST API, a CLI, and a hosted MCP server for AI assistants. You can create or delete databases...","image":"https://media.daily.dev/image/upload/f_auto,q_auto/v1/posts/9e360df791c276c2bb6f1322a98ff205?_a=AQAEuop","thumbnailUrl":"https://media.daily.dev/image/upload/f_auto,q_auto/v1/posts/9e360df791c276c2bb6f1322a98ff205?_a=AQAEuop","isAccessibleForFree":true,"articleSection":"API Evangelist","inLanguage":"en","publisher":{"@type":"Organization","name":"daily.dev","url":"https://daily.dev","logo":{"@type":"ImageObject","url":"https://daily.dev/apple-touch-icon.png","width":180,"height":180}},"author":{"@type":"Organization","name":"API Evangelist","logo":"https://media.daily.dev/image/upload/t_logo,f_auto/v1/logos/a36244ae67bc4f41a605f780267ecb5f","url":"https://daily.dev/sources/apievangelist"},"commentCount":0,"discussionUrl":"https://daily.dev/posts/create-back-up-and-restore-your-postgres-databases-automatically-with-prisma-eaflfnomy","interactionStatistic":[{"@type":"InteractionCounter","interactionType":{"@type":"LikeAction"},"userInteractionCount":0},{"@type":"InteractionCounter","interactionType":{"@type":"CommentAction"},"userInteractionCount":0}],"keywords":"postgresql,mcp,rest-api,prisma","timeRequired":"PT5M"} {"@context":"https://schema.org","@type":"BreadcrumbList","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https://daily.dev"},{"@type":"ListItem","position":2,"name":"API Evangelist","item":"https://daily.dev/sources/apievangelist"},{"@type":"ListItem","position":3,"name":"Create, Back Up And Restore Your Postgres Databases Automatically With Prisma"}]} {"@context":"https://schema.org","@type":"FAQPage","@id":"https://daily.dev/posts/create-back-up-and-restore-your-postgres-databases-automatically-with-prisma-eaflfnomy#faq","mainEntity":[{"@type":"Question","name":"How do I automatically back up and restore a Prisma Postgres database via API?","acceptedAnswer":{"@type":"Answer","text":"Use the Prisma REST Management API: POST a manual backup with POST /databases/{databaseId}/backups, list existing backups with GET /databases/{databaseId}/backups, then restore with POST /databases/{databaseId}/backups/{backupId}/restore. A separate endpoint, POST /v1/databases/{targetDatabaseId}/restore, overwrites a database directly from a backup and is labeled destructive. A cataloged workflow chains backup, wait, and restore into one sequence. Developers scripting Postgres recovery flows can track Prisma's API changes on daily.dev."}},{"@type":"Question","name":"Does Prisma offer an MCP server for database management?","acceptedAnswer":{"@type":"Answer","text":"Yes, Prisma ties its tooling together with a command line tool, a REST Management API, and a hosted MCP server, the connector standard AI assistants use to call tools. This lets an AI assistant or script create databases, trigger backups, manage environments, and rotate service tokens without a human performing each step manually. Those wiring AI assistants into database operations can follow MCP tooling updates on daily.dev."}},{"@type":"Question","name":"How do I give an automated tool its own credentials to access a Prisma database without affecting other integrations?","acceptedAnswer":{"@type":"Answer","text":"Create a dedicated service token for that tool using POST /v1/workspaces/{workspaceId}/service-tokens, then revoke it independently with DELETE /v1/workspaces/{workspaceId}/service-tokens/{serviceTokenId} if the tool is retired or a contractor leaves. Because each tool gets its own token, revoking one does not break any other integration. Teams managing credential sprawl across integrations can track token rotation practices on daily.dev."}}]} ```