Prisma Workflow

What it does

This skill enables AI agents to interact with and manage data using Prisma, a Node.js ORM (Object-Relational Mapper). It allows for querying databases, creating new records, updating existing ones, and deleting data based on natural language instructions. The agent can translate user requests into Prisma queries and execute them against the connected database.

When to use it

• Data Extraction: Retrieve specific information from a database when you need to answer questions or generate reports. For example, "Get all customer orders placed last month."
• Record Creation: Automatically add new entries to a database based on user input or external data sources. Like creating a new product record with details provided in a form.
• Data Updates: Modify existing records within the database according to instructions. For instance, "Update the price of product X to $25."
• Database Cleanup: Delete outdated or irrelevant data from the database based on defined criteria. Such as removing inactive user accounts after a certain period.

Key capabilities

• Prisma ORM integration
• Natural language query translation
• Data creation, retrieval, update, and deletion (CRUD) operations
• Node.js environment support

Example prompts

• "Find all users who signed up in the last week."
• "Create a new blog post with title 'My First Post' and content 'Hello world!'"
• "Update the status of order ID 123 to 'shipped'."

Tips & gotchas

• Requires a Prisma schema file configured for your database. Ensure the agent has access credentials to connect to the database.