Prisma MCP Server

@prisma

リポジトリ

基本情報

カテゴリ

データベース

トランスポート

stdio

作者

prisma

投稿者

Nitin Gupta

Prisma MCP Server について

概要はまだありません

#prisma #orm #database

Prisma MCP Server の設定

以下の設定を使って、このサーバーを MCP 対応クライアントに追加してください。

{
  "mcpServers": {
    "Prisma": {
      "command": "npx",
      "args": [
        "-y",
        "prisma",
        "mcp"
      ]
    }
  }
}

Prisma MCP Server のツール

The prisma migrate status command looks up the migrations in ./prisma/migrations/* folder and the entries in the _prisma_migrations table and compiles information about the state of the migrations in your database. Example output: Status 3 migrations found in prisma/migrations Your local migration history and the migrations table from your database are different: The last common migration is: 20201127134938_new_migration The migration have not yet been applied: 20201208100950_test_migration The migrations from the database are not found locally in prisma/migrations: 20201208100950_new_migration

Prisma Migrate Dev is used to update Prisma whenever the schema.prisma file has been modified. Always provide a descriptive name argument describing the change that was made to the Prisma Schema. The migrate dev command performs these steps: 1. Reruns the existing migration history in the shadow database in order to detect schema drift (edited or deleted migration file, or a manual changes to the database schema) 2. Applies pending migrations to the shadow database (for example, new migrations created by colleagues) 3. Generates a new migration from any changes you made to the Prisma schema before running migrate dev 4. Applies all unapplied migrations to the development database and updates the _prisma_migrations table 5. Triggers the generation of artifacts (for example, Prisma Client)

Open Prisma Studio to view data in your database in a pleasing visual ui. Provide the current working directory of the users project. This should be the top level directory of the project.

概要

What is Prisma?

Prisma is a next-generation ORM that consists of Prisma Client (auto-generated type-safe query builder for Node.js/TypeScript), Prisma Migrate (declarative data modeling & migration system), and Prisma Studio (GUI to view and edit database data). It is designed for any Node.js or TypeScript backend application, including serverless and microservices.

How to use Prisma?

Install the @prisma/client npm package, which invokes prisma generate. Define a Prisma schema file with a data source, generator, and data model. Then import and instantiate PrismaClient in your code to send queries to your database.