orm-query-builder

Generate ORM queries with filtering, sorting, pagination, and eager loading.

1|Updated Mar 17, 2025

Search Tags:#query optimization #ORM #data access #Prisma #TypeORM #SQLAlchemy #database query

One-click install

npx skills add https://github.com/MaciWP/CV_Astro --skill orm-query-builder

Or copy as Structured Prompt for Agent▼

Please help me install this Agent Skill.
Skill: orm-query-builder
Source: https://github.com/MaciWP/CV_Astro/tree/main/.claude/skills/orm-query-builder
Command: npx skills add https://github.com/MaciWP/CV_Astro --skill orm-query-builder

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires SQLAlchemy, Prisma, TypeORM, Drizzle, Django ORM, and includes references (resource) components.

What problem does it solve?

This Skill simplifies the creation of complex, efficient, and type-safe database queries using Object-Relational Mappers (ORMs), eliminating the need for raw SQL and reducing query-related bugs.

Core Features & Use Cases

Relationship Handling: Easily fetch related data with eager loading (JOINs) to avoid N+1 query problems.
Advanced Filtering & Pagination: Construct complex WHERE clauses, sort results, and implement efficient pagination.
Use Case: Generate a Prisma query to fetch a user by ID, including their 5 most recent published posts, ordered by creation date, or an SQLAlchemy query with nested relationships and complex filters.

Quick Start

Generate a Prisma query to fetch a user by ID, including their 5 most recent published posts, ordered by creation date.