SQLSERVER-POSTGRES-Plugin

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

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

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

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

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

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

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

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

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

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

Top-level AI SQL performance advisor that orchestrates detection, rewrite candidates, ranking, workload impact, benchmarks, and consultant answer.

Grade advisory recommendations by evidence strength and identify missing proof before production change.

Correlate query stats, telemetry, policy decisions, and replay memory into deterministic incident hypotheses and next-best actions.

Check schema drift, required columns, PII declaration, retention, and governance controls against a declared data contract.

Generates bounded read SQL with tenant, policy, audit, and performance guardrails.

Score migration blast radius and produce a rollback rehearsal plan before schema changes reach production.

Generate safe query rewrite candidates with deterministic explainability without executing SQL.

Generate audit-grade records for sensitive SQL operations including approvals, risk outcomes, and execution traces.

Orchestrates a DBA loop from evidence collection through confidence grading, experiment design, ticket prep, and rollback.

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

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

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

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

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

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

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

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

Rates emergency database hotfix risk and blocks unsafe production changes.

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

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

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

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

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

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

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

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

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

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

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

Creates rollback rehearsal steps and proof checklist for database changes.