@queryleaf/cli NPM

Overview

@queryleaf/cli provides a command-line interface for QueryLeaf, allowing you to execute SQL queries against MongoDB directly from your terminal. It leverages the core @queryleaf/lib package to parse SQL, transform it into MongoDB commands, and execute those commands.

Installation

# Global installation
npm install -g @queryleaf/cli
# or
yarn global add @queryleaf/cli

# Local installation
npm install @queryleaf/cli
# or
yarn add @queryleaf/cli

Usage

# Basic usage
queryleaf --uri mongodb://localhost:27017 --db mydb "SELECT * FROM users"

# With authentication
queryleaf --uri mongodb://user:pass@localhost:27017 --db mydb "SELECT * FROM users"

# Output formatting
queryleaf --uri mongodb://localhost:27017 --db mydb --format table "SELECT * FROM users"

# Help
queryleaf --help

Example Queries

# Basic SELECT with WHERE
queryleaf "SELECT name, email FROM users WHERE age > 21"

# Nested field access
queryleaf "SELECT name, address.city FROM users WHERE address.zip = '10001'"

# Array access
queryleaf "SELECT items[0].name FROM orders WHERE items[0].price > 100"

# GROUP BY with aggregation
queryleaf "SELECT status, COUNT(*) as count FROM orders GROUP BY status"

# JOIN between collections
queryleaf "SELECT u.name, o.total FROM users u JOIN orders o ON u._id = o.userId"

Configuration

You can configure the CLI using command-line arguments or environment variables:

Argument	Environment Variable	Description
`--uri`	`MONGODB_URI`	MongoDB connection URI
`--db`	`MONGODB_DB`	MongoDB database name
`--format`	`QUERYLEAF_FORMAT`	Output format (json, table, csv)
`--debug`	`QUERYLEAF_DEBUG`	Enable debug output