bic-awr

What This Skill Does

The bic-awr skill is a specialized agent capability designed to streamline database performance diagnostics. It allows users to submit Oracle AWR (Automatic Workload Repository) or compatible reports directly to the BIC-QA analysis engine. The tool handles the authentication and data submission process, ensuring that reports are uploaded securely to the official API endpoints. Once submitted, the backend processes these complex performance files asynchronously and delivers a structured, actionable analysis report directly to the user's registered email address.

Installation

To install this skill, use the OpenClaw command-line interface as follows: clawhub install openclaw/skills/skills/bbsyd2/bic-awr After installation, ensure you have your BIC-QA API key configured. You can set it via an environment variable BIC_API_KEY or create a config file at ~/.bic/config/api_key. The skill is designed to prioritize environmental variables for maximum flexibility in CI/CD or containerized environments.

Use Cases

• Proactive Performance Tuning: Database administrators can submit AWR reports after experiencing sudden latency to identify bottleneck wait events.
• Regular Health Audits: Automate the submission of weekly health reports for Oracle databases to maintain system stability.
• Post-Incident Analysis: Use the tool after a production outage to gain insights into database resource consumption, such as CPU, I/O, and memory contention.
• Multi-tenant Monitoring: Analyze performance across different databases by specifying the appropriate dbtype for each submission.

Example Prompts

1. "Analyze this AWR report file and tell me what the main resource bottlenecks were for the last 24 hours."
2. "I've uploaded the Oracle AWR log. Please submit it to BIC-QA for analysis; use Chinese as the output language."
3. "Can you check my database performance using this report? My API key is already configured in my environment."

Tips & Limitations

• Asynchronous Nature: Please note that analysis is not instantaneous. The skill will confirm a successful submission, but the detailed report is delivered via email. Ensure you check your spam folder if the results do not arrive within a reasonable timeframe.
• Security: Your API key is handled securely and only transmitted to api.bic-qa.com. Never share your API key in plain text or push it to public repositories.
• Supported Formats: Ensure your reports are in valid formats supported by the BIC-QA backend. If the system fails to recognize your file, verify that the dbtype parameter is set correctly (e.g., 'oracle').
• Environment: If running in a local environment, ensure the agent has read permissions to the directory where the report files are stored.