New Integration: Prisma

Start by comparing integrations/github/src/index.ts with the integrations/linear/ and integrations/slack/ templates, then review the required Prisma files and Management API documentation. Implement the OAuth or bearer-token setup, workspace and project synchronization, event formatting, error handling, rate limiting, README, and integrations/README.md entry. Done means the complete Prisma integration structure and all listed tasks are covered.

Description

Add Prisma Data Platform integration to sync database projects, workspace activity, and Prisma Postgres database management events into CORE.

Reference Implementations

Existing Integrations (use as templates)

• integrations/github/ - Developer tooling integration
• integrations/linear/ - Project management patterns
• integrations/slack/ - For reference

Required Files Structure

integrations/prisma/
├── src/
│   ├── index.ts          # Main entry, OAuth spec
│   ├── schedule.ts       # Sync logic
│   ├── utils.ts          # Prisma API utilities
│   ├── account-create.ts # OAuth setup
│   └── create-activity.ts # Activity formatting
├── package.json
├── tsup.config.ts
└── README.md

Prisma API Integration

OAuth Setup

• Use OAuth 2.0 or Bearer Token authentication
• The @prisma/management-api-sdk provides built-in OAuth with automatic token refresh
• Token endpoint for OAuth: Prisma Platform OAuth flow
• Required scope: offline_access (for automatic token refresh)
• Alternative: Direct Bearer token authentication via API tokens from Prisma Console
• Console: https://console.prisma.io/

Key Endpoints (Management API)

• GET /workspaces - List workspaces
• GET /workspaces/{id} - Get workspace details
• GET /projects - List projects in a workspace
• GET /projects/{id} - Get project details
• POST /projects - Create a new project
• GET /databases - List databases
• POST /databases - Create a database
• DELETE /databases/{id} - Delete a database
• GET /environments - List environments

SDK Usage

import { ManagementAPIClient } from '@prisma/management-api-sdk'

const client = new ManagementAPIClient({
  token: 'your-bearer-token'
})

const workspaces = await client.listWorkspaces()
const projects = await client.getProject({ id: 'project-id' })

Events to Track

1. Projects & Databases

   • Project created, updated, deleted
   • Database created, deleted
   • Database connection string changes
   • Environment provisioning

2. Workspace Activity

   • Workspace member additions/removals
   • Workspace settings changes
   • Billing/plan updates

3. Schema & Migrations

   • Schema changes detected
   • Migration history
   • Database health status

Implementation Tasks

• Set up basic integration structure following integrations/github/src/index.ts pattern
• Implement OAuth 2.0 or Bearer Token flow in account-create.ts
• Create Prisma Management API utilities in utils.ts (consider using @prisma/management-api-sdk)
• Implement sync logic in schedule.ts for workspace and project activity
• Convert Prisma events to CORE activity format
• Add error handling and rate limiting
• Create integration documentation
• Add to integrations/README.md

Technical Notes

• Prisma offers a TypeScript SDK (@prisma/management-api-sdk) that simplifies API access with built-in OAuth and token refresh.
• The Management API is specifically for Prisma Data Platform (Prisma Postgres, cloud projects) - not for the Prisma ORM itself.
• The SDK supports both simple Bearer token auth and full OAuth 2.0 with automatic token refresh (requires offline_access scope).
• Prisma Data Platform is relatively new; the API surface may evolve.
• The API is primarily for managing Prisma Postgres databases and projects, not for querying database contents.
• Consider distinguishing between Prisma ORM (local development tool) and Prisma Data Platform (cloud service) in documentation.
• Note: Prisma Cloud (Palo Alto Networks) is a completely different product; this is about Prisma by Prisma Data, Inc.

Resources

• Prisma Management API SDK
• Prisma Management API Reference
• Prisma Platform Documentation
• Prisma Console
• Prisma Documentation Home

Labels

enhancement, integration, new-feature