8 repositorios
Tools for creating and organizing data queries.
Distinguishing note: Focuses on query lifecycle management rather than database storage.
Explore 8 awesome GitHub repositories matching data & databases · Data Query Management. Refine with filters or upvote what's useful.
ToolJet is a low-code development platform designed for building and deploying internal business applications. It provides a visual interface where users can drag and drop components to design layouts, connect to various data sources, and execute custom logic. The platform is built on a containerized architecture, ensuring that applications remain portable and consistent across different cloud and server environments. The platform distinguishes itself through integrated artificial intelligence capabilities that assist in the generation of user interfaces, database schemas, and data queries fr
Builds new data queries by selecting from available sources within a dedicated interface.
dbt-core is a command-line framework for transforming data within a warehouse using modular SQL and version control. It functions as a data transformation engine that enables users to define data structures and business logic through declarative configuration files, which the system then compiles into executable code. By managing complex data dependencies through a directed acyclic graph, it ensures that transformation tasks execute in the correct order while maintaining a manifest-driven state to track lineage and execution history. The project distinguishes itself through an adapter-based d
Stores and retrieves frequently used query definitions to ensure consistent reporting across teams.
Citus is a PostgreSQL extension that transforms a standard database into a distributed system. It functions as a sharding framework and distributed SQL engine, enabling horizontal scaling by partitioning tables across a cluster of nodes. By utilizing a coordinator-worker topology, the system manages metadata and routes queries to the appropriate nodes, allowing for parallel execution of complex operations across distributed data shards. The platform distinguishes itself through its specialized support for multi-tenant architectures and real-time analytical processing. It enables tenant-based
Creates pre-aggregated tables at defined time intervals to speed up analytical queries and reduce storage requirements.
Rerun is a multimodal data visualizer and robotics data logger designed for rendering synchronized streams of 3D spatial data, images, and time-series metrics. It functions as a tool for capturing high-frequency sensor data and AI outputs into a queryable columnar format, providing a dedicated interface for viewing MCAP recording files and analyzing physical environments. The project distinguishes itself as a machine learning dataset streamer, capable of feeding logged recordings directly into GPU buffers and PyTorch training pipelines without intermediate exports. It supports a high-performa
Includes tools for retrieving and transforming multimodal data from a catalog for local analysis and team management.
This project is a Go client library and API wrapper for interacting with Elasticsearch clusters. It serves as a programmatic interface for managing documents, indices, and cluster health, allowing Go applications to perform search and indexing operations via the REST API. The library functions as a distributed search orchestrator, providing specialized tools for high-throughput data ingestion and cluster administration. It features a buffered bulk processor with exponential backoff retries for optimizing write performance and supports automated index lifecycle transitions and historical data
Summarizes historical data into compact forms by creating and controlling rollup jobs.
Este proyecto es un kit de desarrollo de software (SDK) y una herramienta de gestión de clústeres para PHP. Sirve como SDK de búsqueda de texto completo e interfaz de búsqueda vectorial, permitiendo a las aplicaciones realizar búsquedas léxicas, difusas y semánticas sobre datos indexados. La librería implementa un cliente HTTP PSR 7 para garantizar la compatibilidad entre entornos mediante interfaces de mensajería estandarizadas. Proporciona una interfaz especializada para recuperar embeddings y realizar flujos de trabajo de recuperación semántica utilizando datos vectoriales. Su superficie de capacidades abarca una amplia gama de tareas administrativas y operativas, incluyendo la gestión de índices de búsqueda, monitoreo de salud del clúster y operaciones del ciclo de vida de documentos. Admite diversos métodos de consulta como SQL, EQL y ES|QL, junto con agregación de datos y análisis geoespacial. Además, proporciona herramientas para la orquestación de machine learning, detección de anomalías y gestión de identidad y acceso.
Manages automated rollup jobs to summarize historical data into searchable indices for accelerated analytical queries.
TablePro is a cross-platform database management client designed for browsing, querying, and administering both SQL and NoSQL databases. It functions as a unified workspace that integrates a code-centric SQL editor with schema visualization tools, allowing developers to manage complex data models and execute queries across diverse database engines. The application distinguishes itself through an agentic AI integration layer that connects language models directly to database tools, enabling automated query generation, optimization, and error fixing with configurable approval gates. It features
Executes GoogleSQL queries and provides a data grid for browsing, editing, and deleting rows across datasets and tables.
Ahoy es un framework de análisis de primera parte para aplicaciones Ruby on Rails. Proporciona herramientas para capturar comportamientos de usuario y vistas de página, permitiendo a los desarrolladores mantener la propiedad total de sus datos de análisis. El sistema se distingue por el análisis de datos relacionales, que vincula los identificadores de visita directamente a los modelos de aplicación para una atribución profunda de objetos de negocio. Incluye una herramienta de seguimiento que preserva la privacidad que utiliza enmascaramiento de direcciones IP y agrupación de visitantes sin cookies para anonimizar los datos del usuario. El proyecto cubre una amplia gama de capacidades de análisis, incluyendo seguimiento de eventos personalizados, resolución de ubicación geográfica mediante geocodificación IP y análisis de embudo de usuario. Gestiona los datos a través de la persistencia en bases de datos relacionales y utiliza rollups pre-agregados para mantener el rendimiento de las consultas en grandes datasets. Las características de infraestructura adicionales incluyen enrutamiento de mensajes asíncrono, filtrado de tráfico a nivel de middleware para excluir bots y una API dedicada para recopilar datos de clientes móviles o externos.
Summarizes high-volume event data into periodic totals to maintain fast query performance on large datasets.