modulepackage
0.0.0-20240831041107-7d0fd14055f2
Repository: https://github.com/dbohdan/automatic-api.git
Documentation: pkg.go.dev
# README
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 | 13479 ★; 51562 commits, latest 2024-08-30 | A database with a built-in REST API. Official Docker image. |
| CouchDB | CouchDB | REST | Erlang | Apache-2.0 | 6156 ★; 13703 commits, latest 2024-08-18 | A database with a built-in REST API. Official Docker image. |
| Datasette | SQLite 3 | REST | Python 3 | Apache-2.0 | 9218 ★; 2648 commits, latest 2024-08-22 | Read-only. Official Docker image. |
| DB2Rest | PostgreSQL, MySQL, MariaDB, Oracle, CockroachDB | REST | Java | Apache-2.0 | 157 ★; 974 commits, latest 2024-08-30 | Official Docker image. |
| Dgraph | Dgraph | GraphQL (since version 2.0.0-rc1) | Go | Apache-2.0 | 20288 ★; 6168 commits, latest 2024-08-28 | 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) | 26966 ★; 12205 commits, latest 2024-08-30 | Official Docker image. |
| DreamFactory | MySQL, PostgreSQL, SQLite, MongoDB, CouchDB, and others. | REST | PHP 5 | Apache-2.0, proprietary (optional extras) | 1529 ★; 1140 commits, latest 2024-05-16 | Official Docker image. |
| EJDB2 | EJDB2 | REST | C | MIT | 1441 ★; 2833 commits, latest 2024-08-30 | 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 | 6681 ★; 3401 commits, latest 2024-08-30 | The SQLAlchemy extension isn't automatic. It requires the user to write SQLAlchemy mappings. |
| GraphJin Service | PostgreSQL, MySQL, Yugabyte | GraphQL | Go | Apache-2.0 | 2904 ★; 928 commits, latest 2024-07-13 | Using GraphJin as a standlone service. Official Docker image. |
| GraphQL Mesh | PostgreSQL (PostGraphile), MongoDB (graphql-compose-mongoose), SQLite 3 (tuql), Neo4j (Neo4j GraphQL Library), MySQL | GraphQL | TypeScript (Node.js) | MIT | 3245 ★; 7382 commits, latest 2024-08-29 | Provides a common GraphQL gateway for different APIs and databases. |
| Hasura GraphQL Engine | PostgreSQL | GraphQL | Haskell | Apache-2.0 | 31021 ★; 8729 commits, latest 2024-08-30 | Official Docker image. |
| HTSQL | MySQL, PostgreSQL, SQLite (free); Oracle, MS SQL (proprietary) | REST | Python 3 | Apache-2.0, proprietary (Oracle and MS SQL support) | 22 ★; 1235 commits, latest 2020-08-11 | |
| InfluxDB | InfluxDB | REST | Go | MIT | 28521 ★; 49304 commits, latest 2024-08-27 | A timeseries database with a built-in REST API. Official Docker image. |
| neo4j-graphql | Neo4j | GraphQL | Kotlin | Apache-2.0 | 450 ★; 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 | 45812 ★; 23976 commits, latest 2024-08-30 | Official Docker image. |
| OrientDB | OrientDB | REST | Java | Apache-2.0 | 4728 ★; 23222 commits, latest 2024-08-28 | A database with a built-in REST API. Official Docker image. |
| PHP-CRUD-API | MySQL, PostgreSQL, MS SQL Server. | REST | PHP 7 | MIT | 3575 ★; 2142 commits, latest 2024-07-29 | Supports GIS + automatic OpenAPI 3.0 docs. |
| PostGraphile | PostgreSQL | GraphQL | TypeScript (Node.js) | MIT | 12541 ★; 10811 commits, latest 2024-08-16 | Formerly "PostGraphQL". Official Docker image. |
| PostgREST | PostgreSQL | REST | Haskell | MIT | 23079 ★; 3787 commits, latest 2024-08-23 | Official Docker image. |
| pREST | PostgreSQL | REST | Go | MIT | 4188 ★; 1993 commits, latest 2024-08-30 | Official Docker image. |
| pRESTige | MySQL | REST | PHP | MIT | 108 ★; 1089 commits, latest 2024-05-31 | |
| RESTHeart | MongoDB | REST | Java | AGPL-3.0 | 799 ★; 4569 commits, latest 2024-08-30 | Official Docker image. |
| restSQL | MySQL, PostgreSQL | REST | Java | MIT | 144 ★; 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 | 1997 ★; 250 commits, latest 2020-12-21 | Official Docker image. |
| Silence | MySQL, MariaDB | REST | Python 3 | MIT | 14 ★; 445 commits, latest 2024-02-14 | 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 | 45 ★; 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 | 1480 ★; 362 commits, latest 2024-06-19 | 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 | 71011 ★; 28990 commits, latest 2024-08-30 | Uses PostgREST. Guide to self-Hosting with Docker. |
| tuql | SQLite 3 or SQL infile | GraphQL | JavaScript (Node.js) | MIT | 1049 ★; 72 commits, latest 2021-06-06 | |
| Webdis | Redis | REST | C | BSD-2-Clause | 2833 ★; 659 commits, latest 2024-05-20 | 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 | 2234 ★; 1919 commits, latest 2024-05-21 | WunderGraph Docs. |
| XTDB | XTDB | REST | Clojure | MIT | 2523 ★; 5736 commits, latest 2024-08-30 | 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 | 67 ★; 283 commits, latest 2018-10-16 | Read-only. |
GitHub stats updated 2024-08-31. The commit count and the latest commit date are for the default branch.
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.