abhisheksharma-17/prisma-orm
skills/prisma-orm/SKILL.md
Next-generation Node.js and TypeScript ORM with type-safe database access, declarative schema, migrations, and query building. MANDATORY TRIGGERS: prisma, Prisma, PrismaClient, prisma.schema, prisma migrate, prisma generate, @prisma/client, Prisma ORM. Also trigger when user wants to define database models in TypeScript, run type-safe queries, manage database migrations, set up an ORM for PostgreSQL/MySQL/SQLite/MongoDB, handle relations and joins, or optimize database queries in Node.js. When in doubt about whether to use this skill for database ORM tasks, use it.
$ install --global
skillsauthnpx skillsauth add abhisheksharma-17/skills-graph prisma-ormInstall this skill globally with one command. Works with Claude Code, Cursor, and Windsurf.
Security Scan Results
3 of 9 scanners reported clean
Some scanners were skipped, did not run, or reported a non-clean status. Review each row below.
3
Scanners Passed
9
Scanners in report
Clean
TrivyContainer and dependency vulnerability scanner
95%
Clean
SemgrepStatic code analysis for vulnerabilities
95%
Clean
mcp-scan (Snyk)Model Context Protocol security validation
95%
Skipped
Snyk (dep)Open source security scanning
50%
Skipped
Socket.devSupply chain security analysis
50%
Skipped
VirusTotalMulti-engine malware detection
50%
Skipped
CrowdStrikeAdvanced threat intelligence
50%
Skipped
OSV-ScannerOpen Source Vulnerability database check
50%
Skipped
OWASP Dep-Check
50%
Last scanned: May 5, 2026, 4:21 AM223.5s18 files scanned
SKILL.md
- name:
- prisma-orm
- description:
- Next-generation Node.js and TypeScript ORM with type-safe database access, declarative schema, migrations, and query building. MANDATORY TRIGGERS: prisma, Prisma, PrismaClient, prisma.schema, prisma migrate, prisma generate, @prisma/client, Prisma ORM. Also trigger when user wants to define database models in TypeScript, run type-safe queries, manage database migrations, set up an ORM for PostgreSQL/MySQL/SQLite/MongoDB, handle relations and joins, or optimize database queries in Node.js. When in doubt about whether to use this skill for database ORM tasks, use it.
- license:
- MIT
- version:
- 1.0.0
- author:
- Abhishek Sharma
- tags:
- ["prisma", "orm", "database", "typescript", "postgresql", "mysql", "sqlite", "mongodb", "migrations", "type-safe"]
Prisma ORM — Skill Router
Next-generation ORM for Node.js & TypeScript — type-safe queries, declarative schema, automated migrations.
Source: prisma.io/docs | Package: @prisma/client v7.x | License: Apache-2.0
Reference Files
| Reference | File | Read When |
|-----------|------|-----------|
| Overview & Setup | references/00-overview.md | Installation, Prisma 7 setup, driver adapters, project init |
| Schema Language | references/01-schema-language.md | Models, fields, scalar types, attributes, enums, type modifiers |
| Relations | references/02-relations.md | One-to-one, one-to-many, many-to-many, self-relations, referential actions |
| Client CRUD | references/03-client-crud.md | findMany, findUnique, create, update, upsert, delete, batch operations |
| Filtering & Sorting | references/04-filtering-sorting.md | where clauses, operators, AND/OR/NOT, relation filters, orderBy, pagination |
| Select & Include | references/05-select-include.md | Field selection, relation loading, nested queries, _count, omit |
| Transactions | references/06-transactions.md | Sequential, interactive, nested writes, isolation levels, timeouts |
| Raw Queries | references/07-raw-queries.md | $queryRaw, $executeRaw, tagged templates, TypedSQL, SQL injection prevention |
| Migrations | references/08-migrations.md | migrate dev, deploy, reset, seeding, baseline, production workflows |
| Client Extensions | references/09-client-extensions.md | $extends, model/query/result/client extensions, computed fields |
| JSON Fields | references/10-json-fields.md | JSON read/write, path filtering, array filters, DbNull vs JsonNull |
| Error Handling | references/11-error-handling.md | Error types, P2002/P2025 codes, try/catch patterns, validation errors |
| Performance | references/12-performance.md | N+1 solutions, connection pooling, Accelerate, query optimization |
Installation
# Install Prisma CLI and Client (Prisma 7 — PostgreSQL)
npm install prisma --save-dev
npm install @prisma/client @prisma/adapter-pg pg
# Initialize Prisma
npx prisma init
# Generate client after schema changes
npx prisma generate
# Create and apply migration
npx prisma migrate dev --name init
# Deploy migrations in production
npx prisma migrate deploy
Quick Reference
- Docs: https://www.prisma.io/docs
- GitHub: https://github.com/prisma/prisma
- npm: https://www.npmjs.com/package/@prisma/client
- Changelog: https://www.prisma.io/changelog
- Playground: https://playground.prisma.io
Related Skills
abhisheksharma-17/weaviate
tools
VerifiedTrustedCommunity
Open-source AI-native vector database for semantic search, hybrid search, RAG, and agent-driven workflows with multi-tenancy and model provider integrations. MANDATORY TRIGGERS: weaviate, Weaviate, weaviate-client, near_text, near_vector, hybrid search vector database, WeaviateClient, weaviate.connect, collections.create, query.near_text, query.hybrid, query.bm25. Also trigger when user wants to build semantic search, store vector embeddings, implement RAG pipelines, combine keyword and vector search, set up multi-tenant vector storage, use named vectors, or integrate vector DB with LLM providers. When in doubt about whether to use this skill for vector database or semantic search tasks, use it.
1SKILL.mdUpdated Jun 4, 2026
abhisheksharma-17/playwright
tools
VerifiedTrustedCommunity
End-to-end testing and browser automation framework by Microsoft — locators, assertions, fixtures, network mocking, visual testing, tracing, codegen, API testing, and CI/CD integration. MANDATORY TRIGGERS: playwright, Playwright, @playwright/test, page.goto, page.click, page.locator, getByRole, getByText, getByTestId, expect(page), toHaveScreenshot, playwright.config, npx playwright. Also trigger when user wants to write E2E tests, automate browser interactions, test across Chromium/Firefox/WebKit, mock network requests in tests, do visual regression testing, generate tests with codegen, or set up CI test pipelines. When in doubt about whether to use this skill for browser testing or E2E automation tasks, use it.
1SKILL.mdUpdated Jun 4, 2026
abhisheksharma-17/openai-agents-sdk
tools
VerifiedTrustedCommunity
OpenAI Agents SDK for building multi-agent workflows with tools, handoffs, guardrails, streaming, MCP, sessions, and tracing. MANDATORY TRIGGERS: openai-agents, openai agents sdk, openai-agents-python, openai agents, Runner.run, function_tool, handoff, guardrail, MCPServerStdio, MCPServerStreamableHttp, HostedMCPTool, RunContextWrapper, AgentHooks. Also trigger when user wants to build multi-agent systems with OpenAI models, create agent orchestration with handoffs, add guardrails to LLM applications, integrate MCP servers with agents, implement streaming agent responses, or use OpenAI's official agent framework. When in doubt about whether to use this skill for OpenAI agent tasks, use it.
1SKILL.mdUpdated Jun 4, 2026
abhisheksharma-17/haystack
tools
VerifiedTrustedCommunity
AI orchestration framework for building production-ready RAG applications, autonomous agents, and multimodal search systems. MANDATORY TRIGGERS: haystack, deepset, haystack-ai, haystack pipeline, haystack agent. Also trigger when the user wants to build RAG pipelines with modular components, create tool-calling agents with Haystack, orchestrate retrieval-augmented generation, build semantic search systems, or evaluate LLM pipelines. When in doubt about whether to use this skill for RAG orchestration or AI pipeline tasks, use it.
1SKILL.mdUpdated Jun 4, 2026