Skip to content

anyquery

A tool to query any data source

Synopsis

Anyquery allows you to query any data source by writing SQL queries. It can be extended with plugins

Terminal window
anyquery [database] [query] [flags]

Examples

Terminal window
# Run a one-off query
anyquery -d mydatabase.db -q "SELECT * FROM mytable"
# Open the interactive shell
anyquery -d mydatabase.db
# Open a database in memory
anyquery -d ":memory:"

Options

Terminal window
-c, --config string Path to the configuration database
--csv Output format as CSV
-d, --database string Database to connect to (a path or :memory:)
--dev Run the program in developer mode
--extension strings Load one or more extensions by specifying their path. Separate multiple extensions with a comma.
--format string Output format (pretty, json, csv, plain)
-h, --help help for anyquery
--in-memory Use an in-memory database
--init stringArray Run SQL commands in a file before the query. You can specify multiple files.
--json Output format as JSON
--language string Alternative language to use
--log-file string Log file
--log-format string Log format (text, json) (default "text")
--log-level string Log level (trace, debug, info, warn, error, off) (default "info")
--no-input Do not launch an interactive input
--plain Output format as plain text
--pql Use the PQL language
--prql Use the PRQL language
-q, --query string Query to run
--read-only Start the server in read-only mode
--readonly Start the server in read-only mode

SEE ALSO