MCP.so
Sign In
P

Prisma

@prisma

About Prisma

No overview available yet

Config

Add this server to your MCP-compatible client using the configuration below.

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

Tools

3

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.

Overview

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

FAQ from Prisma

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

Frequently asked questions

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

Comments

More Databases MCP servers