Run SQL command.md

Running a SQL Command on the Atlas CMMS Database

This guide explains how to run a SQL command on the PostgreSQL database container used in the atlas-cmms Docker Compose setup.

Prerequisites

• Docker and Docker Compose installed.
• The atlas-cmms stack up and running:

docker compose up -d

Access the PostgreSQL Container

To execute a SQL command, first access the running PostgreSQL container:

docker exec -it atlas_db psql -U $POSTGRES_USER -d atlas

• atlas_db: Name of the container as defined in docker-compose.yml
• psql: The PostgreSQL CLI tool
• -U $POSTGRES_USER: Connects using the username from environment variables
• -d atlas: Connects to the atlas database

If your environment variables are not exported, replace $POSTGRES_USER with your actual database username.

Running a SQL Command

Once inside the PostgreSQL shell (psql), you can execute any SQL command. For example:

SELECT * FROM own_user;

To exit the psql shell, type:

\q

Running a One-Liner SQL Command Directly

You can also run a SQL command directly without entering the interactive shell:

docker exec -i atlas_db psql -U $POSTGRES_USER -d atlas -c "SELECT * FROM own_user;"

Replace "SELECT * FROM own_user;" with your actual SQL command.

For more advanced database operations or bulk SQL files, consider mounting a .sql file into the container and executing it.

Running a .sql File

Assuming you have a file init.sql in your current directory:

docker cp init.sql atlas_db:/init.sql
docker exec -i atlas_db psql -U $POSTGRES_USER -d atlas -f /init.sql

---

Troubleshooting

• Ensure the database container is running:

  docker ps

• Check logs if connection fails:

  docker logs atlas_db

---