Know Your Code.

Answer critical questions about your code with SQL

Try a Demo Single Tenant Cloud

Connect your repos

Connect your Git repositories

Extract and sync data

Extract data from your code using open-source tools and scanners

Know your code 🎉

Ask and answer questions about your code

Example Use Cases & Queries

Tracking language versions across repos makes it easier to understand what language features and patterns may be available to use. It's also a way to surface out of date projects and tech debt.

Learn More

What versions of Go are in use across repos?

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

What versions of Go are in use across repos?

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

Use cases

Code querying

Treat your code (and configuration files) like a database to operationalize aspects of the SDLC.

Audit and compliance

Ensure your organization is always following best practices in the software-development-lifecycle.

Engineering transparency

Keep tabs on the areas of interest in your engineering organization, across repositories and teams.

Why SQL?

MergeStat interface showing list of Git repositories

Data-informed software development

MergeStat enables SQL queries on the tools and processes involved in building and shipping software.

Use data to inform decisions, support arguments, and work more efficiently.

MergeStat interface showing a SQL query running and a chart showing the results

Tailored specifically to you

Leverage the flexibility of SQL to ask the questions that matter to you.

Existing tools tell you what to care about, MergeStat lets you decide what's important.

Run MergeStat on your terms

MergeStat can run on most infrastructure. Ours or yours.

Open Source

Fully open-source and self-deployable on any infrastructure to ensure security/privacy

View On GitHub Documentation

Cloud

Single tenant

A hosted instance of our open source stack, managed and operated by MergeStat

Get a cloud instance

Join our newsletter

Get notified about the latest news from MergeStat