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
Basic information
About Prisma MCP Server
No overview available yet
Prisma MCP Server config
Add this server to your MCP-compatible client using the configuration below.
{
"mcpServers": {
"cadcamfun-mcp-server-db-prisma": {
"command": "npx",
"args": [
"prisma",
"generate"
]
}
}
}Prisma MCP Server tools
Tool list not available yet
This listing does not currently have a tool list to display. This does not mean the server has no tools; check its documentation for supported capabilities.
Fetch the live tool list by running this server in a temporary sandbox using the button above.
Overview
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.
Frequently asked questions
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.
More Databases MCP servers
PostgreSQL Model Context Protocol (PG-MCP) Server
stuzero540
Multi Database MCP Server
FreePeakA powerful multi-database server implementing the Model Context Protocol (MCP) to provide AI assistants with structured access to databases.
397
MotherDuck's DuckDB MCP Server
motherduckdbLocal MCP server for DuckDB and MotherDuck
498
Fund Momentum MCP Server
schneidavieFund Momentum MCP Server — VC intelligence for AI assistants. 1000+ active VC funds, live investor signals, AI-powered startup matching.
golfdata.online - Verified Golf Clubs
golfdata.onlineVerified golf club data for AI agents: holes, par, address, phone, booking links, facilities, visitor rules and green fees for golf clubs in Spain (Canary Islands and mainland), expanding across Europe. Every fact comes
Comments