The CloudQuery CircleCI plugin extracts CI data from CircleCI and loads it into any supported CloudQuery destination
Publisher
cloudquery
Latest version
v1.0.0
Type
Source
Platforms
Date Published
Loading plugin documentation
CloudQuery's use of cookies
We use tracking cookies to understand how you use the product and help us improve it. Your consent is required before we can enable these cookies. You can opt out via the link in the footer.
api_token field in the plugin spec configuration:spec:
api_token: "${CIRCLECI_API_TOKEN}"
kind: source
spec:
name: "circleci"
path: "cloudquery/circleci"
registry: "cloudquery"
version: "v1.0.0"
tables: ["*"]
destinations: ["postgresql"]
spec:
api_token: "${CIRCLECI_API_TOKEN}"
api_token (string) (required)base_url (string, optional, default: https://circleci.com)https://circleci.mycompany.com).orgs ([]string, optional)["gh/my-org"]). If not specified, all organizations the token has access to will be synced.concurrency (integer, optional, default: 100)scheduler (string, optional, default: dfs)dfs (depth-first search), round-robin, shuffle and shuffle-queue.SELECT
p.id,
p.project_slug,
p.number,
p.state,
p.trigger_type,
p.trigger_actor_login,
p.vcs_branch,
p.created_at
FROM circleci_pipelines p
ORDER BY p.created_at DESC
LIMIT 50;
SELECT
w.id,
w.name,
w.status,
w.project_slug,
w.pipeline_id,
w.created_at,
w.stopped_at
FROM circleci_workflows w
WHERE w.status = 'failed'
ORDER BY w.created_at DESC
LIMIT 20;
SELECT
project_slug,
name AS workflow_name,
COUNT(*) AS run_count,
AVG(EXTRACT(EPOCH FROM (stopped_at - created_at))) AS avg_duration_seconds
FROM circleci_workflows
WHERE status = 'success'
AND stopped_at IS NOT NULL
GROUP BY project_slug, name
ORDER BY avg_duration_seconds DESC;
SELECT
j.id,
j.name,
j.status,
j.project_slug,
j.started_at,
j.stopped_at
FROM circleci_workflow_jobs j
WHERE j.status = 'failed'
AND j.started_at > NOW() - INTERVAL '24 hours'
ORDER BY j.started_at DESC;
SELECT
c.name AS context_name,
e.variable,
e.created_at
FROM circleci_contexts c
JOIN circleci_context_environment_variables e
ON c.id = e.context_id
ORDER BY c.name, e.variable;
SELECT
name,
slug,
organization_name,
vcs_info_provider,
vcs_info_vcs_url,
vcs_info_default_branch
FROM circleci_projects
ORDER BY organization_name, name;
SELECT
s.name AS schedule_name,
s.project_slug,
s.timetable_per_hour,
s.timetable_hours_of_day,
s.timetable_days_of_week,
s.created_at,
s.updated_at
FROM circleci_schedules s
ORDER BY s.project_slug, s.name;
SELECT
project_slug,
COUNT(*) FILTER (WHERE state = 'errored') AS error_count,
COUNT(*) AS total_count,
ROUND(100.0 * COUNT(*) FILTER (WHERE state = 'errored') / COUNT(*), 2) AS error_rate_pct
FROM circleci_pipelines
GROUP BY project_slug
HAVING COUNT(*) > 10
ORDER BY error_rate_pct DESC;
SELECT
name AS workflow_name,
project_slug,
COUNT(*) AS total_runs,
COUNT(*) FILTER (WHERE status = 'success') AS success_count,
ROUND(100.0 * COUNT(*) FILTER (WHERE status = 'success') / COUNT(*), 2) AS success_rate_pct
FROM circleci_workflows
GROUP BY name, project_slug
ORDER BY success_rate_pct ASC;