What problem does it solve?
Investigating learner progress issues or debugging data in a production PostgreSQL database requires secure, auditable access without hard-coded credentials or risky ad-hoc changes. This Skill provides a safe, repeatable workflow for running authenticated read-only queries against the production database.
Core Features & Use Cases
- Entra ID Authentication: Connects to PostgreSQL using an Azure OSS RDBMS access token and the signed-in Entra principal, avoiding stored passwords.
- Schema-Aware Queries: Targets known tables like verification_attempts and learner_step_completions keyed by user_id and requirement or step UUIDs.
- Safe Write Guardrails: Requires showing affected rows, explaining rollback behavior, and obtaining explicit confirmation before any write transaction or firewall rule change.
- Use Case: A learner reports their verification status is stuck. Use this Skill to look up their verification_attempts rows by user_id and diagnose the current state without modifying data.
Quick Start
Ask the assistant to query the production database for a specific user's verification attempts using their user ID.
