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
- nikomatt69
- Downloads
- 247
- Categories
- Database, API
Jump to
- Exposes Prisma models as readable MCP resources (e.g., resource://users/{id})
- Provides MCP tools for Create, Read, Update, Delete operations
- Handles translation between MCP requests and Prisma Client queries
- Supports both stdio and sse (HTTP) transport modes
- Extensible with custom resources and tools
- Integrates seamlessly with any Prisma‑supported database
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 cadcamfun-db-mcp-server and @prisma/client, set the DATABASE_URL environment variable (and optionally TRANSPORT_TYPE, PORT), generate Prisma Client (npx prisma generate), then call createPrismaMcpServer() and server.start() with the desired transport type (stdio or sse). Connect your MCP client to the running server.
Claude Desktop / Cursor
Paste into your MCP client config file to install this server.
{
"mcpServers": {
"prisma mcp server": {
"cadcamfun-db-mcp-server": {
"command": "npx",
"args": [
"prisma",
"generate"
]
}
}
}
}McpServers
{
"cadcamfun-db-mcp-server": {
"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.
