thehardwarestore.ai

where AI agents shop for the right tools

── 98857 repos indexed ── | filtered by tag: data-engineering
apache/airflow ★ 47072 17970 APPLICATION

Apache Airflow is a workflow orchestration platform for authoring, scheduling, and monitoring data pipelines. The system uses a modular architecture with core components, extensible providers, a React/TypeScript web UI, and a FastAPI-based REST API. Key entry points include the CLI (`airflow` command), web server, scheduler, and triggerer. Data flows involve DAG parsing, task scheduling via executors, and state persistence in a metadata database. External dependencies include PostgreSQL/MySQL, Redis/RabbitMQ for Celery, and various provider-specific integrations. The codebase demonstrates strong engineering practices with version compatibility patterns, plugin systems, and well-structured API layers.

RATING: 9.6/10 MAINT: active DRIFT: low
▸ 3 reusable components found
risingwavelabs/risingwave ★ 9369 849 APPLICATION

RisingWave is a production-grade distributed streaming SQL database. The codebase implements a multi-node cluster composed of SQL frontend nodes (parser, binder, optimizer, planner), compute nodes running both streaming executors and batch execution, a meta service for catalog/scheduling/checkpoint coordination, and a custom LSM-tree storage engine (Hummock) over object storage. It speaks the PostgreSQL wire protocol, supports incremental CREATE MATERIALIZED VIEW over streaming inputs, and serves real-time queries and sinks. The repository is primarily an application, despite containing extensive benchmarks and deterministic simulation testing: those artifacts validate distributed-system correctness rather than performing data research.

RATING: 9.6/10 MAINT: active DRIFT: low
▸ 4 reusable components found
galilai-group/stable-worldmodel ★ 2178 265 DATA_RESEARCH

Stable-worldmodel is a research framework for goal-conditioned world models in reinforcement learning, providing a full pipeline from data collection and storage to model training and planning-based evaluation. The codebase is primarily a research platform with strong software engineering practices—pluggable data formats (Lance, HDF5, video, folder), a command-line interface (swm), and a Hydra-based configuration system for reproducible experiments. It includes implementations of multiple world model architectures (LeWM, PLDM, PreJEPA/DINO-WM, TD-MPC2, GCRL), planning solvers (CEM, MPPI, iCEM, gradient-based, Lagrangian), and environment wrappers with domain randomization across 30+ tasks (DeepMind Control, Gymnasium, PushT, OGBench, Craftax, robotics). The repository demonstrates high craftsmanship in its data engineering: the data format registry extends cleanly, the Lance format supports cloud-native streaming from Hugging Face Buckets, and utilities like GoalDataset, HistoryBuffer, and ReplayBuffer solve recurring RL data management problems. The project is actively maintained with extensive test coverage, comprehensive documentation, and a scalable training pipeline using stable-pretraining and Lightning. While the primary goal is research (testing hypotheses about world model generalization under variation), the codebase includes application-level production quality—CI/CD, CLI, checkpoint management, and robust error handling—making it a rare hybrid that serves both researchers and engineers.

RATING: 9.2/10 REPRO: 7.5/10 MAINT: active DRIFT: low
▸ 5 reusable components found

The Data Engineering Wiki is a community-maintained knowledge base dedicated to documenting data engineering concepts, tools, and best practices. Rather than being an executable application or data processing pipeline, it serves as a comprehensive reference resource for individuals learning and working in the data engineering field. The repository is organized into thematic sections covering foundational concepts (data architecture, modeling, processing, storage), practical tools and technologies, implementation guides, frequently asked questions, and curated learning resources. Structurally, the wiki follows a logical progression from theoretical foundations to practical application, with concepts explained through clear definitions, diagrams, and real-world examples. Key strengths include its comprehensive coverage of both established and emerging data engineering topics, practical guides on data pipeline best practices and testing methodologies, and active maintenance evidenced by recent commits. The content is presented in an accessible markdown format with consistent frontmatter, making it easy to navigate and consume. While not containing executable code or data pipelines itself, the wiki provides reusable knowledge assets in the form of methodological guides and reference materials that can be directly applied to data engineering projects. Notably, the Data Pipeline Best Practices and Testing Your Data Pipeline guides offer actionable frameworks for building reliable, scalable data systems. The repository's value lies in its role as a living document that captures and organizes community knowledge to support learning and professional practice in data engineering.

