Tools · SPBoucher
Menu

Directory

15 tools

Results

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

Apache Superset

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

Apache-2.0Open sourceFreeSelf-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

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

Metabase

Metabase, Inc. · BI & dashboards

Self-hostable BI tool with a no-code question builder, SQL editor, dashboards and embedding; AGPL open-source edition plus commercial Pro and Enterprise

AGPL-3.0Open sourceFreeSelf-hostedNov 2, 2026

MySQL

Oracle · Relational databases

Oracle's widely deployed open-source relational database server, offered as a GPL community edition and commercial enterprise and cloud editions

GPL-2.0-only WITH Universal-FOSS-exception-1.0Open sourceFreeSelf-hostedBroken

pgvector

Andrew Kane (pgvector project) · Vector databases

In-depth entry

PostgreSQL extension adding vector types, distance operators and HNSW/IVFFlat indexes for similarity search inside the database

PostgreSQLOpen sourceFreeSelf-hostedNov 2, 2026

PostGIS

PostGIS Project Steering Committee (OSGeo) · GIS & mapping

In-depth entry

Spatial extension for PostgreSQL adding geometry, geography and raster types with indexing and hundreds of SQL functions

GPL-2.0-or-laterOpen sourceFreeSelf-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

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

TimescaleDB

Tiger Data (formerly Timescale) · Relational databases

PostgreSQL extension for time-series data adding hypertables, compression and continuous aggregates, from the company now named Tiger Data

Apache-2.0 AND LicenseRef-Timescale-LicenseOpen sourceFreeSelf-hostedNov 2, 2026

Trino

Trino Software Foundation · Analytical engines & OLAP

Distributed SQL query engine that federates queries across data lakes, warehouses and databases through connectors, formerly PrestoSQL

Apache-2.0Open sourceFreeSelf-hostedNov 2, 2026

Page 1 of 1

Share this view: /tools?tag=sql&exec=self-hosted&status=active