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.

Key features of Prisma

Auto-generated, fully type-safe query builder for Node.js & TypeScript
Declarative data modeling and migration system
Visual GUI (Prisma Studio) to view and edit data
Supports PostgreSQL, SQLite, and existing databases via introspection
Extensible with Prisma Accelerate, Optimize, and Studio
Works with REST, GraphQL, gRPC, and other API stacks

Use cases of Prisma

Building type-safe REST or GraphQL APIs backed by a database
Developing serverless applications with database access
Prototyping applications with Prisma Postgres or SQLite
Adding Prisma to an existing project with a custom database

常见问题

What databases does Prisma support?

Prisma supports PostgreSQL, SQLite, and can work with existing databases via introspection. Quickstarts are available for Prisma Postgres and SQLite.

Does Prisma work with TypeScript?

Yes, Prisma Client provides full type-safety for all queries when using

数据库分类下的更多 MCP 服务器

Postgres Mcp

crystaldba

Postgres MCP Pro provides configurable read/write access and performance analysis for you and your AI agents.

3.0K

ClickHouse MCP Server

ClickHouse

Connect ClickHouse to your AI assistants.

818

Redis

modelcontextprotocol

Model Context Protocol Servers

88.2K

Chroma MCP Server

chroma-core

A Model Context Protocol (MCP) server implementation that provides database capabilities for Chroma

569

MCP DB Wizard

srmadscience

Oracle MCP server with no run-sql tool: It generates tools for each of the PL/SQL procedures, tables and approved SQL you choose. The server doesn't expose a SQL prompt, and can't reveal how it's connected to Oracle.