dbohdan/automatic-api

A list of software that turns your database into a REST/GraphQL API

The following is a list of tools that automatically expose a REST, GraphQL, or another kind of API for your database, as well as databases with a built-in HTTP API.

Project name/link	Database(s) supported	API type	Implementation language	License	GitHub stats	Notes
Apinizer API Creator	Oracle, MySQL, PostgreSQL, MsSQL, IBM DB2, SAP Sybase ASE, Apache Impala, Apache Hive	REST	Java	Proprietary (SaaS)	n/a	Generates OpenAPI Specifications.
ArangoDB	ArangoDB	REST	C++	Apache-2.0	13182 ★; 50853 commits, latest 2023-12-01	A database with a built-in REST API. Official Docker image.
CouchDB	CouchDB	REST	Erlang	Apache-2.0	5880 ★; 13451 commits, latest 2023-12-01	A database with a built-in REST API. Official Docker image.
Datasette	SQLite 3	REST	Python 3	Apache-2.0	8498 ★; 2469 commits, latest 2023-10-13	Read-only. Official Docker image.
Dgraph	Dgraph	GraphQL (since version 2.0.0-rc1)	Go	Apache-2.0	19763 ★; 6058 commits, latest 2023-10-13	A database with a built-in GraphQL API. Official Docker image.
Directus	PostgreSQL, MySQL, SQLite, OracleDB, CockroachDB, MariaDB, MS SQL	REST and GraphQL	TypeScript	Propretary (BUSL-1.1), GPL-3.0 (after three years)	23874 ★; 11030 commits, latest 2023-12-01	Official Docker image.
DreamFactory	MySQL, PostgreSQL, SQLite, MongoDB, CouchDB, and others.	REST	PHP 5	Apache-2.0, proprietary (optional extras)	1437 ★; 1131 commits, latest 2023-11-30	Official Docker image.
EJDB2	EJDB2	REST	C	MIT	1402 ★; 2827 commits, latest 2023-11-03	A database with a built-in REST API. Official Docker image.
Eve	MongoDB; extensions for Elasticsearch, Neo4j, SQLAlchemy (SQL databases).	REST	Python 2/3	BSD-3-Clause	6644 ★; 3393 commits, latest 2023-07-10	The SQLAlchemy extension isn't automatic. It requires the user to write SQLAlchemy mappings.
Hasura GraphQL Engine	PostgreSQL	GraphQL	Haskell	Apache-2.0	30506 ★; 7849 commits, latest 2023-12-01	Official Docker image.
HTSQL	MySQL, PostgreSQL, SQLite (free); Oracle, MS SQL (proprietary)	REST	Python 3	Apache-2.0, proprietary (Oracle and MS SQL support)	20 ★; 1235 commits, latest 2020-08-11
InfluxDB	InfluxDB	REST	Go	MIT	26788 ★; 49152 commits, latest 2023-11-02	A timeseries database with a built-in REST API. Official Docker image.
neo4j-graphql	Neo4j	GraphQL	Kotlin	Apache-2.0	449 ★; 164 commits, latest 2020-10-22	Can generate a GraphQL API from an existing database or derive a new database model from a GraphQL schema and auto-generate the resolvers.
NocoDB	MySQL, PostgreSQL, SQL Server, SQLite	REST	JavaScript (Node.js)	MIT	38799 ★; 18694 commits, latest 2023-12-02	Official Docker image.
OrientDB	OrientDB	REST	Java	Apache-2.0	4650 ★; 21600 commits, latest 2023-11-29	A database with a built-in REST API. Official Docker image.
PHP-CRUD-API	MySQL, PostgreSQL, MS SQL Server.	REST	PHP 7	MIT	3451 ★; 2120 commits, latest 2023-11-13	Supports GIS + automatic OpenAPI 3.0 docs.
PostGraphile	PostgreSQL	GraphQL	TypeScript (Node.js)	MIT	12263 ★; 9619 commits, latest 2023-12-01	Formerly "PostGraphQL". Official Docker image.
PostgREST	PostgreSQL	REST	Haskell	MIT	21394 ★; 2584 commits, latest 2023-12-02	Official Docker image.
pREST	PostgreSQL	REST	Go	MIT	3975 ★; 1953 commits, latest 2023-11-06	Official Docker image.
pRESTige	MySQL	REST	PHP	MIT	95 ★; 1081 commits, latest 2022-07-13
RESTHeart	MongoDB	REST	Java	AGPL-3.0	784 ★; 4282 commits, latest 2023-11-30	Official Docker image.
restSQL	MySQL, PostgreSQL	REST	Java	MIT	138 ★; 54 commits, latest 2018-10-18	Official Docker image.
sandman2	All supported by SQLAlchemy (MySQL, PostgreSQL, SQLite, Oracle, MS SQL, and others).	REST	Python 2/3	Apache-2.0	1964 ★; 250 commits, latest 2020-12-21	Official Docker image.
Silence	MySQL, MariaDB	REST	Python 3	MIT	10 ★; 425 commits, latest 2022-12-22	Automatically generates REST endpoints to do CRUD operations against the database, test studs, and JS files to access the API.
Siodb	Siodb	REST	C++, Go	AGPL-3.0	44 ★; 278 commits, latest 2023-02-18	A database with a built-in REST API. Official Docker image.
Soul	SQLite 3	REST	JavaScript (Node.js)	MIT	1054 ★; 202 commits, latest 2023-12-01	A RESTful SQLite server.
subZero	PostgreSQL	REST and GraphQL	Haskell, Lua	Proprietary	n/a
Supabase	PostgreSQL	REST and GraphQL	TypeScript, Elixir (Realtime), Rust (pg_graphql), Go (GoTrue)	Apache-2.0	60095 ★; 26365 commits, latest 2023-12-02	Uses PostgREST. Guide to self-Hosting with Docker.
tuql	SQLite 3 or SQL infile	GraphQL	JavaScript (Node.js)	MIT	1026 ★; 72 commits, latest 2021-06-06
Webdis	Redis	REST	C	BSD-2-Clause	2750 ★; 657 commits, latest 2023-11-04	Supports pub/sub with chunked transfer encoding and WebSockets.
WunderGraph	PostgreSQL, MySQL, SQLite, SQL Server, MongoDB + Atlas, PlanetScale, YugabyteDB, Neon.tech, FaunaDB	GraphQL	TypeScript, Go	Apache-2.0	2039 ★; 1875 commits, latest 2023-12-01	WunderGraph Docs.
XTDB	XTDB	REST	Clojure	MIT	2384 ★; 7476 commits, latest 2023-11-29	A database with a built-in REST API. Official Docker image.
ZenQuery	PostgreSQL, MySQL, IBM Db2, Oracle Database, Microsoft SQL Server and others	REST	Java	Apache-2.0	62 ★; 283 commits, latest 2018-10-16	Read-only.

