Prisma MCP integration
Runs read-only queries against Prisma Postgres, provisions projects and databases on request, audits connections, and restores backups.
22actions available
Three actions you can hand over today
Every action runs live through MCP. Nothing to build, nothing to maintain.
Create prisma project
Ayro provisions a new Prisma project with a managed PostgreSQL database. Developers have a production-ready database without manually provisioning infrastructure.
Get prisma project
Ayro retrieves the configuration and metadata of a Prisma project by ID. Engineers confirm project settings without logging into Prisma's web console.
Delete prisma project
Ayro permanently removes a Prisma project and all associated resources. You stop paying for unused databases and keep your project inventory clean.
How businesses use Prisma + Ayro
Each card is one request a support team gets, and the Prisma actions Ayro runs to close it.
Answer a data question without opening a SQL client
Ayro inspects the tables, columns, and relationships first, then runs a read-only SELECT over an SSL connection and reports usage metrics alongside it when the question is about cost or volume.
Inspect Database SchemaExecute SQL QueryGet Database Usage MetricsProvision a project and database on request
Ayro creates a Prisma project with managed Postgres in the region asked for, adds a further database to an existing project, and issues a connection string with credentials ready to use.
Create Prisma ProjectCreate Project DatabaseCreate Database ConnectionAudit who still has database access
Ayro lists the API key connections on a database with their names and creation dates, the OAuth integrations granted on the workspace, and the projects each one reaches, so a security review starts from a real inventory.
List Database ConnectionsList Workspace IntegrationsList Prisma ProjectsRecover a database from its last good backup
Ayro reports which backups exist with their size and restoration readiness, restores the chosen one into a new database instance, and checks that instance's status while the asynchronous restore completes.
List Database BackupsRestore Database BackupGet Prisma Database
How it works
Get started in 3 steps
Connect once, then just ask. There is no workflow builder to learn and nothing to maintain — Ayro reads the Prisma actions it has and picks the ones a request needs.
Connect Prisma
Authorize the Prisma account your team already uses — one consent screen, no API keys, no mapping tables. Ayro can only do what you granted that account, and you can disconnect it at any time.
Tell your agent what you need
Describe the job the way you would hand it to a teammate. Ayro maps it to the Prisma actions that close it and chains as many as the request needs.
Watch it work
The agent runs the actions inside the conversation the customer is already in, so nobody copies data between tabs and your team can take over at any point.
Get started free
Prisma · Ayro
What can you do in Prisma without me setting anything up?
These, right away:
- Create database connection
- Get prisma database
- Delete database connection
Great, let's start with the first one.
FAQ
Everything else about Prisma
Setup, permissions, and the limits of what Ayro can do inside Prisma.
The two are separate actions. Execute SQL Query runs read-only SELECT statements over a direct SSL connection, while INSERT, UPDATE, DELETE, and CREATE TABLE all go through Execute SQL Command. Enabling only the query action gives Ayro analysis access with no ability to modify anything.
Every action available in Prisma
All 22 actions your agent can call on Prisma, straight from the live MCP connection.
Create database connection
Create new API key connection for database access.
Create project database
Create new postgres database in an existing Prisma project.
Create prisma project
Create new Prisma project with managed postgres database.
Delete database connection
Permanently delete database connection and revoke API key access.
Delete prisma database
Permanently delete Prisma database and all stored data.
Delete prisma project
Permanently delete Prisma project and all associated resources.
Execute SQL command
Execute SQL commands that modify database data or structure.
Execute SQL query
Execute SQL SELECT queries against Prisma Postgres databases.
Get prisma database
Retrieve specific Prisma database by ID.
Get database usage metrics
Retrieve usage metrics for a specific Prisma database.
Get prisma project
Retrieve specific Prisma project by ID.
Inspect database schema
Inspect database schema structure and table information.
List prisma accelerate regions
Retrieve all available regions for Prisma Accelerate.
List database backups
Retrieve list of available backups for a specific database.
List database connections
Retrieve paginated list of connections for a specific database.
List project databases
Retrieve paginated list of databases for a specific Prisma project.
List prisma postgres regions
Retrieve all available regions for Prisma Postgres.
List prisma projects
Retrieve paginated list of Prisma projects accessible to authenticated user.
List workspace integrations
Retrieve paginated list of integrations for a specific Prisma workspace.
List prisma workspaces
Retrieve paginated list of Prisma workspaces accessible to authenticated user.
Restore database backup
Restore database backup to new database instance.
Transfer prisma project
Transfer Prisma project ownership to another user's workspace.
The tools Prisma sits next to
Same connection, same setup. Pick the next one your team already uses.
Bench
Pauses a step for a set interval through Bench's single Sleep action, pacing a run of calls instead of firing them at once.
Codemagic
Starts builds on a chosen workflow and branch, reads build history, updates variable groups, and clears application caches without opening the dashboard.
Formcarry
Stands up a form with its notification and webhook settings, pages through its submissions, and retires it when it is finished.
Mezmo
Checks ingestion status, builds filtered views and preset alerts, writes exclusion rules to hold down index cost, and rotates API keys and member roles.
RudderStack Transformation
Lists published transformations and libraries, creates and publishes new code, and walks back through revision history on request.
Twocaptcha
Checks the 2Captcha balance, submits a CAPTCHA as a solving task, and reports solutions the target site rejected.
Ready to connect Prisma?
Authorize the account and your agent has all 22 actions from the first conversation.