Prisma MCP Server

Name: Prisma MCP Server
Author: CADCAMFUN

@CADCAMFUN

Repository

About Prisma MCP Server

No overview available yet

#cadcamfun #mcp-server #prisma

Basic information

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

We auto-extract tools from the README. The maintainer can list them under a ## Tools heading to populate this section.

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.

Comments

More Databases MCP servers

MCP Server for MySQL based on NodeJS

benborla

A Model Context Protocol server that provides read-only access to MySQL databases. This server enables LLMs to inspect database schemas and execute read-only queries.

1.9K