All Modules

SQL Orchestrate

Unified Job Scheduling

The central orchestration platform for all SQL2.AI operations. Manage Azure Functions, AWS Lambda, GCP Cloud Functions, and cron jobs from one unified interface with integrated monitoring in SQL Monitor.

Managed Platforms

⚡

Azure Functions

Timer & HTTP triggers

🔶

AWS Lambda

EventBridge scheduling

☁️

GCP Cloud Functions

Cloud Scheduler

⏰

Cron Jobs

Traditional cron

Key Capabilities

Unified Scheduling

One interface to schedule jobs across all platforms with consistent syntax.

  • Cron expression support
  • Rate-based scheduling
  • Event-driven triggers
  • Manual invocation

Module Operations

Schedule operations for all SQL2.AI modules from one place.

  • Key rotation (SQL Encrypt)
  • Compliance scans (SQL Comply)
  • Replication sync (SQL Centralize)
  • Data generation (SQL Simulate)

Before/After Context

Capture schema snapshots and compare changes for impact analysis.

  • Schema snapshots
  • Diff engine
  • Breaking change detection
  • Migration validation

Unified Architecture

SQL ORCHESTRATE - UNIFIED SCHEDULING
═══════════════════════════════════════════════════════════════

┌─────────────────────────────────────────────────────────────────┐
│                    SQL ORCHESTRATE                               │
│  ┌────────────────────────────────────────────────────────────┐ │
│  │   Unified Job Scheduler                                    │ │
│  │   • Cron expressions                                       │ │
│  │   • Rate-based scheduling                                  │ │
│  │   • Event-driven triggers                                  │ │
│  │   • Dependency chains                                      │ │
│  └──────────────────────┬─────────────────────────────────────┘ │
└─────────────────────────┼───────────────────────────────────────┘
                          │
     ┌────────────────────┼────────────────────┐
     │                    │                    │
     ▼                    ▼                    ▼
┌─────────────┐   ┌─────────────┐   ┌─────────────┐
│   Azure     │   │    AWS      │   │    GCP      │
│  Functions  │   │   Lambda    │   │  Functions  │
└─────────────┘   └─────────────┘   └─────────────┘
     │                    │                    │
     └────────────────────┼────────────────────┘
                          │
                          ▼
┌─────────────────────────────────────────────────────────────────┐
│                    SQL2.AI MODULES                               │
│  ┌──────────┐ ┌──────────┐ ┌──────────┐ ┌──────────┐           │
│  │ Encrypt  │ │  Comply  │ │Centralize│ │  Audit   │  ...     │
│  └──────────┘ └──────────┘ └──────────┘ └──────────┘           │
└─────────────────────────────────────────────────────────────────┘
                          │
                          ▼
┌─────────────────────────────────────────────────────────────────┐
│                    SQL MONITOR                                   │
│  • Execution history    • Performance metrics                   │
│  • Error tracking       • Alerting                              │
└─────────────────────────────────────────────────────────────────┘

Configuration

# sql2ai-orchestrate.yaml
jobs:
  # Encryption key rotation
  - name: rotate-tde-keys
    module: sql-encrypt
    action: rotate-keys
    schedule: "0 2 * * 0"  # Sundays at 2 AM
    platform: azure-functions
    config:
      key_type: tde
      notify_on_complete: true

  # Compliance scan
  - name: daily-compliance-scan
    module: sql-comply
    action: full-scan
    schedule: "0 6 * * *"  # Daily at 6 AM
    platform: aws-lambda
    config:
      frameworks: [soc2, hipaa, pci-dss]
      report_format: pdf

  # Data replication
  - name: sync-branch-data
    module: sql-centralize
    action: sync
    schedule: "*/5 * * * *"  # Every 5 minutes
    platform: gcp-functions
    config:
      sources: [branch_ny, branch_la, branch_chi]

  # Job dependency chain
  - name: nightly-maintenance
    steps:
      - job: optimize-indexes
      - job: update-statistics
        depends_on: optimize-indexes
      - job: generate-reports
        depends_on: update-statistics

Orchestration Dashboard

╔══════════════════════════════════════════════════════════════════╗
║                    SQL ORCHESTRATE DASHBOARD                      ║
╠══════════════════════════════════════════════════════════════════╣
║ ACTIVE JOBS                                                       ║
║ ─────────────────────────────────────────────────────────────── ║
║ Total Jobs:       47                                              ║
║ Running:          3                                               ║
║ Scheduled (24h):  156                                             ║
║ Failed (24h):     2                                               ║
╠══════════════════════════════════════════════════════════════════╣
║ PLATFORM DISTRIBUTION                                             ║
║ ─────────────────────────────────────────────────────────────── ║
║ Azure Functions:  23 jobs  │ ✓ All healthy                       ║
║ AWS Lambda:       15 jobs  │ ✓ All healthy                       ║
║ GCP Functions:    6 jobs   │ ✓ All healthy                       ║
║ Cron:             3 jobs   │ ✓ All healthy                       ║
╠══════════════════════════════════════════════════════════════════╣
║ RECENT EXECUTIONS                                                 ║
║ ─────────────────────────────────────────────────────────────── ║
║ rotate-tde-keys     │ ✓ Completed │ 2min ago  │ 45s duration     ║
║ sync-branch-data    │ ✓ Completed │ 3min ago  │ 12s duration     ║
║ compliance-scan     │ ► Running   │ Started 5min ago              ║
║ backup-verification │ ✗ Failed    │ 1hr ago   │ Retry scheduled  ║
╚══════════════════════════════════════════════════════════════════╝

Orchestrates All SQL2.AI Modules

One scheduling platform for every SQL2.AI operation

SQL Encrypt
SQL Comply
SQL Centralize
SQL Audit
SQL Test
SQL Anonymize
SQL Simulate
SQL Optimize

Unify Your Database Operations

One scheduling platform for all SQL2.AI modules across Azure, AWS, GCP, and on-prem.

Start Free TrialView All Features

No credit card required • Free for individual developers