Fonctionnalités
21 fonctionnalités natives réparties sur 5 suites DBA : visual query builder, migrations zero-downtime (ozOSC), lock resolvers et anonymiseurs PII.
1. Connection & Security Suite
Encrypted network tunnels, zero cloud intermediary hops, and hardware-backed biometric safety gates.
Connection Management & Tunnels
Direct TCP/IP, mutual TLS certificates, SSH Jump Host bastions, and HTTP PHP tunnels.
Safety Gate & Automated Backups
Touch ID verification, opaque write guardrails, and operation-specific recovery guidance.
ozTeam™ Cryptographic Profiles
256-bit AES-GCM encrypted profile capsules for secure team sharing.
2. Query & Data Processing Suite
Virtually rendered grids, non-blocking query cancellation, and autonomous local SQL AI copilots.
SQL Editor & Execution Engine
Non-freezing query cancellation, transactional read-only locks, and unconditional UPDATE guardrails.
Table Data Grid & Inspector
Bounded and file-backed result processing for large datasets.
Visual Query Builder Canvas
Interactive relationship canvas with automatic foreign-key detection.
ozAI™ Natural Language SQL Copilot
Natural language SQL authoring and query optimization with local providers.
ozCharts™ Live Data Visualizer
Instant line, bar, and pie charts directly from result sets.
3. Schema & Migration Suite
Visual ERD modeling, two-way structural drift diffs, and guarded online schema transformations.
Visual Schema Designer v2.0
Full ERD modeling, reverse/forward engineering, minimap canvas navigation.
Schema Compare & Differential Sync
Four-level structural comparison matrix with side-by-side SQL diffs.
Data Compare & Row Reconciliation
Row-level primary key hash comparisons and throttled sync scripts.
Cross-Dialect Smart Transpiler™
DDL/DML transpilation between MySQL, PostgreSQL, and SQLite.
ozOSC™ Zero-Downtime Migrations
Live ALTER TABLE execution via ghost table chunking and atomic table swap.
4. DBA Diagnostics & Engine Health
Real-time telemetry, directed lock-wait graphs, and graphical JSON query execution trees.
DBA Suite & Engine Health Metrics
Live thread-safe processlist, buffer pool hit rates, TPS counters.
ozLockTree™ Deadlock & Blocker Resolver
Visual directed lock wait graphs pinpointing root blocker transactions.
ozExplain™ Cost Tree & Plan Analyzer
Transforms EXPLAIN FORMAT=JSON into colored graphical cost trees.
5. Privacy & System Management
Regulatory compliance anonymization, macOS HIG settings, and low-level diagnostic runbooks.
ozMask™ Dynamic PII Anonymizer
Automated live-grid masking for emails, national IDs, and credit cards.
Getting Started & Architecture
Zero-overhead Swift/AppKit engineering and Apple Silicon optimization.
Preferences & Advanced Tuning
Engine timeout budgets, streaming chunk sizes, and query row limits.
Shortcuts & Diagnostic Runbook
Full macOS Cmd shortcut cheatsheet, socket diagnostics, and crash dump recovery.