Aivana Database Engineer

autonomous-experiment-planner

Designs dry-run experiments across query rewrites, indexes, workload twins, and rollout gates.

autonomous-learning-backlog

Prioritize missing evidence and follow-up experiments from database advisor feedback.

autonomous-ops-briefing

Produces a board-level briefing for closed-loop autonomous database operations.

autonomous-verification-loop

Create prove-before-apply gates for migrations, indexes, rewrites, SLOs, replay, and rollback evidence.

autonomy-boundary-enforcer

Enforces closed-loop dry-run boundaries and blocks autonomous production apply.

benchmark-ab-runner

Compare baseline and candidate query performance metrics and declare a benchmark winner.

change-ticket-exporter

Export approval-ready production change tickets with problem, recommendation, risk, rollback, and checklist.

cognitive-schema-mapper

Infer candidate business concepts from supplied database schema metadata.

confidence-budget-manager

Scores whether enough evidence exists to recommend, defer, or escalate an autonomous operator decision.

counterfactual-risk-engine

Compares do-nothing, dry-run-change, rollback, and defer scenarios for an operating objective.

cross-agent-consensus-builder

Compare supplied advisor recommendations and report agreement and unresolved disagreements.

decision-evidence-compiler

Builds an executive-grade decision evidence packet from runtime signals and confidence checks.

dry-run-action-critic

Critiques proposed dry-run actions for blast radius, rollback gaps, tenant risk, and weak evidence.

enforce-policy

Evaluate request against governance policies and either permit, gate, or block execution.

erp-crm-advisor

Use when diagnosing ERP or CRM performance, integration failures, tenant isolation, reporting or customization risks using scoped evidence and explicit vendor-coverage gaps.

estimate-cost

Estimate compute, IO, and runtime cost for a candidate query, migration, or schema operation.

evidence-pack-generator

Build a DBA-ready performance case file with SQL, plan, waits, recommendation, rollback, and evidence grade.

explain-query

Run structured explain/explain-analyze workflows and convert plan output into explainable optimization insights.

fleet-health-scorecard

Ranks database fleet health by latency, error-budget burn, and replication lag.

hotfix-risk-assessor

Rates emergency database hotfix risk and blocks unsafe production changes.

incident-analysis

Correlate lock, query, and replication signals into causal incident hypotheses with prioritized remediation guidance.

index-portfolio-optimizer

Optimize the whole index portfolio by finding redundant, overlapping, unused, and high-write-cost indexes.

index-roi-simulator

Ranks index candidates by read benefit, write penalty, storage cost, and maintenance risk.

knowledge-gap-detector

Identify missing database evidence before recommending an operational action.

llm-prompt-risk-auditor

Inspect database operation requests for ambiguity and unsafe intent using deterministic rules.

migration-twin-simulator

Builds a SQL Server to PostgreSQL migration twin and rates query-family performance risk.

next-best-safe-action

Chooses the safest next dry-run diagnostic or experiment from candidate actions.

objective-to-ops-plan

Converts an enterprise database operations objective into measurable goals, guardrails, and closed-loop dry-run workflows.

operator-goal-monitor

Converts SLO, cost, compliance, and incident goals into ongoing watch criteria and escalation policy.

performance-pr-reviewer

Reviews schema and migration pull requests for performance, locking, index, and rollback risks before merge.

policy-gated-self-healing

Creates safe self-healing runbooks with policy, rollback, and approval gates instead of blind production changes.

production-readiness-check

Check whether CodexDB Agent is safe to run in production with live database connections, signing, audit replay, drivers, and complete skill metadata.

production-rollout-orchestrator

Combine production readiness, verification gates, and migration risk into a Go/No-Go rollout decision.

query-contract-tester

Validates SQL against query contracts such as required columns, max rows, and read-only expectations.

recommendation-ranker

Rank SQL performance recommendations by expected impact, operational risk, and implementation effort.

release-readiness-report

Produce a release readiness report across production blockers, connector status, and health assessment.

rollback-rehearsal-engine

Creates rollback rehearsal steps and proof checklist for database changes.

semantic-incident-predictor

Classify potential database incident risks from supplied signals using heuristic analysis.

semantic-memory-index

Build a local token-vector memory index for deterministic retrieval without external embeddings.

slo-impact-guard

Translates SQL latency regressions into SLO status, error-budget burn, impacted traffic, and executive summary.

sql-code-review-assistant

Reviews SQL like a senior DBA and returns PR-ready comments and decision.

sql-performance-advisor

Use when investigating SQL Server or PostgreSQL performance and guiding a case from scoped diagnosis to measured, business-correct verification.

telemetry-correlation

Correlate deployment, lock, query-plan, and replication telemetry into incident evidence.

validate-compliance

Validate planned database operation against GDPR, HIPAA, SOC2, SOX, and ISO27001-aligned checks.

vendor-feature-mapper

Maps competitor capabilities to plugin USPs and differentiators.

workload-impact-analyzer

Rank workload queries by latency, call volume, and CPU impact to identify optimization hotspots.

workload-twin

Simulate workload scenarios such as traffic growth, added indexes, dropped indexes, and PII-sensitive workload risk.