rweisssieker-xp
- 833 skills
- 0 followers
- 1 repo stars
- last month last updated
- ▌ Benchmark Ab Runner · rweisssieker-xpCompare baseline and candidate query performance metrics and declare a benchmark winner.
- ▌ Index Roi Simulator · rweisssieker-xpRanks index candidates by read benefit, write penalty, storage cost, and maintenance risk.
- ▌ Validate Compliance · rweisssieker-xpValidate planned database operation against GDPR, HIPAA, SOC2, SOX, and ISO27001-aligned checks.
- ▌ AI Query Rewrite Lab · rweisssieker-xpGenerate safe query rewrite candidates with deterministic explainability without executing SQL.
- ▌ Hotfix Risk Assessor · rweisssieker-xpRates emergency database hotfix risk and blocks unsafe production changes.
- ▌ AI Decision Simulator · rweisssieker-xpSimulate database agent decisions against evidence, policy, and approval constraints.
- ▌ Dry Run Action Critic · rweisssieker-xpCritiques proposed dry-run actions for blast radius, rollback gaps, tenant risk, and weak evidence.
- ▌ Next Best Safe Action · rweisssieker-xpChooses the safest next dry-run diagnostic or experiment from candidate actions.
- ▌ Objective To Ops Plan · rweisssieker-xpConverts an enterprise database operations objective into measurable goals, guardrails, and closed-loop dry-run workflows.
- ▌ Operator Goal Monitor · rweisssieker-xpConverts SLO, cost, compliance, and incident goals into ongoing watch criteria and escalation policy.
- ▌ Query Contract Tester · rweisssieker-xpValidates SQL against query contracts such as required columns, max rows, and read-only expectations.
- ▌ Recommendation Ranker · rweisssieker-xpRank SQL performance recommendations by expected impact, operational risk, and implementation effort.
- ▌ Semantic Memory Index · rweisssieker-xpBuild a local token-vector memory index for deterministic retrieval without external embeddings.
- ▌ Telemetry Correlation · rweisssieker-xpCorrelate deployment, lock, query-plan, and replication telemetry into incident evidence.
- ▌ Vendor Feature Mapper · rweisssieker-xpMaps competitor capabilities to plugin USPs and differentiators.
- ▌ Autonomous Dba Copilot · rweisssieker-xpOrchestrates a DBA loop from evidence collection through confidence grading, experiment design, ticket prep, and rollback.
- ▌ Change Ticket Exporter · rweisssieker-xpExport approval-ready production change tickets with problem, recommendation, risk, rollback, and checklist.
- ▌ Fleet Health Scorecard · rweisssieker-xpRanks database fleet health by latency, error-budget burn, and replication lag.
- ▌ Knowledge Gap Detector · rweisssieker-xpIdentify missing database evidence before recommending an operational action.
- ▌ AI Migration Risk Radar · rweisssieker-xpScore migration blast radius and produce a rollback rehearsal plan before schema changes reach production.
- ▌ AI Strategy Synthesizer · rweisssieker-xpBuild a database improvement roadmap from objectives, evidence, and operational constraints.
- ▌ Autonomous Ops Briefing · rweisssieker-xpProduces a board-level briefing for closed-loop autonomous database operations.
- ▌ Cognitive Schema Mapper · rweisssieker-xpInfer candidate business concepts from supplied database schema metadata.
- ▌ Evidence Pack Generator · rweisssieker-xpBuild a DBA-ready performance case file with SQL, plan, waits, recommendation, rollback, and evidence grade.
- ▌ LLM Prompt Risk Auditor · rweisssieker-xpInspect database operation requests for ambiguity and unsafe intent using deterministic rules.
- ▌ Performance Pr Reviewer · rweisssieker-xpReviews schema and migration pull requests for performance, locking, index, and rollback risks before merge.
- ▌ SQL Performance Advisor · rweisssieker-xpUse when investigating SQL Server or PostgreSQL performance and guiding a case from scoped diagnosis to measured, business-correct verification.
- ▌ AI Guarded SQL Generator · rweisssieker-xpGenerates bounded read SQL with tenant, policy, audit, and performance guardrails.
- ▌ Migration Twin Simulator · rweisssieker-xpBuilds a SQL Server to PostgreSQL migration twin and rates query-family performance risk.
- ▌ Release Readiness Report · rweisssieker-xpProduce a release readiness report across production blockers, connector status, and health assessment.
- ▌ Workload Impact Analyzer · rweisssieker-xpRank workload queries by latency, call volume, and CPU impact to identify optimization hotspots.
- ▌ Advisor Confidence Grader · rweisssieker-xpGrade advisory recommendations by evidence strength and identify missing proof before production change.
- ▌ AI Data Contract Guardian · rweisssieker-xpCheck schema drift, required columns, PII declaration, retention, and governance controls against a declared data contract.
- ▌ Confidence Budget Manager · rweisssieker-xpScores whether enough evidence exists to recommend, defer, or escalate an autonomous operator decision.
- ▌ Index Portfolio Optimizer · rweisssieker-xpOptimize the whole index portfolio by finding redundant, overlapping, unused, and high-write-cost indexes.
- ▌ Policy Gated Self Healing · rweisssieker-xpCreates safe self-healing runbooks with policy, rollback, and approval gates instead of blind production changes.
- ▌ Rollback Rehearsal Engine · rweisssieker-xpCreates rollback rehearsal steps and proof checklist for database changes.
- ▌ SQL Code Review Assistant · rweisssieker-xpReviews SQL like a senior DBA and returns PR-ready comments and decision.
- ▌ AI Roi Narrative Generator · rweisssieker-xpExplain database tuning ROI from supplied measurements and explicitly labeled estimates.
- ▌ Autonomy Boundary Enforcer · rweisssieker-xpEnforces closed-loop dry-run boundaries and blocks autonomous production apply.
- ▌ Counterfactual Risk Engine · rweisssieker-xpCompares do-nothing, dry-run-change, rollback, and defer scenarios for an operating objective.
- ▌ Decision Evidence Compiler · rweisssieker-xpBuilds an executive-grade decision evidence packet from runtime signals and confidence checks.
- ▌ Production Readiness Check · rweisssieker-xpCheck whether CodexDB Agent is safe to run in production with live database connections, signing, audit replay, drivers, and complete skill metadata.
- ▌ Autonomous Learning Backlog · rweisssieker-xpPrioritize missing evidence and follow-up experiments from database advisor feedback.
- ▌ Semantic Incident Predictor · rweisssieker-xpClassify potential database incident risks from supplied signals using heuristic analysis.
- ▌ Autonomous Verification Loop · rweisssieker-xpCreate prove-before-apply gates for migrations, indexes, rewrites, SLOs, replay, and rollback evidence.
- ▌ Autonomous Experiment Planner · rweisssieker-xpDesigns dry-run experiments across query rewrites, indexes, workload twins, and rollout gates.
- ▌ Cross Agent Consensus Builder · rweisssieker-xpCompare supplied advisor recommendations and report agreement and unresolved disagreements.
- ▌ Production Rollout Orchestrator · rweisssieker-xpCombine production readiness, verification gates, and migration risk into a Go/No-Go rollout decision.
- ▌ Aos Load Analysis · rweisssieker-xpAnalyze AOS counters, user sessions, batch/service distribution, AOS topology, and load-separation recommendations.
- ▌ Blocking Analysis · rweisssieker-xpAnalyze SQL blocking, deadlocks, lock waits, root blockers, affected AX tables, and recommended low-risk remediation.
- ▌ Index Risk Review · rweisssieker-xpReview SQL Server missing-index and plan-warning evidence through AX-specific risk, write overhead, existing index overlap, and rollback guidance.
- ▌ Itil Change Draft · rweisssieker-xpGenerate ITIL/CAB change drafts from AX performance findings with risk, test plan, rollback, validation, and approval workflow.
- ▌
- ▌ AI Runbook Copilot · rweisssieker-xpProduce step-by-step operator runbook guidance for top AXPA findings.
- ▌ Daily Health Check · rweisssieker-xpRun a daily AX 2012 and SQL Server health check with prioritized risks, module health scores, root causes, and management summary.
- ▌ Tempdb Io Analysis · rweisssieker-xpAnalyze TempDB pressure, file latency, PAGEIOLATCH/WRITELOG waits, spills, and storage-related AX performance risk.
- ▌ AI Incident Summary · rweisssieker-xpGenerate incident summaries with cause, impact, evidence, and next steps.
- ▌ Evidence Pack Audit · rweisssieker-xpCreate audit-ready evidence packs with masking, chain of custody, evidence quality grades, and validation artifacts.
- ▌ Admin Execution Mode · rweisssieker-xpGenerate guarded admin execution previews with policy gates, confirmation tokens, audit records, and rollback/validation metadata.
- ▌ AI Finding Explainer · rweisssieker-xpExplain AXPA findings for technical teams, AX key users, and management.
- ▌ Custom Code Risk Map · rweisssieker-xpMap custom AX code, X++ classes, reports, services, query families, and findings to owners and risk.
- ▌ Known Issue Matching · rweisssieker-xpMatch AXPA findings against the local known issue pattern library and return fix paths and validation criteria.
- ▌ Advanced Usp Analysis · rweisssieker-xpGenerate advanced operational USP outputs including SLO burn rate, maintenance sequencing, cost of delay, release gates, retention candidates, known issue matching, and executive briefings.
- ▌ Causal Graph Analysis · rweisssieker-xpAnalyze AX performance as a cause-effect graph linking root causes, waits, findings, tables, and business impact.
- ▌ Local RAG Evidence QA · rweisssieker-xpBuild local evidence Q&A artifacts with source finding IDs and no external LLM dependency.
- ▌ Powerbi Report Export · rweisssieker-xpExport AXPA findings and metrics for Power BI CSV datasets or streaming endpoint push when credentials are configured.
- ▌ Web Portal Operations · rweisssieker-xpConfigure, validate, or run the local AXPA RBAC web portal with token-based dashboard access and audit logging.
- ▌ AI Anomaly Forecasting · rweisssieker-xpForecast likely SLA, capacity, or workload anomalies from AXPA trend evidence.
- ▌
- ▌ AI Learning Extensions · rweisssieker-xpGenerate AI learning and decision-quality artifacts such as recommendation memory, similarity search, acceptance simulation, narrative variants, anomaly explanations, and action confidence tuning.
- ▌ AI Regression Detector · rweisssieker-xpIdentify performance regressions after deployments, configuration, index, or schedule changes.
- ▌
- ▌ Autonomous Ops Copilot · rweisssieker-xpBuild or run Autonomous Ops workflows for AX Performance Advisor, including investigation queues, evidence acquisition plans, follow-up questions, change drafts, validation planning, and readiness gates.
- ▌ Batch Job Optimization · rweisssieker-xpAnalyze Dynamics AX 2012 batch jobs, SysOperation workloads, collisions, runtime trends, and SQL side effects to recommend safer scheduling and tuning actions.
- ▌ Data Lifecycle Advisor · rweisssieker-xpAnalyze AX table growth, archive candidates, retention policy, archiving impact, and lifecycle ROI.
- ▌ Knowledge Graph Export · rweisssieker-xpExport or inspect the AXPA knowledge graph of findings, playbooks, modules, and tables.
- ▌ Rbac Portal Generation · rweisssieker-xpGenerate role-labeled static dashboard entry points for viewer, DBA, AX admin, QA/GxP, CIO, and admin users.
- ▌ Slo Burn Rate Analysis · rweisssieker-xpAnalyze SLO burn-rate signals for AXPA playbooks and high-risk finding budgets.
- ▌
- ▌
- ▌ Ax Performance Analysis · rweisssieker-xpAnalyze Dynamics AX 2012 R3 performance by correlating SQL Server, AOS, batch, Trace Parser, and DynamicsPerf evidence into prioritized explainable findings.
- ▌ LLM Connector Readiness · rweisssieker-xpPrepare and validate LLM connector payloads for AXPA evidence-grounded Q&A without exposing secrets or making unapproved external calls.
- ▌ Release Gate Governance · rweisssieker-xpEvaluate AXPA release gate pass/block decisions from current high and critical findings.
- ▌ Release Package Builder · rweisssieker-xpBuild a plugin release ZIP with SHA-256 manifest while excluding evidence, output, and cache files.
- ▌ Sla Anomaly Forecasting · rweisssieker-xpAnalyze SLOs, SLA breach prediction, anomalies, capacity exhaustion, and performance budgets for AX workloads.
- ▌ SQL Server Query Tuning · rweisssieker-xpInterpret SQL Server 2016 performance evidence for Dynamics AX 2012 workloads, including expensive queries, waits, indexes, statistics, plan cache, Query Store, and parameter sniffing.
- ▌ Xpp Attribution Mapping · rweisssieker-xpMap AXPA findings to Trace Parser or DynamicsPerf X++ class/method evidence when normalized trace exports are available.
- ▌ AI Change Risk Predictor · rweisssieker-xpClassify risk for proposed AX/SQL remediation actions before implementation.
- ▌ AI D365 Migration Signal · rweisssieker-xpIdentify AX 2012 performance findings that suggest modernization or D365 migration planning.
- ▌ AI Evidence Gap Detector · rweisssieker-xpDetect missing evidence required for confident AX/SQL diagnosis.
- ▌ Azure Devops Jira Export · rweisssieker-xpExport or push AXPA findings as Azure DevOps or Jira tickets with dry-run support and credential checks.
- ▌ Enterprise Observability · rweisssieker-xpGenerate AXPA enterprise observability outputs such as time-series store, alerts, estate inventory, plan repository, notification payloads, and competitive coverage.
- ▌ Operator Copilot Runbook · rweisssieker-xpGenerate operator runbooks, copilot context, next checks, incident replay, and root-cause narratives.
- ▌ Performance Digital Twin · rweisssieker-xpBuild and use an AX performance digital twin containing topology, query families, hot tables, batch workload, AOS nodes, and business calendar.
- ▌ Process Owner Scorecards · rweisssieker-xpGenerate process-owner scorecards from AXPA findings, business owners, high-risk counts, and module context.
- ▌ AI Safe Action Classifier · rweisssieker-xpClassify AXPA recommendations as observe, maintenance-window, TEST-only, CAB-required, or review-required.
- ▌ Knowledge Base Governance · rweisssieker-xpMaintain known issues, self-healing rules, feedback loops, and anonymized AX performance pattern libraries.
- ▌ Optional Agent Operations · rweisssieker-xpConfigure, dry-run, or operate the optional AXPA local agent and scheduled task wrapper.
- ▌ Sensitive Data Governance · rweisssieker-xpDetect sensitive evidence boundaries, apply masking policies, and prepare share-safe AX performance evidence.