Prisma MCP Server
Description
# Prisma MCP Server This package provides a Model Context Protocol (MCP) server that acts as an interface to a database managed by Prisma ORM. It allows MCP-compatible clients (like AI assistants or other applications) to interact with your database by querying resources and…
About
# Prisma MCP Server This package provides a Model Context Protocol (MCP) server that acts as an interface to a database managed by Prisma ORM. It allows MCP-compatible clients (like AI assistants or other applications) to interact with your database by querying resources and executing tools. This server uses `fastmcp`…
Details
- Author
- CADCAMFUN
- Downloads
- 262
- Categories
- Database
Jump to
- Exposes Prisma models as readable MCP resources.
- Provides MCP tools for CRUD operations on models.
- Handles translation between MCP requests and Prisma Client queries.
- Supports configurable stdio or sse (HTTP) transport.
- Easily extensible by adding custom resources or tools.
Setting up with Highlight
This MCP is not yet compatible with Highlight’s one-click setup. However, you can still use it with Highlight by following these steps:
- Download and install Highlight from highlightai.com/download
- Navigate to the plugins tab and select "Add Custom Plugin"
-
Configure the plugin with the settings below
Plugin Name
Prisma MCP ServerCommand (node, npx, python, etc.)Please refer to the README for specific instructions on how to obtain API keys or other required environment variables.
- Enable "Start Automatically" if you want the plugin to start when Highlight launches
From the repository
Install the package and @prisma/client as a peer dependency, generate the Prisma Client from your schema, set the required DATABASE_URL environment variable (and optionally TRANSPORT_TYPE, PORT, etc.), then call createPrismaMcpServer and start the server with the desired transport (stdio or sse). An example TypeScript entry point is provided in the README.
Claude Desktop / Cursor
Paste into your MCP client config file to install this server.
{
"mcpServers": {
"prisma mcp server": {
"cadcamfun-mcp-server-db-prisma": {
"command": "npx",
"args": [
"prisma",
"generate"
]
}
}
}
}McpServers
{
"cadcamfun-mcp-server-db-prisma": {
"command": "npx",
"args": [
"prisma",
"generate"
]
}
}Prisma MCP Server
This package provides a Model Context Protocol (MCP) server that acts as an interface to a database managed by Prisma ORM. It allows MCP-compatible clients (like AI assistants or other applications) to interact with your database by querying resources and executing tools.
This server uses fastmcp to expose Prisma models and operations.
Features
Resource Loading: Exposes Prisma models as readable MCP resources (e.g., resource://users/{user_id}, resource://projects).
Tool Execution: Provides MCP tools for common CRUD (Create, Read, Update, Delete) operations on your Prisma models (e.g., create_user, update_project).
Database Interaction: Handles the translation between MCP requests and Prisma Client database queries.
Configurable Transport: Supports both stdio and sse (Server-Sent Events over HTTP) transport modes.
Extensible: Easily add custom resources or tools for more complex operations or interactions with other application services.
Prerequisites
Node.js: A recent version (check package.json engines if specified).
Yarn or npm: Package manager.
Prisma Client: Your consuming project must have @prisma/client installed and a prisma/schema.prisma file configured for your target database.
- Database: A running database instance supported by Prisma (e.g., PostgreSQL, MySQL, SQLite).
Installation
```bash
Sign in to leave a review
Use Google, GitHub, or an email account so ratings stay tied to real people.
No reviews posted yet.