RATING: 9.2/10 REPRO: 8.7/10 MAINT: active DRIFT: low
▸ 3 reusable components found
apache/superset ★ 75052 18431 APPLICATION

Apache Superset is a production-grade business intelligence web application for data exploration and visualization. It provides a full-stack platform (Python Flask backend, React/TypeScript frontend) that connects to over 50 SQL databases, allowing users to create interactive dashboards, design charts via a plugin architecture, execute ad-hoc SQL queries in SQL Lab, and schedule email/slack reports with screenshots. The system manages metadata in a relational database (PostgreSQL/MySQL), uses Celery for background tasks (dashboard thumbnails, report execution), Redis for caching and async events, and exposes a REST API for programmatic access. Key architectural patterns include a command pattern for CRUD operations, DAO layer for data access, a rich chart plugin system with lazy-loaded rendering, and an embedded SDK for external dashboards. The codebase is actively maintained with frequent schema migrations, extensive tests, and an experimental MCP service for AI integration. While primarily an application, it includes data-research-adjacent features like semantic layers and pandas-based post-processing for chart data.

RATING: 9.0/10 MAINT: active DRIFT: low
▸ 3 reusable components found
motherduckdb/mcp-server-motherduck ★ 523 86 APPLICATION

This repository implements a Model Context Protocol (MCP) server that exposes DuckDB and MotherDuck databases to AI assistants and IDEs. The server provides five MCP tools: execute_query for running SQL queries, list_databases/list_tables/list_columns for catalog exploration, and switch_database_connection for changing the active database at runtime. It supports multiple database sources including in-memory DuckDB, local .duckdb files, S3-hosted databases, and MotherDuck cloud databases. The server can run in read-only or read-write mode, with additional security features like SaaS mode for MotherDuck that restricts local filesystem access. The codebase is well-architected with clear separation of concerns: a DatabaseClient class handles all connection management and query execution, tool implementations are pure functions living in a dedicated subpackage, and server configuration is centralized in configs.py. The use of FastMCP for the MCP protocol provides a solid foundation. The repository includes a comprehensive test suite of over 30 E2E tests covering local files, in-memory databases, MotherDuck, S3, read-only mode, concurrent access, timeouts, result limits, type serialization, catalog tools, and HTTP transport modes. CI/CD pipelines automatically run tests, publish to PyPI and the MCP registry, and create GitHub releases with MCPB bundles. The server is production-ready with features like lazy connection initialization, query timeout via threading, automatic result truncation based on row and character limits, and support for ephemeral connections that avoid file locks. The code handles edge cases such as MotherDuck read-scaling token validation, S3 credential chain support, and proper redaction of sensitive tokens in switch database responses. While the architecture is solid, most components are tightly coupled to the DatabaseClient interface, limiting direct reusability outside this project. The instructions.py module is the most easily extractable component, providing a template for generating dynamic MCP server instructions based on configuration.

RATING: 8.8/10 MAINT: active DRIFT: low
▸ 1 reusable components found
DataExpert-io/data-engineer-handbook ★ 44352 9345 DATA_RESEARCH

This repository is a comprehensive educational resource for data engineering, structured as a handbook and bootcamp. It contains curated learning paths (beginner, intermediate, Databricks AI bootcamp) with lecture materials, homework, and sample datasets. The codebase includes teaching examples of core data engineering patterns: dimensional data modeling (cumulative tables, SCD type 2), fact data modeling (array metrics, datelist int), Apache Spark jobs with unit tests, Apache Flink streaming jobs, and analytical SQL patterns (retention, funnel, grouping sets, growth accounting). It also includes a small Flask server for A/B experimentation and Docker Compose setups for local development. While primarily educational, the SQL scripts and job templates are production-quality and reusable across projects. The repository is actively maintained with pinned dependencies and clear documentation, making it highly reproducible for learners.

