> ## 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](/connect-data/setup/clickhouse)
* [Databricks](/connect-data/setup/databricks)
* Exasol
* [MariaDB](/connect-data/setup/mariadb)
* [Microsoft SQL Server](/connect-data/setup/microsoftsql)
* [MySQL](/connect-data/setup/mysql)
* [PostgreSQL](/connect-data/setup/postgres)
* [Redshift](/connect-data/setup/redshift)
* [Snowflake](/connect-data/setup/snowflake)
* [StarRocks](/connect-data/setup/starrocks)
* Trino

<Note>
  Oracle connections require manual setup through the connection form to accept the license agreement.
</Note>

## 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).
</Tip>

### Examples

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

  ```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
  ```
</CodeGroup>

## Using quick connect

<Steps>
  <Step title="Prep the database" titleSize="h3">
    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.
  </Step>

  <Step title="Navigate to the new connection page" titleSize="h3">
    In Omni, go to **Settings > Connections** and click **New connection**.
  </Step>

  <Step title="Paste your connection string" titleSize="h3">
    <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.
    </Tip>

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

    <img src="https://mintcdn.com/omni-e7402367/nyZ3EFAVf53-22yr/connect-data/images/quick-connect.png?fit=max&auto=format&n=nyZ3EFAVf53-22yr&q=85&s=080e285fdc9cb29251ef002f4693cfb5" alt="Quick connect input field on the new connection page" width="1369" height="211" data-path="connect-data/images/quick-connect.png" />

    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.
  </Step>
</Steps>

## 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 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](/connect-data/schema-restriction) to limit which schemas are visible in Omni
* [Configure timezones](/connect-data/timezones) for your connection
* Set up [SSH tunnels](/connect-data/ssh-tunnels) or [AWS PrivateLink](/connect-data/aws-privatelink) for secure connections