preset-sqllab

スター11

フォーク2

更新日2026年6月11日 20:12

Inspect Preset SQL Lab bootstrap, query history, saved queries, result/export routing, query control, and SQL execution routing through direct Superset API calls. Use only for direct API workflows; Do not use for MCP-only work.

インストール

Codex または Claude でインストールこの Prompt をコピーして Codex、Claude、または他のアシスタントに貼り付けると、Skill ページを確認してインストールできます。

ソース

preset-io

preset-io/agent-skills

GitHub リポジトリを開く Creator のリポジトリを見る

ダウンロード

preset-sqllab

Use for SQL Lab capability and query metadata workflows in a resolved Preset workspace.

Always

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. Consult preset-superset only when permissions drift matters.
Run SQL Lab bootstrap/capability metadata reads directly.
Run the user's own query history and saved-query reads directly when they asked in their own message AND current-user/owner filtering is applied before SQL-bearing fields are fetched (default page 25 records, hard cap 100 without explicit confirmation). If an endpoint returns SQL text before ownership is proven, keep the read confirmation-gated as SQL-text disclosure.
Route execution, result retrieval/export, query stop, saved-query mutation, and permalinks to preset-sql-execution.

Decision Rules

Distinguish query history metadata from SQL text, result retrieval, and execution to pick the right endpoint and filters.
Other users' history or SQL text, and any history read where owner filtering cannot be applied first, require confirmation.
Route saved query, history, result, stop, permalink, and execution requests separately.
Avoid SQL execution from this skill.

Workflow Order

Inspect SQL Lab bootstrap state.
Route history, saved query, result, stop, permalink, and execution request.
Fetch owner-filtered history or saved queries the user asked for with parameterized page limits.
Confirm before unowned SQL-text reads; route execution-family operations to preset-sql-execution.

Retrieve

Combined SQL Lab routing and approval essentials: references/routing-essentials.md
SQL Lab availability, database options, UI defaults: references/sqllab-bootstrap.md
Query history reads and SQL text exposure: references/query-history.md
Saved query reads, mutations, permalinks: references/saved-queries.md
SQL execution routing: references/sql-execution.md
Result retrieval and exports: references/query-results-and-exports.md
Query stop/cancel: references/query-control.md

このリポジトリの他の Skills

同じリポジトリ

preset-api

preset-io/agent-skills

Prepare direct Preset API access: auth, JWT exchange, base URLs, pagination, Rison parameters, response handling, and shared API setup. Use only for direct API workflows; Do not use for MCP-only work.

2026-06-2211

preset-dashboards

preset-io/agent-skills

Inspect Preset workspace dashboards, charts, dashboard composition, screenshots, thumbnails, chart data, and chart/dashboard operation routing through direct Superset API calls. Use only for direct API workflows; Do not use for MCP-only work.

2026-06-1211

preset-sql-execution

preset-io/agent-skills

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.

2026-06-1211

preset-cli

preset-io/agent-skills

Drive Preset's `sup` CLI (PyPI package `superset-sup`) for shell, scripting, CI/CD, and agent-driven Preset workflows. Use only for CLI workflows; Do not use for MCP-only work or for direct HTTP/SDK code paths.

2026-06-1211

preset-import-export

preset-io/agent-skills

Inspect and route direct Superset import/export workflows for dashboards, charts, datasets, databases, saved queries, themes, and asset bundles. Use only for direct API workflows; Do not use for MCP-only work.

2026-06-1111

preset-admin

preset-io/agent-skills

Manage Preset teams, workspaces, memberships, invites, role identifiers, seat checks, and audit logs through direct Management API calls. Use only for direct API workflows; Do not use for MCP-only work.

2026-06-1111

preset-sqllab

Use for SQL Lab capability and query metadata workflows in a resolved Preset workspace.

Always

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. Consult preset-superset only when permissions drift matters.

Run SQL Lab bootstrap/capability metadata reads directly.

Run the user's own query history and saved-query reads directly when they asked in their own message AND current-user/owner filtering is applied before SQL-bearing fields are fetched (default page 25 records, hard cap 100 without explicit confirmation). If an endpoint returns SQL text before ownership is proven, keep the read confirmation-gated as SQL-text disclosure.

Route execution, result retrieval/export, query stop, saved-query mutation, and permalinks to preset-sql-execution.

Decision Rules

Distinguish query history metadata from SQL text, result retrieval, and execution to pick the right endpoint and filters.

Other users' history or SQL text, and any history read where owner filtering cannot be applied first, require confirmation.

Route saved query, history, result, stop, permalink, and execution requests separately.

Avoid SQL execution from this skill.

Workflow Order

Inspect SQL Lab bootstrap state.

Route history, saved query, result, stop, permalink, and execution request.

Fetch owner-filtered history or saved queries the user asked for with parameterized page limits.

Confirm before unowned SQL-text reads; route execution-family operations to preset-sql-execution.

Retrieve

name	preset-sqllab
description	Inspect Preset SQL Lab bootstrap, query history, saved queries, result/export routing, query control, and SQL execution routing through direct Superset API calls. Use only for direct API workflows; Do not use for MCP-only work.