rweisssieker-xp/SQLSERVER-POSTGRES-Plugin

autonomous-experiment-planner

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

autonomous-ops-briefing

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

autonomy-boundary-enforcer

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

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.

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.

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.

sql-performance-advisor

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

advisor-confidence-grader

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

ai-anomaly-triage

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

ai-data-contract-guardian

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

ai-guarded-sql-generator

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

ai-migration-risk-radar

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

ai-query-rewrite-lab

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

audit-query

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

autonomous-dba-copilot

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

autonomous-verification-loop

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

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.

enforce-policy

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

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.

migration-twin-simulator

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

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.