datapilot

What This Skill Does

The datapilot skill is a powerful, comprehensive interface for the DataPilot OpenAPI, specifically designed to empower OpenClaw agents with advanced data analysis capabilities. By integrating this skill, your agent can bridge the gap between raw data sources and actionable insights using natural language processing. It enables seamless connectivity to various databases (MySQL, PostgreSQL, SQLite, ODPS, OBOracle) and orchestrates the entire lifecycle of data analysis—from initial data source ingestion and Knowledge Base management to complex SQL query generation, chart rendering, and automated report exports.

Installation

To install this skill, use the following command in your OpenClaw environment: clawhub install openclaw/skills/skills/hsunboy/oceanbase-datapilot Once installed, ensure you have configured your environment variables DATAPILOT_API_URL and DATAPILOT_API_KEY to authenticate and communicate with the backend services.

Use Cases

This skill is ideal for business intelligence teams, data analysts, and non-technical stakeholders who need to extract value from data without writing complex code. Use cases include:

• Automated Reporting: Automatically generating and exporting daily sales, marketing, or operational reports.
• Ad-hoc Data Discovery: Allowing non-technical users to ask complex questions like "What were the top 3 product categories by conversion rate last week?" and receiving immediate visual results.
• Knowledge Management: Storing SQL snippets, business logic, and analysis templates within the Agent's knowledge base to ensure consistent reporting across the organization.
• Database Orchestration: Managing multiple data analysis agents for different business units or domains simultaneously through the centralized CLI commands.

Example Prompts

1. "Initialize a new data analysis agent for our inventory management system using the provided JSON config file and call it inventory_monitor."
2. "Show me the top 5 regions by total revenue for the current month in a bar chart format."
3. "List all active agents and retrieve the 'quarterly_financial_summary' knowledge item from the sales_copilot agent."

Tips & Limitations

• Security: Since this skill interacts with production databases, ensure your DATAPILOT_API_KEY has appropriate read-only permissions where necessary.
• Data Privacy: Be mindful of sensitive information; always sanitize your datasource configuration before committing to repository files.
• Knowledge Base: Regularly update your knowledge base with 'business_knowledge' entries to improve the agent's accuracy in interpreting industry-specific terminology.
• Limits: The skill relies on SSE streaming; ensure your network environment supports persistent HTTP connections for long-running data queries.