Connection CLI w/ password parameter

[noelgoodday]

Problem

I use git worktrees to run development of multiple features in parallel. Each worktree creates its own docker container with DB so that they don't share a single DB and can run completely in isolation. I have a worktree setup script that updates the connections JSON file with the new connection automatically but I cannot provide the password that way and have to manually enter it when connecting to the DB the first time.

Proposed solution

Allow creating connections via CLI, including setting the password.

Alternatives considered

To connect to a worktree DB I have to edit the connection once in the app to enter the password.

Related database type

None

[datlechin]

Thanks, real gap.

Going to solve this with a passwordSource field in connections.json instead of a CLI. Your script keeps editing the JSON the way it already does, plus one extra field per connection.

Three kinds:

• file: read from a chmod 600 file
• env: read an env var
• command: run a shell command (works with op read, vault, sops, pass)

For the worktree case:

{
  "passwordSource": {
    "kind": "file",
    "path": "~/.config/tablepro/secrets/feature-x.pw"
  }
}

Skipping the CLI because the password would land in shell history and ps output, and a separately signed binary is a lot of overhead for one extra JSON field.

Let me know if this misses anything in your workflow before I start.