> For the complete documentation index, see [llms.txt](https://docs.skyone.cloud/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.skyone.cloud/english/skyone-studio/modules/settings-and-operations/module-settings/connectivity-database.md).

# Connectivity: Database

### Overview <a href="#overview" id="overview"></a>

**Database connectivity** is used to enable direct access to information from major Database Management Systems (DBMS) in the market: **MySQL, PostgreSQL, SQL Server, Firebird,** and **Oracle**.

For this type of connectivity, Skyone Studio supports SQL commands such as **SELECT**, **UPDATE**, **DELETE**, **CREATE**, among others.

**SELECT operations** are the most common. They allow secure querying of the database, returning information in a structured JSON format.

**UPDATE**, **DELETE**, and **CREATE operations** are used when the system lacks processes exposed via APIs and require more control, as these commands modify the database directly. We recommend using **views** or **temporary tables** that will be processed later.

***

#### How to connect an account <a href="#how-to-connect-an-account" id="how-to-connect-an-account"></a>

After defining the type of connectivity, the next step is to choose the **type of authentication.** Only after these settings have been made will you be able to add a new account, as well as select, edit or remove one of the previously registered accounts.

To add a connected account, click on "**Connected account"** and then "**Add connected account"**.

<figure><img src="https://2493694111-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FQPcfIOA6Tl2Bmk6CdV2O%2Fuploads%2FLlpNzoDVnYOFMmSd9jKV%2Fchrome_e69REhvFLb.gif?alt=media&amp;token=f0793453-3581-4d8a-be07-7c6b2a9fb60d" alt=""><figcaption></figcaption></figure>

Follow the steps according to the type chosen in **Database (authentication type)**:

<details>

<summary>MySQL</summary>

When you choose the "**Add connected account"** option, the following modal will be displayed:

<figure><img src="https://2493694111-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FQPcfIOA6Tl2Bmk6CdV2O%2Fuploads%2FuCUQHp63vGKkup71LKdM%2Fimage.png?alt=media&amp;token=29c373f8-f7aa-45ad-b91f-99b0c91a845d" alt=""><figcaption></figcaption></figure>

Fill in the details:

1. **Terminal (optional)**: if you have a terminal set up, select it so that the connection is made through the corresponding **"Agent"**;
2. **Account name**: name of the registered account;
3. **Host**: IP of the database host;
4. **Port**: port number;
5. **User**;
6. **Password**;
7. **Database name (optional)**.

After filling in the details, click on **"Create account"**.

That's it! Your connected account has been created and can be used by other modules and flows, appearing among the options of accounts configured in both cases.

</details>

<details>

<summary>PostgreSQL</summary>

When you choose the "**Add connected account"** option, the following modal will be displayed:

<figure><img src="https://2493694111-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FQPcfIOA6Tl2Bmk6CdV2O%2Fuploads%2F1KzZmTPmSXtFiwbirrf1%2Fimage.png?alt=media&amp;token=811a3b8f-2904-4c40-baea-f1b5d483fbbd" alt=""><figcaption></figcaption></figure>

Fill in the details:

1. **Terminal** (optional): if you have a terminal set up, select it so that the connection is made through the corresponding **"Agent"**;
2. **Account name**: name of the registered account;
3. **Host**: IP of the database host;
4. **Port**: port number;
5. **User**;
6. **Password**;
7. **Database name** (optional).

After filling in the details, click on **"Create account"**.

That's it! Your connected account has been created and can be used by other modules and flows, appearing among the options of accounts configured in both cases

</details>

<details>

<summary>SQL Server</summary>

When you choose the "**Add connected account"** option, the following modal will be displayed:

<figure><img src="https://2493694111-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FQPcfIOA6Tl2Bmk6CdV2O%2Fuploads%2Ff4gTBmxNvoy4AejylbYJ%2Fimage.png?alt=media&amp;token=3b93afc7-3a30-473c-bbaa-408e36f968d2" alt=""><figcaption></figcaption></figure>

Fill in the details:

1. **Terminal** (optional): if you have a terminal set up, select it so that the connection is made through the corresponding **"Agent"**;
2. **Account name**: name of the registered account;
3. **Host**: IP of the database host;
4. **Port**: port number;
5. **User**;
6. **Password**;
7. **Database name** (optional);
8. **AppKey** (optional): application key.

After filling in the details, click on **"Create account"**.

Done! Your connected account has been created and can be used by other modules and flows, appearing among the options of accounts configured in both cases.

</details>

<details>

<summary>FireBird</summary>

When you choose the "**Add connected account"** option, the following modal will be displayed:

<figure><img src="https://2493694111-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FQPcfIOA6Tl2Bmk6CdV2O%2Fuploads%2FfQU75KnYD7Lm2q5DvGzu%2Fimage.png?alt=media&amp;token=be8b00d4-b84b-43e2-b4b9-a1dc258ecf55" alt=""><figcaption></figcaption></figure>

Fill in the details:

1. **Terminal** (optional): if you have a terminal set up, select it so that the connection is made through the corresponding **"Agent"**;
2. **Account name**: name of the registered account;
3. **Host**: IP of the database host;
4. **Port**: port number;
5. **User**;
6. **Password**;
7. **Database name** (optional).

After filling in the details, click on **"Create account"**.

That's it! Your connected account has been created and can be used by other modules and flows, appearing among the options of accounts configured in both cases.

</details>

<details>

<summary>FireBird 3+</summary>

When you choose the "**Add connected account"** option, the following modal will be displayed:

<figure><img src="https://2493694111-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FQPcfIOA6Tl2Bmk6CdV2O%2Fuploads%2FjaqMBiMgFrLMqCSdZiCn%2Fimage.png?alt=media&amp;token=9c4da306-db61-4890-8dad-794cc4bf265d" alt=""><figcaption></figcaption></figure>

Fill in the details:

1. **Terminal** (optional): if you have a terminal set up, select it so that the connection is made through the corresponding **"Agent"**;
2. **Account name**: name of the registered account;
3. **Host**: IP of the database host;
4. **Port**: port number;
5. **User**;
6. **Password**;
7. **Database name** (optional).

After filling in the details, click on **"Create account"**.

That's it! Your connected account has been created and can be used by other modules and flows, appearing among the options of accounts configured in both cases.

</details>

<details>

<summary>Oracle</summary>

When you choose the "**Add connected account"** option, the following modal will be displayed:

<figure><img src="https://2493694111-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FQPcfIOA6Tl2Bmk6CdV2O%2Fuploads%2FsK26eNvgCk7MGiuBnTyp%2Fimage.png?alt=media&amp;token=5e35f9df-dbdb-47f7-9d84-2f7a4663c425" alt=""><figcaption></figcaption></figure>

Fill in the details:

1. **Terminal** (optional): if you have a terminal set up, select it so that the connection is made through the corresponding **"Agent"**;
2. **Account name:** name of the registered account;
3. **Host**: IP of the database host;
4. **Port**: port number;
5. **User**;
6. **Password**;
7. **Database name** (optional);
8. **Schema** (optional): set of objects (tables, views, etc.) that belong to your account.

After filling in the details, click on **"Create account"**.

That's it! Your connected account has been created and can be used by other modules and flows, appearing among the options of accounts configured in both cases.

</details>

<details>

<summary>SAP Hana</summary>

When you choose the "**Add connected account"** option, the following modal will be displayed:

<figure><img src="https://2493694111-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FQPcfIOA6Tl2Bmk6CdV2O%2Fuploads%2FtrDWSuTcNCf7CDYzrmM9%2Fimage.png?alt=media&amp;token=fcfb2ded-0da2-4afc-8369-bb760d77e128" alt=""><figcaption></figcaption></figure>

Fill in the details:

1. **Terminal** (optional): if you have a terminal set up, select it so that the connection is made through the corresponding **"Agent"**;
2. **Account name**: name of the registered account;
3. **Host**: IP of the database host;
4. **Port**: port number;
5. **User**;
6. **Password**;
7. **Database name** (optional);
8. **Schema** (optional): set of objects (tables, views, etc.) that belong to your account.

After filling in the details, click on **"Create account"**.

That's it! Your connected account has been created and can be used by other modules and flows, appearing among the options of accounts configured in both cases.

</details>

<details>

<summary>InterSystems Caché</summary>

When you choose the "**Add connected account"** option, the following modal will be displayed:

<figure><img src="https://2493694111-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FQPcfIOA6Tl2Bmk6CdV2O%2Fuploads%2F5tSMvUOAX9IAnvr03RXb%2Fimage.png?alt=media&amp;token=3d8374a0-f7e6-4242-a5a6-78445041642f" alt=""><figcaption></figcaption></figure>

Fill in the details:

1. **Terminal (optional)**: if you have a terminal set up, select it so that the connection is made through the corresponding **"Agent"**;
2. **Account name**: name of the registered account;
3. **Host**: IP of the database host;
4. **Port**: port number;
5. **User**;
6. **Password**;
7. **Database name (optional)**.
8. **Namespace** (optional): must have the same value as the "database name" field.

After filling in the details, click on **"Create account"**.

That's it! Your connected account has been created and can be used by other modules and flows, appearing among the options of accounts configured in both cases.

</details>

<details>

<summary>ODBC</summary>

When you choose the "**Add connected account"** option, the following modal will be displayed:

<figure><img src="https://2493694111-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FQPcfIOA6Tl2Bmk6CdV2O%2Fuploads%2F5l47dMPyl1wQSfp1w7x4%2Fimage.png?alt=media&amp;token=6b2d6bbb-7e0f-419b-84cb-4d38881cb153" alt=""><figcaption></figcaption></figure>

Fill in the details:&#x20;

1. **Terminal:** select a previously configured [terminal](/english/skyone-studio/terminals-and-agent.md) so that the connection is made through the corresponding “**Agent**”;
2. **Account name**: name of the account to be registered;
3. **Connection string**: sequence of characters that provides all the information needed to connect to the ODBC database.

After filling in the details, click on **"Create account"**.

That's it! Your connected account has been created and can be used by other modules and flows, appearing among the options of accounts configured in both cases.

</details>

<details>

<summary>MongoDB</summary>

When you choose the "**Add connected account"** option, the following modal will be displayed:

<figure><img src="https://2493694111-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FQPcfIOA6Tl2Bmk6CdV2O%2Fuploads%2Fkyp0JElXoFkERbTsyMXM%2Fimage.png?alt=media&amp;token=01b955cb-1049-4b12-b9e2-c7d403e1179f" alt=""><figcaption></figcaption></figure>

Fill in the details:&#x20;

1. **Account name**: name of the account to be registered;
2. **Connection string**: sequence of characters that provides all the information needed to connect to the MongoDB database.

After filling in the details, click on **"Create account"**.

That's it! Your connected account has been created and can be used by other modules and flows, appearing among the options of accounts configured in both cases.

</details>

Finally, click on "**Save changes"** to configure your module settings.

{% hint style="warning" %}
Important: after saving the changes, it will no longer be possible to change the Connectivity type and/or Authentication type (Database).
{% endhint %}

Next step: [Create operations for the module](/english/skyone-studio/modules/settings-and-operations/operations.md)

Read also: [Connected accounts management](/english/skyone-studio/modules/settings-and-operations/module-settings/connected-account-management.md)


---

# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.

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

Perform an HTTP GET request on the following URL with the `ask` and `goal` query parameters:

```
GET https://docs.skyone.cloud/english/skyone-studio/modules/settings-and-operations/module-settings/connectivity-database.md?ask=<question>&goal=<user_goal>
```

`ask` is the immediate question: it should be specific, self-contained, and written in natural language.
`goal` is what the user is ultimately trying to achieve, the reason they need the answer. Sharing it helps GitBook give you a better, more relevant answer. A goal is most helpful when it describes the outcome the user wants rather than restating the question. For example, with `ask=how do I create an API token`, a goal like `automate deployments from our CI pipeline` lets GitBook tailor the answer to that use case.

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.