Prisma

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>