Prisma
Prisma Data Platform provides database tools including Accelerate (global database cache), Optimize (AI-driven query analysis), and Prisma Postgres (managed PostgreSQL). Manage workspaces, projects, environments, and API keys programmatically.
This is a first-class FlyMyAI MCP. Agents discover it automatically via tool search and call the actions below on demand - you never wire it up by hand. See the Composio catalog for how discovery works.
Connect
Prisma connects with a single OAuth click - there is no token to paste. The first time an agent uses a Prisma action, FlyMyAI asks you to authorize your Prisma account. Approve it once and the connection is reused for every later run.
- Provider: Prisma
Actions
Every action this integration exposes. Agents pick the right one from the task; you do not call them by name.
| Action | What it does | Required inputs |
|---|---|---|
PRISMA_CREATE_CONNECTION | Create new api key connection for database access. creates connection string with embedded credentials for application database access. returns complete connection details ready for immediate use. | databaseId, name |
PRISMA_CREATE_DATABASE | Create new postgres database in an existing prisma project. creates database in specified region with connection strings and api keys. returns complete database details ready for immediate use. | projectId, name, region |
PRISMA_CREATE_PROJECT | Create new prisma project with managed postgres database. creates project in authenticated user's workspace with postgres database in specified region. returns complete project details including connection strings and api keys. | name, region |
PRISMA_DELETE_CONNECTION | Permanently delete database connection and revoke api key access. warning: this immediately revokes database access for any applications using this connection string. ensure no critical systems depend on this connection. | id |
PRISMA_DELETE_DATABASE | Permanently delete prisma database and all stored data. warning: this action cannot be undone. all data in the database will be permanently destroyed. default databases typically cannot be deleted. | databaseId |
PRISMA_DELETE_PROJECT | Permanently delete prisma project and all associated resources. warning: this action cannot be undone. all databases, environments, and project data will be permanently destroyed. use with extreme caution in production environments. | id |
PRISMA_EXECUTE_SQL_COMMAND | Execute sql commands that modify database data or structure. runs insert, update, delete, create table, and other data modification commands safely through postgresql driver with parameterized query support. | connectionString, command |
PRISMA_EXECUTE_SQL_QUERY | Execute sql select queries against prisma databases. runs read-only queries safely through postgresql driver with automatic type mapping. perfect for data analysis, schema inspection, and reporting operations. | connectionString, query |
PRISMA_GET_DATABASE | Retrieve specific prisma database by id. returns database details including status, project context, and regional deployment. use for database monitoring, validation, and administrative operations. | databaseId |
PRISMA_GET_PROJECT | Retrieve specific prisma project by id. returns project details including name, creation timestamp, and workspace information. use for project detail views, validation, and administrative operations. | id |
PRISMA_INSPECT_DATABASE_SCHEMA | Inspect database schema structure and table information. returns comprehensive schema details including tables, columns, data types, constraints, and relationships. essential for understanding database structure before executing queries. | connectionString |
PRISMA_LIST_ACCELERATE_REGIONS | Retrieve all available regions for prisma accelerate. returns regions where accelerate global database cache can be deployed. use for cache region selection to minimize latency for your users. | - |
PRISMA_LIST_BACKUPS | Retrieve list of available backups for a specific database. returns backup details including status, size, type, and restoration readiness. use for backup monitoring, restoration planning, and compliance auditing. | databaseId |
PRISMA_LIST_CONNECTIONS | Retrieve paginated list of connections for a specific database. returns connection details including names, creation dates, and database context. use for api key management, security audits, and access control. | databaseId |
PRISMA_LIST_DATABASES | Retrieve paginated list of databases for a specific prisma project. returns database details including status, region, and project context. use for database discovery, monitoring, and project administration. | projectId |
PRISMA_LIST_POSTGRES_REGIONS | Retrieve all available regions for prisma postgres. returns regions where prisma postgres databases can be deployed with current availability status. use for region selection during database creation and capacity planning. | - |
PRISMA_LIST_PROJECTS | Retrieve paginated list of prisma projects accessible to authenticated user. returns project ids, names, workspace info, and timestamps with cursor-based pagination. use for project discovery, ui selection flows, and administrative operations. | - |
PRISMA_LIST_WORKSPACES | Retrieve paginated list of prisma workspaces accessible to authenticated user. returns workspace ids, names, creation timestamps with cursor-based pagination. use for workspace discovery, ui selection flows, and administrative operations. | - |
PRISMA_RESTORE_BACKUP | Restore database backup to new database instance. creates new database from existing backup with specified name. operation is asynchronous - monitor the returned database status for completion. restoration may take several minutes. | databaseId, backupId, targetDatabaseName |
PRISMA_TRANSFER_PROJECT | Transfer prisma project ownership to another user. changes project ownership to recipient specified by their access token. current owner loses access unless explicitly granted by new owner. | id, recipientAccessToken |
Links
We love our partners - FlyMy.AI builds with the best. Thanks, Prisma!