All skills
secondsky avatar

/sap-bw-query

@620a19a
by Eddiesecondsky/sap-skills456 stars
120

Use when automating SAP BW query inspection, InfoProvider metadata reads (characteristics, key figures), metadata-verified specification review, unsaved draft preparation, or human-confirmed query draft population through Eclipse or HANA Studio with BW Modeling Tools.

Use this Skill: https://skilld.dev/gh/secondsky/sap-skills/sap-bw-query

This session only. Nothing lands on disk.

referencesdeployment-and-trust.md

≈1.1k tokens on demand. Your agent reads this file only when SKILL.md points to it.

Portable deployment and trust

User deployment

Run from the installed plugin root:

./scripts/BwStudio.ps1 -Action Status -Json
./scripts/BwStudio.ps1 -Action Deploy -ArtifactPath <bundle.zip> -ManifestPath <manifest.json> -Json
./scripts/BwStudio.ps1 -Action Launch -Json

That local command requires no installation, administrator rights, Java, Node, Eclipse, or signing setup. Online deployment uses -ReleaseChannelUrl <approved-channel.json> plus a local pinned -TrustPolicyPath and remains signature-gated.

For local files, the deployer verifies archive SHA-512, platform/version, safe archive paths, bundle lock, every inventoried file, and all entrypoints before appending activation. Remote downloads additionally verify an RSA-SHA256 manifest signature.

Install location defaults to %LOCALAPPDATA%\BWAutomationStudio — deliberately a per-user, no-install, portable, append-only location that needs no administrator rights, registry edits, machine PATH, package installation, or file associations. Because that location is not obvious, a successful deploy also writes two launch shortcuts to the user's visible desktop ([Environment]::GetFolderPath("Desktop"), which follows a OneDrive/Known-Folder-Move redirection): SAP BW Automation Studio (kein Passwortspeicher).lnk (launches the active version's eclipse.exe -noPwdStore, recommended) and SAP BW Automation Studio (mit Passwortspeicher).lnk (launches eclipse.exe without the flag, so Eclipse's own secure store may remember credentials — an optional convenience for the manual human login only; the automation/MCP surface still never handles passwords). The shortcuts are refreshed on every deploy to point at the active version, are created with the COM WScript.Shell (no admin, no deletion), and are best-effort (a failure only warns). They are skipped automatically in CI and when BW_STUDIO_NO_SHORTCUT is set.

Append-only behavior

  • Each deployment uses a new download/staging directory.
  • Installed versions are immutable.
  • Activation and rollback add timestamped records.
  • Failed/old data is retained for manual inspection.
  • No uninstall or cleanup command exists.

Publisher setup

config/trusted-publishers.json is irrelevant for local use. It is needed only if a team later enables a shared remote download channel.

bundle/Build-BwStudio.ps1 produces the runnable Eclipse/BWMT/JRE/Node/MCP bundle, per-file lock, CycloneDX SBOM, build provenance, and artifact manifest. The resulting local ZIP runs without a signature; detached signing is optional for remote distribution.

After a successful build, the builder also copies the release ZIP and its manifest (plus the detached .sig and trusted-publishers.release.json files when the build is signed) to the local user Desktop (%USERPROFILE%\Desktop, created if missing). This is deliberately the local Desktop and not the OneDrive-redirected Desktop, so large bundles are not synced to the cloud. If that Desktop is itself OneDrive-managed (for example under Known Folder Move), the builder refuses to auto-publish there, warns, and leaves the artifacts in the output directory. Pass -PublishDirectory <path> to retarget the copy (including to a synced folder if you want that, which is always honored when requested explicitly), or -SkipPublish to disable it entirely. This step is best-effort: a copy failure only emits a warning and never fails the build, and the authoritative artifacts always remain in the builder's output directory.

Because the local publish directory is usually not the user's visible desktop (which is OneDrive-redirected under Known Folder Move), the builder additionally drops a small shortcut (<zip-name>.zip.lnk) on the visible desktop ([Environment]::GetFolderPath("Desktop")) pointing at the local ZIP — so the finished bundle is visible and one-click accessible while only a few KB sync to the cloud instead of the full ~1 GB. This is also best-effort and only warns on failure. After publishing, the builder opens Windows File Explorer on the output directory with the release ZIP selected so you can see the built app; suppress it with -SkipExplorer, and it is skipped automatically in CI or non-interactive sessions.

Sources

  • Pinned upstream URLs, official checksum sources, and verification status are recorded in bundle/bundle-source-lock.json and docs/project/sap-bw-query-source-review-2026-07-13.md.

Source: SKILL.md on GitHub

No alerts1mo3 checks · Risk SAFE
  • Gen Agent Trust Hub1mo

    This skill provides a secure, human-in-the-loop automation studio for SAP BW Query design. It uses a bundled Eclipse/BWMT environment and features extensive security hardening, including bidirectional credential scanning, machine-local communication, and mandatory human confirmation for all state-changing operations.

  • Socket1mo

    No alerts

  • Snyk1mo

    Risk: LOW · No issues

Signed by skilld at 620a19a. This ties the file your Agent reads to that commit on GitHub. It does not review the instructions.

Last checked against GitHub 2 weeks ago.

Activeupdated 2 months ago
What it can do
Reads files Runs commands
All 4 allowed tools
ReadGrepGlobBash
Other metadata
metadata
{
  "maintainer": "Eduard Jiglau",
  "maintainer_email": "hello@sap-ai-skills.com",
  "website": "https://sap-ai-skills.com",
  "version": "2.4.1",
  "last_verified": "2026-07-17",
  "eclipse_version": "4.40",
  "bwmt_version": "1.27.36",
  "java_version": "21.0.11",
  "node_version": "24.18.0",
  "verification_scope": "public source/package evidence, signature-level BWMT API inspection, local unit tests, signed fixture deployment, and Eclipse compile only; live BW system validation pending per docs/project/sap-bw-query-live-validation-runbook.md"
}

README badge

README badge for secondsky/sap-skills/sap-bw-query