Prisma MCP Server

@CADCAMFUN

About Prisma MCP Server

No overview available yet

Config

Add this server to your MCP-compatible client using the configuration below.

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

Tools

No tools detected

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

Frequently asked questions

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.

Comments

Basic information

More Databases MCP servers

Local YDB MCP

astandrik

Safety-first stdio MCP server with 38 tools for operating Docker-based local-ydb environments locally or over SSH.

MotherDuck's DuckDB MCP Server

motherduckdb

Local MCP server for DuckDB and MotherDuck

498

Neon MCP Server

neondatabase

MCP server for interacting with Neon Management API and databases

617

Elasticsearch/OpenSearch MCP Server

cr7258

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

295

mcp_mysql_server

xwb602625136

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

245