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).
Prisma MCP Server
@CADCAMFUN
基本信息
关于 Prisma MCP Server
暂无概览
Prisma MCP Server 配置
使用下面的配置,将此服务器添加到你的 MCP 客户端。
{
"mcpServers": {
"cadcamfun-mcp-server-db-prisma": {
"command": "npx",
"args": [
"prisma",
"generate"
]
}
}
}Prisma MCP Server 工具
工具列表暂未提供
当前收录暂时没有可展示的工具列表，不代表服务没有工具。请查阅项目文档了解支持的能力。
点击上方按钮,在临时沙箱中运行此服务器并实时获取工具列表。
概览
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
stdioorsse(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.
常见问题
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 服务器
MongoDB MCP Server
mongodb-jsA Model Context Protocol server to connect to MongoDB databases and MongoDB Atlas Clusters.
1.1K
ClickHouse MCP Server
ClickHouseConnect ClickHouse to your AI assistants.
818
MotherDuck's DuckDB MCP Server
motherduckdbLocal MCP server for DuckDB and MotherDuck
498
Elasticsearch MCP Server
elastic685
Redis MCP Server
redisThe official Redis MCP Server is a natural language interface designed for agentic applications to manage and search data in Redis efficiently
539
评论