Prisma MCP Server
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`…
Explore
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.
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
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).
create_user
, `update_user`, `delete_user`
create_subscription
, `update_subscription`, `delete_subscription`
create_organization
, `update_organization`, `delete_organization`
create_project
, `update_project`, `delete_project`
create_drawing
, `update_drawing`, `delete_drawing`
create_component
, `update_component`, `delete_component`
create_material
, `update_material`, `delete_material`
create_tool_prisma
, `update_tool_prisma`, `delete_tool_prisma`
create_machine_config
, `update_machine_config`, `delete_machine_config`
create_toolpath
, `update_toolpath`, `delete_toolpath`
create_library_item
, `update_library_item`, `delete_library_item`
trigger_main_app_notification
(Example custom tool)
This server exposes MCP resources and tools corresponding to the Prisma models defined in its internal schema (prisma/schema.prisma within the package, although it uses the consuming project's generated client).
Resources (Examples):
resource://users
resource://users/{user_id}
resource://projects
resource://projects/{project_id}
resource://drawings?project_id={project_id}
resource://drawings/{drawing_id}
resource://components?project_id={project_id}
resource://components/{component_id}
resource://materials
resource://materials/{material_id}
resource://tools
resource://tools/{tool_id}
resource://machine-configs
resource://machine-configs/{machine_config_id}
resource://toolpaths?project_id={project_id}
resource://toolpaths/{toolpath_id}
resource://library-items
resource://library-items/{library_item_id}
(Refer to src/resources.ts for the complete list and arguments)
Tools (Examples):
create_user, update_user, delete_user
create_subscription, update_subscription, delete_subscription
create_organization, update_organization, delete_organization
create_project, update_project, delete_project
create_drawing, update_drawing, delete_drawing
create_component, update_component, delete_component
create_material, update_material, delete_material
create_tool_prisma, update_tool_prisma, delete_tool_prisma
create_machine_config, update_machine_config, delete_machine_config
create_toolpath, update_toolpath, delete_toolpath
create_library_item, update_library_item, delete_library_item
trigger_main_app_notification (Example custom tool)
(Refer to src/tools.ts for the complete list and parameters defined using Zod)
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"
]
}
}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.
