AskGit

Query Bitbucket Git Repos w/ SQL

Or install directly using https://bitbucket.askgit.com/connect.json

Made by Augmentable Software (augmentable.io)

Examples

1
2

-- get every commit id in the current history
SELECT id FROM commits

1
2

-- get top commit counts by author (name)
SELECT count(*) AS count, author_name FROM commits GROUP BY author_name ORDER BY count DESC

 -- print a bar chart of total commit distribution percentage (by author name)
WITH total_commits(total) AS (
  SELECT count(*) AS total FROM commits
)
SELECT
  author_name,
  round(count(*)*100.0 / (SELECT total FROM total_commits), 2) AS percentage,
  printf('%.' || (CAST (round(count(*)*100.0 / (SELECT total FROM total_commits)) AS INT) + 1) || 'c', '█') AS commits
FROM commits GROUP BY author_name
ORDER BY percentage DESC