Analyze database performance
Aivana Database Engineer by Aivana GmbH helps Codex investigate SQL Server and PostgreSQL databases using measured evidence, repeatable tests, business-result checks, and controlled lab changes. Production changes remain blocked. More
What you can ask Investigate slow SQL Server or PostgreSQL queries. Show evidence, risks, and verification steps. Do not change production. Copy
· Migration twin simulator skill
Skills 59 in the ChatGPT listing
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 decision simulator Simulate database agent decisions against evidence, policy, and approval constraints. 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. Ai roi narrative generator Explain database tuning ROI from supplied measurements and explicitly labeled estimates. Ai strategy synthesizer Build a database improvement roadmap from objectives, evidence, and operational constraints. Ai trust scorecard Assess the evidence and explainability of database advisor recommendations. 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 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. 
