Prisma MCP Server

Name: Prisma MCP Server
Author: nikomatt69

@nikomatt69

代码仓库

关于 Prisma MCP Server

暂无概览

#cadcamfun #mcp-server #prisma #database #api

基本信息

分类

数据库

运行时

node

传输方式

stdio

发布者

nikomatt69

配置

使用下面的配置,将此服务器添加到你的 MCP 客户端。

{
  "mcpServers": {
    "cadcamfun-db-mcp-server": {
      "command": "npx",
      "args": [
        "prisma",
        "generate"
      ]
    }
  }
}

工具

未检测到工具

工具是从 README 中自动提取的。维护者可以在 ## Tools 标题下列出工具,即可填充这部分内容。

概览

What is Prisma MCP Server?

It provides a Model Context Protocol (MCP) server that acts as an interface to a database managed by Prisma ORM, allowing MCP-compatible clients (like AI assistants) to query resources and execute CRUD tools on Prisma models.

How to use Prisma MCP Server?

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.

Key features of Prisma MCP Server

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

Use cases of Prisma MCP Server

Query database records through an AI assistant that supports MCP
Perform CRUD operations on Prisma models programmatically via MCP tools
Build a custom MCP‑based API layer over an existing Prisma backend
Automate database tasks like creating subscriptions or updating toolpaths

FAQ from Prisma MCP Server

What are the prerequisites?

You need Node.js, yarn or npm, @prisma/client installed as a peer dependency, a valid prisma/schema.prisma file, and a running database (e.g., PostgreSQL, MySQL, SQLite).

How do I configure the transport mode?

Set the TRANSPORT_TYPE environment variable to sse for Server‑Sent Events over HTTP (defaults to stdio). If using sse, you can also set PORT (default 8080).

How do I connect Claude Desktop?

Configure the MCP client with either the stdio command (e.g., npx cadcamfun-db-mcp-server) or the SSE URL (http://localhost:8080/sse). Example mcp.json snippets are provided in the README.

Can I extend the server with custom resources/tools?

Yes. Fork the package or modify src/resources.ts and src/tools.ts, then rebuild with yarn build.

What environment variables are required?

DATABASE_URL is required. Optional variables include TRANSPORT_TYPE, PORT, MAIN_APP_URL, and LOG_LEVEL. Do not commit sensitive variables to version control.

数据库分类下的更多 MCP 服务器

Elasticsearch/OpenSearch MCP Server

cr7258

A Model Context Protocol (MCP) server implementation that provides Elasticsearch and OpenSearch interaction.

295

MongoDB MCP Server

mongodb-js

A Model Context Protocol server to connect to MongoDB databases and MongoDB Atlas Clusters.

1.1K

mcp_mysql_server

wenb1n-dev

Model Context Protocol (MCP) server that supports secure interaction with MySQL databases and has anomaly analysis capabilities.更加牛逼！更加好用！不仅止于mysql的增删改查功能；还包含了数据库异常分析能力；且便于开发者们进行个性化的工具扩展

245