Skip to main content
Version: Next

Features

Executor provides a comprehensive set of capabilities designed to simplify, standardize, and automate database change workflows. Explore the key features below to understand how Executor helps teams manage scripts, ensure consistency across environments, and maintain full visibility into database operations.

Browse by feature​

Online SQL Editor​

The Online SQL Editor allows you to create interactive SQL sessions connected to your configured environments (e.g., DEV, TEST, PROD).

All executed queries and session activities are audited and logged, ensuring full traceability of every database operation.

Key benefits:

  • Real-time query execution from browser
  • Secure credential management
  • Full activity audit trail

Versioned Database Objects​

Version control isn’t just for code — Executor lets you version your database objects (tables, views, procedures, functions, etc.).

Each change is tracked, so you can compare object definitions between versions or rollback to previous states if needed.

Key benefits:

  • Track changes across environments
  • Compare previous and current definitions
  • Prevent unintentional schema drift

Schema / Baseline Compare​

Use the Schema Compare feature to detect differences between database instances or versions.

You can compare your production schema with a development baseline and generate synchronization scripts automatically.

Example:

  • Compare DEV → TEST
  • Identify missing indexes, altered columns, or permission changes

Output:

- COLUMN salary NUMBER(10,2)
+ COLUMN salary DECIMAL(10,2)

Key benefits:

  • Detect drift before deployment
  • Auto-generate fix scripts
  • Ensure consistency across environments

Mailbox Inspector​

The Mailbox Inspector continuously monitors incoming emails for approval or rejection requests.

For example, if your database update requires managerial approval, the system reads the corresponding email and updates the request status automatically.

Example workflow:

  • A user submits a DDL script for approval.
  • The approver replies with “✅ Approved” or “❌ Rejected.”
  • The Mailbox Inspector processes the response and updates the execution queue.

Key benefits:

  • Automate approval workflows via email
  • Reduce manual intervention
  • Maintain full audit logs of approval events

Roles and Permissions​

Executor DB provides a flexible role-based permission system.

You can define roles locally or map them to existing database roles (for example, Oracle or PostgreSQL roles).

Example:

  • Local role: DB_EXECUTOR
  • Mapped database role: HR_ADMIN
  • Users with DB_EXECUTOR can execute queries using HR_ADMIN privileges.

Key benefits:

  • Centralized access control
  • Database-level role integration
  • Fine-grained permission management

Tasks and Scheduling​

Automate repetitive operations with Tasks.

You can schedule tasks to run SQL scripts, perform schema comparisons, or send summary reports automatically.

Example:

  • Daily schema validation at 03:00
  • Weekly data cleanup job
  • Automatic notification if a schema mismatch is found

Key benefits:

  • Reduce manual effort
  • Ensure

Workspaces​

Create and manage workspaces.