ROAPI

Open source

ROAPI generates read-only SQL, GraphQL and REST APIs for slowly changing datasets without code, built on Apache Arrow and DataFusion.

roapi.github.io
ROAPI homepage screenshot
GitHub stars
3.4k
Last 30 days
+2(+0%)
Last commit
7 mo ago
Repository age
5 years
Version
roapi-v0.13.0
Licence
Apache-2.0
Self-hosted
Yes

About ROAPI

ROAPI automatically starts read-only APIs and query frontends for slowly moving datasets, without requiring any code. It is built on Apache Arrow and Datafusion.

Its design has four parts: query frontends that translate SQL, GraphQL and REST queries into Datafusion plans, Datafusion for executing plans, a data layer that loads sources with automatic schema inference, and a response layer that encodes Arrow record batches into the format a client asks for.

Because the query core is pluggable, joins can run across different sources, from CSV and Parquet files in data warehouses to MySQL and Postgres, and spreadsheets such as Google Sheets. The code is licensed under Apache-2.0.

Key features

  • Read-only APIs created without writing code
  • SQL, GraphQL and REST query frontends
  • Automatic schema inference when loading data
  • Responses in client-requested formats
  • Joins across different data sources

Good fit for

  • Serving CSV or Parquet files over an API
  • Querying spreadsheets with SQL
Tags
api
sql
graphql
rest
datafusion
arrow
data

ROAPI: questions and answers

What is ROAPI used for?
ROAPI generates read-only SQL, GraphQL and REST APIs for slowly changing datasets without code, built on Apache Arrow and DataFusion. It is a good fit for serving CSV or Parquet files over an API and querying spreadsheets with SQL.
Is ROAPI open source?
Yes. ROAPI is open source under the Apache-2.0 licence. Its source code is on GitHub at roapi/roapi and is written mainly in Rust.
Is ROAPI free?
Yes. ROAPI is open source, so the software itself is free to use.
What are some alternatives to ROAPI?
Similar open-source tools in the API Tools category include Bruno, Hoppscotch and Insomnia. SaaS products in the same category include Apollo GraphOS, AWS AppSync and Canopy API.
Is ROAPI actively maintained?
The most recent commit to ROAPI was on 25 March 2026. The project has 3.4k stars on GitHub, with 2 added in the last 30 days.

Open-source alternatives to ROAPI

See all

SaaS alternatives to ROAPI

See all