velocirepo

Track your open-source project's pulse across package registries, GitHub, and the web.

Overview

velocirepo collects metrics from multiple sources, stores them as JSONL files, and exposes them via SQL (powered by DuckDB). It's designed to run on a schedule (e.g., nightly via GitHub Actions) and commit the results to git, giving you a permanent record of your project's growth.

Supported sources:

Highlights

• Git-native storage — JSONL files committed to your repo as a permanent, versioned history
• SQL-powered queries — DuckDB under the hood with built-in views for metrics, events, content, and indicators
• Growth indicators — automatic 28-day growth rate and trend computation
• Dashboards & reports — pluggable Views system supporting Quarto, Marimo, Jupyter, R, and ggsql
• AI-ready — built-in MCP server for conversational access from Claude and other assistants
• Zero-config CI — runs as a GitHub Action with one-command workflow generation
• Badges — auto-generated shields.io-style SVG badges from your live data
• Export anywhere — Parquet, CSV, DuckDB file for use with pandas, Polars, R, Observable, and more

Quick start

# Install
brew install posit-dev/tap/velocirepo

# Initialize config (auto-detects sources)
velocirepo init

# Fetch metrics
velocirepo fetch

# Query with SQL
velocirepo query "SELECT project, SUM(value) AS stars FROM metrics WHERE metric = 'daily_stars' GROUP BY project ORDER BY stars DESC LIMIT 5"

Documentation

Full documentation is available at posit-dev.github.io/velocirepo:

• Installation — GitHub Actions, Homebrew, uv, Go, and more
• Configuration — set up velocirepo.toml and authentication
• Data Storage — how metrics, events, and content are stored
• Querying Data — SQL queries with examples
• Exporting — Parquet, CSV and DuckDB export and tool integrations
• Data Dictionary — a data-dict.yaml of the export, for agents and people
• Indicators — growth rate and trend computation
• Badges — generate SVG badges
• Views — dashboards and reports
• MCP Server — AI assistant integration
• CLI Reference — all commands

License

MIT