> ## Documentation Index
> Fetch the complete documentation index at: https://docs.omni.co/llms.txt
> Use this file to discover all available pages before exploring further.

# Creating quick database connections with connection strings

> Create database connections quickly by pasting a connection URI

You can quickly create a database connection in Omni by pasting a standard connection URI instead of filling out the connection form manually. This method supports most common database types and automatically parses your connection details.

## Requirements

To use quick connect with a connection string, you'll need:

* **Organization Admin permissions in Omni**
* A connection string (URI) for your database in the standard format

## Supported databases

Quick connect supports the following databases:

* [ClickHouse](https://docs.omni.co/connect-data/setup/clickhouse.md)
* [Databricks](https://docs.omni.co/connect-data/setup/databricks.md)
* Exasol
* [MariaDB](https://docs.omni.co/connect-data/setup/mariadb.md)
* [Microsoft Fabric](https://docs.omni.co/connect-data/setup/microsoft-fabric.md)
* [Microsoft SQL Server](https://docs.omni.co/connect-data/setup/microsoftsql.md)
* [MySQL](https://docs.omni.co/connect-data/setup/mysql.md)
* [PostgreSQL](https://docs.omni.co/connect-data/setup/postgres.md)
* [Redshift](https://docs.omni.co/connect-data/setup/redshift.md)
* [Snowflake](https://docs.omni.co/connect-data/setup/snowflake.md)
* [StarRocks](https://docs.omni.co/connect-data/setup/starrocks.md)
* Trino

> [!NOTE]
>
> Oracle connections require manual setup through the connection form to accept the license agreement.

## Connection string format

Connection strings follow the standard URI format:

```text theme={null}
dialect://username:password@host:port/database
```

For databases that support additional parameters, add them as [query parameters](#database-specific-parameters):

```text theme={null}
dialect://username:password@host:port/database?parameter=value
```

> [!TIP]
>
> If your username or password contains special characters, they must be [URL-encoded in the connection string](#special-characters-in-credentials).

### Examples

```text Databricks theme={null}
databricks://token:dapi123abc@workspace.cloud.databricks.com:443/default?http_path=/sql/1.0/warehouses/abc123
```

```text Microsoft Fabric theme={null}
fabric://<client-id>:<secret>@<sql-connection-string>:1433/sales_warehouse?schema=dbo
```

```text Microsoft SQL Server theme={null}
mssql://omni_user:password@db.example.com:1433/analytics?schema=dbo
```

```text MySQL theme={null}
mysql://omni_user:password@db.example.com:3306/analytics
```

```text PostgreSQL theme={null}
postgresql://omni_user:password@db.example.com:5432/analytics
```

```text Snowflake theme={null}
snowflake://omni_user:password@account.snowflakecomputing.com/database?warehouse=COMPUTE_WH
```

## Using quick connect

### 1. Prep the database

Before you start, prep your database for the connection. This can include:

* Creating an Omni database user and granting permissions
* Setting up a table upload schema (for CSV uploads)
* Adding Omni's IP addresses to an allowlist

Refer to the [setup guide](#supported-databases) for your database for more information.

### 2. Navigate to the new connection page

In Omni, go to **Settings > Connections** and click **New connection**.

### 3. Paste your connection string

> [!TIP]
>
> If your credentials contain any special characters, be sure to [URL-encode them](#special-characters-in-credentials) when adding the connection string in Omni.

At the bottom of the page, you'll see a quick connect input field. Paste your connection string and press **Connect**:

![Quick connect input field on the new connection page](https://mintcdn.com/omni-e7402367/nyZ3EFAVf53-22yr/connect-data/images/quick-connect.png?fit=max\&auto=format\&n=nyZ3EFAVf53-22yr\&q=85\&s=080e285fdc9cb29251ef002f4693cfb5)

Omni will automatically parse the connection details and create the connection.

If the connection string format is invalid or missing required fields, an error message will display below the input. Error messages never include passwords for security.

If you encounter a server error during connection creation, you'll be redirected to the connection form where you can review and adjust the settings.

## Database-specific parameters

Some databases support additional parameters in the connection string:

| Database | Parameter | Description | Example |
| - | - | - | - |
| Snowflake | `warehouse` | Snowflake warehouse name | `?warehouse=COMPUTE_WH` |
| Snowflake | `account` | Snowflake account identifier | Added automatically from host |
| Microsoft Fabric | `schema` | Default schema | `?schema=dbo` |
| Microsoft SQL Server | `schema` | Default schema | `?schema=dbo` |
| Databricks | `http_path` | HTTP path to the SQL warehouse | `?http_path=/sql/1.0/warehouses/abc123` |

## Special characters in credentials

If your username or password contains special characters, they must be URL-encoded in the connection string:

| Character | Encoded value |
| - | - |
| `@` | `%40` |
| `:` | `%3A` |
| `/` | `%2F` |
| `?` | `%3F` |
| `#` | `%23` |
| `&` | `%26` |

For example, if your password is `p@ss:word`, use `p%40ss%3Aword` in the connection string.

## What's next?

After creating your connection, you may want to:

* [Restrict schemas](https://docs.omni.co/connect-data/schema-restriction.md) to limit which schemas are visible in Omni
* [Configure timezones](https://docs.omni.co/connect-data/timezones.md) for your connection
* Set up [SSH tunnels](https://docs.omni.co/connect-data/ssh-tunnels.md) or [AWS PrivateLink](https://docs.omni.co/connect-data/aws-privatelink.md) for secure connections
