holistic

holistic.devsite

More than 1,300 rules to analyze SQL queries. Takes an SQL schema definition and the query source code to generate improvement recommendations. Detects code smells, unused indexes, unused tables, views, materialized views, and more.

from

Static Analysis & Code Quality, Database Tools

added

2026-10-10

likes

0

similar

1. ▲

   codeql github.com

   Deep code analysis - semantic queries and dataflow for several languages with VSCode plugin support.

   tool link ↗
   tool
2. ▲

   SQL github.com

   SQL linting rules for ESLint.

   tool topic programming link ↗
   
3. ▲

   SafeQL safeql.dev

   Validate and auto-generate TypeScript types from raw SQL queries in PostgreSQL. SafeQL is an ESLint plugin for writing SQL queries in a type-safe way.

   site topic programmingtopic books & writing link ↗
   site
4. ▲

   SQLFluff sqlfluff.com

   Multiple dialect SQL linter and formatter.

   site topic programming link ↗
   
5. ▲

   Semgrep semgrep.dev

   A fast, open-source, static analysis tool for finding bugs and enforcing code standards at editor, commit, and CI time. Its rules look like the code you already write; no abstract syntax trees or regex wrestling. Supports 17+ languages.

   site link ↗
   
6. ▲

   jOOQ github.com

   Parses SQL, translates it to other dialects, and allows for expression tree transformations.

   tool topic programming link ↗
   

Static Analysis & Code Quality › Programming Languages: “More than 1,300 rules to analyze SQL queries. Takes an SQL schema definition and the query source code to generate improvement recommendations. Detects code smells, unused indexes, unused tables, views, materialized views, and more.”

Database Tools › SQL > Analyzers: “Automatic detection service for database performance, security, and architecture issues.”