# Prisma (verified)

Database toolkit and ORM for TypeScript. Query schemas, explore data models, and manage database migrations.

## Quick Start

```bash
# Connect this server (installs CLI if needed)
npx -y @smithery/cli@latest mcp add prisma

# Browse available tools
npx -y @smithery/cli@latest tool list prisma

# Get full schema for a tool
npx -y @smithery/cli@latest tool get prisma create_prisma_postgres_database

# Call a tool
npx -y @smithery/cli@latest tool call prisma create_prisma_postgres_database '{}'
```

## Direct MCP Connection

Endpoint: `https://prisma.run.tools`

## Tools (13)

- `create_prisma_postgres_database` — Create a new managed Prisma Postgres database.
- `list_prisma_postgres_databases` — Fetch a list of available Prisma Postgres Databases for user's workspace.
- `delete_prisma_postgres_database` — Delete a Prisma Postgres database with the given database id.
- `create_prisma_postgres_connection_string` — Create a new Connection String for a Prisma Postgres database with the given id.
- `delete_prisma_postgres_connection_string` — Delete a Connection String with the given connection string id.
- `fetch_workspace_details` — Fetch the details of a Prisma Postgres workspace. The Result will be returned as JSON.
- `list_prisma_postgres_connection_strings` — Fetch a list of available Prisma Postgres Database Connection Strings for the given database id.
- `create_prisma_postgres_backup` — Create a new managed Prisma Postgres Backup.
- `list_prisma_postgres_backups` — Fetch a list of available Prisma Postgres Backups for the given database id.
- `create_prisma_postgres_recovery` — Restore a Prisma Postgres Database to a new database with the given Backup id.
- `execute_sql_query` — Execute a SQL query on a Prisma Postgres database with the given id.
- `introspect_database_schema` — Introspect the schema of a Prisma Postgres database with the given id.
- `execute_prisma_postgres_schema_update` — Execute a Schema Update on a Prisma Postgres database with the given id.

```bash
# Get full input/output schema for a tool
npx -y @smithery/cli@latest tool get prisma <tool-name>
```