
Database management with Prisma ORM - introspect schemas, generate migrations, run type-safe queries, and manage your database directly from the agent.
Create Prisma Postgres Database
Create a new managed Prisma Postgres database. Specify a name that makes sense to the user - maybe the name of the project they are working on. Specify a region that makes sense for the user. Valid regions are: us-east-1,us-west-1,eu-west-3,eu-central-1,ap-northeast-1,ap-southeast-1. If you are unsure, pick us-east-1. If the response indicates that you have reached the workspace plan limit, you should instruct the user to do one of these things: - If they want to connect to an existing database, they should go to console.prisma.io and copy the connection string. - If they want to upgrade their plan, they should go to console.prisma.io and upgrade their plan in order to be able to create more databases. - If they want to delete a database, they can list these via the List-Prisma-Postgres-Databases tool and then delete one they no longer need. If the response is successful: - If the user has the prisma client installed, offer to populate their .env file with the DATABASE_URL value.
List Prisma Postgres Databases
Fetch a list of available Prisma Postgres Databases for user's workspace. Each database in the response includes an 'id' field which should be used as the 'databaseId' parameter for other tools like introspect_database_schema or execute_sql_query. If the response indicates that you have no databases you should instruct the user to do one of these things: - If they want to create a new database, they should use the Create-Prisma-Postgres-Database tool - If they want to connect to an existing database, they should go to console.prisma.io and copy the connection string - If they want to upgrade their plan, they should go to console.prisma.io and upgrade their plan in order to be able to create more databases
Delete Prisma Postgres Database
Delete a Prisma Postgres database with the given database id. Inform the user that this is a permanent action and cannot be undone. Ask them to confirm that they wish to proceed. To obtain the correct database id, use the List-Prisma-Postgres-Databases tool first. If the response indicates that the database was not found, instruct the user to verify the database id using the List-Prisma-Postgres-Databases tool. If the response indicates that you cannot delete the default environment, instruct the user to delete the project instead or create a new default environment first.
Create Prisma Postgres Connection String
Create a new Connection String for a Prisma Postgres database with the given id. To obtain the correct input parameters use the List-Prisma-Postgres-Databases tool. If the response does not contain a Direct Connection String, only display the Prisma Connection String. If the response contains both Direct and Prisma Connection Strings, display both. If the response indicates that you have no databases you should instruct the user to do one of these things: - If they want to create a new database, they should use the Create-Prisma-Postgres-Database tool. - If they want to upgrade their plan, they should go to console.prisma.io and upgrade their plan in order to be able to create more databases.
Delete Prisma Postgres Connection String
Delete a Connection String with the given connection string id. Inform the user that this is a permanent action and cannot be undone. Ask them to confirm that they wish to proceed. To obtain the correct input parameters use the List-Prisma-Postgres-Connection-Strings tool
Fetch Workspace Details
Fetch the details of a Prisma Postgres workspace with the given project id. To obtain the correct input parameters use the List-Prisma-Postgres-Databases tool. The Result will be returned as a formatted Markdown string.
List Prisma Postgres Connection Strings
Fetch a list of available Prisma Postgres Database Connection Strings for the given database id. To obtain a list of available database ids, use the List-Prisma-Postgres-Databases tool If the response indicates that you have no connection strings you should instruct the user to do one of these things: - If they want to create a new connection string, they should use the Create-Prisma-Postgres-Connection-String tool
Create Prisma Postgres Backup
Create a new managed Prisma Postgres Backup. Note: On-demand backup creation is not currently supported. Backups are created automatically by the system. Use the list_prisma_postgres_backups tool to view available automated backups.
List Prisma Postgres Backups
Fetch a list of available Prisma Postgres Backups for the given database id. To obtain a list of available database ids, use the List-Prisma-Postgres-Databases tool If the response indicates that you have no databases you should instruct the user to do one of these things: - If they want to create a new database, they should use the Create-Prisma-Postgres-Database tool If the response indicates that you have no backups you should instruct the user to do one of these things: - If they want to create a new backup, they should use the Create-Prisma-Postgres-Backup tool
Create Prisma Postgres Recovery
Restore a Prisma Postgres Database to a new database with the given Backup id. To obtain the correct input parameters use the List-Prisma-Postgres-Backups tool. The target database name should be unique and not already exist. If the response is successful, use the List-Prisma-Postgres-Databases and Create-Prisma-Postgres-Connection-String tools to get the new connection string.
Execute Sql Query
Execute a SQL query on a Prisma Postgres database with the given id. To obtain the correct input parameters use the List-Prisma-Postgres-Databases tool. To obtain context about the database use the Introspect-Database-Schema tool. This tool will not have permission to execute schema updates. To make schema updates use the Execute-Schema-Update tool. The Result will be returned as JSON. <caution> - Make sure that the user is aware that this tool will execute a SQL query on a Prisma Postgres database and may result in data loss. - Confirm that the user understands the risks. - Confirm that the user understands the SQL query before you execute it. - Try restrict queries to Read-Only. </caution>
Introspect Database Schema
Introspect the schema of a Prisma Postgres database with the given id. To obtain the correct input parameters use the List-Prisma-Postgres-Databases tool. The Result will be returned as a formatted Markdown string.
Execute Prisma Postgres Schema Update
Execute a Schema Update on a Prisma Postgres database with the given id. To obtain the correct input parameters use the List-Prisma-Postgres-Databases tool. To obtain context about the database use the Introspect-Database-Schema tool. This tool should be used for schema updates only. To read/write data use the Execute-Sql-Query tool. The Result will be returned as formatted markdown string. <caution> - Make sure that the user is aware that this tool will execute a Schema Update on a Prisma Postgres database and may result in data loss. - Confirm that the user understands the risks. - Confirm that the user understands the SQL query before you execute it. </caution>
GAIA connects to Prisma via MCP (Model Context Protocol) and exposes every action as a natural-language command. Tell GAIA what you want — it handles the rest, automatically.
Set up your Prisma automation in three simple steps — no code required.
Connect Prisma to GAIA
Open the GAIA Marketplace, find the Prisma integration, and click "Add to your GAIA". Authorise access in under two minutes — no code, no configuration files.
Tell GAIA what to automate in plain English
Describe the task in your own words: "summarise my Prisma activity every morning" or "notify me on Slack when a new developer event happens". GAIA understands context and intent.
GAIA handles it automatically, 24/7
GAIA runs your Prisma automations in the background around the clock. No manual triggers, no scripts to maintain — just results delivered to you.
Everything you need to know about the GAIA Prisma integration.
Prisma is just one piece of the puzzle. GAIA integrates with 50+ tools across developer, communication, productivity, and more — letting you build cross-tool automations in plain English without writing a single line of code.
Browse all integrations