SQLOZ OZSUITE™ ARCHITECTURE

The SQLOZ Feature Set

Engineered specifically for database architects, site reliability engineers, and backend teams. Grouped into 5 core suites under one native roof.

🛡️

1. Connection & Security Suite

Encrypted network tunnels, zero cloud intermediary hops, and hardware-backed biometric safety gates.

Module 02 →

Connection Management & Tunnels

Direct TCP/IP, mutual TLS certificates, SSH Jump Host bastions, and HTTP PHP tunnels.

Module 10 →

Safety Gate & Automated Backups

Touch ID verification, opaque write guardrails, and operation-specific recovery guidance.

Module 16 →

ozTeam™ Cryptographic Profiles

256-bit AES-GCM encrypted profile capsules for secure team sharing without exposed plaintext credentials.

⚡

2. Query & Data Processing Suite

Virtually rendered grids, non-blocking query cancellation, and autonomous local SQL AI copilots.

Module 03 →

SQL Editor & Execution Engine

Non-freezing query cancellation, transactional read-only locks, and unconditional UPDATE guardrails.

Module 04 →

Table Data Grid & Inspector

Bounded and file-backed result processing for large datasets, with inline editing and inspection tools.

Module 08 →

Visual Query Builder Canvas

Interactive relationship canvas with automatic foreign-key detection and live AST SQL generation.

Module 14 →

ozAI™ Natural Language SQL Copilot

Cmd+K natural language SQL authoring and query optimization with local providers and explicit remote-endpoint consent.

Module 15 →

ozCharts™ Live Data Visualizer

Instant line, bar, and pie charts directly from result sets with high-resolution Retina PDF export.

🏗️

3. Schema & Migration Suite

Visual ERD modeling, two-way structural drift diffs, and guarded online schema transformations for supported MySQL/MariaDB tables.

Module 05 →

Visual Schema Designer v2.0

Full ERD modeling, reverse/forward engineering, minimap canvas navigation, and drag-and-drop foreign keys.

Module 06 →

Schema Compare & Differential Sync

Four-level structural comparison matrix with side-by-side SQL diffs and compensating rollback scripts.

Module 07 →

Data Compare & Row Reconciliation

Row-level primary key hash comparisons, missing row detection, and throttled sync scripts.

Module 11 →

Cross-Dialect Smart Transpiler™

Seamless automated DDL/DML transpilation between MySQL, PostgreSQL, and SQLite with zero syntax errors.

Module 17 →

ozOSC™ Zero-Downtime Migrations

Live ALTER TABLE execution via ghost table chunking and sub-millisecond atomic table swap.

🔍

4. DBA Diagnostics & Engine Health

Real-time telemetry, directed lock-wait graphs, and graphical JSON query execution trees.

Module 09 →

DBA Suite & Engine Health Metrics

Live thread-safe processlist, buffer pool hit rates, TPS counters, and unused index pruning analysis.

Module 18 →

ozLockTree™ Deadlock & Blocker Resolver

Visual directed lock wait graphs pinpointing root blocker transactions in seconds.

Module 19 →

ozExplain™ Cost Tree & Plan Analyzer

Transforms EXPLAIN FORMAT=JSON into colored graphical cost trees with automated CREATE INDEX advisor.

🔒

5. Privacy & System Management

Regulatory compliance anonymization, macOS HIG settings, and low-level diagnostic runbooks.

Module 20 →