Skip to content
Anyquery logo Anyquery

anyquery connection

Manage connections to other databases

Synopsis

Anyquery can connect to other databases such as MySQL, PostgreSQL, SQLite, etc. You can add, list, and delete connections.

Each connection has a name, a type, and a connection string. You can also define a small CEL script to filter which tables to import. The connection name will be used as the schema name in the queries. For example, if you have a connection named “mydb”, a schema named “information_schema” and a table named “tables”, you can query it with “SELECT * FROM mydb.information_schema_tables”.

Terminal window
anyquery connection [flags]

Examples

Terminal window
# List the connections
anyquery connection list


# Add a connection
anyquery connection add mydb mysql mysql://user:password@localhost:3306/dbname "table.schema == 'public'"


# Remove a connection
anyquery connection remove mydb

Options

Terminal window
      --csv             Output format as CSV
      --format string   Output format (pretty, json, csv, plain)
  -h, --help            help for connection
      --json            Output format as JSON
      --plain           Output format as plain text

SEE ALSO