What is a Database URL?

The Database URL is the connection string of a database.

By default in Mitto it is the local database (postgresql://localhost/analytics).

The structure of database connection strings is as follows:

<driver>://<username>:<password>@<server>:<port>/<database>?<parameters>

Common database drivers

DBMS Driver
Amazon Redshift redshift+psycopg2
Google BigQuery bigquery
MariaDB mysql+pymysql
MySQL mysql+pymysql
PostgreSQL postgresql
SQL Server mssql+pyodbc
Snowflake snowflake

Parameters

DBMS Parameter
SQL Server ?driver=ODBC+Driver+17+for+SQL+Server
Snowflake ?warehouse={warehouse}