sql_query_analyzer 0.12.0

Static analysis tool for SQL queries with 31 built-in rules for performance, security, and style
Documentation 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51

<!--
SPDX-FileCopyrightText: 2026 RAprogramm
SPDX-License-Identifier: MIT
-->

# Configuration

Configuration is merged from several sources, highest priority first:

1. Command line arguments
2. Environment variables
3. `.sql-analyzer.toml` in the current directory
4. `~/.config/sql-analyzer/config.toml`

## Config file

```toml
[llm]
provider = "openai"
model = "gpt-4"
# api_key can be set here, but the environment variable is preferred
# ollama_url = "http://localhost:11434"

[retry]
max_retries = 3
initial_delay_ms = 500
max_delay_ms = 8000
backoff_factor = 2.0

[rules]
# Disable rules by ID
disabled = ["STYLE001", "PERF010"]

# Override severities: error | warning | info
[rules.severity]
PERF001 = "error"
SEC003 = "warning"
```

## Environment variables

| Variable | Effect |
|----------|--------|
| `LLM_API_KEY` | API key for OpenAI / Anthropic |
| `LLM_PROVIDER` | Default provider name |

## Rule tuning

- `rules.disabled` — a list of rule IDs to skip entirely.
- `rules.severity` — per-rule severity overrides; affects both output and the
  process exit code (see [Quick Start](quick-start.md#4-exit-codes)).