Answer critical questions about your code with SQL
Connect your Git repositories
Extract data from your code using open-source tools and scanners
Ask and answer questions about your code
1-- count the number of repos using each version of Go 2-- by looking at the version declared in go.mod files 3SELECT 4 dependencies_go_version, 5 SUM(count) AS count 6FROM (SELECT 7 1 AS count, 8 SUBSTRING(public.git_files.contents FROM 'go ([0-9]+.[0-9]+)') AS dependencies_go_version 9 FROM public.git_files 10 INNER JOIN public.repos ON public.repos.id = public.git_files.repo_id 11 WHERE public.git_files.path LIKE '%go.mod' 12) AS t 13GROUP BY dependencies_go_version
Treat your code (and configuration files) like a database to operationalize aspects of the SDLC.
Ensure your organization is always following best practices in the software-development-lifecycle.
Keep tabs on the areas of interest in your engineering organization, across repositories and teams.