scratchdata/scratchdata
Scratch is a swiss army knife for big data. observed · 2026-08-28
Health v2 · maintenance only
19/100
- Activity 0
- Release rhythm 8
- Longevity 82
How is this computed?
round(0.45*activity + 0.35*rhythm + 0.20*longevity); archived -> min(score, 10) — computed 2026-09-03. Adoption (stars, forks) is never an input.
- gap_med: n/a
- age_days: 1150
- days_rel: n/a
- days_push: 775
- n_releases_24m: 0
Adoption not part of the score
1120 stars · 53 forks observed · 2026-08-28
What it is AI-extracted, prompt v1, taxonomy v1, 2026-08-30, confidence not recorded
Scratch Data is a self-hosted Go service that acts as a wrapper around analytics databases like DuckDB, ClickHouse, BigQuery, Snowflake, and Redshift. It accepts arbitrary JSON via an HTTP API, auto-creates tables, and lets you run SQL queries, share results as CSV/JSON links, and copy data between databases.
Use cases
- stream json events into an analytics database without schema setup
- query a data warehouse over a simple http api
- share query results as expiring csv or json links
- copy data between clickhouse, snowflake, bigquery and other warehouses
- spin up a local duckdb analytics endpoint quickly
- ingest event data with automatic table creation
When to choose
- you want a lightweight self-hosted layer to stream JSON into OLAP databases
- you need a simple REST API in front of a data warehouse
- you want automatic schema creation from arbitrary JSON payloads
- you need to move query results between different analytics databases
When to avoid
- you need a full-featured ETL orchestration platform with scheduling and transforms
- you require transactional OLTP database workloads
- you need a managed cloud service with enterprise support
- AGPL-3.0 licensing is incompatible with your usage
Facets
service · maturity active
database etl http-server api-framework streaming databases analytics big-data go self-hosted cross-platform olap clickhouse duckdb data-warehouse json-ingestion sql-api share-links data-copy data-engineering docker
1 source
- readme: https://github.com/scratchdata/scratchdata · fetched 2026-08-28 · d670b73607e8
Member repositories
| Repository | Role | Health v2 |
|---|---|---|
| scratchdata/scratchdata | main | 19 |
For agents
markdown · JSON · MCP: product_card(name="scratchdata/scratchdata")
Data as of 2026-08-30T08:39:29.467469+00:00 · Report a problem