Azure Data Studio

[Azure Data Studio] provides a GUI to administer MSSQL and Postgres databases.

Docker command to show port numbers to add database connections in Azure Data Studio.


Azure Data Studio has an extension [PostgreSQL extension for Azure Data Studio] to add support for PostgresSQL. In Azure Data Studio, click the gears on the bottom left, click Extensions, and search for PostgresSQL.

Docker Setup

Command to show currently running docker containers.

docker ps

The ps argument displays a table with headers: IMAGE, COMMAND, CREATED, STATUS, PORTS, and NAMES.

Command to show all docker containers running or not.

docker ps -a

Command to stop a docker container.


Command to start a docker container.

docker start NAME_OF_CONTAINER

Command to remove a docker container.


Command to install MSSQL in a docker container. (Windows)

docker run --name sqlserver2019 -e "ACCEPT_EULA=Y" -e "SA_PASSWORD=Adam123456" -p 1401:1433 -d

Command to install PostgresSQL in a docker container.

docker run --name postgresql -p 5401:5432 -e POSTGRES_PASSWORD=Adam123456 -d postgres:latest

Command to open an interactive terminal (bash shell) in a docker container.

docker exec -it NAME_OF_CONTAINER bash

Bash shell command to show OS details.

cat /etc/os-release

Bash shell command to log into the SQL command-line tool.

/opt/mssql-tools/bin/sqlcmd -U sa -P Adam123456

SQL command to query the database version.

SELECT @@Version;

More Docker commands, bash commands, and SQL commands are available in Chapter 2 of [Database Foundations: Intro to Databases].

Ex_Files_Database_Foundations_Intro\Chapter 2