Quick Start#

# Set environment variables
export DATABASE_URL="mysql://user:password@localhost:3306/database"
export DATABASE_QUERY="SELECT id, name FROM users LIMIT 10"
export OUTPUT_FILE="users.json"

# Run Gold Digger
gold_digger

gold_digger \
  --db-url "mysql://user:password@localhost:3306/database" \
  --query "SELECT id, name FROM users LIMIT 10" \
  --output users.csv

gold_digger \
  --db-url "mysql://user:pass@localhost:3306/db" \
  --query "SELECT id, name, email FROM users LIMIT 5" \
  --output users.json \
  --pretty

# Create a query file
echo "SELECT COUNT(*) as total_users FROM users" > user_count.sql

# Use the query file
gold_digger \
  --db-url "mysql://user:pass@localhost:3306/db" \
  --query-file user_count.sql \
  --output stats.json

# Force CSV format regardless of file extension
gold_digger \
  --db-url "mysql://user:pass@localhost:3306/db" \
  --query "SELECT * FROM products" \
  --output data.txt \
  --format csv

# Exit with code 0 even if no results (default exits with code 1)
gold_digger \
  --allow-empty \
  --db-url "mysql://user:pass@localhost:3306/db" \
  --query "SELECT * FROM users WHERE id = 999999" \
  --output empty.json

# Enable verbose output for debugging
gold_digger -v \
  --db-url "mysql://user:pass@localhost:3306/db" \
  --query "SELECT COUNT(*) FROM large_table" \
  --output count.json

# Bash
gold_digger completion bash > ~/.bash_completion.d/gold_digger
source ~/.bash_completion.d/gold_digger

# Zsh
gold_digger completion zsh > ~/.zsh/completions/_gold_digger

# Fish
gold_digger completion fish > ~/.config/fish/completions/gold_digger.fish

# PowerShell
gold_digger completion powershell > gold_digger.ps1

gold_digger \
  --db-url "mysql://user:pass@localhost:3306/db" \
  --query "SELECT 1" \
  --output test.json \
  --dump-config

{
  "database_url": "***REDACTED***",
  "query": "SELECT 1",
  "output": "test.json",
  "format": "json",
  "verbose": 0,
  "quiet": false,
  "pretty": false,
  "allow_empty": false,
  "features": {
    "ssl": true,
    "json": true,
    "csv": true,
    "verbose": true
  }
}