Log inSign upAdd Service
OSS Insight logo

OSS Insight

Popularity

2 out of 5 levels

about 20K users per month
Visit

Service information

Plans

free

Platforms

websiteAPI

Description

OSS Insight is a free online service that helps translate questions into SQL and visualize results. It's available through the website or API and offers deep insight into developers and repos on GitHub, including stars, pull requests, issues, pushes, comments, and reviews. With around 70,000 monthly visits, it provides real-time trending repositories and analyzes massive events from GitHub.

👀📊
visualize data
💾🌐
translate question into sql

Examples

📊👀

Visualize Data

#1
inputs
outputs

SELECT

 `gr`.`repo_name` AS `repo_name`,

 COUNT(*) AS `stars`,

 `gr`.`description` AS `description`

FROM

 `github_events` AS `ge`

 INNER JOIN `github_repos` AS `gr` ON `ge`.`repo_id` = `gr`.`repo_id`

WHERE

 `ge`.`type` = 'WatchEvent'

 AND `ge`.`action` = 'started'

 AND YEAR(`ge`.`created_at`) >= 2020

 AND (

  LOWER(`gr`.`description`) LIKE LOWER('%data science%')

  OR LOWER(`gr`.`description`) LIKE LOWER('%ML%')

 )

GROUP BY

 `gr`.`repo_name`

ORDER BY

 `stars` DESC

LIMIT

 10

#2
inputs
outputs

SELECT

 DATE_FORMAT(`ge`.`created_at`, '%Y-%m-01') AS `t_month`,

 COUNT(*) AS `stars`

FROM

 `github_events` AS `ge`

WHERE

 `ge`.`type` = 'WatchEvent'

 AND `ge`.`repo_id` IN (

  SELECT

   `repo_id`

  FROM

   `github_repos`

  WHERE

   LOWER(`description`) LIKE LOWER('%mlops%')

 )

GROUP BY

 `t_month`

ORDER BY

 `t_month` ASC

LIMIT

 200

#3
inputs
outputs

WITH

 `prs` AS (

  SELECT

   DATE_FORMAT(`ge`.`created_at`, '%Y-%m-01') AS `t_month`,

   COUNT(*) AS `prs`

  FROM

   `github_events` AS `ge`

  WHERE

   `ge`.`type` = 'PullRequestEvent'

   AND `ge`.`action` = 'opened'

   AND `ge`.`repo_id` IN (

    SELECT

     `repo_id`

    FROM

     `github_repos`

    WHERE

     `owner_login` = 'twitter'

    LIMIT

     50

   )

  GROUP BY

   `t_month`

  ORDER BY

   `t_month` ASC

 ),

 `issues` AS (

  SELECT

   DATE_FORMAT(`ge`.`created_at`, '%Y-%m-01') AS `t_month`,

   COUNT(*) AS `issues`

  FROM

   `github_events` AS `ge`

  WHERE

   `ge`.`type` = 'IssuesEvent'

   AND `ge`.`action` = 'opened'

   AND `ge`.`repo_id` IN (

    SELECT

     `repo_id`

    FROM

     `github_repos`

    WHERE

     `owner_login` = 'twitter'

    LIMIT

     50

   )

  GROUP BY

   `t_month`

  ORDER BY

   `t_month` ASC

 )

SELECT

 `prs`.`t_month`,

 `prs`.`prs`,

 `issues`.`issues`

FROM

 `prs`

 LEFT JOIN `issues` ON `prs`.`t_month` = `issues`.`t_month`

ORDER BY

 `prs`.`t_month` ASC

LIMIT

 200

Features

  • It can track GitHub events in real-time.
  • It provides language-specific insights.
  • It offers monthly and historical rankings.
  • It generates curated repository lists.
  • It delivers activity and engagement metrics.

Perfect for

  • Data analysts could find it really handy.
  • Technical researchers might find it useful.
  • Developers could make good use of this service.

Similar services

WELD preview
Weld logo
OSS Insight preview
OSS Insight logo
Rose preview
Rose logo
JSON Crack Editor preview
JSON Crack logo
Share this page: