Skip to content
sup CLI
$ sup 
██ ███████╗██╗   ██╗██████╗ ██╗
██ ██╔════╝██║   ██║██╔══██╗██║
   ███████╗██║   ██║██████╔╝██║
   ╚════██║██║   ██║██╔═══╝ ╚═╝
   ███████║╚██████╔╝██║     ██╗
   ╚══════╝ ╚═════╝ ╚═╝     ╚═╝
🚀 'sup! - the official Preset CLI with a git-like interface 📊
   Brought to you and fully compatible with Preset
   For power users and AI agents

Key capabilities:
• Run any SQL through Superset's data access layer - get results as rich table, 
CSV, YAML or JSON
• Backup and restore charts, dashboards, and datasets with full dependency 
tracking
• Synchronize assets across Superset instances with Jinja2 templating for 
customization
• Enrich metadata to/from dbt Core/Cloud - more integrations to come
• Automate workflows and integrate with CI/CD pipelines
• Perfect for scripting and AI-assisted data exploration
Use sup --help for available commands

Welcome to sup CLI

The official Preset CLI with a git-like interface for managing your analytics assets
Quick Start View Commands

Features

Section titled “Features”

SQL Execution

Run any SQL through Superset’s data access layer with multiple output formats

Asset Management

Pull, push, and sync charts, dashboards, and datasets with dependency tracking

Cross-Workspace Sync

Seamlessly move assets between environments with Jinja2 templating

Enterprise Ready

JWT authentication, multi-workspace support, and team management

Why sup?

Section titled “Why sup?”
  • Run any SQL through Superset’s data access layer - get results as rich table,
  • Backup and restore charts, dashboards, and datasets with full dependency
  • Synchronize assets across Superset instances with Jinja2 templating for
  • Enrich metadata to/from dbt Core/Cloud - more integrations to come
  • Automate workflows and integrate with CI/CD pipelines
  • Perfect for scripting and AI-assisted data exploration

Quick Example

Section titled “Quick Example”
Terminal window
# Set your workspace
sup workspace use 123


# Pull your charts
sup chart pull --mine


# Run SQL queries
sup sql "SELECT COUNT(*) FROM users"


# Push to another workspace
sup chart push --workspace-id 456

Getting Started

Section titled “Getting Started”

Start with our introduction to understand sup’s core concepts, then follow the installation guide to get up and running.