6 Repos
Capabilities for defining business KPIs and metrics using SQL queries executed against a data warehouse.
Distinguishing note: Candidates focus on SQL functions or pipeline definitions, not the definition of business metrics for analytics.
Explore 6 awesome GitHub repositories matching data & databases · SQL Metric Definitions. Refine with filters or upvote what's useful.
This project is a library of prompt-based skill definitions and functional extensions for AI assistants. It provides a system for automating product management tasks and strategic workflows by integrating specialized capabilities into coding agents and command line interfaces. The toolset utilizes a collection of standardized templates and guided processes to execute product management frameworks. These include tools for product discovery, market analysis, and business viability modeling, allowing users to chain analytical skills into end-to-end automated processes. The capability surface co
Provides tools for establishing North Star metrics and key performance indicators to measure product success.
GrowthBook is a feature flagging and experimentation platform that utilizes a warehouse-native approach to data analysis. It serves as a system for managing feature rollouts and conducting A/B tests by executing SQL queries directly against existing data warehouses to calculate experiment results. The platform is distinguished by its integration of a Model Context Protocol server, which allows AI coding assistants and IDEs to manage flags and query analytics using natural language. It also provides specialized capabilities for AI model optimization, enabling the testing of prompts and models
Creates business KPIs using SQL to track conversion, latency, retention, and revenue directly from a warehouse.
Perfetto is a platform for system-level performance tracing and analysis on Linux and Android. It combines a high-throughput trace recorder, a SQL-based query engine, and a browser-based visualizer into a single toolchain. The platform covers CPU scheduling and call-stack profiling, native and Java heap memory allocation tracking, GPU and graphics events, and system-wide counters such as CPU frequency and power consumption. The architecture decouples trace recording from offline analysis, using a compact protobuf format for event encoding and columnar storage for efficient SQL queries. The we
Generates multiple related trace metrics from a single reusable query specification.
Flagger is a Kubernetes operator designed to automate the lifecycle of application deployments through progressive delivery. It functions as a controller that monitors custom resource definitions to orchestrate complex release strategies, including canary, blue/green, and A/B testing. By continuously reconciling the desired cluster state with the actual environment, it ensures that deployments adhere to defined specifications while managing the underlying infrastructure required for traffic routing. The project distinguishes itself through a sophisticated metric-driven analysis loop that eval
Provides reusable query definitions to measure performance indicators across different application versions.
Supersonic ist eine LLM-basierte Datenanalyseplattform und eine Engine für semantische Layer, die natürlichsprachliche Fragen in ausführbare SQL-Abfragen übersetzt. Sie fungiert als Business-Intelligence-Dashboard und Text-zu-SQL-Schnittstelle, die es Benutzern ermöglicht, Geschäftskennzahlen und Erkenntnisse über eine Konversationsschnittstelle abzurufen. Das System entkoppelt Geschäftsdefinitionen von physischen Datenbankschemata, indem es einen verwalteten logischen Layer verwendet, um einheitliche Metriken und Dimensionen zu definieren. Diese semantische Modellierung ermöglicht es der Plattform, menschliche Sprachmuster auf kuratierte Modelle abzubilden und abstrakte semantische Aussagen in physisches SQL zu übersetzen, das auf spezifische Datenbank-Engines zugeschnitten ist. Die Plattform bietet ein Enterprise-Data-Gateway mit rollenbasierter und granularer Zugriffskontrolle auf Datensatz-, Spalten- und Zeilenebene. Zu ihren Fähigkeiten gehören Multi-Turn-Dialogmanagement, Multi-Datenbank-Konnektivität und eine Plugin-Architektur für die Integration von Drittanbieter-Tools. Das Projekt stellt seine Funktionalität über eine Headless-Programmatic-API und eine Semantic-Layer-API für den externen Datenkonsum bereit.
Allows the creation of new metrics based on existing measures or field expressions to expand analysis.
DevLake is a DevOps data platform and analytics tool designed to orchestrate data pipelines that ingest, transform, and sync metadata from external development tools into a unified database. It functions as a system for collecting and normalizing data from source control, CI/CD pipelines, and issue trackers into a standardized schema to enable consistent software delivery analytics. The platform distinguishes itself by transforming tool-specific data into a common domain model, allowing for the calculation of engineering metrics via SQL. It provides specialized frameworks for measuring DORA m
Calculates engineering performance indicators by executing SQL queries against a normalized relational database.