Prisma Automation

Backend

Automate Prisma operations through Rube MCP (Composio) -- migrations, queries, and schema management.

Overview

This skill automates Prisma database tasks by leveraging Composio's Prisma toolkit via the Rube MCP server. Instead of running Prisma CLI commands directly, it discovers available tools at runtime, verifies connections, and executes operations through a standardized MCP interface. This ensures the agent always works with current tool schemas rather than stale assumptions.

When to Use

• Running Prisma migrations through an MCP-connected workflow
• Querying or mutating data via Prisma's remote toolkit
• Managing Prisma schema changes without direct CLI access
• Automating bulk database operations through Composio

Key Features

• MCP-native: Requires Rube MCP connection (https://rube.app/mcp) -- no API keys needed
• Tool discovery first: Always calls RUBE_SEARCH_TOOLS before executing, ensuring schemas are current
• Connection management: Verifies RUBE_MANAGE_CONNECTIONS shows ACTIVE status before any operation
• Session-aware: Reuses session IDs within workflows; generates new ones for new workflows
• Pitfall-aware: Guards against hardcoded tool slugs, missing memory parameters, and pagination gaps

Example Prompts

Use Prisma via Rube MCP to run a migration on my database.

Search for available Prisma tools and create a new record in the users table.

Check my Prisma connection status and list all schemas.

Source

• Skill folder: skills/prisma-automation/
• Standard: agentskills.io