A powerful tool for transforming raw SQL query results into professionally formatted Feishu cloud documents automatically.
Install & Download
1. ClawHub CLI
The fastest way to install a skill directly from the registry.
npx clawhub@latest install sql-to-doc
2. Manual Installation
Copy the skill folder to one of these locations
~/.openclaw/skills/ <project>/skills/ Priority: Workspace > Local > Bundled
3. Prompt Installation
Copy this prompt to OpenClaw to install it automatically.
Help me install sql-to-doc using Clawhub. If Clawhub is not installed, install it first (npm i -g clawhub).
Prefer to download?
Get the raw skill files in a ZIP archive.
What is SQL to Feishu Document Automation?
This skill bridges the gap between enterprise data warehouses and collaborative workspaces. By utilizing Openclaw Skills, users can automate the entire pipeline of data extraction, processing via Jinja2 templates, and publishing to Feishu wikis or folders. It is specifically designed to eliminate the manual effort involved in copying data from SQL clients to business reports.
Built to work with MaxCompute and DataWorks, this skill provides a developer-friendly way to handle repetitive data reporting tasks. It ensures that data remains consistent and up-to-date by providing a direct link between your database and your documentation platform through Openclaw Skills integration.
SQL to Feishu Document Automation Use Cases
- Automating the generation of weekly business data reports for stakeholders.
- Consolidating business metrics into a central knowledge base.
- Creating one-off data snapshots from SQL queries into readable, shareable documents.
- Exporting complex data tables into human-readable formatted documents using custom templates.
How SQL to Feishu Document Automation Works
- The skill connects to MaxCompute or DataWorks to execute a specified SQL query.
- The raw query results are converted into structured Python objects like lists and dictionaries.
- A Jinja2 template is used to render the structured data into a formatted Markdown layout.
- The skill calls the Feishu API to create a new document in the target wiki or folder.
- Upon completion, the system returns the document URL and can optionally notify a specific user via Feishu IM.
SQL to Feishu Document Automation Setup
To use this skill within Openclaw Skills, you must configure the required environment variables and ensure access to the relevant APIs.
# Set required environment variables
export META_CENTER_TOKEN="your_meta_center_token"
export DATAWORKS_PROJECT="your_dataworks_project_name"
Ensure that the agent has permissions to access both the DataWorks OpenAPI and the Feishu document creation scopes.
SQL to Feishu Document Automation Data Schema & Taxonomy
The skill manages data flow through several key parameters to ensure high-quality output within Openclaw Skills:
| Parameter | Description | Example |
|---|---|---|
| sql_query | The SQL statement to be executed | SELECT * FROM sales_table WHERE date = 'today' |
| template | Jinja2 format for data rendering | See template syntax below |
| doc_title | The final title of the Feishu document | Weekly Transaction Report |
| target_location | Destination in Feishu | wiki:space_id:node_token |
| notify_user | Feishu open_id for notification | ou_xxxxxx |
Template Example
## {{ title }}
| Metric | Value |
|---|---|
{% for row in data %}
| {{ row.metric_name }} | {{ row.metric_value }} |
{% endfor %}
SQL to Feishu Document Automation Advanced Features
- Advanced Jinja2 rendering support for complex data visualization and loops.
- Deep integration with Feishu Knowledge Base (Wiki) for structured documentation.
- Multi-stage automation involving MaxCompute SQL execution and Feishu IM notifications.
- Support for custom folder destination tokens to organize reports dynamically.
- Part of the robust Openclaw Skills ecosystem for seamless AI-driven data workflows.
SKILL.md
Loading
Related Openclaw Skills
AI E-commerce Image Creation Team
An autonomous multi-agent team designed to handle the end-to-end workflow of planning, generating, and quality-checking professional e-commerce product imagery.
Houwei Hello World
A foundational test skill designed to verify cross-device synchronization and provide a development template for custom AI agent extensions.
QWeather Integration
A powerful weather integration for AI agents providing real-time data and long-term forecasts via the QWeather API.
Task Tracker
A persistent context management system that uses structured markdown files to maintain task state and project memory across AI agent sessions.
Cross-Border Intel
An automated market intelligence workstation for cross-border sellers to track Amazon competitors and TikTok viral trends.
AI-Free Video Editor
A deterministic video editing skill for Openclaw Skills that enables manual trimming, merging, and exporting of video files without generative AI processing.
Featured*
