Spry CLI Commands

Command Overview

The Spry CLI provides commands for managing executable Markdown notebooks, SQLPage content, and task orchestration.

• ./spry.ts --help - Display help information for the CLI
• ./spry.ts --version - Show the current version number
• ./spry.ts init - Initialize Spryfile.md and spry.ts for local development
• ./spry.ts init --dialect postgres - Initialize with PostgreSQL
• ./spry.ts init --force - Force reinitialize
• ./spry.ts doctor - Check dependencies and their availability
• ./spry.ts mdast ls Spryfile.md - List all MDAST nodes in Spryfile
• ./spry.ts mdast ls README.md docs/guide.md . - List nodes from multiple files
• ./spry.ts mdast ls docs/*.md - List nodes from all Markdown files in docs directory
• ./spry.ts mdast identifiers Spryfile.md - List all node identifiers
• ./spry.ts mdast identifiers docs/*.md - List identifiers across multiple files
• ./spry.ts mdast identifiers Spryfile.md | sort | uniq - List unique identifiers sorted
• ./spry.ts mdast identifiers docs/*.md | sort | uniq -d - Find duplicate identifiers
• ./spry.ts mdast tree Spryfile.md - Show document hierarchy
• ./spry.ts mdast tree docs/*.md - Show hierarchy for all docs
• ./spry.ts mdast class Spryfile.md - Show all classifications
• ./spry.ts mdast schema Spryfile.md - Validate document schema
• ./spry.ts mdast schema docs/*.md - Validate multiple documents
• ./spry.ts spc --package - Generate SQL package for SQLite
• ./spry.ts spc --package --dialect postgres - Generate SQL package for PostgreSQL
• ./spry.ts spc --fs dev-src.auto - Materialize files to directory
• ./spry.ts spc --fs dev-src.auto --conf sqlpage/sqlpage.json - Materialize files with config file
• ./spry.ts spc --fs dev-src.auto --destroy-first - Clean build (remove existing files first)
• ./spry.ts spc --fs dev-src.auto --watch - Watch mode with auto-rebuild
• ./spry.ts spc --fs dev-src.auto --destroy-first --watch --with-sqlpage - Watch mode with SQLPage server
• ./spry.ts spc --fs dev-src.auto --watch --with-sqlpage --sqlpage-bin /usr/local/bin/sqlpage - Watch mode with custom SQLPage binary
• ./spry.ts spc --package | sqlite3 app.db - Deploy to SQLite database
• ./spry.ts spc --package --dialect postgres | psql $DATABASE_URL - Deploy to PostgreSQL
• ./spry.ts spc --package --dialect postgres | psql postgresql://user:pass@host:5432/db - Deploy to remote PostgreSQL
• ./spry.ts spc ls - List SQLPage files
• ./spry.ts spc cat -g "*.sql" - Show file contents matching glob pattern
• ./spry.ts task prepare-db - Execute prepare-db task
• ./spry.ts task deploy --summarize --verbose rich - Execute deploy task with summary and verbose output
• ./spry.ts task build --verbose rich - Execute build task with verbose output
• ./spry.ts task ls - List all available tasks
• ./spry.ts task ls --md example.md - List tasks from specific file
• ./spry.ts task ls --all - List all tasks with details
• ./spry.ts task ls --select "language:bash" - List tasks by language
• ./spry.ts task ls --select 'flags.graph == "init"' - List tasks by graph flag
• ./spry.ts runbook - Execute all tasks in DAG order
• ./spry.ts runbook --select "language:sql" - Execute filtered tasks by language
• ./spry.ts runbook --select 'flags.graph == "init"' - Execute tasks by graph flag
• ./spry.ts runbook --verbose rich --summarize - Execute with verbose output and summary
• ./spry.ts runbook --visualize - Visualize execution graph
• ./spry.ts runbook --visualize <style> - Visualize with specific style
• ./spry.ts runbook ls - List runbook entries
• ./spry.ts qf ls - List quality folio items

Command Structure

All commands follow this pattern:

./spry.ts [command] [subcommand] [options] [arguments]

See individual command pages for detailed usage and examples.