Devops Run SQL

Running SQL in the environment — queries or scripts, with credentials and connection from .env.

1. Know which database you are about to touch. The connection comes from this worktree's .env, so the same command hits a different database in another worktree. Check compass where if unsure.
2. Run the query through the recipe below, which supplies the credentials and connection rather than having you retype them.
3. Prefer a read before a write. A SELECT that returns the rows a DELETE would remove costs one command and prevents the mistake that needs a database rebuild.

• How do I run SQL in the environment? — credentials and connection come from the .env.

• ores.compass — the tool every one of these commands runs through.