croft

Croft is an innovative open-source data pipeline tool designed for developers who prefer working with TypeScript and SQL. It enables users to effortlessly pull data from APIs and files, transform it using familiar SQL queries or TypeScript code, and keep datasets up-to-date on a scheduled basis. All data resides within a single DuckDB file, streamlining data management and access. A standout feature is the automatic generation of types for each table, enhancing type safety and developer experience. Additionally, Claude Code integration allows for seamless automation and control. By eliminating dependencies on Python and offering an easy-to-use, unified environment, Croft appeals to modern data engineers and developers seeking simplicity, flexibility, and performance in their data workflows.