execute

Executes VQL statements and Data Marketplace REST calls against live Denodo 9.5 servers.

Updated Sep 4, 2026
One-click install
npx skills add https://github.com/kirivandubai/denodo_wipe_coading_skills --skill execute-kirivandubai
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: execute
Source: https://github.com/kirivandubai/denodo_wipe_coading_skills/tree/main/skills/execute
Command: npx skills add https://github.com/kirivandubai/denodo_wipe_coading_skills --skill execute-kirivandubai

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) and references (resource) components.

What problem does it solve? Applying VQL to a live Denodo server and verifying the result involves connection profiles, statement splitting, destructive-operation risk on production, and cryptic server error messages. This Skill wraps all of that in one CLI tool that returns structured JSON, so every execution is checked, safe, and interpretable. ## Core Features & Use Cases - VQL execution and inspection: Apply .vql files or inline statements, run DESC and test SELECTs, and read per-statement results with row counts and failure positions. - Data Marketplace REST calls: Issue GET/POST requests against the marketplace API with query params, JSON bodies, and multipart parts through the same profile-based tool. - Production safety rails: Destructive statements (DROP, ALTER, state-changing procedures, synchronizing POSTs) are refused on production profiles until a human explicitly confirms, and passwords are encrypted via a hidden prompt rather than passed as arguments. - Use Case: After writing a .vql file that creates a base view, apply it with vql run --env dev, then confirm the object actually reads with vql desc and a capped SELECT before reporting success. ## Quick Start Ask the agent to apply the file model/sales/views.vql to the dev Denodo environment and verify the created views with a DESC and a test SELECT.

Frequently Asked Questions about execute

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I apply a VQL file to a Denodo server?

Run the denodo script with `vql run --env <profile> path/to/file.vql`. The file is split into statements client-side and executed one by one in a single session, returning per-statement results as JSON. On the first failure execution stops and `failed_at` identifies the failing statement.

How do I call the Denodo Data Marketplace REST API?

Use `api get --env <profile> /public/api/tags` for reads and `api post` with `--json`, `--param`, or `--part` for writes. The profile must define `marketplace_url`; the tool returns HTTP status separately from the body, and `ok` is true only for 2xx responses.

What happens when running DROP or ALTER on a production Denodo profile?

The tool refuses destructive statements on profiles marked production, returning `error.kind: refused` with the list of offending statements and executing nothing. Only after a human explicitly confirms in the conversation can the command be re-run with `--allow-destructive`.

Why does my Denodo VQL execution fail midway through a file?

Execution stops at the first failed statement; earlier statements are applied and nothing is rolled back. Read `statements[failed_at].error.message`, match it against the error reference, fix the statement, and re-apply the whole file since templates use CREATE OR REPLACE.

How do I encrypt a data source password for Denodo VQL?

Run `secret encrypt --env <profile>`, which prompts for the password in a hidden prompt or reads it from stdin, and returns only the ciphertext for `USERPASSWORD = '...' ENCRYPTED`. The ciphertext is tied to the server that produced it, so encrypt separately per environment.

Why does a Denodo base view return zero rows after creating successfully?

A DF wrapper whose OUTPUTSCHEMA lists only some of the file's columns creates cleanly but its base view returns zero rows. Always verify with a test SELECT after applying, since CREATE success does not guarantee the object reads correctly.