OFFICIAL USER GUIDE & REFERENCE
SQLOZ Documentation
Comprehensive documentation for SQLOZ: master visual query building, zero-downtime schema changes, lock analysis, and native macOS database management.
23 Chapters
Core & Getting Started
Setup, SSH tunnel connections, preferences, and essential shortcuts.
Data Operations & Queries
High-speed SQL execution, inline editable grid, visual query builder, and dialect transpiler.
Schema & Model Architecture
Interactive ERD designer, two-way schema compare, and attended data synchronization.
DBA & Production Safety
Server diagnostics, zero-downtime migrations (OzOSC), deadlock resolver (OzLockTree), and live PII masking.
9
Chapter 9: DBA Suite & Server Health
10
Chapter 10: Security, Backup & Disaster Recovery
22
Chapter 22: Supported Databases & Versions
23
Chapter 23: Operations Center & Scheduled Jobs
17
Chapter 17: OzOSC - Zero-Downtime Schema Changes
18
Chapter 18: OzLockTree - Lock Resolver
20
Chapter 20: OzMask - PII Anonymizer
OzSuite™ AI & Advanced Tools
Local privacy AI assistant (OzAI), visual query execution trees, chart generator, and encrypted profile exchange.