Developer Projects

create_dev_project

Create a new software developer project. Applies the software preset (repo_url, deploy_url, stack, framework, ci_status, hosting_provider, license, stable) automatically. Only name is required; pass any dev fields to populate them.

update_dev_project

Update a developer project. Any of name/notes/domain/url and the dev custom fields (repo_url, repo_full_name, deploy_url, stack, framework, ci_status, hosting_provider, license, priority, remarks, stable) can be set; omitted fields are left unchanged. repo_full_name is re-inferred from repo_url if not provided.

add_dev_project_remark

Append a remark to a developer project's remarks thread (stored in custom_fields.remarks_log). Also updates the summary custom_fields.remarks to the latest body. Returns the new remark.

list_dev_project_remarks

List the remarks thread for a developer project (from custom_fields.remarks_log), newest first.

list_dev_projects_enriched

List all developer projects (projects with the software preset) with live enrichment stats: GitHub stars/issues, search clicks (30d), uptime %, and revenue (30d).

list_dev_projects

List all developer projects (software preset) with live enrichment stats, as a bare array. Use this for table/collection rendering where an array is expected; use list_dev_projects_enriched for the object shape with enrichment_columns metadata.

list_dev_project_status

Overview dashboard summary for developer projects: scalar counts (total, active, needs_attention, with_open_tasks) for KPI cards, a `gsc_daily_series` array (daily impressions/clicks across all projects for the last 90 days), an `attention` array of projects needing a human (inactive, search-traffic crash, sharp drop, ads projects earning nothing), plus a `recent` array. pending_input is always null. Serves a per-workspace cache for instant loads; pass refresh=true to recompute (the Overview Refresh button does this).

get_dev_project_stats

Get aggregated stats for one developer project: GitHub stars/open_issues, search clicks (30d), uptime %, revenue (30d), and open task count.

apply_dev_preset

Convert an existing project into a developer project by applying the software preset field schema. Existing custom fields are preserved; preset fields are merged in.

list_dev_repos

List GitHub repositories linked to developer projects, with star/issue counts and last push.

seed_dev_enrichments

Register (idempotently) the developer-project enrichment columns on the projects table: github_stars, github_open_issues, dev_gsc_clicks_30d, dev_uptime_pct, dev_revenue_30d. Call once after installing the plugin. Safe to call repeatedly.

list_dev_project_categories

List all dev-project categories (editable grouping tags) for the current workspace. Categories are shared across all dev projects in the workspace.

create_dev_project_category

Create a new dev-project category (tag) in the current workspace. Use this to create grouping labels like 'City Guides', 'SaaS', 'Experiments'.

update_dev_project_category

Update a dev-project category's name or color.

delete_dev_project_category

Delete a dev-project category. All project-to-category links are removed automatically.

set_dev_project_categories

Set the full list of categories for a dev project (replace semantics). Pass an empty array to unassign all categories.

check_dev_project

Mark a dev project as manually reviewed by the owner. Stamps custom_fields.last_checked_at = now() and appends an entry to custom_fields.check_log recording who checked + when. Call after a human has reviewed the project's performance. Returns the new last_checked_at timestamp.

list_dev_project_check_log

Read the full check history (who checked + when) for a dev project, most-recent first.

log_project_activity

Append an event to a dev project's unified activity log (custom_fields.activity_log). Use for data-refresh events, review milestones, or any project lifecycle event that should show in the Activity Log timeline.

list_project_activity

Read the unified activity log (check events, data refreshes, reviews) for a dev project, most-recent first. Merges legacy check_log entries with the new activity_log.