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
PostgreSQL postgresql
SQL Server mssql+pyodbc
Amazon Redshift redshift+psycopg2
Snowflake snowflake
MySQL mysql+pymysql
MariaDB mysql+pymysql

Parameters

DBMS Parameter
SQL Server ?driver=ODBC+Driver+17+for+SQL+Server