Skip to content
Anyquery logo Anyquery

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 (requires prqlc in PATH)
  -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