GitHub stats updated 2023-12-02. The commit count and the latest commit date are for the default branch (usually master).

Related projects

For projects that depend on or enhance those on the list see the Related projects wiki page. Feel free to add yours.

Contributing

Your contributions are welcome! Please submit a pull request or create an issue to add a new project to the list or to update an existing one. See CONTRIBUTING for the details.

License

This document and the data in data/ are licensed under the Creative Commons Attribution 4.0 International License. By contributing you agree to release your contribution under this license.

automatic-api's Issues

Add Riff (in ruby) to the list

I`ve just finished and published the project an dwould like to suggest it to be listed in this repo.

xgenecloud is archived

Hi,
xgenecloud has been archived.
Does anyone knows why? Is there a replacement?
Should it be removed from the list?
Thanks

make fails: GitHub API: Bad credentials

go fmt render-template.go
go: downloading github.com/magiconair/properties v1.8.5
go: downloading github.com/rhinoman/go-commonmark v0.0.0-20170821135903-b6e895a10b08
go run render-template.go > README.md
2021/08/31 10:49:49 GitHub API: Bad credentials
exit status 1
make: *** [Makefile:13: README.md] Error 1

Awesome List

Consider turning this into an Awesome List because everyone likes cool sunglasses 😎

See an example: https://github.com/styfle/awesome-online-ide

Few missing items

• https://graphjin.com/
• https://www.graphile.org/postgraphile/realtime/
• https://supabase.com/
• https://aws.amazon.com/appsync/

Add loopback.io

The list is missing my personal favourite os nodejs framework: http://loopback.io

Rest, works with practically any db via pluggable connectors, easy auth&acl, awesome cli tool, open api spec, etc.

I'm traveling without my laptop so just an issue for now sorry. Unless someone beats me to it, i might post a PR later :)

Add the number of contributors to the GitHub stats

As soon as GitHub makes the data available through the GraphQL API.

https://platform.github.community/t/get-contribution-statistics/971

directus should be added

https://github.com/directus/directus
wraps any SQL database with a real-time GraphQL+REST API

Docker image availability?

Some of these tools (like PostgREST, which is the one I'm most familiar with) provide Docker images, meaning I can use them in a Docker Compose project with no code and very little configuration. It would be helpful for me if this list said which projects have docker images maintained by the project authors.

Add Apinizer to the list

Hi, please add Apinizer to the list, thanks.

Apinizer Oracle, MySQL, PostgreSQL, MsSQL, IBM DB2, SAP Sybase ASE, Apache Impala, Apache Hive REST Java Proprietary n/a Supports SQL operations and Procedure Call, creates Swagger & OpenAPI automatically Preview.

xmysql becomes nocodb

for info xmysql has moved to nocodb

Poll: Proprietary software and services on the list

Would you, personally, find it useful if the list included

1. Self-hostable proprietary software;
2. SaaS like Amazon's recent AWS AppSync?

Why/why not? If you want either included, would you prefer to have the services and the proprietary software listed in separate tables or together with the open source software? (Note that this isn't a vote.)