Connecting to databases

sqlx-ts supports the following approach connect to the database

  1. File based configuration
  2. CLI options
  3. Environment variables

If you provide database host by a CLI option and an environment variable, CLI option will take the priority over the environment variable.

1. File based config

If your project needs connections to multiple databases for SQL check, you have to use the file based config and specify connection details for those databases. Please check here for more details

2. CLI options

You can only configure the primary database connection through CLI options. Please check here for more details

3. Environment variables

You can only configure the primary database connection through environment variables. Please check here for more details