Prisma

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

    Lyro provisions a new Prisma project with a managed PostgreSQL database. Developers have a production-ready database without manually provisioning infrastructure.

  • Get prisma project

    Lyro 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

    Lyro permanently removes a Prisma project and all associated resources. You stop paying for unused databases and keep your project inventory clean.

See all 22 actions

How businesses use Prisma + Lyro

Each card is one request a support team gets, and the Prisma actions Lyro runs to close it.

  • Answer a data question without opening a SQL client

    Lyro 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 Metrics
  • Provision a project and database on request

    Lyro 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 Connection
  • Audit who still has database access

    Lyro 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 Projects
  • Recover a database from its last good backup

    Lyro 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 — Lyro reads the Prisma actions it has and picks the ones a request needs.

  1. 01

    Connect Prisma

    Authorize the Prisma account your team already uses — one consent screen, no API keys, no mapping tables. Lyro can only do what you granted that account, and you can disconnect it at any time.

  2. 02

    Tell your agent what you need

    Describe the job the way you would hand it to a teammate. Lyro maps it to the Prisma actions that close it and chains as many as the request needs.

  3. 03

    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 · Lyro

Everything else about Prisma

Setup, permissions, and the limits of what Lyro 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 Lyro 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.

Ready to connect Prisma?

Authorize the account and your agent has all 22 actions from the first conversation.

Support agent working at a laptop next to the Lyro mascot