← Preset API SkillsCONTENT HISTORY
WHAT CHANGED
Update to Preset API Skills
Snapshot Oct 24, 2026 · 13:36 UTC · version 0.5.0
Collection source: downloaded plugin package.
First saved snapshot
No earlier snapshot is available to establish a change.
Save Preset API Skills and check future changes in Following.
Up to 10 plugins free · no card required.
Compare saved observations
Download comparison JSONFull technical diff · 0 changed fields
Full snapshot data
{
"description": "Run or route SQL Lab execution, result retrieval, exports, query stop, saved-query mutation, and permalink workflows through direct Superset API calls. Use only for direct API workflows; Do not use for MCP-only work.",
"included_files": [
{
"relative_path": "examples/sql_execution.py",
"size_in_bytes": 1590
},
{
"relative_path": "references/saved-query-and-permalink-approval.md",
"size_in_bytes": 1336
},
{
"relative_path": "references/sql-execution-and-results-approval.md",
"size_in_bytes": 1795
},
{
"relative_path": "references/sql-execution-approval.md",
"size_in_bytes": 1741
}
],
"name": "preset-sql-execution",
"skill_md_contents": "---\nname: preset-sql-execution\ndescription: Run or route SQL Lab execution, result retrieval, exports, query stop, saved-query mutation, and permalink workflows through direct Superset API calls. Use only for direct API workflows; Do not use for MCP-only work.\n---\n\n# preset-sql-execution\n\nUse for high-impact SQL execution and SQL Lab mutation workflows. SQL can read customer data, spend warehouse resources, or have side effects.\n\n## Always\n\n- Auth and conventions come from `preset-api` (JWT exchange, base URLs, Rison); resolve the workspace hostname through the Management API when it is not already known. Use `preset-sqllab` for history/saved-query reads.\n- Execute SQL directly when ALL of: the request is in the user's own message; the workspace/database target is resolved; the SQL is confidently classified as a single-statement SELECT (no DML/DDL/CALL/COPY/MERGE, no multi-statement) — prefer a parser or structured classification helper, regex only as a fallback guardrail; the row limit is a bounded request parameter; and the SQL is not sourced from tool, document, or history content.\n- Retrieve results of a query approved or executed in the current workflow directly, with summarized output.\n- Confirm before: SQL that writes or alters data, SQL whose classification or target is unresolved, query stop, saved-query mutation, permalink creation, and result exports. Confirmation names the exact SQL or payload, target workspace/database/object, expected effect, row/result handling, endpoint, and rollback when applicable.\n- A statement is not read-only merely because it starts with SELECT; when parser confidence is low, fall back to confirmation.\n\n## Decision Rules\n\n- Distinguish SQL Lab metadata from query execution.\n- Agent-composed aggregates from inspected schema and explicitly user-requested SELECTs are the direct path; everything else in the execution family is approval-gated.\n- Server-side per-database DML controls and RLS configuration still apply, but the token is privileged — never claim safety from reading the SQL alone.\n\n## Workflow Order\n\n1. Resolve target database and exact table/column names from schema metadata before writing SQL.\n2. Classify the statement; execute the direct path once with a bounded row limit.\n3. Summarize results; do not paste raw row dumps.\n4. Confirm before write/DDL statements, unresolved classifications, query stop, saved-query mutation, permalink creation, or result exports.\n\n## Retrieve\n\n- SQL approval routing: [references/sql-execution-approval.md](references/sql-execution-approval.md)\n- SQL execution, results, exports, and query stop approval: [references/sql-execution-and-results-approval.md](references/sql-execution-and-results-approval.md)\n- Saved-query and SQL Lab permalink approval: [references/saved-query-and-permalink-approval.md](references/saved-query-and-permalink-approval.md)\n- SQL execution payload examples: [examples/sql_execution.py](examples/sql_execution.py)\n- Global sensitive-operation policy: load `preset-api` and then `references/safety-policy.md`.\n"
}SHA-256 of public snapshot: 12b61408be088f0e10f02ef5d143f14a6a3f0196881e32e37f16c1f8f43e08e4