Prisma MCP Server

@CADCAMFUN

リポジトリ

基本情報

カテゴリ

データベース

トランスポート

stdio

作者

CADCAMFUN

Prisma MCP Server について

概要はまだありません

#cadcamfun#mcp-server #prisma

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

よくある質問

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.

「データベース」の他のコンテンツ

nuzur

nuzur is a model-first database platform for MySQL and PostgreSQL. The MCP server lets any AI assistant or agent (Claude, Cursor, Gemini, or anything else that speaks MCP) design your schema, query your data, generate mi

Expired Domains MCP | Karma.Domains

karma-domains

Connect Karma.Domains to ChatGPT, Claude, Cursor, VS Code, or another MCP client — and find a domain in plain language. The same auctions, expired, backorder, and buy-now data you use in the app, plus saved filters, note

Redis

modelcontextprotocol

Model Context Protocol Servers

88.2K

PostgreSQL