usql is a command line SQL client for Uptycs with auto-complete and syntax highlighting features.

Pre-requisites for installation

Python 2.7 or higher

For complete details, refer to the article below

Usage / examples:

usql -k <api_key_file> global

global> <global_queries>

usql -k <api_key_file> realtime

realtime> set hostname = '<hostname>'

realtime> <realtime queries>

global> use realtime;

realtime> use global;

Related Articles

How to Obtain API key file

    • Related Articles

    • Create Jira Tickets from Uptycs Alerts

      This python module allows you to create Jira tickets from Uptycs alerts.  Usage: ./ <uptycs_apikey_file> [--domainsuffix <uptycs_domain>] The --domainsuffix flag is only required for uptycs domains other than '' This python script ...
    • OneLogin Integration

      Overview This document outlines all the information needed / provisioned  for Uptycs to configure OneLogin authentication Setup on the your side 1. ACS (Consumer) URL Validator* : https://<domain> 2. ACS (Consumer) URL* : ...
    • Auth0 Integration

      Overview This document outlines steps / information needed  to configure Auth0 authentication Procedure Create Uptycs Application Provision "Allowed Callback URLs", "Allowed Web Origins" Note : Replace <domain> with the actual domain. Enable SAML2 ...
    • AWS Tag Creation From Uptycs Saved Queries This script applies AWS tags to resources based on an Uptycs saved query. It uses the AWS Python SDK (boto3).  Usage:   python3 <uptycs_apikey_file> [-q <"query name"> | --all] -k <key> [-v <value>] -ec2 ...
    • SAML Configuration

      Uptycs supports SAML 2.0 authentication and is configured on the back-end by Uptycs Customer Success Team. Before generating metadata file on your side, request Uptycs to provide the config xml with contains Uptycs public cert. Here are the other ...