Skip to content
Anyquery logo Anyquery
🔍 Seeking a 6-month software engineering internship starting January 2027. Based in France, open to remote or relocation.
contact@julienc.me • Resume

anyquery

A tool to query any data source

Synopsis

Section titled “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

Section titled “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

Section titled “Options”
Terminal window
      --allow-attach           When sandboxed, allow ATTACH/VACUUM INTO to on-disk paths within --allow-dirs
      --allow-db-connections   When sandboxed, allow the database reader modules (duckdb/postgres/mysql/clickhouse/cassandra)
      --allow-dirs strings     When sandboxed, directories that read_* tables (and on-disk ATTACH) may access (repeatable, comma-separated)
      --allow-remote           When sandboxed, allow read_* tables to fetch remote URLs (http/https)
  -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 (the dev-mode plugin functions are unavailable if --sandbox is also passed)
      --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
      --sandbox                Apply server-style sandboxing restrictions (off by default in CLI mode)

SEE ALSO

Section titled “SEE ALSO”