cadcamfun-mcp-server-db-prisma

cadcamfun-mcp-server-db-prisma

0
databases

The Prisma MCP Server is an extensible Model Context Protocol server that provides access to databases via Prisma ORM, facilitating interactions for MCP-enabled clients to perform queries and tooling operations.

Prisma MCP Server

This project provides an MCP server using Prisma ORM to act as an interface to a database, allowing MCP-compatible clients to interact with it for querying resources and executing tools. Key features include:

  • Resource Loading: Exposes Prisma models as MCP resources.
  • Tool Execution: Implements CRUD operations using MCP tools.
  • Database Interaction: Translates MCP requests into Prisma Client queries.
  • Configurable Transport: Supports stdio and sse transport modes.
  • Extensibility: Custom resources and tools can be added.

Prerequisites

  • Requires Node.js, Yarn or npm, Prisma Client, and a running database supported by Prisma.

Setup in Consuming Project

  1. Ensure a valid Prisma schema is in place.
  2. Set environment variables for database connection and transport.
  3. Generate Prisma Client before running the server.

Connecting with Claude Desktop

  • Supports connections via stdio or sse transport methods.

Available Resources & Tools

Exposes various resources and tools related to Prisma models for user, project, and other operations.

Extending

The package can be extended to add custom resources and tools.

Deployment

Instructions are provided for configuring environment variables and starting the application in a production setup.

License

Licensed under MIT.