Add optimizer, index, and comment hints to GORM queries.
npx skills add https://github.com/liurida/gorm-development-skill --skill gorm-hints
Please help me install this Agent Skill. Skill: gorm-hints Source: https://github.com/liurida/gorm-development-skill/tree/main/hints Command: npx skills add https://github.com/liurida/gorm-development-skill --skill gorm-hints
GORM queries can suffer from suboptimal execution plans, leading to slower performance or incorrect routing in multi‑tenant databases. Without explicit hints, developers cannot guide the database optimizer or force specific indexes.
"Add an index hint that forces the idx_user_name index when querying the User model."
High-intent search queries and answers about installing and using this skill.
You can force a specific index in GORM by adding index hints to your queries, suggesting or forcing indexes for SELECT, JOIN, ORDER BY, and GROUP BY clauses to correct suboptimal execution plans without modifying application logic.
Optimizer hints are directives that guide the database optimizer's execution behavior, such as setting MAX_EXECUTION_TIME. You need them when fine-tuning query performance or enforcing specific indexes to resolve inefficient execution plans.
Yes, you can route queries in multi-tenant or read-replica environments by attaching custom SQL comment hints to GORM queries, allowing you to direct traffic and add traceable comments for routing and observability.
You can add custom SQL comments to GORM queries by leveraging comment hints, attaching database-specific directives for routing, debugging, or monitoring purposes to improve system observability.
Yes, GORM supports database-specific hints through the gorm.io/hints package, allowing you to inject optimizer, index, and comment directives directly into queries without modifying your existing application logic.
liuridaExecute, inspect, and debug raw SQL and SQL builder queries in GORM.
GDSDNAnalyze PostgreSQL query plans with EXPLAIN ANALYZE to identify bottlenecks.
liuridaConfigure GORM logging with customizable levels and slow-query detection.
microwindAnalyze SQL execution plans and provide index optimization suggestions for multiple databases.
