Apache DataFusion
Apache Software Foundation · Analytical engines & OLAP
Extensible Rust query engine built on Apache Arrow offering SQL and DataFrame APIs, Parquet readers and an optimizer for embedding in data systems
12 tools
Apache Software Foundation · Analytical engines & OLAP
Extensible Rust query engine built on Apache Arrow offering SQL and DataFrame APIs, Parquet readers and an optimizer for embedding in data systems
Apache Software Foundation · Analytical engines & OLAP
Distributed data processing engine with DataFrame and SQL APIs in Python, Scala, Java and R, plus structured streaming and MLlib
Apache Software Foundation · BI & dashboards
Apache-licensed BI web application with SQL Lab, a no-code chart builder, dashboards and connectors to any SQLAlchemy-compatible database
ClickHouse, Inc. · Analytical engines & OLAP
Open-source columnar OLAP database server for fast aggregations over billions of rows, with MergeTree storage, SQL and a managed ClickHouse Cloud
DuckDB Foundation / DuckDB Labs · Analytical engines & OLAP
In-process analytical SQL database that queries Parquet, CSV and Arrow data directly from Python, R, Node or the CLI
Great Expectations project (open-source stewardship by Fivetran) · Data quality & validation
Python data-quality framework that declares Expectations about datasets, validates them against pandas, Spark or SQL sources and produces Data Docs
Andrew Kane (pgvector project) · Vector databases
PostgreSQL extension adding vector types, distance operators and HNSW/IVFFlat indexes for similarity search inside the database
PostGIS Project Steering Committee (OSGeo) · GIS & mapping
Spatial extension for PostgreSQL adding geometry, geography and raster types with indexing and hundreds of SQL functions
PostgreSQL Global Development Group · Relational databases
Open-source object-relational database server with a large extension ecosystem (PostGIS, pgvector, TimescaleDB) and broad SQL coverage
Prisma Data, Inc. · Web frameworks & UI
TypeScript ORM with a declarative schema language, generated type-safe client and migration tooling, from the company that also offers Prisma Postgres and related hosted services
SQLite Consortium / Hipp, Wyrick & Company · Relational databases
Public-domain embedded SQL database engine that stores a whole database in one file and ships inside most operating systems and browsers
Trino Software Foundation · Analytical engines & OLAP
Distributed SQL query engine that federates queries across data lakes, warehouses and databases through connectors, formerly PrestoSQL
Page 1 of 1
Share this view: /tools?tag=sql&os=macos&source=open-source