Awesome GitHub RepositoriesDatabase Query Translators

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

Cube is a semantic data layer that provides a unified framework for defining business metrics, dimensions, and relationships across diverse data sources. By acting as a headless business intelligence engine, it transforms raw data into a governed model that can be queried via SQL, REST, and GraphQL interfaces. This architecture ensures consistent data definitions and logic across all downstream analytical applications and reporting tools. The platform distinguishes itself through its integrated conversational AI capabilities, which allow users to explore data using natural language. It orches

FerretDB is an open-source database emulator and protocol translator that mimics a MongoDB environment to support existing drivers and client tools on a relational backend. It functions as a stateless database proxy that converts binary wire protocol messages into SQL statements, allowing a relational engine to handle document-oriented requests. The project serves as a migration tool for moving applications from MongoDB to PostgreSQL without rewriting queries or changing client drivers. It achieves this by using PostgreSQL as a document store, storing and querying BSON documents through a tra

PRQL is a functional, modular data transformation language that serves as a compiler for relational data pipelines. It allows developers to write expressive, pipelined queries that are translated into standard SQL dialects. By abstracting complex data manipulation into a readable, sequential syntax, the project enables the construction of maintainable workflows that remain independent of specific database engines. The language distinguishes itself through a robust compilation infrastructure that performs type validation and relational algebra analysis before generating target-specific code. I

phpMyAdmin is a web-based interface for administering MySQL and MariaDB databases. Written in PHP, this relational database administrator allows users to perform common database tasks through a browser instead of a command line. The tool provides a graphical interface for database schema design, including the creation and modification of tables, columns, and indexes. It also enables web-based SQL querying to analyze or modify data and handles general server administration for both MySQL and MariaDB.

CASL is a JavaScript authorization library for defining and enforcing declarative access control rules across both frontend and backend environments. It provides an attribute-based access control system that manages permissions based on user roles and specific object properties. The library is designed for isomorphic access control, allowing a consistent set of permission rules to be shared between a server API and a client interface. It enables the serialization of permission sets as plain data objects to maintain synchronization across these different layers. Its capabilities include trans

SpiceDB is a distributed permission store and relationship-based access control system. It provides a scalable database for storing and querying fine-grained authorization relationships, implementing a consistency model inspired by Google Zanzibar to manage access rights across large-scale applications. The system uses a dedicated schema language to define the rules and logic governing how relationships translate into permissions independently of application code. It functions as a pluggable authorization engine that persists relationship tuples in external relational databases such as Postgr

Dieses Projekt ist eine serverseitige Implementierung zum Rendern interaktiver Datentabellen unter Verwendung des Laravel-Frameworks. Es fungiert als Brücke und API-Wrapper, der Datenbankabfragen auf das spezifische JSON-Format abbildet, das vom jQuery DataTables-Plugin benötigt wird. Das Tool konzentriert sich auf die Handhabung großer Datensätze, indem Paginierung, Filterung und Suche auf dem Server verarbeitet werden, anstatt alle Datensätze in den Browser zu laden. Es übersetzt eingehende HTTP-Anfrageparameter in Datenbankabfragen, um sicherzustellen, dass nur die notwendigen Zeilen abgerufen und serialisiert werden. Die Funktionspalette umfasst Eloquent-basiertes Data-Mapping, automatische Wildcard-Suchinjektion und die Serialisierung von Response-Objekten. Es bietet zudem Diagnose-Utilities für das Debugging von Datenbankabfragen, indem ausgeführte SQL-Statements an API-Antworten angehängt werden. Das Paket bietet integrierte Utilities für den Datenexport und die interaktive Tabellenbearbeitung.

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