How to install SQL Database Shell

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:

• Python 3.x
• Psycopg2
• MySQL Connector/Python

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

2. Enter the directory:

cd edgesql-shell

3. Install the Python dependencies:

python -m venv env
source env/bin/activate
brew install postgresql
pip install -r requirements.txt

4. Install the required system dependencies:

pip install mysql-connector-python
pip install psycopg2

5. Set your personal token as an environment variable:

 export AZION_TOKEN="<your_auth_token_here>"

6. 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.