---
name: "apache-superset-sql-lab-chart-builder"
description: "Build interactive enterprise BI dashboards, parameterized SQL queries, and role-based charts."
metadata:
  author: "Apache Software Foundation"
  version: "1.0.0"
  runtime_compatibility:
    - "codex"
    - "claude-code"
    - "cursor"
    - "windsurf"
triggers:
  - "create superset chart"
  - "write jinja templated sql lab query"
  - "configure superset rls"
permissions:
  fs_read: true
  fs_write: "workspace"
  shell_exec: false
  net_access: false
---

# Apache Superset SQL Lab & Dashboard Engineering

Develops visual analytics in Apache Superset: authoring queries in SQL Lab with Jinja templating, configuring semantic datasets, building rich slice charts, managing dashboard layouts, and configuring row-level security (RLS).

## When to Invoke
Invoke this skill whenever you need to:
- create superset chart
- write jinja templated sql lab query
- configure superset rls

## Execution SOP & Rules
1. Connect database via SQLAlchemy URI in Settings -> Database Connections.
2. Write query in SQL Lab leveraging Jinja templates: WHERE tenant_id = '{{ current_user_id() }}'.
3. Save query as a Virtual Dataset and configure metrics, dimensions, and column certifications.
4. Assemble charts onto dashboards and configure Dashboard Native Filters for interactive drilling.

## Verification Checklist
- Run local linting, syntax validation, and type-checks before reporting completion.
- Ensure all created or modified files adhere to workspace boundaries and avoid uncommitted secrets.
- Verify tests or build commands exit cleanly with return code 0.