connect

open psql on a database

Open psql on a database through an authenticated tunnel. Needs psql on your PATH and, for now, public access on with your IP address allowed (csph db public enable <name> --allow <your-ip>). Anything after -- goes to psql.

Usage

csph db connect <name|id> [-- psql args] [flags]

Options

Command Specific

--environment <string>

environment ID

--pooled

go through the connection pooler instead of the primary

--project <string>

project ID

Inherited

--config <string>

config file (default is $HOME/.config/computesphere/configuration.yaml)

--debug

enable debug logging

-h, --help

show this help message

-i, --interactive

run interactively (prompts, pickers, table browser)

--log-level <string>

log level: [trace|debug|info|warn|error|fatal|panic|disabled||api]

--no-color

disable color output

--no-input

disable interactive mode

Examples

  csph db connect orders
  csph db connect orders -- -c 'select now()'

See also

• csph db — manage SphereDB databases
• csph db list — list databases
• csph db get — show a database
• csph db create — create a SphereDB database
• csph db delete — delete a database
• csph db instance-types — list database instance types and prices
• csph db resize — change a database's instance type, high availability or storage
• csph db connection-string — print a connection string
• csph db credentials — manage database credentials
• csph db tunnel — open a local port to a database
• csph db public — manage the public endpoint (IP allowlist)