# Project connections

Project connections are data connections linked to a specific project in Recurve. For each project connection, you can define the connection type and specify separate target databases for **development** and **production** environments. This setup provides smooth transitions when promoting changes from development to production.

While a project can have multiple project connections, only one connection can be set as the primary database at a time. This primary database, also called the **analytics database**, is optimized for reading and aggregating data in large volumes. All models in your project will be executed and built under the analytics database.

This guide shows you how to create a project connection and set the analytics database.

## Create a project connection

Follow these steps:

1. Open your project and go to **Settings** > **Data connections**.
2. In the **Define connection** section, click **+ Add connection**.
3. Provide the connection name and the connection type for development and production environments.

   Note that the connection type must be the same for both development and production environments.

   <figure><img src="/files/QjHXy3cTK3o9F7LIlvWH" alt=""><figcaption></figcaption></figure>
4. Click **Create**.

## Set analytics database

To set connection as the analytics database, follow these steps:

1. Open your project and go to **Settings** > **Data connections.**
2. Click on the option button of the desired connection.

   <figure><img src="/files/9uEQXmBQcM6N1IOYXlnk" alt=""><figcaption></figcaption></figure>
3. In the opened pop-up, click **Confirm**.


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.reorc.com/connections/project-connections.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.
