Enforce GenDB correctness and performance rules for query execution.
npx skills add https://github.com/SolidLao/GenDB --skill experience
Please help me install this Agent Skill. Skill: experience Source: https://github.com/SolidLao/GenDB/tree/main/.claude/skills/experience Command: npx skills add https://github.com/SolidLao/GenDB --skill experience
This Skill codifies critical correctness and performance rules learned from past GenDB runs, preventing common bugs and optimizing query execution.
gendb::add_years utility, preventing subtle errors in date arithmetic that could lead to incorrect results.Always load this skill to ensure critical rules about date handling and hash tables are checked.
High-intent search queries and answers about installing and using this skill.
Preventing date arithmetic errors requires enforcing strict date handling rules, specifically using the `gendb::add_years` utility for all date manipulations. This prevents subtle calculation errors and ensures robust query execution.
Data-dependent correctness issues in query execution often stem from improper hash table capacity, incorrect DECIMAL encoding, and unoptimized date handling. Enforcing strict guidelines on these elements prevents common bugs and ensures robust results.
Optimizing query performance involves applying codified rules for hash table implementation and understanding optimizer behavioral patterns. Following these best practices improves query speed and maximizes resource utilization during execution.
Yes, GenDB requires strict rules for DECIMAL encoding and hash table capacity to prevent data-dependent correctness issues. Adhering to these guidelines ensures robust query execution and avoids common processing bugs.
You need to check optimizer behavioral patterns when optimizing query performance and addressing data-dependent correctness issues. Understanding these patterns allows you to enforce strict guidelines and achieve efficient query execution.
swarm-ai-safetyRe-run pytest suites and compare performance metrics against historical baselines.
Diversus23Optimize complex 1C queries using joins, virtual tables, and ITS type dereferencing.
vinaykumarvkScan codebases for security flaws, quality issues, and accessibility violations.
potenlabApply Supabase best-practice rules to optimize Postgres queries, indexes, and schemas.