open-digger

Reference for the OpenDigger ClickHouse database schema (database `opensource`). Use this skill when writing, reviewing, or debugging SQL against the OpenDigger backend store — e.g. querying the `events` table, OpenRank/contribution rankings (`global_openrank`, `community_openrank`, `normalized_community_openrank`), repo/user metadata (`repo_info`, `user_info`), labels, location data, or AI analysis tables (`issue_info`, `pull_info`). It explains every core table's purpose, engine, sort/partition keys, key columns, the materialized views, and how the tables relate, so you can write correct, performant ClickHouse queries.

Retrieve OpenDigger open-source metric data via public URLs. Use this skill when the user wants to query open-source metrics for a repository, developer, or project (e.g. OpenRank, activity, attention, stars, contributors, PR/issue stats, collaboration networks, or project/repo leaderboards). It explains the public OSS endpoints, URL patterns, supported platforms, the full metric catalog, and the JSON data formats so you can fetch and interpret the data directly without authentication.