greengage

Plugin greengage from marketplace greengage-agent-skills in GreengageDB/gg-agent. Commands read from the repo's manifest — 16 days ago.

Skills (18)

• greengage-answer-files

  Regenerate Greengage regression answer files without burying a real bug - the success-to-ERROR safety gate, the upstream-assertion-still-holds gate and MPP test-input adaptation, reading gpdiff regression.diffs rather than git diff, init_file matchignore and matchsubs masks, atmsort blind spots, bas

• greengage-backup-restore

  Back up and restore Greengage, choosing the right tool. Covers gpbackup/gprestore (shipped outside the greengage repo), --timestamp identifiers, incremental backups, --leaf-partition-data, S3 storage plugins, pg_dump/pg_dumpall coordinator funnel, --gp-syntax, WAL archiving's %c escape, gp_create_re

• greengage-build

  Turn a Greengage source change into a running binary and prove the binary under test is the one you built. Covers ./configure flags and real defaults, --enable-cassert/-depend/-debug-extensions, the 6.x gpAux devel vs dist build, ORCA link failures, stale-object and stale-install traps, ci/Dockerfil

• greengage-ci

  Triage a red Greengage CI run on GitHub Actions - greengage-ci.yml job matrix, pinned greengagedb/greengage-ci reusable workflows, shared expected/*.out answer files, pulling regression.diffs from job logs and artifacts with gh, classifying failures as cosmetic drift, real bug, flaky or lost coverag

• greengage-cluster-ops

  Connect to a Greengage cluster and fix an unwell one. Covers the attach-vs-provision gate, greengage_path.sh + gpdemo-env.sh, gp_segment_configuration health (status 'd', role <> preferred_role), gpstate, gp_stat_replication, gpstart/gpstop -M/-u, gpconfig, gprecoverseg -F/-r, gpactivatestandby, gpc

• greengage-contribute

  Get a change accepted into GreengageDB/greengage: branch targeting, the CLA, committee review, formatting, linting, regression tests, pull-request CI gates. Covers 6.x/7.x vs the stale main branch, two-approval merges, +1/-1 votes, pgindent policy for inherited code, greengage_schedule, installcheck

• greengage-data-loading

  Load and unload Greengage in parallel, not serially through the coordinator. Covers gpfdist, readable/writable external tables, URI-to-segment mapping, gp_external_max_segs, LOG ERRORS / SEGMENT REJECT LIMIT, gp_read_error_log(), gpload YAML control files, COPY ON SEGMENT, gp_exttable_fdw, mpp_execu

• greengage-debug

  Diagnose Greengage crashes, assertion failures, hangs and wrong results - CSV segment logs, the Greengage-specific assert signature, minimal reproduction, gp_debug_linger, gp_inject_fault suspend/wait/reset, temporary elog instrumentation, gdb on a live QE, global-deadlock hangs, blast-radius triage

• greengage-internals

  Make MPP-correct Greengage backend changes - QD/QE roles and Gp_role, gangs and dispatch, outfast.c/readfast.c plan serialization, Motion and slices, locus, GPORCA's silent fallback, FTS outside a transaction, append-optimized aux relkinds, utility mode, fault injection, gpexpand protection. Use whe

• greengage-overview

  Orient on a Greengage cluster or checkout and route to the right skill. Covers what MPP changes in PostgreSQL - distribution policy, Motion nodes, slices, GPORCA vs the Postgres planner, heap and append-optimized storage - plus 6.x/7.x version detection, coordinator/segment/mirror/standby anatomy an

• greengage-pg-batch

  Prepare a batch of upstream PostgreSQL commits on greengage_sync for team review - picking the cut and checking split revert pairs, merging with conflict markers committed, bring-up on a raw branch, units of change (UoC) split per operation by conflict-region, bring-up-commit, identifier and answer-

• greengage-pg-merge

  Merge an upstream PostgreSQL major version into Greengage and bring the fork back up - pinned one-major-per-step targets on greengage_sync, semantic conflict resolution against reference branches, minimal-diff scope, post-target lookahead for reverts and pre-release fixes, behaviour decisions as sep

• greengage-query-performance

  Diagnose and fix slow queries on a Greengage MPP cluster - EXPLAIN motions (Gather, Redistribute, Broadcast), slices and gangs, per-segment rows, GPORCA vs the Postgres planner and its silent fallback, data and computational skew, ANALYZE and analyzedb, statement_mem and workfile spill. Use when a q

• greengage-schema-design

  Designs Greengage tables for MPP - distribution key choice, join co-location, DISTRIBUTED REPLICATED and RANDOMLY, heap vs append-optimized row/column storage, compresstype and column ENCODING, classic and declarative partitioning, unique-key rules, unenforced foreign keys. Use when writing or revie

• greengage-testing

  Run Greengage's test suites and read the results. Covers installcheck-good vs installcheck-world, greengage_schedule, single-test runs and the --use-existing trap, optimizer=on/off answer files, gpdiff/atmsort masking, isolation2, gp_inject_fault, resgroup v1/v2, JIT, behave, ORCA ctest, false passe

• greengage-uoc-review-pr

  Open and carry through the review PRs of a greengage_sync batch split into units of change (UoC) - one <prefix>-uocN -> <prefix>-base PR per unit, opening them with uoc_review.py, reading a unit by its Review focus, review fixes on the unit branch without force-push, the -test branch CI runs, squash

• greengage-uoc-review-status

  Keep the unit table of a greengage_sync batch PR current - finding every unit PR by its <prefix>-uoc<N> head branch, reading state, draft, review verdicts and CI through the GitHub API, writing one row per unit with all its PRs and a summary of units not merged yet, idempotently and without clobberi

• greengage-workload-management

  Controls Greengage cluster admission with resource groups or resource queues - gp_resource_manager none/queue/group/group-v2, cgroup v1/v2, CONCURRENCY, CPU_MAX_PERCENT, CPUSET, MEMORY_LIMIT, IO_LIMIT, ACTIVE_STATEMENTS, MAX_COST, PRIORITY, gp_toolkit views, statement_mem, superuser bypass. Use when

Slash commands (8)

• /greengage:gg-cluster-up

  Bring up a Greengage demo cluster, or attach to and verify an existing one

• /greengage:gg-explain

  Explain a Greengage query under both optimizers and interpret motions, slices and skew

• /greengage:gg-health

  Report Greengage cluster health - segment configuration, mirror sync, standby, disk, and skew

• /greengage:gg-pg-bump

  Start or continue a PostgreSQL major-version bump of Greengage on the campaign line

• /greengage:gg-review

  Review a Greengage change for MPP correctness and report findings on the diff

• /greengage:gg-skew

  Report data and computational skew across Greengage segments for a table, schema, or database

• /greengage:gg-test

  Run a Greengage regression test or suite with the right target, optimizer and environment

• /greengage:gg-triage-ci

  Fetch a failed Greengage CI run's artifacts and classify every failure as cosmetic, real, or flaky

Subagents (3)

• greengage-mpp-reviewer

  Reviews a Greengage backend change for MPP correctness - the failure modes that look fine on a single node and break on a distributed cluster. Checks QD/QE dispatch and node serialization, motion and locus, distributed transactions, FTS, append-optimized aux relations, catalog and GUC changes, and u

• greengage-perf-analyst

  Diagnoses a slow Greengage query end to end - reads the MPP plan under both optimizers, measures data and computational skew, checks statistics freshness, and traces the cost back to the distribution key, storage layout, or partitioning decision behind it. Use when a query is slow, a workload regres

• greengage-pg-merger

  Runs a PostgreSQL major-version bump of Greengage end to end on the greengage_sync campaign line - pins the upstream target, types and clusters the conflict inventory, resolves each conflict semantically by adopting the upstream API shape and re-grafting the MPP logic into it, then drives the compil

Similar plugins