Prisma Postgres

prisma.io

Prisma is a hosted Postgres database with a code library and app hosting.

Can an AI agent use Prisma Postgres? Yes, without signing up. Our agent got into Prisma Postgres on its own in 2 minutes and did all 9 of its core tasks.

Category

Databases

Connects by

MCP, API, CLI, SDK

Agent payments

Stripe Projects

Driven 24 Oct 2026

From finding it to leaving

What an agent managed without a person, at each step.

  1. Find

    On its own

    Docs it can act on: llms.txt, an OpenAPI and an MCP server.

    600 doc pages read

  2. Get in

    On its own

    Try first, claim later, sign-up in a browser.

    2 minutes

  3. Use

    On its own

    Did: create a database, tables and rows and read them back; run schema changes and typed queries.

    9 of 9 core tasks

  4. Pay

    Reaches the checkout

    Stopped at the €9.27 a month charge.

    1 way for agents to pay

  5. Leave

    On its own

    Nothing to cancel; its account stays.

Getting in

4 of 6 ways in worked without a person.

The way that worked

Try first, claim later2 minutes

  • An inboxNot needed
  • A browserNot needed
  • A personNot needed
  • Agent on a serverAPI, MCP, CLIPartlyWithout an account (try first, claim later) it gets an API key, makes its first API call and does all of the core work, then stops at payment: paying takes a checkout page in a browser.
  • Assistant in its own browserLike ChatGPT agentNot checkedSign-up wasn't tried in this drive.
  • Signed agentYesThe sign-up page opens.

Every way in

Every way in and what happened
Way inWhat happenedWhy
Try first, claim laterWorked
Email and passwordWorked
CLI code loginWorked
Sign-in for apps (OAuth, MCP)Worked
Continue with GitHubNot triedNot part of this drive
Continue with GoogleNot triedNot part of this drive
  • Crawlersrobots.txt asks crawlers to stay off sign-up and the API. Nothing to fix. It keeps these pages out of search and doesn't stop agents signing up.

What an agent can do with Prisma Postgres

All 9 core tasks done, and 17 of 21 others.

Core tasks

  • done there
  • offered, not tried
Core tasks of Prisma Postgres: the result and the surfaces they went through
TaskResultThrough
Create a databaseDoneAPI: done thereMCP: done thereCLI: done there
Define a data model schema and generate a typed clientDoneAPI: done thereCLI: done there
Deploy a schema migrationDoneAPI: done thereMCP: done thereCLI: done there
Create or update a recordDoneAPI: done thereMCP: done there
Run a database queryDoneAPI: done thereMCP: done there
Delete a recordDoneAPI: done there
Deploy an app to Prisma ComputeDoneAPI: done thereMCP: done thereCLI: done there
List databases and read their schemaDoneAPI: done thereMCP: done thereCLI: done there
Browse and edit data visually in Prisma StudioDoneCLI: offered, not tried
  • Reliability

    92of 100

    Core tasks that worked on all 3 runs

  • Handles mistakes

    57of 100

    Clear errors, retries without duplicates, honest limits

  • What it can't do, and why

    • Pay for a plan Only a card checkout; no way for an agent to pay.
    • Run admin or production writes through MCP alone The owner must approve each class in the web console.
    • Roll back a deployment Only the newest version is kept, so no earlier one exists.
    • See slow queries in Query Insights The page stayed empty on the free plan.
    • Back up and restore a database Needs a paid plan.

17 of 21 other tasks done

  • Query a database over a REST APIDone
  • Create a deploy preview environment per feature branchDone
  • Manage connection string credentialsDone
  • Run a vector similarity search (pgvector)Done
  • Read Compute app logsDone
  • Set environment variables and secrets for a deploymentDone
  • Create a storage bucketDone
  • Mint or revoke a bucket access keyDone
  • Upload a file to a bucketDone
  • Create a signed URL for a fileDone
  • Delete a storage bucketDone
  • Choose a database or app regionDone
  • See Composer services topologyDone
  • Enable a Postgres extensionDone
  • Read usage and cost breakdownDone
  • Install Prisma coding-agent skillsDone
  • Search Prisma docs from an AI agentDone
  • Inspect slow queries (Query Insights)Partly
  • Back up a databasePaid plan
  • Restore a database backup: Needs a paid plan.Paid plan
  • Set a spend limitPaid plan
  • Roll back a deployment: Only the newest version is kept, so no earlier one exists.Blocked
  • Connect a custom domain to an appBlocked
  • Embed Prisma Studio data editor in your own appNot tried

