sql-sentinel
Audit SQL for the cost & performance anti-patterns that burn warehouse credits. Scores warehouse health 0-100 and outputs a prioritized cost-reduction plan for BigQuery, Snowflake, Redshift, and Postgres.
Profile →npx skills add sickn33/agentic-awesome-skills --skill sql-sentinel --agent claude-code
Same command for any agent — swap --agent for codex, cursor, copilot.
Weekly change comes from our own snapshots, not the repository page — it measures attention, not adoption.
# sql-sentinel ## Overview A static-analysis skill that audits SQL for the cost & performance anti-patterns that dominate warehouse bills — `SELECT *`, full-table scans, non-sargable predicates, Cartesian joins, the `NOT IN` NULL trap, and 15 more. It scores warehouse query health 0-100 (A-F) and outputs a prioritized cost-reduction plan, each finding with a `why`, a concrete `fix`, and an estimated savings. Built for analytics engineers (dbt, Looker), data platform teams running FinOps / "reduce cloud spend" initiatives, and anyone reviewing a SQL pull request before it hits production. Works across BigQuery, Snowflake, Redshift, and Postgres. Zero dependencies, MIT licensed. The executable engine and full rule set live in the source repository: https://github.com/takeaseatventure/sql-sentinel. Treat that repository as third-party executable code. ## When to Use This Skill - A user writes or reviews a query for BigQuery, Snowflake, Redshift, Postgres, or Spark SQL. - A user asks "why is this query so slow?" or "why is my warehouse bill so high?" - A user is about to promote a dashboard query or dbt model to production. - A data engineer wants a second pair of eyes before a code re
- Overview
- When to Use This Skill
- How It Works
- Step 1: Run the audit
- Step 2: Read the prioritized plan
- Examples
- Example 1: A messy dashboard query
- Example 2: A clean, sargable query
- The 20 rules (ruleset v1.0.0)
- Limitations
git clone https://github.com/takeaseatventure/sql-sentinel.git cd sql-sentinel git checkout <reviewed-commit-or-tag> node scripts/sql-sentinel.js path/to/query.sql cd scripts && node test.js # 26 tests, zero dependencies
What does the sql-sentinel skill do?
Audit SQL for the cost & performance anti-patterns that burn warehouse credits. Scores warehouse health 0-100 and outputs a prioritized cost-reduction plan for BigQuery, Snowflake, Redshift, and Postgres.
How do I install it?
Run `npx skills add sickn33/agentic-awesome-skills --skill sql-sentinel --agent claude-code` — it drops the skill into your project so the agent can pick it up. Swap the --agent value for codex, cursor or copilot if you use one of those.
Where does this skill come from?
From sickn33/agentic-awesome-skills, a repository with 44,414 stars. We read it straight from the repository tree rather than a submitted listing, so what you see here is what is actually published.
Is a popular skill a good skill?
Not necessarily. Stars measure attention, not adoption — a repository can trend for a week and be abandoned. That is why we show the weekly change from our own snapshots next to the total, instead of a single flattering number.