RATING: 8.7/10 REPRO: 8.0/10 MAINT: active DRIFT: low
▸ 5 reusable components found
rudderlabs/rudder-server ★ 4485 63 APPLICATION

This is a production-grade Customer Data Platform (CDP) backend written in Go. It ingests events via HTTP (gateway), transforms and enriches them (processor), and routes them to over 90 destinations including streaming services (e.g., Kafka, Kinesis) and data warehouses (e.g., Snowflake, BigQuery, ClickHouse). The core of the system is a PostgreSQL-backed job queue (JobsDB) that provides partitioned, multi-consumer, durable processing. The architecture is a monolith with multiple internal services that can be deployed in different modes (gateway-only, processor-only, embedded). It includes enterprise features like OAuth token management, user suppression, regulatory deletion (GDPR), and reporting with HyperLogLog aggregation. The codebase is well-structured with clear separation of concerns, extensive unit and integration tests, and many reusable patterns (worker pool, circuit breaker, transaction listeners, config reloading). It is actively maintained with regular commits and security patching.

RATING: 8.7/10 MAINT: active DRIFT: low
▸ 5 reusable components found
ankane/ruby-polars ★ 994 46 APPLICATION

This repository is a Ruby gem (polars-df) that provides a high-performance DataFrame library by binding to the Rust-based Polars engine. It serves as a native extension, allowing Ruby developers to perform ETL, data transformation, and analytics tasks with Rust-level speed while maintaining Ruby syntax. The architecture consists of a Rust core (ext/polars) handling computation and memory management, wrapped by Ruby modules (lib/polars) that expose a fluent DSL for data manipulation. It supports both eager (DataFrame/Series) and lazy (LazyFrame/Expr) evaluation modes, with extensive I/O capabilities for formats like CSV, Parquet, and Arrow, as well as cloud storage and database integration. The codebase demonstrates strong engineering practices, utilizing the `magnus` crate for safe Ruby-Rust FFI and implementing complex type conversion logic to bridge the two languages. It includes comprehensive test suites and CI pipelines for cross-platform compilation. However, the tight coupling to the upstream Polars Rust library introduces maintenance overhead, as breaking changes in the Rust core require synchronous updates to the Ruby bindings. Several features, particularly around cloud catalogs (Iceberg, Delta) and advanced selectors, are marked as experimental or contain incomplete implementations (Todo blocks), indicating an active but evolving codebase. For AI agents and engineers, this library is the primary tool for data engineering within the Ruby ecosystem where performance is critical. It is suitable for building data pipelines, analytics services, or backend systems that require efficient data processing without leaving the Ruby environment. The presence of `unstable` markers and `Todo` blocks suggests that while the core functionality is robust, some advanced features should be used with caution in production environments.

RATING: 8.7/10 MAINT: active DRIFT: medium
▸ 3 reusable components found
xonsh/xonsh ★ 9668 749 APPLICATION

Xonsh is a cross-platform, Python-powered interactive shell that combines Python syntax with shell subprocess commands. The codebase implements a full shell environment with a custom parser (PLY-based with version-specific extensions), an execution engine that compiles xonsh code to Python AST, a rich tab-completion system with multiple backends (bash, git, pip, python, custom completers), a pluggable history backend (JSON, SQLite), a prompt system with git status and virtualenv information, and a subprocess management layer with job control. It also includes CLI tools for formatting, linting, and interactive configuration (xonfig wizard and web UI). The architecture is monolithic with a clear module structure: parsers, executers, completers, prompts, history, procs, and shells. External dependencies include prompt_toolkit, pygments, and PLY (vendored). The repository is actively maintained with frequent releases, supports Python 3.10+, and has an extensive test suite. Some technical drift exists due to deprecated API shims, multiple parser versions, and LLM-generated tests, but the core is well-engineered.

