OSS Insight

OSS Insight is a live, open-source intelligence service that turns GitHub events into interactive, ready-to-query datasets. The platform continuously ingests every public GitHub event—commits, pull requests, issues, releases, stars, forks, etc.—through TiDB Cloud’s serverless HTAP engine, then exposes the data via a no-login web portal and a free GraphQL API. Users can run ad-hoc SQL on more than 5 billion rows in seconds, or click pre-built dashboards to watch rankings, growth curves and dependency networks update in real time.

Main features
1. Ready-made datasets: six canonical tables (events, users, repos, commits, pull_requests, issues) updated every few minutes; no ETL work required.
2. Instant SQL analytics: browser-based editor with schema hints, shared snippets and sub-second results powered by TiDB’s columnar storage.
3. Interactive explorer pages: one-click visualizations for “Top Languages”, “Fastest Growing Repos”, “Most Active Contributors”, “Repo Dependency Graph”, etc.; all charts are embeddable.
4. Deep repo insights: language composition, contributor geography, issue response time, PR cycle, star velocity and fork genealogy for any repository.
5. Developer ranking & comparison: personal dashboards that aggregate commits, PRs, reviews and issues across organizations; side-by-side diff for two developers or repos.
6. Free public API: GraphQL endpoint with 100 k requests/month quota, plus language SDKs (JavaScript, Python) and example notebooks.
7. Live data freshness: events appear in the database within 5 minutes of GitHub firehose delivery; historical data reaches 2011.
8. Zero-setup: no registration, no credit card, no local download; entire service runs on TiDB Cloud serverless tier.