AGENT SKILL
pm-dremio
Dremio connector knowledge and safe action guide.
- License 许可
- AGPL-3.0
- 最近更新
- 2026-09-21
- Stars
- ★ 7
- Forks
- 0
01 前言 Front Matter
- name
- pm-dremio
- description
- Dremio connector knowledge and safe action guide.
02 资源文件 1
- 参考文档MANUAL.md5.3 KB
03 SKILL.md 正文
pm-dremio
Purpose
Reads and writes Dremio catalog entries, reflections, sources, users, and roles through the Dremio REST API.
Icon
- id: dremio
- asset: icons/dremio.svg
- source: upstream_registry
- review_status: upstream_seeded
- review_url: https://docs.dremio.com/software/rest-api/
Capabilities
- check=true catalog=true read=true write=true query=false
- Integration type: api
Authentication
- Use pm credentials add with --from-env or --value-stdin for secret fields.
Configuration
- base_url
- page_size
- api_key (secret) (required)
ETL Streams
- catalog:
- primary key: id
- fields: containerType(string), createdAt(string), datasetType(string), id(string), path(array), tag(string), type(string)
- reflections:
- primary key: id
- fields: createdAt(string), datasetId(string), enabled(boolean), id(string), name(string), status(object), type(string), updatedAt(string)
- sources:
- primary key: id
- fields: createdAt(string), id(string), name(string), path(array), tag(string), type(string)
- users:
- primary key: id
- fields: active(boolean), email(string), firstName(string), id(string), lastName(string), name(string)
- roles:
- primary key: id
- fields: description(string), id(string), memberCount(integer), name(string), roles(array), type(string)
Sync Modes
- ETL sync modes: full_refresh_append, full_refresh_overwrite
Reverse ETL Actions
- create_user:
- endpoint: POST /user
- required fields: name
- risk: creates a new Dremio user account with instance-wide access, scoped by whatever role assignment follows; external mutation, approval required
- update_user:
- endpoint: PUT /user/{{ record.id }}
- required fields: id
- risk: mutates an existing Dremio user account, including its active flag which can lock the user out; external mutation, approval required
- delete_user:
- endpoint: DELETE /user/{{ record.id }}
- required fields: id
- risk: permanently removes a Dremio user account and revokes its access; destructive, approval required
- create_role:
- endpoint: POST /role
- required fields: name
- risk: creates a new Dremio role; low external mutation risk on its own until members/grants are attached
- update_role:
- endpoint: PUT /role/{{ record.id }}
- required fields: id
- risk: mutates an existing Dremio role's name/description; external mutation, approval required
- delete_role:
- endpoint: DELETE /role/{{ record.id }}
- required fields: id
- risk: permanently removes a Dremio role and its grants for every member; destructive, approval required
- update_reflection:
- endpoint: PUT /reflection/{{ record.id }}
- required fields: id
- risk: mutates an existing reflection's definition (name/enabled/tag); disabling a reflection removes its query-acceleration benefit until re-enabled and rebuilt; external mutation, approval required
- refresh_reflection:
- endpoint: POST /reflection/{{ record.id }}/refresh
- required fields: id
- risk: forces an immediate reflection rebuild, consuming cluster compute; low external-mutation risk, no data loss, no approval required
- delete_reflection:
- endpoint: DELETE /reflection/{{ record.id }}
- required fields: id
- risk: permanently removes a reflection definition; any query relying on it for acceleration falls back to the raw dataset; destructive, approval required
- create_personal_access_token:
- endpoint: POST /user/{{ record.user_id }}/token
- required fields: user_id, label
- optional fields: millisToExpire
- risk: mints a new long-lived Personal Access Token credential for the named user; the response body carries the plaintext token exactly once and must never be logged; external mutation, approval required
- delete_personal_access_token:
- endpoint: DELETE /user/{{ record.user_id }}/token/{{ record.token_id }}
- required fields: user_id, token_id
- risk: revokes a single Personal Access Token, immediately invalidating any client still using it; destructive to that credential's holders, approval required
Security
- read risk: external Dremio API read of catalog, reflection, source, user, and role data
- write risk: external Dremio API mutation of user/role/reflection/PAT lifecycle objects; several actions are destructive (delete_user, delete_role, delete_reflection, delete_personal_access_token) and require approval
- approval: required for create/update/delete user, role, and reflection actions and PAT lifecycle actions; refresh_reflection is low-risk and does not require approval
- Never pass secret values in chat, shell arguments, logs, docs, or JSON output.
Commands
Inspect as a manual
pm connectors inspect dremio
Inspect as structured JSON
pm connectors inspect dremio --json
Agent Rules
- Run pm connectors inspect dremio before creating credentials or plans.
- Use --json only when the caller needs structured output; use the manual for human-readable guidance.
- Never ask the user to paste secret values into chat.
- For reverse ETL writes, create a plan, show the preview, wait for explicit approval, then run with the approval token.
04 同仓库更多 Skills
recipe-preview-approve-reverse-etl
Preview and approve a reverse ETL plan safely.
★ 7
recipe-github-prs-to-warehouse
Sync GitHub pull requests into the local warehouse.
★ 7
pm-zoom
Zoom connector knowledge and safe action guide.
★ 7
pm-zonka-feedback
Zonka Feedback connector knowledge and safe action guide.
★ 7
pm-zoho-invoice
Zoho Invoice connector knowledge and safe action guide.
★ 7
pm-zoho-inventory
Zoho Inventory connector knowledge and safe action guide.
★ 7