How to install SQL Database Shell

Learn how to install SQL Database Shell to interact with your SQL Database database.

View as Markdown

SQL Database Shell is a command-line interface (CLI) tool for interacting with Azion SQL Database, allowing users to manage databases, execute SQL commands, and perform various database operations.

This guide will show you how to install SQL Database Shell and start taking advantage of its features to easily manage your databases.

Requirements

In order to install SQL Database Shell you must have the following dependencies installed:

You’ll also need an Azion personal token.

Installing SQL Database Shell

  1. Clone the SQL Database Shell git repository:
git clone https://github.com/aziontech/edgesql-shell.git
  1. Enter the directory:
cd edgesql-shell
  1. Install the Python dependencies:
python -m venv env
source env/bin/activate
brew install postgresql
pip install -r requirements.txt
  1. Install the required system dependencies:
pip install mysql-connector-python
pip install psycopg2
  1. Set your personal token as an environment variable:
export AZION_TOKEN="<your_auth_token_here>"
  1. Execute the following command to run the SQL Database Shell:
python edgesql-shell.py

Now you can use the SQL Database Shell commands, set environment variables and run SQL queries directly in the terminal.

Go to SQL Database Shell commands reference