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 ist ein Rapid-Application-Framework auf Basis von Flask, das die Erstellung von Admin-Interfaces und datenbankgesteuerten Anwendungen automatisiert. Es fungiert als automatischer CRUD-Generator und SQL-Datenbank-Admin-Interface, das die Generierung von Benutzeroberflächen und REST-APIs direkt aus Datenmodellen ermöglicht. Das Framework enthält ein Sicherheitssystem zur Verwaltung von Benutzeridentitäten und Zugriffsrollen durch rollenbasierte Zugriffskontrolle (RBAC). Es unterstützt die Authentifizierung über interne Datenbanken oder externe Anbieter wie LDAP, OAuth und OpenID. Die Plattform deckt breitere Funktionen ab, einschließlich Multi-Dialekt-Datenbankkonnektivität, Modell-Audit-Tracking und Internationalisierung von Benutzeroberflächeninhalten. Zudem bietet sie Tools zur Datenvisualisierung durch Diagramme, Dateiupload-Handling und dynamische Menügenerierung basierend auf Benutzerberechtigungen.

supabase-js ist eine umfassende Client-Bibliothek, die entwickelt wurde, um Frontend-Anwendungen mit einem gehosteten Backend-as-a-Service zu integrieren. Sie bietet ein einheitliches Interface für die Interaktion mit einer PostgreSQL-Datenbank, Identitätsmanagementsystemen, Cloud-Objektspeicherung und Echtzeit-Datensynchronisierung. Die Bibliothek bietet ein isomorphes Client-Design, das sowohl in Browser- als auch in Serverumgebungen funktioniert. Sie zeichnet sich durch einen Typ-sicheren Ansatz aus, nutzt TypeScript, um Datenbankschemata direkt auf Client-seitige Definitionen zu mappen, und verwendet eine PostgREST-basierte API, um JavaScript-Aufrufe in RESTful-Requests zu übersetzen. Der Client deckt ein breites Spektrum an Funktionen ab, einschließlich Nutzerauthentifizierung via OAuth, OIDC und Passkeys sowie Sitzungsmanagement unter Verwendung signierter Token. Er verwaltet große Binärdaten über ein S3-kompatibles Speicher-Interface und ermöglicht Live-Anwendungsupdates via WebSocket-basierter Abonnements für Datenbankänderungen und Präsenzsynchronisierung. Zusätzliche Funktionalität umfasst den Aufruf von Serverless-Edge-Functions und die Durchführung von Ähnlichkeitssuchen unter Verwendung von Vektor-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