Claude Cursor GitHub Copilot Skill

preset-datasets

Inspect Preset workspace datasets, database metadata, schemas, tables, columns, metrics, and dataset/database workflow routing through direct Superset API calls. Use only for direct API workflows; Do not use for MCP-only work.

LLM Mart · 0 points · 2 views 0 listing impressions 0 install-command copies
Download preset-io-agent-skills-plugins_preset-api-skills_skills_preset-datasets-73d2674.zip · 6 KB

Install

skills CLI npx skills add https://github.com/preset-io/agent-skills/tree/master/plugins/preset-api-skills/skills/preset-datasets
Claude Code claude plugin marketplace add https://llmmart.ai/marketplace.json && claude plugin install preset-io-agent-skills@llmmart
Git git clone https://github.com/preset-io/agent-skills.git

The skills CLI installs just this skill, for any of its supported agents. Claude Code installs the whole preset-io/agent-skills collection as a plugin from our marketplace. Git is the plain clone.

Skill manifest

preset-datasets

Use for dataset and database metadata inspection 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 version drift matters.
  • Run schema, table, dataset, column, and metric metadata reads directly.
  • Run samples, distinct values, and datasource values directly when the user asked in their own message with an explicit table/column target: row/value limit as a request parameter (default 100, hard cap 1000 without explicit confirmation), output summarized — no raw row dumps.
  • Connection configuration stays confirmation-gated; route credential-bearing database connection work to preset-database-connections.
  • Require confirmation before dataset/database mutations, uploads, cache changes, imports, exports, validation, or SQL execution.
  • Do not create, update, delete, duplicate, import, refresh schemas, upload files, test databases, validate SQL, or run SQL Lab queries from this skill without confirmation and focused routing.

Decision Rules

  • Treat schema, table, dataset, column, and metric inspection as read-only metadata.
  • Distinguish metadata inspection from data-returning reads.
  • Use database identity from discovered environment facts or API results.
  • Avoid credential-bearing connection fields; route those to preset-database-connections.

Workflow Order

  1. Resolve database connection.
  2. Inspect schemas, tables, datasets, columns, and metrics metadata.
  3. Fetch explicitly requested samples or distinct values with parameterized limits and summarized output.
  4. Confirm before exports, mutations, uploads, cache changes, imports, validation, SQL execution, or credential-bearing connection work.

Retrieve

Files (agent-skills)
  • examples
    • table_and_schema_metadata.py 514 B
      Loading…
  • references
    • connection-configuration.md 1.2 KB
      Loading…
    • data-returning-reads.md 1.2 KB
      Loading…
    • database-metadata.md 1.6 KB
      Loading…
    • dataset-database-mutations.md 1.2 KB
      Loading…
    • dataset-metadata.md 2.3 KB
      Loading…
    • table-and-schema-metadata.md 1.1 KB
      Loading…
  • SKILL.md 2.8 KB
    ---
    name: preset-datasets
    description: Inspect Preset workspace datasets, database metadata, schemas, tables, columns, metrics, and dataset/database workflow routing through direct Superset API calls. Use only for direct API workflows; Do not use for MCP-only work.
    ---
    
    # preset-datasets
    
    Use for dataset and database metadata inspection 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 version drift matters.
    - Run schema, table, dataset, column, and metric metadata reads directly.
    - Run samples, distinct values, and datasource values directly when the user asked in their own message with an explicit table/column target: row/value limit as a request parameter (default 100, hard cap 1000 without explicit confirmation), output summarized — no raw row dumps.
    - Connection configuration stays confirmation-gated; route credential-bearing database connection work to `preset-database-connections`.
    - Require confirmation before dataset/database mutations, uploads, cache changes, imports, exports, validation, or SQL execution.
    - Do not create, update, delete, duplicate, import, refresh schemas, upload files, test databases, validate SQL, or run SQL Lab queries from this skill without confirmation and focused routing.
    
    ## Decision Rules
    
    - Treat schema, table, dataset, column, and metric inspection as read-only metadata.
    - Distinguish metadata inspection from data-returning reads.
    - Use database identity from discovered environment facts or API results.
    - Avoid credential-bearing connection fields; route those to `preset-database-connections`.
    
    ## Workflow Order
    
    1. Resolve database connection.
    2. Inspect schemas, tables, datasets, columns, and metrics metadata.
    3. Fetch explicitly requested samples or distinct values with parameterized limits and summarized output.
    4. Confirm before exports, mutations, uploads, cache changes, imports, validation, SQL execution, or credential-bearing connection work.
    
    ## Retrieve
    
    - Database list/detail and available database metadata: [references/database-metadata.md](references/database-metadata.md)
    - Dataset list/detail, columns, metrics, related objects: [references/dataset-metadata.md](references/dataset-metadata.md)
    - Catalogs, schemas, tables, table metadata, functions: [references/table-and-schema-metadata.md](references/table-and-schema-metadata.md)
    - Samples, distinct values, datasource values: [references/data-returning-reads.md](references/data-returning-reads.md)
    - Connection configuration routing: [references/connection-configuration.md](references/connection-configuration.md)
    - Dataset/database mutations and routing: [references/dataset-database-mutations.md](references/dataset-database-mutations.md)
    

Comments (0)

Sign in to join the conversation.

No comments yet.

Reviews (0)

No reviews yet.