Repository navigation
v0.8.0
What's New in v0.8.0
Hook System Complete
Three production-ready hooks now ship with the application:
Auto-Vacuum Advisor — Analyzes table bloat from pg_stat_all_tables, calculates dead
tuple ratios, and recommends VACUUM operations with priority levels (CRITICAL >50%,
HIGH >20%, MEDIUM >10%, LOW >5%). Includes ML-based growth prediction with scikit-learn.
Schema Anomaly Detector — Runs 9 detection rules against your database: missing
primary keys, foreign key columns without indexes, nullable FK columns, tables without
indexes, VARCHAR without length limits, tables without comments, and more. Generates
specific SQL fixes for each issue.
PostgreSQL Log Analyzer (Perl) — Parses PostgreSQL log files using three methods:
remote SQL via pg_read_file (if pg_monitor role granted), local CSV, and local text.
Categorizes errors and provides fix suggestions.
JSON Export
Hook results are automatically saved with timestamps. The "Export All to JSON" button
combines all saved results into a single export file. Results dialog now shows error
samples, categories, and supports copy-to-clipboard.
Performance
Schema designer FK lookup optimized from O(relationships × tables) to O(relationships)
using hash map indexing.
SSH Tunnel Foundation
SSH tunnel support stub and paramiko dependency added. Full implementation planned
for v0.9.0. Currently the application connects via direct PostgreSQL connection.
Packaging
- RPM and DEB build scripts included (
scripts/packaging/) - Desktop launcher file (
.desktop) ready - Dependencies moved to
pyproject.toml
Upgrading from v0.7.0
No database migration needed. Hook results are stored in a new directory:
~/.config/sql-schema-studio/hook_results/