Awesome GitHub RepositoriesDatabase-to-REST Interfaces

PostgREST is a standalone web server that automatically transforms a PostgreSQL database into a RESTful API. It serves as an API gateway that translates HTTP requests into SQL queries, mapping the database schema directly to endpoints without the need for manual route definitions. The system utilizes a JWT authentication layer to validate user identities and map incoming web requests to specific database roles. This allows the server to delegate authorization and permission enforcement to the internal PostgreSQL role system. It includes a generator for OpenAPI specifications to provide stand

PostgREST is a standalone server process that automatically transforms a relational database schema into a fully functional RESTful API. By querying system catalogs at startup, it maps tables, views, and stored procedures into standardized web endpoints, allowing developers to build backend services by focusing exclusively on database design. The service functions as a declarative engine that translates HTTP requests and query parameters directly into native SQL operations. It maintains stateless request processing and integrates connection pooling to manage high-frequency interactions effici

React-admin is a framework for building data-driven administrative interfaces that connect to REST or GraphQL backends. It provides a comprehensive suite of tools for managing the full lifecycle of administrative applications, including resource-oriented routing, declarative form scaffolding, and context-driven state management. By utilizing a modular adapter-based architecture, the framework abstracts backend communication, allowing developers to build consistent CRUD interfaces that handle data fetching, authentication, and synchronization automatically. The project distinguishes itself thr

Figma-Context-MCP is a design-to-code automation tool that functions as a server for the Model Context Protocol. It acts as a bridge between visual design platforms and development environments, enabling large language models to access design file metadata and component properties directly. The project distinguishes itself by providing a standard-compliant interface that translates design specifications into structured data. By extracting layout and styling information, it facilitates the programmatic conversion of design tokens and component requirements into actionable code structures. Thi

This project is a database driver and interface for the Go programming language, specifically designed for PostgreSQL. It provides a low-level library for executing SQL queries, managing transactions, and handling data persistence within Go applications. The driver distinguishes itself by implementing the native PostgreSQL binary wire protocol, which minimizes communication overhead and maximizes data transfer efficiency. It includes advanced connection pooling to maintain persistent database sessions and supports prepared statement caching to accelerate the execution of frequently repeated o

LoopBack is a Node.js API framework used to build RESTful services and backend applications. It functions as a model-driven API generator that automatically maps predefined data models to network endpoints to create standardized web interfaces. The project features a database abstraction layer that unifies access across diverse SQL databases, NoSQL stores, and remote data sources. It includes a backend application scaffolder using command-line generators to automate the creation of project structures and data connectors. Additionally, it provides an API authentication system to manage applica

This project provides a standardized RESTful API for accessing comprehensive aerospace mission records and space exploration data. It serves as a structured interface for retrieving historical and upcoming launch details, hardware specifications, and media assets, while also providing real-time tracking for satellite orbital paths. The service distinguishes itself through a robust architecture designed for high-performance data retrieval. It utilizes in-memory response caching to reduce latency and server load, alongside query-parameter-based filtering that allows users to precisely control t

Eve is a REST API framework that maps database collections to web resources through declarative configuration files. It functions as a database-to-API mapper, automatically exposing data as RESTful endpoints with built-in support for CRUD operations and schema-based request validation. The project distinguishes itself through a HATEOAS API engine that generates hypermedia links and resource schemas for dynamic client discovery. It also includes an automated Swagger documentation generator that produces interactive specifications for client SDK generation and testing. The framework provides a

Flask-AppBuilder est un framework d'application rapide construit sur Flask qui automatise la création d'interfaces d'administration et d'applications pilotées par base de données. Il fonctionne comme un générateur CRUD automatique et une interface d'administration de base de données SQL, permettant la génération d'interfaces utilisateur et d'API REST directement à partir de modèles de données. Le framework inclut un système de sécurité pour gérer les identités des utilisateurs et les rôles d'accès via un contrôle d'accès basé sur les rôles (RBAC). Il prend en charge l'authentification via des bases de données internes ou des fournisseurs externes tels que LDAP, OAuth et OpenID. La plateforme couvre des capacités plus larges, notamment la connectivité de base de données multi-dialectes, le suivi d'audit des modèles et l'internationalisation du contenu de l'interface utilisateur. Elle fournit également des outils pour la visualisation de données via des graphiques, la gestion des téléchargements de fichiers et la génération de menus dynamiques basés sur les permissions des utilisateurs.

supabase-js est une bibliothèque client complète conçue pour intégrer des applications frontend avec un backend-as-a-service hébergé. Elle fournit une interface unifiée pour interagir avec une base de données PostgreSQL, des systèmes de gestion des identités, le stockage d'objets cloud et la synchronisation de données en temps réel. La bibliothèque présente une conception client isomorphe qui fonctionne à la fois dans les environnements navigateur et serveur. Elle se distingue par une approche typée, utilisant TypeScript pour mapper les schémas de base de données directement aux définitions côté client, et emploie une API basée sur PostgREST pour traduire les appels JavaScript en requêtes RESTful. Le client couvre un large éventail de capacités, incluant l'authentification utilisateur via OAuth, OIDC et passkeys, ainsi que la gestion de session utilisant des jetons signés. Il gère des données binaires à grande échelle via une interface de stockage compatible S3 et permet des mises à jour d'application en direct via des abonnements basés sur WebSocket pour les changements de base de données et la synchronisation de présence. Une fonctionnalité supplémentaire inclut l'invocation de fonctions edge serverless et l'exécution de recherches de similarité utilisant des plongements vectoriels (vector embeddings).

This project is a PHP SQL REST API generator and database API wrapper that automatically transforms SQL database tables into a functional web interface. It serves as a lightweight layer that maps HTTP methods to SQL commands, allowing for the creation, reading, updating, and deletion of records without writing manual endpoint code. The tool distinguishes itself by providing a dedicated spatial data API gateway for querying and exporting geometry columns using GeoJSON and WKT standards. It also functions as a multi-tenant data API, capable of isolating records for different users through share

Martin is a geospatial data API and vector tile server that delivers map tiles, styles, sprites, and glyphs to web map clients. It functions as a PostGIS vector tile server, generating tiles directly from databases, as well as serving data from MBTiles and PMTiles files. The project distinguishes itself through a specialized command line interface for managing MBTiles archives, allowing users to validate, compare, and merge offline map data. It also provides dynamic map styling capabilities, including the generation of signed distance field sprites for runtime recoloring and the on-the-fly pr

This project is a Model Context Protocol server and AI agent database connector. It provides a standardized communication layer that allows language models to interact with relational data stores, read database schemas, and manage PostgreSQL database resources. The implementation acts as a serverless host for the Model Context Protocol, deploying on distributed edge functions to connect AI assistants to a project. This enables AI agents to perform database administration, execute SQL queries, and handle schema migrations through an AI-compatible interface. The system covers broader capabilit

Data API builder is a service that automatically generates REST and GraphQL endpoints directly from database schemas and stored procedures. By interpreting database metadata, it provides immediate programmatic access to information without requiring the development of custom backend routes or manual query logic. The engine distinguishes itself through a metadata-driven translation layer that maps incoming HTTP requests to native database queries while enforcing granular, role-based access control and row-level security policies. It includes a dedicated bridge for AI agents, allowing these sys