# roapi/roapi

Create full-fledged APIs for slowly moving datasets without writing a single line of code.

Repository: https://github.com/roapi/roapi
Canonical: https://ross.abutalabs.com/products/roapi
Homepage: https://roapi.github.io/docs
Language: Rust
License: Apache-2.0
License Family: permissive
Topics: sql, graphql, arrow, rest-api, analytics, query, columnar, rust, in-memory-database, datafusion, blob-storage, cloud-native, parquet, query-frontends, datasets, static-datasets, s3, delta-lake
Last push: 2026-03-25T05:39:57+00:00

## Health v2 (maintenance only)
Score: 80/100 (v2, computed 2026-09-03T02:20:16.233290+00:00)
- activity 74, release rhythm 76, longevity 100
- inputs: {"age_days": 2092, "days_push": 161, "days_rel": 162, "gap_med": 17, "n_releases_24m": 6}
- flags: none
- formula: round(0.45*activity + 0.35*rhythm + 0.20*longevity); archived -> min(score, 10)

## Adoption (not part of the score)
Stars 3420, forks 209 (observed 2026-08-28T04:08:03.802255+00:00)

## What it is
ROAPI automatically spins up read-only REST, GraphQL, SQL, and FlightSQL query APIs over static or slowly moving datasets without writing any code. It is built on Apache Arrow and Datafusion, loading data from files, S3, Delta Lake, or databases with automatic schema inference.

## Use cases
- expose a csv file as a rest api
- query parquet files on s3 with sql
- spin up a graphql api for a dataset without writing code
- serve a json file as a queryable table
- join data from multiple sources via one api
- quickly share analytics data with a query endpoint

## When to choose
- you need read-only query APIs over static or slowly changing datasets with zero code
- you want SQL, GraphQL, and REST frontends over the same data
- you need automatic schema inference across CSV, Parquet, JSON, and databases

## When to avoid
- you need write support or transactional updates
- you need a full production database with user management and fine-grained auth
- your datasets change rapidly and require real-time consistency

## Facets
- artifact type: application
- maturity: active
- function: api-framework, http-server, graphql, search-engine, serialization, database
- domain: analytics, apis, databases, developer-tools
- platform: windows, rust, cli, self-hosted
- tags: apache-arrow, datafusion, parquet, delta-lake, rest-api, flightsql, s3, read-only-api, schema-inference, columnar, data-engineering, linux, macos, docker

## Member repositories
- roapi/roapi (main) score 80

## Provenance
- Observed fields: from GitHub, fetched 2026-08-28T04:08:03.802255+00:00.
- Health v2: computed from the inputs above; adoption is never an input.
- Inferred fields (summary, facets, guidance): AI-extracted, prompt v1, taxonomy v1, on 2026-08-29T18:38:09.980255+00:00, confidence not recorded.
  - readme: https://github.com/roapi/roapi (fetched 2026-08-28T04:08:03.802255+00:00, sha 177c21259905)
  - homepage: https://roapi.github.io/docs (fetched 2026-08-29T09:32:12.052992+00:00, sha 722f44b21e27)
- Data as of 2026-08-30T08:39:29.467469+00:00.