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 — Tutorials
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 •
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 •
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 •
AWS
Cloud Infrastructure
Tutorials
Finding AWS Lambda Functions Affected by Node.js 20.x End-of-Life
Identify Lambda functions using Node.js 20.x runtime before April 2026 EOL using CloudQuery across multiple AWS accounts
Joe Karlsson •
AWS
Azure
GCP
Security
Tutorials
How to Find Internet-Facing Cloud Assets in AWS, Azure and GCP
Find all internet-facing cloud resources across AWS, Azure, and GCP with SQL queries. Identify exposed VMs, storage, databases, and load balancers to reduce your attack surface.
Adam Cobb •