Stats
Actions
Tags
From godmode
Optimizes ORM and data access layer: selects/configures ORMs (Prisma, Drizzle, etc.), detects N+1 queries, sets up pooling/transactions/query builders, audits performance. Outputs recommendations, reports, code, commits.
How this command is triggered — by the user, by Claude, or both
Slash command
/godmode:ormgodmode/The summary Claude sees in its command listing — used to decide when to auto-load this command
# /godmode:orm ORM and data access optimization. Covers ORM selection (Prisma, Drizzle, TypeORM, SQLAlchemy, GORM, ActiveRecord), N+1 query detection, connection pooling, transaction management, and query builder patterns. ## Usage ## What It Does 1. Detects current ORM, database, and data access patterns in the project 2. Selects the right ORM with framework-specific comparison matrices (TypeScript, Python, Go, Ruby, Java, Rust) 3. Detects N+1 query patterns and provides ORM-idiomatic eager loading fixes 4. Configures connection pooling (pool size, timeouts, recycling, health checks)...
ORM and data access optimization. Covers ORM selection (Prisma, Drizzle, TypeORM, SQLAlchemy, GORM, ActiveRecord), N+1 query detection, connection pooling, transaction management, and query builder patterns.
/godmode:orm # Interactive ORM selection and configuration
/godmode:orm --select # ORM comparison matrix and recommendation
/godmode:orm --n-plus-one # Scan codebase for N+1 query patterns
/godmode:orm --pool # Configure connection pooling for production
/godmode:orm --transactions # Design transaction management patterns
/godmode:orm --query-builder # Implement dynamic query building
/godmode:orm --raw-sql # Add raw SQL for complex queries
/godmode:orm --audit # Full ORM usage and performance audit
/godmode:orm --migrate # Migrate between ORMs
/godmode:orm --replica # Set up read replica routing
/godmode:orm --logging # Configure query logging and slow detection
/godmode:orm --report # Full data access layer report
"orm: optimize <description> data access layer"After ORM configuration: /godmode:query for query-level optimization, or /godmode:schema to revisit the data model.
/godmode:orm Prisma or Drizzle for my edge-deployed API?
/godmode:orm --n-plus-one # Find all N+1 queries in the codebase
/godmode:orm --pool # My connections keep timing out
/godmode:orm --transactions # How to handle checkout with inventory
/godmode:orm --audit # Full data access layer health check
npx claudepluginhub arbazkhan971/godmode/profile-queriesProfiles database queries for N+1 issues, missing indexes, full scans, inefficient joins, and more; generates reports with inventory, recommendations, CREATE INDEX SQL, and before/after examples.
/prisma-optimizeAnalyzes Prisma queries for N+1 issues, missing indexes, overfetching, and other performance problems, then suggests optimizations from official documentation.
/optimizeOptimizes database performance: analyzes queries with EXPLAIN, detects N+1 and slow queries, suggests indexes and rewrites, applies fixes, and reports improvements.
/schema-generatorGenerates optimized database schemas and automated migration scripts for PostgreSQL, MySQL, MongoDB with ORM integration for Prisma, TypeORM, Sequelize, and Mongoose.
/optimize-database-performanceOptimizes database performance by analyzing bottlenecks, slow queries, execution plans, schema, indexes, and resource usage; implements improvements for PostgreSQL and MySQL.
/database-reviewAnalyzes database schemas, queries, and architecture in codebase or scoped changes/PRs, generating prioritized optimization plan as markdown report.