← 返回 Skill 列表
extension
分类: 开发与工程API Key 暂未确认

keboola-cli

使用此技能来管理和审查Keboola项目。当同步项目配置(初始化、拉取、推送、差异)、运行项目审查、分析SQL转换、审计安全性、评估性能、验证财务逻辑或评估模板就绪性时激活。涵盖完整的Keboola CLI工作流程和10个代理审查团队。

person作者: jakexiaohubgithub

Keboola CLI Plugin

Manage and review Keboola projects using the CLI and a 10-agent review team.

Commands

| Command | Description | |---------|-------------| | /kbc-init | Initialize a new Keboola project locally | | /kbc-pull | Pull configurations from remote project | | /kbc-push | Push local changes to remote project | | /kbc-diff | Show differences between local and remote | | /kbc-review | Launch the full 10-agent project review team |

Review Team

/kbc-review spawns 10 agents in parallel to audit every dimension of a Keboola project:

  1. SQL Reviewer -- Anti-patterns, correctness, Snowflake-specific issues
  2. Config Reviewer -- Naming, descriptions, mappings, best practices
  3. DWH Architect -- Data model, layering, dimensional modeling, naming
  4. Data Quality Analyst -- NULLs, duplicates, freshness, referential integrity (live MCP queries)
  5. Financial Analyst -- P&L, Balance Sheet, KPIs, COA mapping, multi-ERP awareness
  6. Semantic Layer Reviewer -- Metric definitions, completeness, auto-generation readiness
  7. Security Auditor -- Credentials, PII, access control, GDPR/CCPA compliance
  8. Performance Optimizer -- Job durations, SQL efficiency, incremental loading, parallelization
  9. Template Readiness Assessor -- Parameterization, mapping tables, generation blockers
  10. Consolidator -- Data flow mapping + merged report from all 9 reviewers

Output: Individual reports in docs/review_*.md plus a consolidated docs/PROJECT_REVIEW_REPORT.md.

Prerequisites

  • Keboola CLI installed for sync commands
  • Keboola MCP server configured for live data analysis (data quality, performance agents)
  • Storage API token (Master token) for project access

ERP Systems Supported

Financial review agents understand data structures from:

  • NetSuite (GL, journal entries, subsidiaries)
  • SAP S/4HANA / BW (BKPF/BSEG, cost centers, profit centers)
  • Oracle Fusion / EBS (GL segments, ledgers, subledger accounting)
  • Microsoft Dynamics 365 (financial dimensions, main accounts)
  • QuickBooks / Xero (simplified COA, class tracking)

Financial Metrics Covered

  • Core P&L + Balance Sheet (Revenue, COGS, EBITDA, Net Income, Working Capital)
  • SaaS metrics (MRR, ARR, Churn, LTV, CAC, NRR, Rule of 40)
  • Cash flow (Operating CF, Free CF, DSO, DPO, DIO, Cash Conversion Cycle)
  • Budget variance (Actual vs Budget, Forecast accuracy, YoY/MoM growth)