Overview - Corsair

Use Prisma through Corsair: one client, typed API calls, local DB sync. Prisma is the company behind Prisma ORM and the Prisma Data Platform: Prisma Postgres (managed PostgreSQL), Accelerate (global database cache), and the Console for managing workspaces, projects, databases, API keys, backups, and integrations. This plugin drives all of that through the Prisma Management API (https://api.prisma.io/v1) plus direct Postgres wire-protocol access for read-only queries, write commands, and schema inspection. Use Corsair permissions for destructive actions such as deleting projects, deleting databases, restoring backups, and revoking connections. What you get:

23 typed API operations
7 synced entities (backups, connections, databases, integrations, projects, regions, and 1 more) for fast .search() / .list()

Setup

Install

npm install corsair @corsair-dev/prisma

yarn add corsair @corsair-dev/prisma

pnpm install corsair @corsair-dev/prisma

bun add corsair @corsair-dev/prisma

Add the plugin

corsair.ts

import Database from 'better-sqlite3';
import { createCorsair } from 'corsair';
import { prisma } from '@corsair-dev/prisma';

export const corsair = createCorsair({
	plugins: [
		prisma(),
	],
	database: new Database('corsair.db'),
	kek: process.env.CORSAIR_KEK!,
	hub: {
		projectApiKey: process.env.CORSAIR_API_KEY!,
		signingSecret: process.env.CORSAIR_SIGNING_SECRET!,
	},
});

Multi-tenancy is the default — scope calls with corsair.withTenant(id). See Quick start for KEK + Hub keys, and Multi-tenancy for account isolation.

Choose authentication

API Key (Recommended)
OAuth 2.0

No setup required yet. When you make your first request as a tenant, Corsair prompts for the API key.

prisma()

More: API Key

Open hub.corsair.dev, navigate to your project, and enter the client ID and client secret from your Prisma OAuth app.

prisma({
	authType: 'oauth_2',
})

More: OAuth 2.0

Connect a tenant

Mint a connect link and send the tenant to it. Hub hosts the page and delivers the result to your app — see Connect / OAuth.

const { connectUrl } = await corsair.manage.connect.createLink({
	plugin: 'prisma',
	tenantId: 'acme',
});
// redirect the user's browser to connectUrl

Example API calls

backups.list

const tenant = corsair.withTenant('acme');
await tenant.prisma.api.backups.list({});

backups.restore

const tenant = corsair.withTenant('acme');
await tenant.prisma.api.backups.restore({});

See the full list on the API page.

Query synced data

Synced entities support tenant.prisma.db.<entity>.search() and .list(): backups, connections, databases, integrations, projects, regions, workspaces. See Database for filters and operators.

What’s next

API reference

Every prisma.api.* operation with input and output types.

Database

Synced entities, search filters, and operators.

Connect / OAuth

createLink, Hub delivery, and tenant connect flows.

Use with agents

Expose this plugin’s operations as MCP tools.

​Setup

​Example API calls

​Query synced data

​What’s next