Automatically Generate REST and GraphQL APIs From Your Database

1. Directus

   1 220 29,591 9.9 TypeScript

   The flexible backend for all your projects 🐰 Turn your DB into a headless CMS, admin panels, or apps with a custom UI, instant APIs, auth & more.

   

   Some solutions are flexible to handle multiple types of databases. Often allowing you to combine them into a single API. We already mentioned Dreamfactory, but others include Apinizer, Directus, and sandman2.

2. CodeRabbit

   coderabbit.ai featured

   CodeRabbit: AI Code Reviews for Developers. Revolutionize your code reviews with AI. CodeRabbit offers PR summaries, code walkthroughs, 1-click suggestions, and AST-based analysis. Boost productivity and code quality across all major languages with each PR.

   

3. zenstack

   2 55 2,402 9.5 TypeScript

   Fullstack TypeScript toolkit that enhances Prisma ORM with flexible Authorization layer for RBAC/ABAC/PBAC/ReBAC, offering auto-generated type-safe APIs and frontend hooks.

   

   Prisma combined with ZenStack offers a more programmatic approach. While requiring more setup than PostgREST, it provides better TypeScript integration and more control over the generated API. This combination excels in projects where type safety and custom business logic are priorities.

4. sandman2

   3 4 2,020 0.0 Python

   Automatically generate a RESTful API service for your legacy database. No code required!

   

   Some solutions are flexible to handle multiple types of databases. Often allowing you to combine them into a single API. We already mentioned Dreamfactory, but others include Apinizer, Directus, and sandman2.

5. Prisma

   4 477 41,614 9.8 TypeScript

   Next-generation ORM for Node.js & TypeScript | PostgreSQL, MySQL, MariaDB, SQL Server, SQLite, MongoDB and CockroachDB

   

   Prisma combined with ZenStack offers a more programmatic approach. While requiring more setup than PostgREST, it provides better TypeScript integration and more control over the generated API. This combination excels in projects where type safety and custom business logic are priorities.

6. supabase

   5 868 79,803 10.0 TypeScript

   The open source Firebase alternative. Supabase gives you a dedicated Postgres database to build your web, mobile, and AI applications.

   

   You can't talk about REST APIs for Postgres without mentioning Supabase's excellent REST API they generate over your database using PostgREST.

7. wundergraph

   6 110 2,326 7.4 TypeScript

   WunderGraph is a Backend for Frontend Framework to optimize frontend, fullstack and backend developer workflows through API Composition.

   

   Wundergraph

8. DreamFactory

   7 6 1,591 8.6 Shell

   DreamFactory API Generation Platform - API Wrapper for SQL Server, Snowflake, MySQL, and more!

   

   DreamFactory provides comprehensive API generation for MySQL databases. It includes features like API key management, role-based access control, and the ability to combine multiple data sources into a single API. The platform also supports custom scripting for cases where generated endpoints need modification.

9. SaaSHub

   www.saashub.com featured

   SaaSHub - Software Alternatives and Reviews. SaaSHub helps you find the best software and product alternatives

   

10. dgraph

    8 36 20,731 9.4 Go

    high-performance graph database for real-time use cases

    

    Dgraph

11. InfluxDB

    9 33 29,690 9.7 Rust

    Scalable datastore for metrics, events, and real-time analytics

    

    InfluxDB

12. webdis

    10 4 2,878 5.0 C

    A Redis HTTP interface with JSON output

    

    Webdis (Redis)

13. examples

    11 20 44 3.3 TypeScript

    Quickstart examples of different tooling and stacks in combination with StepZen. (by stepzen-dev)

    

    StepZen and AWS AppSync excel at generating GraphQL APIs for MySQL and NoSQL databases. StepZen simplifies the process of combining multiple data sources, while AppSync provides smooth integration with AWS services and real-time data capabilities.

14. postgrest

    12 112 24,887 9.5 Haskell

    REST API for any Postgres database

    

    PostgREST stands out as the leading solution for PostgreSQL databases. It turns your database directly into a RESTful API with minimal configuration. The tool automatically creates endpoints for tables and views, supports complex filters, and leverages PostgreSQL's row-level security for fine-grained access control. If you'd like to see this in action, check out our Neon PostgresQL sample.

15. Hasura

    13 234 31,415 9.9 TypeScript

    Blazing fast, instant realtime GraphQL APIs on all your data with fine grained access control, also trigger webhooks on database events.

    

    Hasura and PostGraphile lead the PostgreSQL GraphQL landscape. Hasura provides real-time subscriptions and a powerful permissions system, while PostGraphile offers deep PostgreSQL integration and excellent performance for complex queries.

16. aws-appsync-community

    14 36 509 0.0 HTML

    The AWS AppSync community

    

    StepZen and AWS AppSync excel at generating GraphQL APIs for MySQL and NoSQL databases. StepZen simplifies the process of combining multiple data sources, while AppSync provides smooth integration with AWS services and real-time data capabilities.

17. SaaSHub

    www.saashub.com featured

    SaaSHub - Software Alternatives and Reviews. SaaSHub helps you find the best software and product alternatives

    

Suggest a related project