---
title: "List trending repos"
method: GET
path: "/trends/repos/"
tags: ["Trends"]
---

# List trending repos

`GET /trends/repos/`

Trending repos is an open source alternative to GitHub trends, which showcases recently popular open source projects in the GitHub community.

> **Note**
>
> Please URI encode the requested parameters, e.g. `C++` needs to be encoded as `C%2B%2B`.
 
☁️ Daily run on [TiDB Cloud](https://tidbcloud.com/?utm_source=ossinsight&utm_medium=ossinsight_api), analyze upon dataset that has over 6 billion GitHub events.

## Query parameters

- `period` 'past_24_hours' | 'past_week' | 'past_month' | 'past_3_months'
- `language` 'All' | 'JavaScript' | 'Java' | 'Python' | 'PHP' | 'C++' | 'C#' | 'TypeScript' | 'Shell' | 'C' | 'Ruby' | 'Rust' | 'Go' | 'Kotlin' | 'HCL' | 'PowerShell' | 'CMake' | 'Groovy' | 'PLpgSQL' | 'TSQL' | 'Dart' | 'Swift' | 'HTML' | 'CSS' | 'Elixir' | 'Haskell' | 'Solidity' | 'Assembly' | 'R' | 'Scala' | 'Julia' | 'Lua' | 'Clojure' | 'Erlang' | 'Common Lisp' | 'Emacs Lisp' | 'OCaml' | 'MATLAB' | 'Objective-C' | 'Perl' | 'Fortran'

## Response `200`

Default Response

- object
  - `type` 'sql_endpoint', required — The type of the endpoint.
  - `data` object, required
    - `columns` object[], required
      - `col` string, required — The name of the column in the query result.
      - `data_type` 'CHAR' | 'BIGINT' | 'DECIMAL' | 'INT' | 'UNSIGNED BIGINT' | 'TINYINT' | 'TIMESTAMP' | 'TEXT' | 'VARCHAR' | 'DATETIME' | 'DOUBLE' | 'FLOAT' | 'DATE' | 'TIME' | 'YEAR' | 'MEDIUMINT' | 'SMALLINT' | 'BIT' | 'BINARY' | 'VARBINARY' | 'JSON' | 'ENUM' | 'SET' | 'TINYTEXT' | 'MEDIUMTEXT' | 'LONGTEXT' | 'TINYBLOB' | 'MEDIUMBLOB' | 'BLOB' | 'LONGBLOB', required — The data type of the column.
      - `nullable` boolean, required — Whether the column is nullable.
    - `rows` object[], required
      - `repo_id` string — ID of the repo
      - `repo_name` string — Name of the repo
      - `primary_language` string — Primary programing language used by the repo
      - `description` string — Description of the repo
      - `stars` string — Number of stars in the period
      - `forks` string — Number of forks in the period
      - `pull_requests` string — Number of pull requests in the period
      - `pushes` string — Number of pushes in the period
      - `total_score` string — Total score of the repo
      - `contributor_logins` string — Comma separated list of active contributor logins
      - `collection_names` string — Comma separated list of collection names
    - `result` object, required
      - `code` number — The code of the response.
      - `message` string — The message of the response.
      - `start_ms` number — The start time of the query in milliseconds.
      - `end_ms` number — The end time of the query in milliseconds.
      - `latency` string — The latency of the query.
      - `row_count` number — The number of rows in the query result.
      - `row_affect` number — The number of rows affected by the query.
      - `limit` number — The maximum number of rows in the query result.
      - `databases` string[] — The databases used in the query.

---

[API](https://skmtc.net/pingcap/apis/ossinsight-public-api.md) · [All operations](https://skmtc.net/pingcap/apis/ossinsight-public-api/llms.txt) · [OpenAPI document](https://skmtc-service-staging.skmtc.workers.dev/v1/apis/pingcap/ossinsight-public-api/revisions/9eeddbadc4bb/schema)