Back to skills

preset-api

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.

Richard Fogaca NienkotterRichard Fogaca Nienkotter
Updated 6/5/2026
View source

Documentation

preset-api

Use as the prerequisite for direct Preset API skills. If the user is working through Preset/Superset MCP tools, stay on MCP unless they approve direct API calls.

Always

  • Keep PRESET_CLIENT_ID, PRESET_CLIENT_SECRET, and tokens out of source, logs, reports, and examples.
  • Derive workspace hostnames through the Management API before workspace Superset calls.
  • Default to metadata reads.
  • Require explicit confirmation before mutations, data-returning reads, SQL text reads, credential-bearing reads, SQL execution, imports, exports, role/RLS changes, or guest-token creation.

Decision Rules

  • Use existing authenticated Preset API context; never ask users to paste secrets.
  • Select base URL from discovered team, workspace, or Superset workspace facts.
  • Use pagination and Rison for list, filter, sort, and search calls.
  • Load safety policy before risky follow-up calls.
  • If the user starts with direct API intent and mentions MCP only as a fallback, keep direct API intent. Say: "No MCP fallback. MCP tools are a different surface and require separate explicit approval. Stop before MCP calls."
  • Do not stop direct API planning just because MCP was mentioned. Stop only before MCP calls or before direct API operations that require confirmation.

Workflow Order

  1. Resolve base URL and credentials.
  2. Plan paginated Rison requests.
  3. Classify follow-up risk before data, credential, SQL, token, export, import, or mutation calls.
  4. Reject unapproved MCP fallback if the requested workflow is direct API.
  5. Ask before changing surfaces and stop before MCP calls.
  6. Continue the direct API plan unless the direct API operation itself requires confirmation.
  7. Redact credentials and tokens in all output.

Retrieve

Files (6)

Related Skills

No related skills found