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

Altinity Sink Connector for ClickHouse

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

Apache Doris

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

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

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

ChunJun

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

ClickHouse

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

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

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

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

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

dlt

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

DuckDB MySQL Extension

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

Evidence

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

Flink CDC

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

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 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

MatrixOne

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

Metabase

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

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

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

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

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

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

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

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

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

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.

Justin Swanhart
WrenAI

WrenAI

An open-source generative BI tool for AI agents that produces governed SQL and dashboards across more than 22 data sources, including MySQL.