skills/konecty-meta-pivot/SKILL.md
Manage Konecty pivot/report metadata: show pivot definitions, inspect rows/columns/values configuration, upsert pivots. Use when the user wants to create or modify pivot tables, configure row groupings, column fields, value aggregators, or default filters. Requires admin credentials.
npx skillsauth add konecty/skills konecty-meta-pivotInstall this skill globally with one command. Works with Claude Code, Cursor, and Windsurf.
3 of 9 scanners reported clean
Some scanners were skipped, did not run, or reported a non-clean status. Review each row below.
Manage pivot-type metadata definitions (rows, columns, values, aggregators, filters).
Requires admin credentials from konecty-session. User must have admin: true.
python3 scripts/meta_pivot.py show Activity Default
python3 scripts/meta_pivot.py upsert Activity Default --file pivot.json
_id pattern: {Document}:pivot:{Name}rows: array of row grouping fields (e.g. _user.group, _user)columns: object-map of column fieldsvalues: array of aggregated value definitions with aggregator (count, sum, avg, min, max)filter, sorters, rowsPerPage, refreshRate: same structure as list metasSee scripts/meta_pivot.py. Stdlib only.
data-ai
Replace with description of the skill and when the agent should use it.
tools
Upload, list, and delete files in Konecty document fields via the file API. Use this skill whenever the user wants to attach a file to a Konecty record, upload a photo/image to a contact or product, add a PDF or document to an opportunity, send a curriculum to a candidate, manage gallery images for a development or promotion, or attach any binary file to any Konecty module field. Also triggers when the user says 'upload', 'anexar', 'enviar arquivo', 'adicionar imagem', 'attach file', or refers to file-type fields in any document. Automatically reads field constraints (accepted extensions, max size, max file count) from metadata before uploading to catch errors early. Requires an active konecty-session (KONECTY_URL and KONECTY_TOKEN in ~/.konecty/.env or ~/.konecty/credentials).
documentation
Updates records in any Konecty module via PUT /rest/data/:document. Enforces the mandatory pre-update fetch workflow: always fetch the current record first to obtain its _updatedAt (optimistic locking guard), then PUT with ids=[{_id, _updatedAt}] and data={changed fields}. Use when the user wants to update, edit, change, or modify any record in Konecty. Requires an active konecty-session. Use konecty-modules to discover field names and types before updating.
development
Opens a Konecty session via OTP login (request OTP, then verify OTP) and persists the access token in .env or ~/.konecty/credentials for use by other skills. Use when the user wants to log in to Konecty with OTP, store credentials, set up KONECTY_TOKEN, or establish a session so other Konecty skills can call the API. Only works when the namespace has OTP enabled (email or WhatsApp).