Prisma MCP Server

Name: Prisma MCP Server
Author: CADCAMFUN

@CADCAMFUN

代码仓库

关于 Prisma MCP Server

暂无概览

#cadcamfun #mcp-server #prisma

基本信息

分类

数据库

运行时

node

传输方式

stdio

发布者

CADCAMFUN

配置

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

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

工具

未检测到工具

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

概览

What is 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.

How to use Prisma MCP Server?

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.

Features of Prisma MCP Server

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.

Use cases of Prisma MCP Server

Query database records (e.g., users, projects) via MCP resource URIs.
Perform create, update, or delete operations on any Prisma model through MCP tools.
Integrate an AI assistant like Claude Desktop with a database-backed application.

FAQ from Prisma MCP Server

What are the prerequisites for using Prisma MCP Server?

You need Node.js, a project with @prisma/client installed, a prisma/schema.prisma file, and a running database supported by Prisma (e.g., PostgreSQL, MySQL, SQLite).

How do I configure the transport mode?

Set the TRANSPORT_TYPE environment variable to sse to use Server‑Sent Events over HTTP; otherwise it defaults to stdio. When using sse, you can optionally set PORT (defaults to 8080).

Where is the database connection configured?

In the DATABASE_URL environment variable. This must be set to a valid database connection string. It should never be committed to version control.

Can I add custom resources or tools?

Yes. Fork or modify the package source; edit src/resources.ts and src/tools.ts to add custom resources and tools, then rebuild with yarn build.

How do I connect Claude Desktop to this server?

For stdio: configure Claude Desktop to launch your application (e.g., npx cadcamfun-db-mcp-server). For sse: point Claude Desktop to http://localhost:8080/sse (or a custom port). Example mcp.json snippets are provided in the README.

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

mcp_mysql_server

xwb602625136

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

245