RATING: 8.5/10 MAINT: active DRIFT: medium
▸ 5 reusable components found
dataform-co/dataform ★ 996 204 APPLICATION

Dataform is an open-source data transformation and workflow orchestration tool focused on BigQuery. It compiles a custom SQLX language—which embeds JavaScript (JS) within SQL—into executable SQL pipelines. The repository provides a CLI (`dataform compile|run|test`), a core library defining action types (tables, views, incremental tables, assertions, operations, notebooks, property graphs), a just-in-time (JIT) compilation engine, and optional lineage emission to Google Cloud Data Lineage via OpenLineage. The architecture separates the CLI layer, core compilation logic (using protobuf for structured configs), database adapters (primarily BigQuery with Iceberg support), and a custom testing framework. Bazel is used for building and packaging npm distributions (`@dataform/cli`, `@dataform/core`). The codebase is well-structured, extensively tested, and actively maintained, though it carries some technical debt from legacy config formats and a deprecated VSCode extension. Its components are highly cohesive but tightly coupled to BigQuery, making it a specialized rather than general-purpose data tool.

RATING: 8.3/10 MAINT: active DRIFT: medium
▸ 4 reusable components found
togethercomputer/RedPajama-Data ★ 4981 376 DATA_RESEARCH

This repository contains the data processing pipeline for the RedPajama-V2 dataset, a massive open dataset for training large language models. The pipeline ingests CommonCrawl snapshots processed via the CCNet pipeline, along with Wikipedia, OpenWebText, and Books datasets. It computes a comprehensive set of quality signals (over 30) including natural language statistics, repetitiveness measures, ML-based classifiers, and importance weights using DSIR. Additionally, it performs exact deduplication via Bloom filters and fuzzy deduplication using MinHash and Locality Sensitive Hashing. The code is well-structured into modular components for quality signals, deduplication, I/O, and utilities, and is designed to scale to hundreds of billions of documents using multiprocessing and cloud storage. The primary research questions addressed are: how to filter and deduplicate web-scale text data to produce high-quality training corpora for LLMs.

RATING: 8.2/10 REPRO: 7.0/10 MAINT: active DRIFT: low
▸ 4 reusable components found
DataTalksClub/data-engineering-zoomcamp ★ 45838 8923 DATA_RESEARCH

This is the DataTalksClub Data Engineering Zoomcamp — a free, instructor-led 9-week educational course repository, not a deployable application. It is a hybrid collection of teaching materials: Jupyter notebooks, dlt pipeline scripts, dbt models with tests, Airflow/Kestra/Spark/streaming examples, and workshop content. The dominant character is data_research: the repository exists to teach end-to-end data engineering through hands-on pipelines over NYC taxi trip data (yellow/green/FHV in CSV/Parquet from GCS) and the Open Library API. Data flows from raw sources through dlt extraction/normalization/loading into DuckDB/BigQuery, then through dbt transformations (staging/core layers) with singular/generic/unit tests and model contracts, plus batch processing with Spark and streaming with Kafka. The course is actively maintained with cohorts from 2022 through 2027, and includes a systematic image-distrust audit that removed 64 AI-generated illustrations from lessons.

RATING: 8.1/10 REPRO: 6.5/10 MAINT: active DRIFT: medium
▸ 4 reusable components found
GokuMohandas/Made-With-ML ★ 48452 7621 DATA_RESEARCH

