The following is a list of open source 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 |
---|---|---|---|---|---|---|
ArangoDB | ArangoDB | REST | C++ | Apache 2.0 | 5617 ★; 42320 commits, latest 2018-05-09 | A database with a built-in REST API. Official Docker image. |
CouchDB | CouchDB | REST | Erlang | Apache 2.0 | 3623 ★; 11128 commits, latest 2018-05-02 | A database with a built-in REST API. Official Docker image. |
Datasette | SQLite 3 | REST | Python 3 | Apache 2.0 | 1413 ★; 370 commits, latest 2018-05-06 | Read-only. Official Docker image. |
Dgraph | Dgraph | GraphQL+-, a GraphQL derivative | Go | Apache 2.0 with a "no selling" restriction | 5520 ★; 2403 commits, latest 2018-05-03 | A database with a built-in GraphQL-like API. Official Docker image. |
DreamFactory | MySQL, PostgreSQL, SQLite, MongoDB, CouchDB, and others. | REST | PHP 5 | Apache 2.0, proprietary (optional extras) | 791 ★; 800 commits, latest 2018-02-25 | Official Docker image. |
Eve | MongoDB; extensions for Elasticsearch, Neo4j, SQLAlchemy (SQL databases). | REST | Python 2/3 | BSD (three-clause) | 4970 ★; 2817 commits, latest 2018-05-09 | The SQLAlchemy extension isn't automatic. It requires the user to write SQLAlchemy mappings. |
HTSQL | MySQL, PostgreSQL, SQLite (free); Oracle, MS SQL (proprietary) | REST | Python 2 | GNU AGPLv3, proprietary (Oracle and MS SQL support) | n/a | |
neo4j-graphql | Neo4j | GraphQL | Kotlin | Apache 2.0 | 198 ★; 125 commits, latest 2018-04-30 | Can generate a GraphQL API from an existing database or derive a new database model from a GraphQL schema and auto-generate the resolvers. |
OrientDB | OrientDB | REST | Java | Apache 2.0 | 3463 ★; 16762 commits, latest 2018-05-08 | A database with a built-in REST API. Official Docker image. |
PHP-CRUD-API | MySQL, PostgreSQL, MS SQL Server 2012. Limited support for SQLite 3. | REST | PHP 5 | MIT | 1442 ★; 1041 commits, latest 2018-05-05 | |
PostGraphile | PostgreSQL | GraphQL | TypeScript (Node.js) | MIT | 5263 ★; 884 commits, latest 2018-05-09 | Formerly "PostGraphQL", Official Docker image. |
PostgREST | PostgreSQL | REST | Haskell | MIT | 10710 ★; 1381 commits, latest 2018-05-04 | Official Docker image. |
pREST | PostgreSQL | REST | Go | MIT | 1676 ★; 415 commits, latest 2018-05-06 | Official Docker image. |
RESTHeart | MongoDB | REST | Java | GNU AGPLv3 | 458 ★; 1439 commits, latest 2018-05-09 | Official Docker image. |
sandman2 | All supported by SQLAlchemy (MySQL, PostgreSQL, SQLite, Oracle, MS SQL, and others). | REST | Python 2/3 | Apache 2.0 | 750 ★; 133 commits, latest 2018-05-07 | |
tuql | SQLite 3 or SQL infile | GraphQL | JavaScript (Node.js) | MIT | 255 ★; 52 commits, latest 2018-02-16 | |
xmysql | MySQL | REST | JavaScript (Node.js) | MIT | 1853 ★; 227 commits, latest 2018-05-07 | Official Docker image. |
ZenQuery | PostgreSQL, MySQL, IBM Db2, Oracle Database, Microsoft SQL Server and others | REST | Java (JavaScript for the front-end) | Apache 2.0 | 32 ★; 282 commits, latest 2017-01-31 | Read-only. |
GitHub stats updated 2018-05-09. The commit count and the latest commit date are for the default branch (usually master
).
For projects that depend on or enhance those on the list see the Related projects wiki page. Feel free to add yours.
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.
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.