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
IBM DB2	db2+ibm_db
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}