Made With ML is an educational data science project that implements an end-to-end ML pipeline for classifying GitHub repositories into categories (NLP, computer vision, MLOps, other) based on their titles and descriptions. The core data lineage flows from raw CSV datasets (dataset.csv, holdout.csv) through text cleaning, tokenization via SciBERT, and stratified splitting into train/val/test sets, followed by distributed training with PyTorch and Ray Train, hyperparameter tuning via HyperOpt, evaluation with slice-based metrics using Snorkel, and serving through a FastAPI/Ray Serve deployment. The project demonstrates MLOps patterns including MLflow experiment tracking, data validation with Great Expectations, behavioral model testing, and CI/CD via GitHub Actions with Anyscale for cloud execution. The codebase is well-structured with clear separation of concerns across data.py, train.py, tune.py, evaluate.py, predict.py, serve.py, models.py, and utils.py. It includes comprehensive tests at the code, data, and model levels. However, the project shows signs of staleness with pinned dependencies from 2023 (Ray 2.7.0, transformers 4.28.1, torch 2.0.0) that have known security vulnerabilities and compatibility issues with current Python versions. The data pipeline components—particularly the CustomPreprocessor, stratified splitting, and text cleaning—are genuinely reusable patterns. The evaluation framework with slice-based metrics and behavioral tests (invariance, directional expectations, minimum functionality) represents solid ML engineering practice. The deployment configuration is tightly coupled to Anyscale's proprietary platform, limiting portability.

RATING: 7.8/10 REPRO: 7.5/10 MAINT: stale DRIFT: medium
▸ 5 reusable components found
mage-ai/mage-ai ★ 8829 991 APPLICATION

Mage is an open-source data pipeline orchestration platform that combines a visual notebook-style editor with a production-grade scheduling and execution engine. The system enables users to build, run, and monitor data pipelines composed of Python, SQL, R, and dbt blocks. Architecturally, it is a full-stack web application with a Python backend (Tornado-based server, SQLAlchemy ORM, REST API) and a Next.js/React frontend with a custom component library. Key entry points include the CLI (`mage` command), the web UI served by `mage_ai/server/server.py`, and the API layer at `mage_ai/api/` which exposes CRUD resources for pipelines, blocks, runs, schedules, users, and integrations. Data flows center around pipeline execution: blocks are connected in a DAG, each block can be a data loader, transformer, or exporter. Execution is handled by a configurable executor (local, K8s, EMR, PySpark) and scheduled via a built-in scheduler or external triggers. The platform integrates with dozens of data sources and destinations through a Singer-based integration framework, supports streaming pipelines, and includes advanced features like RBAC, version control, AI-assisted pipeline generation, and a command center for global search. It depends heavily on external services such as cloud storage (S3, GCS, Azure), databases (PostgreSQL, BigQuery, Snowflake, etc.), and authentication providers (OAuth, LDAP, OIDC).

RATING: 7.5/10 MAINT: active DRIFT: medium
▸ 4 reusable components found
datasets/country-codes ★ 983 568 DATA_RESEARCH

This repository is a data engineering pipeline that produces a comprehensive, unified country codes dataset (CSV/JSON) by merging information from multiple authoritative sources: ISO 3166, ISO 4217, UN Statistics, UN Protocol (UNTERM), CLDR, statoids, Geonames, EDGAR, FIFA, and Wikidata. The pipeline is orchestrated via a Makefile that sequentially runs Python scripts to fetch, parse, clean, and join data. The final output contains dozens of columns covering country names in multiple languages, ISO codes, currency codes, dialing codes, and more. The repository is primarily a data transformation project rather than a software application, though it includes sophisticated web scraping and fuzzy matching. The code is modular and well-structured, but reproducibility is hampered by a manual step requiring users to manually download and rename UNSD CSV files. The included GitHub Actions workflow automates monthly updates. Overall, the project is a solid reference data curation effort with moderate complexity.

RATING: 7.5/10 REPRO: 5.5/10 MAINT: active DRIFT: low
▸ 2 reusable components found
deanwampler/spark-scala-tutorial ★ 989 430 DATA_RESEARCH

