TimescaleDB: 1. Authenticate

This documentation is part of the Automate with the CLI guide. You can view the complete guide here: Start TimescaleDB, retrieve its credentials, and modify its configuration programmatically using the Stackhero CLI.

Welcome to the Stackhero documentation!

Stackhero offers a ready-to-use TimescaleDB cloud solution designed to get you started within minutes. Here’s what you can expect:

• All the top plugins included, such as PostGIS, PgVector, and many more.
• Convenient access to the PgAdmin web interface for straightforward database management.
• Simple, one-click updates to keep your deployment up to date.
• Reliable performance and enhanced security on your own private, dedicated infrastructure.

If you are looking to save time and simplify your processes, Stackhero’s TimescaleDB cloud hosting is designed to make your experience as seamless as possible. You can try it out in just 5 minutes!

The simplest way to get started is to log in via your browser. When you run the login command, the CLI opens a web page where you can approve access. No passwords or 2FA codes are entered into the CLI itself.

stackhero login

Once logged in, your credentials are stored locally and will be used automatically by subsequent CLI commands.

For fully automated environments such as scripts or CI pipelines, you may prefer a non-interactive access token. You can create one from your dashboard (Account > Access tokens), then export it as an environment variable. The CLI, as well as any script you run, will automatically detect it.

export STACKHERO_TOKEN="usr-xxxxxx:your-token"