Paid-plan tasks don't count toward the level. The drive used the free plan.

How an agent connects

MCP, API, OpenAPI, CLI, SDK, agent payments and llms.txt, all found.

  • MCP server

    Yes, tested

    Official server. 42 tools when driven, 28 Jul 2026, OAuth DCR, approval policy.

    mcp.prisma.io/mcp

    31 tools listed without signing in

  • API

    Yes, tested

    REST Management API, ~100 operations (projects, databases, connections, buckets, services, deployments, env vars, tokens)

    100 operations

  • OpenAPI

    Yes

    3.1.0 at /v1/doc, live responses matched.

  • CLI

    Yes, tested

    prisma 8.0.0-rc.27 unified CLI (auth, project, postgres, bucket, service, deploy, contract, db, migration, skills); create-db for no-account databases.

  • SDK

    Yes, tested

    Prisma ORM 8 RC typed client.

  • llms.txt

    Yes
  • Agent payments

    Yes

    Stripe Projects.

    The checkout: Reached the card form and stopped: Starter, €9.27 a month; Checkout: Stripe Checkout; An invisible bot check loaded at checkout; Wallets: Link.

  • Docs

    No gaps in what we read

    Covers getting started, auth, error codes and code examples.

    11 of 14 documented ways to do the core work worked when tried.

    prisma.io/docs

    600 of 801 pages read

MCP tools

Read without signing in on 1 Nov 2026

  • fetch_workspace_details
  • list_prisma_postgres_databases
  • create_prisma_postgres_database
  • delete_prisma_postgres_database
  • list_prisma_postgres_connection_strings
  • create_prisma_postgres_connection_string
  • delete_prisma_postgres_connection_string
  • list_prisma_postgres_backups
  • create_prisma_postgres_recovery
  • introspect_database_schema
  • execute_sql_query
  • execute_prisma_postgres_schema_update
  • list_object_store_buckets
  • create_object_store_bucket
  • delete_object_store_bucket
  • create_object_store_bucket_key
  • delete_object_store_bucket_key
  • search_prisma_documentation
  • list_prisma_compute_apps
  • list_prisma_compute_builds
  • list_prisma_compute_deployments
  • get_prisma_compute_deployment_logs
  • promote_prisma_compute_deployment
  • rollback_prisma_compute_app
7 more tools23 more toolsShow fewer
  • create_prisma_postgres_recovery
  • introspect_database_schema
  • execute_sql_query
  • execute_prisma_postgres_schema_update
  • list_object_store_buckets
  • create_object_store_bucket
  • delete_object_store_bucket
  • create_object_store_bucket_key
  • delete_object_store_bucket_key
  • search_prisma_documentation
  • list_prisma_compute_apps
  • list_prisma_compute_builds
  • list_prisma_compute_deployments
  • get_prisma_compute_deployment_logs
  • promote_prisma_compute_deployment
  • rollback_prisma_compute_app
  • start_prisma_compute_deployment
  • stop_prisma_compute_deployment
  • delete_prisma_compute_deployment
  • delete_prisma_compute_app
  • set_prisma_compute_env_var
  • delete_prisma_compute_env_var
  • get_prisma_composer_topology

Tips for agent builders

From this drive

7 tips
  1. No account needed to start: npx create-db@latest --json returns a connection string and claim URL (24 h).
  2. After one login, mint a service token via POST /v1/workspaces/{id}/service-tokens and use PRISMA_SERVICE_TOKEN + PRISMA_WORKSPACE_ID for CLI and REST: no approvals there.
  3. MCP needs OAuth (DCR); expect approval_required on admin and production writes, poll get_agent_approval, retry with approvalId.
  4. Prisma ORM 8: contract emit replaces generate; migration plan + db migrate replace migrate dev/deploy.
  5. Destructive CLI steps need --confirm <name>; --yes is refused.
  6. Delete Compute services before deleting their project.
  7. Change code before redeploying if only env vars changed: an unchanged redeploy is a no-op.

