Data Warehouse & Analytics
34 resources — subcategories Data Warehouse & Analytics
AliSQL
Alibaba Cloud's open-source MySQL branch, protocol-compatible with MySQL 8.0 and extended with a DuckDB-backed analytical storage engine, native vector search, and flashback queries.

Altinity Sink Connector for ClickHouse
A connector from Altinity that moves data automatically from transactional tables in MySQL and PostgreSQL into ClickHouse.

Apache Doris
An open source, real-time analytics and search database built on MPP architecture, speaking the MySQL wire protocol for fast SQL analytics, lakehouse query acceleration, and hybrid search.
Apache SeaTunnel
A distributed data integration tool from the Apache Software Foundation for synchronizing large volumes of data, with a MySQL CDC source connector.

Apache Superset
An open-source data exploration and visualization platform from the Apache Software Foundation, with a no-code chart builder, a SQL editor, and dashboards on top of MySQL and other SQL databases.

ApeDTS
A lightweight Rust binary for snapshot migration, change data capture, and data validation between MySQL, Postgres, Kafka, and analytical engines like ClickHouse, StarRocks, TiDB, and Doris.
AxialDB
A proprietary analytical engine that reads the MySQL binlog itself and keeps fast columnar copies of the tables your reports use, current as they change, so BI tools can query them in plain SQL without a pipeline or warehouse. Free for up to 5 tables.

ChunJun
A distributed data integration framework built on Apache Flink, formerly FlinkX, with MySQL among more than 20 supported data sources.

ClickHouse
An open-source column-oriented database for real-time analytics that can query MySQL tables directly and accept connections over the MySQL wire protocol.

Cube
An open-source semantic layer that defines metrics and joins once and serves them through SQL, REST, and GraphQL APIs, with a MySQL driver among its data sources.

Databend
A cloud data warehouse written in Rust on object storage, combining SQL analytics, vector search, and full-text search, and accepting connections from MySQL clients.

Datagrit
A Seoul-based database company behind GritDB, an in-house database engine with a built-in analytics engine and compatibility with PostgreSQL and MySQL, and GritKit, an AI-powered tool that automatically tunes parameters and indexes of open-source databases.
DataX
The open-source edition of Alibaba Cloud DataWorks data integration, an offline data synchronization framework with MySQL reader and writer plugins.

DBTrail
A zero-ETL analytical replica for MySQL — it reads the binlog like a replica, keeps a Parquet copy you query with DuckDB, and adds time travel and row-level undo.

dlt
An open-source Python library that automates data loading, including extracting from MySQL through its SQL database source.

DuckDB MySQL Extension
An official DuckDB extension that attaches a running MySQL database so DuckDB can read and write its tables directly with SQL.

Evidence
A code-based business intelligence tool for building reports in SQL and Markdown, with a MySQL connector.

Flink CDC
A streaming data integration tool built on Apache Flink, with MySQL, TiDB, and Vitess binlog source connectors for full-database sync, schema evolution, and data transformation into warehouses and lakehouses.

ingestr
A command-line tool from Bruin that copies data between databases and other sources and destinations with a single command, including MySQL.

MariaDB ColumnStore
MariaDB's columnar storage engine for analytical workloads — plugs into MariaDB Server to run large aggregations and scans over massively parallel, distributed storage instead of the row-oriented InnoDB/Aria engines.

MatrixOne
A cloud-native HTAP database with Git-style version control for data, built-in vector search, and MySQL compatibility.

Metabase
An open-source business intelligence and embedded analytics tool that lets anyone query a MySQL database and build dashboards through a point-and-click interface or the SQL editor.
mysql_ch_replicator
A tool for real-time replication of MySQL databases to ClickHouse, with support for migrations and schema changes.

OceanBase
A distributed relational database from Ant Group with a MySQL-compatible mode, built for HTAP workloads at petabyte scale with no single point of failure.

Querybook
A notebook-style Big Data IDE from Pinterest for discovering, querying, and sharing analyses, with MySQL among its built-in query engines alongside Presto, Hive, and others.

Redash
An open-source query, visualization, and dashboard tool that connects to MySQL (and 30+ other data sources), with a browser-based SQL editor, scheduled refreshes, and alerting on query results.

Sling
A free CLI tool for small to medium data pipelines using the Extract & Load approach, with MySQL as a source and a target.

SQLPage
An SQL-only web application builder that turns database queries into interactive pages with tables, forms, and charts, with a built-in MySQL driver.

StarRocks
An open-source MPP analytical database with native MySQL wire-protocol support, built for sub-second queries over local tables and data-lake tables alike.

Tapdata
A real-time data integration platform based on change data capture, with MySQL as a source for syncing data to other databases and services.

TiDB
An open-source, distributed SQL database with MySQL wire-protocol compatibility, built for horizontal scalability, strong consistency, and hybrid transactional/analytical (HTAP) workloads.

Trino
A fast distributed SQL query engine for big data analytics, with connectors for MySQL and MariaDB.
WarpSQL
An open source, OLAP-focused distribution of MySQL built around the WARP column-store engine, with parallel query and, in the latest beta, materialized views refreshed from the binlog.
