dataflow

Generate CRUD, query, and bulk operation nodes from DataFlow models.

Updated Oct 10, 2025
One-click install
npx skills add https://github.com/FFOO6866/lead2cash --skill dataflow-ffoo6866
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: dataflow
Source: https://github.com/FFOO6866/lead2cash/tree/main/.claude/skills/02-dataflow
Command: npx skills add https://github.com/FFOO6866/lead2cash --skill dataflow-ffoo6866

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

DataFlow automates database CRUD and query workflows by generating workflow nodes directly from database models, so you stop writing repetitive SQL/ORM glue and start executing consistent, parameterized operations across SQL, MongoDB, and vector search.

Core Features & Use Cases

  • Zero-config model-to-workflow node generation: Automatically creates 11 workflow nodes per SQL model (and a smaller set for MongoDB/vector use cases), covering create/read/update/delete/list/upsert/count plus bulk variants.
  • Multi-database + multi-tenant patterns: Supports PostgreSQL, MySQL, SQLite, MongoDB, and pgvector-style vector operations, with enterprise-grade tenant isolation and per-instance isolation.
  • Operational safety & DX guardrails: Provides structured validation rules (including strict parameter handling), safe string-ID preservation, and improved debugging via DF-XXX error codes and inspector patterns.
  • Use cases: Build CRUD APIs (optionally via Express-style direct invocation), implement migrations and bulk ingestion, run transactional multi-step workflows (when you explicitly opt into TransactionScopeNode), and integrate with Nexus and Fabric Engine for external data products.

Quick Start

Ask for: set up a DataFlow instance for SQLite, define a User model with @db.model, and run an express create and read flow using await db.express.create and await db.express.read.

Frequently Asked Questions about dataflow

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I generate database CRUD operations without writing repetitive ORM glue?

Database CRUD operations are generated automatically as workflow nodes from decorated models. This eliminates manual SQL or ORM glue by creating consistent, parameterized create, read, update, delete, list, upsert, and count nodes from your schema definitions.

Can I execute transactional multi-step database workflows across different databases?

Transactional multi-step workflows support PostgreSQL, MySQL, SQLite, MongoDB, and pgvector. You enforce ACID guarantees by explicitly wrapping nodes in a TransactionScopeNode, ensuring safe multi-step database operations across different databases.

Does DataFlow support multi-tenancy and bulk database operations?

Multi-tenancy and bulk operations are supported with enterprise-grade tenant isolation and high-throughput bulk processing. The system handles multi-tenant database isolation and bulk data ingestion directly through generated workflow nodes.

How do I expose database operations as direct API endpoints?

Database operations can be exposed via Express-style direct invocation. By generating deterministic workflow nodes from your models, you can call create, read, or list operations directly using await db.express patterns in your backend code.

What are the limitations of using generated database workflow nodes?

Generated database workflow nodes require a root configuration with model decorators and explicit transaction boundaries for ACID safety. Operations rely on deterministic node patterns, so custom query logic outside standard CRUD, upsert, and bulk patterns requires manual implementation.