list

List all discovered models with their metadata, dependencies, and last run status.

Output adapts to environment:

• Terminal: Styled, colored output
• Piped/Scripted: Markdown format (agent-friendly)

Use --output to override: auto, text, markdown, json

Usage

leapsql list

Global Options

Option	Short	Default	Description
--config			config file (default: ./leapsql.yaml)
--database			Path to DuckDB database (empty for in-memory)
--env			Environment name
--macros-dir			Path to macros directory
--models-dir			Path to models directory
--output	-o		Output format (auto|text|markdown|json)
--project-dir	-C		Project root directory (auto-detected from models-dir or config file location)
--seeds-dir			Path to seeds directory
--state			Path to state database
--target	-t		Target environment to use (e.g., dev, staging, prod)
--verbose	-v	false	Verbose output

Examples

# List all models (auto-detect output format)
leapsql list

# List models as JSON
leapsql list --output json

# List models as Markdown (for agents/scripts)
leapsql list --output markdown

# List models with verbose output
leapsql list -v