Security
Tutorials
Audit CODEOWNERS Against Okta to Find Orphaned Code Ownership with SQL
Find CODEOWNERS entries for employees who left the company by joining Git file content with your identity provider data. No scripts, just SQL.
Joe Karlsson •
Blog
Security
Tutorials
Find Commits by Departed Employees Across All Repos with SQL
Identify code changes made by employees who left your organization. Cross-reference git commit authors against your identity provider to find commits needing review.
Joe Karlsson •
Security
Tutorials
Find Every repo Missing a LICENSE File with One SQL Query
Identify repositories without LICENSE files across your organization using SQL. No cloning required, no scripts to maintain - just query your git file data.
Joe Karlsson •
Product News
Find EOL Docker Images, Missing Licenses, and Stale CODEOWNERS Across Thousands of repos with SQL
Query your Dockerfiles, CODEOWNERS, and package.json files across all repos with SQL. No cloning, no custom scripts - just SQL queries that find EOL images, missing licenses, and outdated dependencies in seconds.
Joe Karlsson •
Security
Tutorials
Query Your Dockerfiles with SQL: Find EOL Node 18 Images Across All repos
Node 18 reached end-of-life. Find every Dockerfile using Node 18 base images across your organization with a single SQL query - no cloning repos required.
Joe Karlsson •
Product News
SQL
Track React Dependencies Across Your Organization with SQL
Find every package.json using React across all repositories. Query dependency versions, track upgrades, identify outdated packages - all with SQL.
Joe Karlsson •
Cloud Infrastructure
FinOps
Tutorials
Centralize Multi-Cloud Cost and Asset Data in BigQuery: A Step-by-Step Guide
Sync AWS, GCP, and Azure cost and asset data into BigQuery with CloudQuery. Complete setup guide with SQL queries for cross-cloud analysis.
Adam Cobb, +1 •
AWS
GCP
Security
Tutorials
How to Inventory All Public IP Addresses Across AWS and GCP using CloudQuery
Track every public IP across AWS and GCP in minutes using SQL. Find exposed EC2 instances, unused Elastic IPs, and GCP Compute resources with a single query instead of manual API calls.
Adam Cobb, +1 •