Toolless - File-based Document Database

Syntax

Terminal

toollessdb query <database> <collection> [options]

Alias: toollessdb q

Argument	Description
`database`	Name of the database
`collection`	Name of the collection

Option	Description	Default
`-p, --path`	Path to database directory	`./data`
`-f, --filter`	Filter query as JSON	`{}`
`-s, --sort`	Sort specification as JSON	-
`-l, --limit`	Limit number of results	`20`
`-k, --skip`	Skip number of results	`0`
`--fields`	Comma-separated fields to display	-
`--json`	Output as JSON array	-
`--count`	Show only count	-

Query all documents:

Terminal

toollessdb query myapp users

Query with filter:

Terminal

toollessdb query myapp users -f '{"active": true}'

Complex filter with operators:

Terminal

toollessdb query myapp users -f '{"age": {"$gte": 18}, "role": {"$in": ["admin", "moderator"]}}'

Sort results:

Terminal

toollessdb query myapp posts -s '{"createdAt": -1}' -l 10

Select specific fields:

Terminal

toollessdb query myapp users --fields name,email,role

Get count only:

Terminal

toollessdb query myapp users -f '{"active": true}' --count

Output as JSON:

Terminal

toollessdb query myapp users -f '{"role": "admin"}' --json

Pagination:

Terminal

# First page
toollessdb query myapp users -l 20 -k 0

# Second page
toollessdb query myapp users -l 20 -k 20

Filter values must be valid JSON. Use single quotes around the JSON and double quotes inside.