skills/drizzle-orm/SKILL.md
Type-safe TypeScript ORM for PostgreSQL, MySQL, and SQLite with SQL-like and relational query APIs. MANDATORY TRIGGERS: drizzle, drizzle-orm, drizzle orm, drizzle kit, typescript orm, type-safe sql. Also trigger when user wants to define database schemas in TypeScript, write type-safe SQL queries, manage database migrations with drizzle-kit, set up relational queries with nested data, integrate Zod validation with database schemas, or configure read replicas. When in doubt about whether to use this skill for TypeScript database tasks, use it.
npx skillsauth add abhisheksharma-17/skills-graph drizzle-ormInstall this skill globally with one command. Works with Claude Code, Cursor, and Windsurf.
3 of 9 scanners reported clean
Some scanners were skipped, did not run, or reported a non-clean status. Review each row below.
Type-safe TypeScript ORM with zero dependencies, SQL-like queries, relational API, and serverless-ready design.
Source: orm.drizzle.team v0.45.1 | Package: drizzle-orm | License: Apache 2.0
| Reference | File | Read When |
|-----------|------|-----------|
| Overview & Setup | references/00-overview.md | Getting started, installation, project setup, what Drizzle is, quickstart |
| Schema Declaration | references/01-schema-declaration.md | Defining tables, column types, defaults, enums, PostgreSQL/MySQL/SQLite schemas |
| Indexes & Constraints | references/02-indexes-constraints.md | Primary keys, foreign keys, unique, check constraints, composite keys, indexes |
| Relations | references/03-relations.md | One-to-one, one-to-many, many-to-many, self-referencing, relations API |
| Select Queries | references/04-select-queries.md | SELECT, filtering, ordering, pagination, aggregations, subqueries, CTEs |
| Mutations | references/05-mutations.md | INSERT, UPDATE, DELETE, returning, upsert, onConflict, batch operations |
| Joins | references/06-joins.md | Inner, left, right, full, cross, lateral joins, aliases, partial select |
| Relational Queries | references/07-relational-queries.md | findMany, findFirst, with, nested relations, extras, prepared statements |
| Transactions | references/08-transactions.md | Transaction API, nested transactions, savepoints, isolation levels, rollback |
| Migrations | references/09-migrations.md | drizzle-kit generate, push, migrate, pull, config, workflows |
| Performance | references/10-performance.md | Prepared statements, placeholders, read replicas, query optimization |
| Validation | references/11-validation.md | Zod integration, insert/select/update schemas, refinements, schema factory |
# Install Drizzle ORM + Kit
npm install drizzle-orm
npm install -D drizzle-kit
# Database drivers (pick one)
npm install postgres # PostgreSQL (postgres.js)
npm install @neondatabase/serverless # Neon
npm install mysql2 # MySQL
npm install better-sqlite3 # SQLite
tools
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.
tools
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.
tools
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.
tools
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.