MCP.so
Sign In

Prisma MCP Server

@CADCAMFUN

Repository

About Prisma MCP Server

No overview available yet

#cadcamfun#mcp-server#prisma

Basic information

Category

Databases

Runtime

node

Transports

stdio

Publisher

CADCAMFUN

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_mysql_server

wenb1n-dev

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

245

Elasticsearch/OpenSearch MCP Server

cr7258

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

295

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

mcp-server-qdrant: A Qdrant MCP server

qdrant

An official Qdrant Model Context Protocol (MCP) server implementation

637

MCP Server for Milvus

zilliztech

Model Context Protocol Servers for Milvus

235