Tools · SPBoucher
Menu

Directory

22 tools

Results

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

Apache-2.0Open sourceFreeLocalNov 2, 2026

Apache Spark

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-2.0Open sourceFreeLocalSelf-hostedNov 2, 2026

ArchiveBox

ArchiveBox (Nick Sweeting and contributors) · Web archiving

Self-hosted, open-source web archiving tool that saves URLs as HTML, PDF, screenshot, WARC, readable text and media snapshots with a web UI and CLI

MITOpen sourceFreeLocalSelf-hostedNov 2, 2026

Chroma

Chroma · Vector databases

Open-source embedding database with a minimal Python and JavaScript API, usable in-process, as a server or through Chroma Cloud

Apache-2.0Open sourceUsage-basedLocalSelf-hostedNov 2, 2026

ClickHouse

ClickHouse, Inc. · Analytical engines & OLAP

In-depth entry

Open-source columnar OLAP database server for fast aggregations over billions of rows, with MergeTree storage, SQL and a managed ClickHouse Cloud

Apache-2.0Open sourceFreeLocalSelf-hostedNov 2, 2026

Crawlee

Apify Technologies s.r.o. · Data collection & crawling

Open-source crawling and scraping library for Node.js/TypeScript and Python that unifies HTTP and headless-browser crawlers with queues, proxies, fingerprints and storage

Apache-2.0Open sourceFreeLocalSelf-hostedNov 2, 2026

Dagster

Dagster Labs · ETL/ELT & orchestration

Asset-oriented Python orchestrator that models pipelines as software-defined data assets with lineage, checks and a hosted Dagster+ option

Apache-2.0Open sourceFreemiumLocalSelf-hostedRedirected

dbt

dbt Labs (Fivetran + dbt Labs) · ETL/ELT & orchestration

In-depth entry

SQL-first transformation framework that compiles templated models, tests and documentation into warehouse tables; open-source Core plus a commercial platform

Apache-2.0Open sourceFreemiumLocalSelf-hostedNov 2, 2026

Drizzle ORM

Drizzle Team · Web frameworks & UI

TypeScript ORM with SQL-like query builder, schema defined in code, migrations through Drizzle Kit, and support for PostgreSQL, MySQL and SQLite drivers

Apache-2.0Open sourceFreeLocalSelf-hostedNov 2, 2026

DuckDB

DuckDB Foundation / DuckDB Labs · Analytical engines & OLAP

In-depth entry

In-process analytical SQL database that queries Parquet, CSV and Arrow data directly from Python, R, Node or the CLI

MITOpen sourceFreeLocalSelf-hostedNov 2, 2026

Great Expectations (GX Core)

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

Apache-2.0Open sourceFreeLocalSelf-hostedNov 2, 2026

Kùzu

Kùzu Inc. (company acquired; project archived) · NoSQL & key-value stores

In-depth entry

Embedded property-graph database with Cypher, vector and full-text search; MIT-licensed but archived in October 2025 after the company was acquired

MITOpen sourceFreeLocalDiscontinuedNov 2, 2026

marimo

marimo (acquisition by CoreWeave announced October 2025) · Notebooks & interactive computing

Reactive Python notebook stored as a plain .py file that re-runs dependent cells automatically and doubles as a script or web app

Apache-2.0Open sourceFreeLocalSelf-hostedNov 2, 2026

Observable

Observable, Inc. · Notebooks & interactive computing

JavaScript data notebooks and the open-source Observable Framework static-site generator for data apps, from the maintainers of D3 and Plot

ISCFreemiumPaidLocalNov 2, 2026

Playwright

Microsoft · Testing & QA

In-depth entry

Microsoft's browser automation and end-to-end testing framework driving Chromium, Firefox and WebKit from one API in TypeScript, Python, Java and .NET

Apache-2.0Open sourceFreeLocalSelf-hostedNov 2, 2026

PostgreSQL

PostgreSQL Global Development Group · Relational databases

In-depth entry

Open-source object-relational database server with a large extension ecosystem (PostGIS, pgvector, TimescaleDB) and broad SQL coverage

PostgreSQLOpen sourceFreeLocalSelf-hostedBroken

Prefect

Prefect Technologies, Inc. · ETL/ELT & orchestration

Python workflow orchestration library and server where decorated functions become observable, retryable flows, with Prefect Cloud as hosted option

Apache-2.0Open sourceFreemiumLocalSelf-hostedRedirected

Prisma ORM

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

Apache-2.0Open sourceFreeLocalSelf-hostedNov 2, 2026

Project Jupyter

Project Jupyter (NumFOCUS) · Notebooks & interactive computing

In-depth entry

Open-source computational notebook ecosystem: the .ipynb format, kernels for Python, R and Julia, JupyterLab and Notebook interfaces and JupyterHub

BSD-3-ClauseOpen sourceFreeLocalSelf-hostedNov 2, 2026

Quarto

Posit Software, PBC · Academic writing & publishing

In-depth entry

Open-source scientific publishing system from Posit that renders Markdown with executable Python, R, Julia or Observable code to HTML, PDF, Word, slides, websites and books via Pandoc

MITFreeOpen sourceLocalNov 2, 2026

Scrapy

Scrapy developers (maintained with Zyte) · Data collection & crawling

In-depth entry

Mature open-source Python framework for writing crawlers (spiders) that fetch pages asynchronously, extract structured items and export them through pipelines

BSD-3-ClauseOpen sourceFreeLocalSelf-hostedNov 2, 2026

SQLite

SQLite Consortium / Hipp, Wyrick & Company · Relational databases

In-depth entry

Public-domain embedded SQL database engine that stores a whole database in one file and ships inside most operating systems and browsers

Open sourceOpen sourceFreeLocalNov 2, 2026

Page 1 of 1

Share this view: /tools?category=data&exec=local&iface=cli