CLI queries

Assumes you have already authenticated and imported data.

All query output is JSON, suitable for piping to jq or other tools.

Developers

List developers matching a pattern:

devpulse query developer list --like mark

Get details for a specific developer:

devpulse query developer detail --name mchmarny

List entities (companies/orgs) matching a pattern:

devpulse query entity list --like google

Get entity details with affiliated developers:

devpulse query entity detail --name GOOGLE

List repositories in an organization:

devpulse query org repos --org mchmarny

Search events with filters:

devpulse query events --org mchmarny --repo devpulse --type pr --since 2024-01-01

Available filters: --org, --repo, --type (pr, pr_review, issue, issue_comment, fork), --author, --since, --label, --mention, --limit.

Pipe to jq for post-processing:

devpulse query events --org mchmarny --repo devpulse --type pr | jq '. | length'

Use --limit on any list command to control result count (default: 100, max: 500).

The default SQLite database is at ~/.devpulse/data.db:

sqlite3 ~/.devpulse/data.db

Schema is defined in pkg/data/sqlite/sql/migrations/. Key tables:

Table	Primary Key	Description
`developer`	`username`	Developer profiles, entity affiliations, and reputation scores
`event`	`org, repo, username, type, date`	Contribution events with optional state/timing fields
`repo_meta`	`org, repo`	Repository status (stars, forks, language, license, last import timestamp)
`repo_metric_history`	`org, repo, date`	Daily star/fork counts for trend charts
`release`	`org, repo, tag`	Release tags and publish dates
`release_asset`	`org, repo, tag, name`	Release binary download counts
`container_package`	`org, repo, tag`	Container image versions
`state`	`query, org, repo`	Import pagination state
`sub`	`type, old`	Entity name substitutions
`schema_version`	`version`	Migration tracking