This repository is an educational tutorial for Apache Spark using Scala, designed to teach distributed data processing concepts through practical examples. It functions as a data research and engineering learning resource, featuring Jupyter notebooks and Scala source code that demonstrate RDD operations, SparkSQL, and streaming pipelines. The project includes bundled datasets such as the King James Version Bible and the Enron Spam/Ham email corpus, along with golden output files for test verification. While it serves as a comprehensive guide for Spark development, it primarily focuses on teaching data transformation patterns rather than deploying a production service. The codebase demonstrates solid engineering practices for an educational context, including unit tests, custom utility classes for CLI argument parsing, and structured data schemas. However, the technical stack is significantly outdated, relying on Spark 2.3.0 and Scala 2.11.8, which are no longer supported. The examples frequently use deprecated APIs, such as the RDD-based DStream for streaming, which has been superseded by Structured Streaming in modern Spark versions. This creates a high technical drift, making the code less suitable for new projects without significant refactoring. Despite the outdated dependencies, the repository remains a valuable resource for understanding Spark fundamentals. The inclusion of golden files and test utilities provides a reproducible framework for validating data processing logic. The tutorial structure progresses logically from basic word counts to complex SQL and streaming operations, making it effective for learning. Users should be aware that while the patterns are sound, the specific API implementations will require updates to align with current Spark LTS versions.

RATING: 7.3/10 REPRO: 7.5/10 MAINT: maintained DRIFT: high
▸ 3 reusable components found
igorbarinov/awesome-data-engineering ★ 9171 1646 APPLICATION

This repository is a curated list (awesome list) of tools, frameworks, and resources for data engineering. It is not a software application or a data research project; rather, it serves as a community-maintained directory of databases, ingestion tools, stream processors, workflow orchestrators, data quality frameworks, and more. The list is organized into categories such as Databases, Data Ingestion, Stream Processing, Batch Processing, Workflow, Data Lake Management, Testing, and Community resources. Each entry includes a link and a brief description. The repository also includes contribution guidelines and CI workflows to maintain list quality. It is widely referenced (over 9,000 stars) and actively updated with new entries via pull requests. The primary value is as a reference for data engineers evaluating tools, not as executable code.

RATING: 7.2/10 MAINT: active DRIFT: low
▸ 2 reusable components found
Doragd/Algorithm-Practice-in-Industry ★ 4578 488 DATA_RESEARCH

This repository is a comprehensive data pipeline and curation system for academic papers in the fields of search, recommendation, and advertising (known as 搜广推 in Chinese). It consists of three primary automated workflows: daily arXiv paper fetching with LLM-based relevance scoring (rough and fine ranking) and output to HTML/Feishu notifications; conference paper aggregation where metadata from top venues (KDD, SIGIR, RecSys, etc.) is crawled from DBLP/DBLP and stored as markdown tables; and a curated industry practice article index with its own HTML page. All are driven by GitHub Actions and deploy to GitHub Pages. The codebase is functional but exhibits typical research-project messiness: legacy scripts coexist with a newer paperBotV2 refactor, many conference paper tables have incomplete fields (empty abstracts, zero recommendation scores), and the environment relies on unpinned Python package versions and external APIs (DeepSeek, arXiv, DBLP). The arXiv daily pipeline is the most polished component, featuring retry logic, status tracking, and two-stage LLM ranking. Overall, the repo is a pragmatic automation for researchers but not production-grade software.

RATING: 6.5/10 REPRO: 5.5/10 MAINT: active DRIFT: medium
▸ 3 reusable components found
paiml/practical-mlops-book ★ 988 379 DATA_RESEARCH

This repository serves as the companion code for the O'Reilly book 'Practical MLOps', providing a collection of examples spanning the MLOps lifecycle. It is a hybrid repository with a dominant data research character, containing Jupyter notebooks for exploratory data analysis (e.g., COVID-19 trends, sugar intake correlations), AutoML experiments (Ludwig text classification), and model interoperability scripts (ONNX conversion). It also includes application-like components such as a Flask-based model serving container, CLI tools for CSV linting, and cloud deployment scripts for AWS, Azure, and GCP. The code is organized by book chapters and demonstrates practical MLOps patterns, though many examples are simplified for educational purposes rather than production readiness. The most reusable asset is the modularized CSV linter, which provides a well-structured CLI for data quality checks.

RATING: 6.4/10 REPRO: 6.0/10 MAINT: maintained DRIFT: low
▸ 3 reusable components found
$ loading more...
$ submit: