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}