How Prisma Postgres compares

In Databases

1st of 9 Databases products our agent got into on its own.

The products we drove in Databases, in the directory's order, with Prisma Postgres
ProductLevelFind to leave
Prisma Postgres (this page)L4Find: On its own, Get in: On its own, Use: On its own, Pay: Partly, Leave: On its own.
UpstashL4Find: On its own, Get in: On its own, Use: On its own, Pay: Partly, Leave: On its own.
AirtableL4Find: Partly, Get in: On its own, Use: On its own, Pay: Partly, Leave: On its own.
ConvexL4Find: On its own, Get in: On its own, Use: On its own, Pay: Not reached, Leave: On its own.
NocoDBL4Find: On its own, Get in: On its own, Use: On its own, Pay: Partly, Leave: On its own.
CouchbaseL4Find: On its own, Get in: On its own, Use: On its own, Pay: Partly, Leave: On its own.
FirebaseL3Find: Stopped, Get in: On its own, Use: Partly, Pay: Not reached, Leave: On its own.
NeonL3Find: On its own, Get in: On its own, Use: Partly, Pay: Not reached, Leave: On its own.
All 15 in Databases

Sorted by level, then work done, then time to the first call. How we rank

For the team behind Prisma Postgres

Our agent got through Pay only in part. Prove Prisma Postgres is yours, then see where each issue is, read your safety findings and ask for a free drive after a fix. How to fix each one comes with the Audit.

9 things to fix for agents

Agent blockers: 3 found

  1. FindClear
  2. Get inClear
  3. UseClear
  4. PayPartly
  5. LeaveClear

Claim Prisma Postgres, freeWhat a drive covers

On our standard

25 criteria: against other databases products where we measured 5 or more, otherwise against every product we measured.

All 25 criteria
How each criterion is graded

Where Prisma Postgres fits

Every earlier drive is in the history. Data under CC BY 4.0.

Found an error? or read how corrections work.

Questions people ask about Prisma Postgres

Can an AI agent sign up for Prisma Postgres on its own?
Our agent got into Prisma Postgres without signing up. Its way in: Try first, claim later, in 2 min. Npx create-db (documented) gave a working database and connection string with no account.
Does Prisma Postgres have an MCP server, and can an agent connect to it?
Yes. Prisma Postgres has an official MCP server. The server lists 42 tools, signs an agent in with OAuth and speaks the 28 Jul 2026 MCP spec. A new agent can get in on its own: in the drive of 24 Oct 2026, our agent got its key without signing up, and without a person. Through the MCP server, 5 of our agent's 5 attempts worked.
How does an AI agent get a Prisma Postgres API key?
In the drive of 24 Oct 2026, our agent got its Prisma Postgres API key over the API, without a browser or a person.
Can an AI agent delete its Prisma Postgres account?
Yes, in a browser, without a human. Console > Account settings > Delete Account (type DELETE). Login with the old password afterwards: 'Invalid email or password'. Projects, buckets, connections, service token and MCP grant were removed first via the API. The claimable create-db database expires by itself after 24 h.
Can an AI agent pay for Prisma Postgres?
Partly. Reaches the checkout: stopped at the €9.27 a month charge. No card needed to start.

Cite this page

The page as a reference, in plain text, APA and BibTeX.

Cite this
Plain
AgentDrives, “Prisma Postgres: AI agent test drive”, 24 October 2026, https://agentdrives.com/tools/prisma. CC BY 4.0.
APA
AgentDrives. (2026, October 24). Prisma Postgres: AI agent test drive. https://agentdrives.com/tools/prisma
BibTeX
@misc{agentdrives_prisma_2026,
  author = {{AgentDrives}},
  title = {Prisma Postgres: AI agent test drive},
  year = {2026},
  month = oct,
  url = {https://agentdrives.com/tools/prisma},
  note = {Agent test drive, CC BY 4.0},
}

Something wrong on this page?

Tell us what's wrong. We check it against the drive and correct the page, with the date.