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
3The 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
Basic information
More Databases MCP servers

Fund Momentum MCP Server
schneidavieFund Momentum MCP Server — VC intelligence for AI assistants. 1000+ active VC funds, live investor signals, AI-powered startup matching.
Neon MCP Server
neondatabase-labsMCP server for interacting with Neon Management API and databases

Redis
modelcontextprotocolModel Context Protocol Servers
MongoDB MCP Server
mongodb-jsA Model Context Protocol server to connect to MongoDB databases and MongoDB Atlas Clusters.
Dbhub
bytebaseZero-dependency, token-efficient database MCP server for Postgres, MySQL, SQL Server, MariaDB, SQLite.
Comments