> For the complete documentation index, see [llms.txt](https://doc.sysdevmobile.com/kalipso/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://doc.sysdevmobile.com/kalipso/documentation/environment/project-explorer/database.md).

# Database

Kalipso lets you interact with either offline or online databases.

To access an existing database (ex. Microsoft SQL Server, Oracle, etc... ) or if you want, you can also create tables that will only exist in Kalipso we call them Local.

<figure><img src="https://1614058754-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FJ5vDGuBZwhJDeu5Rq7Wt%2Fuploads%2Fgit-blob-42b07d0e05eb56aa50cd15a514f085e69f2679b2%2Fenvironment_project_explorer_database_1.png?alt=media" alt=""><figcaption></figcaption></figure>

As you can see, the window appears divided into two areas: Database connection profiles and Tables.

The section on "*Database connection profiles*" is where the profiles are created. You can access a list of profiles already created or create new ones. The icons on the right side of the table with the profiles allow:

* **Add** - Adds a new Database connection profile to the project (this option opens a new window).
* **Edit** - Edit a Database connection profile already created. In this case, you will have to select the profile already created in the list (this option opens a new window).
* **Copy** - Copies a Database connection profile already created.
* **Paste** - Paste a copied Database connection profile.
* **Delete** - Deletes the Database connection profile selected in the list.

When you click on add a new database connection profile a new window appears that allows you to create it. This window is similar to the one that appears when editing an already created profile. Therefore, the process for both actions is described simultaneously. To access the description in more detail click on the following link:

* [**Database Profile**](/kalipso/documentation/environment/project-explorer/database/database-profile.md)

The section on "*Tables*" is where the tables are created. You can access a list of tables already created or create new ones. The icons on the right side of the table with the profiles allow:

* **Add** - Adds a new table to the project (this option opens a new window).
* **Edit** - Edit a table already created. In this case, you will have to select the table already created in the list (this option opens a new window).
* **Rename** - Renames a selected table in the list.
* **Copy** - Copies a table already created.
* **Paste** - Paste a copied table.
* **Duplicate** - Duplicates a selected table in the list.
* **Delete** - Deletes the table selected in the list.

The table presenting the tables already created shows their name and description.

When you click on add a new table a new window appears that allows you to create it. This window is similar to the one that appears when editing an already created table. Therefore, the process for both actions is described simultaneously. To access the description in more detail click on the following link:

* [**Tables**](/kalipso/documentation/environment/project-explorer/database/tables.md)