v1.1.0

Changelog

Features

• ca78e88 feat: Enable SARIF upload in action-smoke.yml for full WO-C11 acceptance testing
• a835431 feat: Implement baseline mode for suppressing known findings
• 47e42af feat: WO-C01 Test coverage push
• 7cd92b6 feat: add --by-user flag for per-user query activity analysis
• 749b6f6 feat: add --format json to version and --quiet flag for agents
• 51919f1 feat: add MCP server mode for agent integration
• b5a7a9e feat: add diff and doctor commands
• a9c3279 feat: add grants, explain commands, redaction, and --stdin pipes
• a2bcb6a feat: add hardening, distribution, and test coverage
• 6c9fcda feat: add incremental query_log collection with watermark
• 3621af1 feat: add init command for guided config setup
• e13b8be feat: add ls, who, and ci-init commands
• 3ca6920 feat: add policy-as-code for table hygiene enforcement
• 8c8d151 feat: add query command — ad-hoc query_log power tool
• fd14e5b feat: add snapshot command for offline cluster state capture
• 9fab741 feat: add spectrehub spectre/v1 envelope output format
• 938a44e feat: add stdout output mode via --output -
• c4e487d feat: add structured exit codes
• 0697e21 feat: add top and slow commands for incident and performance analysis
• 981ede1 feat: add watch command for continuous table drift detection
• 34b3b92 feat: multi-node query_log collection with deduplication

Bug Fixes

• b40915f fix: URL-aware DSN masking and format validation in PreRunE
• 4a800f7 fix: align goreleaser and release workflow with spectre family
• 239b42a fix: apply gofmt to unformatted files
• f090376 fix: remove unused min function (builtin since Go 1.21)
• e2acb90 fix: replace hardcoded version with ldflags injection
• bc8806e fix: spectre/v1 schema compliance — remove additionalProperties

Refactoring

• ad4e0db refactor: migrate serve/deploy logging to slog, expand test coverage
• b6d20a6 refactor: simplify verbose logging to use slog level directly

Chores

• 3282aea chore: gitignore session files
• 58dce4c chore: untrack work orders and add dist to gitignore
• 0833b8d chore: wire claude-skills

v1.0.2

Changelog

Features

• 880d347 feat: add spectrehub spectre/v1 envelope output format

v1.0.1

Changelog

Features

• 571b4a2 feat: Enable SARIF upload in action-smoke.yml for full WO-C11 acceptance testing
• 218dd12 feat: Implement baseline mode for suppressing known findings
• 5f6052c feat: WO-C01 Test coverage push
• 4ccd2ac feat: add hardening, distribution, and test coverage
• b1a342e feat: add structured exit codes

Bug Fixes

• bda24d8 fix: align goreleaser and release workflow with spectre family
• 3ce3e3e fix: apply gofmt to unformatted files
• b329297 fix: remove unused min function (builtin since Go 1.21)

Refactoring

• ec4f755 refactor: simplify verbose logging to use slog level directly

Chores

• 9ce8e32 chore: untrack work orders and add dist to gitignore
• 7fd15ee chore: wire claude-skills

v1.0.0

ClickSpectre v1.0.0

ClickHouse usage analyzer - determines which tables are used, by whom, and which are safe to clean up.

Installation

Quick Install (macOS/Linux)

# Detect your platform automatically
curl -L https://github.com/ppiankov/clickspectre/releases/latest/download/clickspectre-$(uname -s)-$(uname -m) -o clickspectre
chmod +x clickspectre
sudo mv clickspectre /usr/local/bin/

Manual Download

Download the appropriate binary for your platform:

• Linux x86_64: clickspectre-Linux-x86_64
• Linux ARM64: clickspectre-Linux-arm64
• macOS Intel: clickspectre-Darwin-x86_64
• macOS Apple Silicon: clickspectre-Darwin-arm64
• Windows x86_64: clickspectre-Windows-x86_64.exe

Verify Checksums

# Download checksums
curl -LO https://github.com/ppiankov/clickspectre/releases/download/v1.0.0/checksums.txt

# Verify (Linux/macOS)
sha256sum -c checksums.txt

# Or verify single file
sha256sum clickspectre-Linux-x86_64

Quick Start

# Analyze ClickHouse usage (30-day lookback)
clickspectre analyze \
  --clickhouse-dsn "clickhouse://user:password@host:9000/default" \
  --output ./my-report \
  --lookback 30d

# View the report
clickspectre serve ./my-report

# Deploy to Kubernetes
clickspectre deploy ./my-report --namespace monitoring --port 8080

What's New

See full changelog below for detailed changes.

Documentation

• README
• ClickHouse Real Client IP Setup
• Kubernetes Resolution

Support

• Issues: https://github.com/ppiankov/clickspectre/issues
• License: MIT

Full Changelog: https://github.com/ppiankov/clickspectre/commits/v1.0.0