# Connections

## SQL Data Sources

Mprove connects to SQL databases that are supported by Malloy:

- PostgreSQL
- MySQL
- Presto / Trino
- SnowFlake
- BigQuery
- DataBricks
- MotherDuck (DuckDb)

## API Data Sources

The API connection is universal and can work with different API providers.
Logic for creating a request body and logic for transforming a response data must be defined in the [Store Model](/content/docs/reference/model-store).

Store connection types:

- API
- Google API

For **API** query, Mprove does a single request to the data source.

For **Google API** query, Mprove does 2 requests:

- Auth request to get credentials
- Data request (query)

## Internal Host and Internal Port Connection Parameters

Some connection types have optional internal host and internal port parameters.

If you provide connection credentials to an external sandbox provider, it will use 
the host and port that are not internal, because the sandbox is not on a local network with the mprove server.

If the mprove server has an internal host and internal port specified for a connection, it will use them 
instead of the host/port. This removes an extra network hop from the mprove server to the DWH.