> For the complete documentation index, see [llms.txt](https://docs.phocassoftware.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.phocassoftware.com/basics/getting-started/databases.md).

# Databases

Learn about databases, the foundation upon which your Phocas site is built.

Each database in Phocas contains data from an ERP or other business system. This data is usually refreshed overnight. Your actions in Phocas do not affect the source data.

Common databases include Sales, Purchasing, Inventory and Financial Statements. The databases you see depend on your Phocas setup and database permissions. Typically, financial databases open in Financial Statements, while operational (non-financial) databases, such as Sales, can open in Analytics or Analytics (Classic).

### Ways to open a database <a href="#databases-waystoopenadatabase" id="databases-waystoopenadatabase"></a>

Depending on your license and permissions, you can open a database from your homepage, side menu or Recents panel.

On your [homepage](https://docs.phocassoftware.com/basics/getting-started/homepage.md), databases appear in the grid alongside your other content items and are identified by the database icon. To show only databases, select **Database** in the **Type** filter. Click a database to open it.

<div align="left"><figure><img src="https://900295827-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F7pj8v25BOyqZTdG5mdD1%2Fuploads%2FlpRXUO2TWqI1gHuwZ2Yb%2Fimage.png?alt=media&amp;token=abb19f6e-f384-4fb6-aa04-6e93099f43e1" alt="" width="358"><figcaption></figcaption></figure></div>

In your [side menu](https://docs.phocassoftware.com/basics/getting-started/navigation.md), click **Analytics**, **Analytics (Classic)** or **Financial Statements** to view the available databases, then click a database to open it. You can also reopen recently viewed databases from the **Recents** panel.

{% columns %}
{% column width="41.66666666666667%" %}

<div align="left"><figure><img src="https://900295827-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F7pj8v25BOyqZTdG5mdD1%2Fuploads%2FAWAcq52sExR4ujL4GOub%2Fimage.png?alt=media&amp;token=d39ce64a-87fc-4c47-9a83-615755443b09" alt=""><figcaption></figcaption></figure></div>
{% endcolumn %}

{% column width="58.33333333333333%" %}

<figure><img src="https://900295827-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F7pj8v25BOyqZTdG5mdD1%2Fuploads%2FInRxBehhKbzWGmbzGKAC%2Fimage.png?alt=media&amp;token=cd8efdcd-227d-4283-9083-7d8ca1f744ab" alt=""><figcaption></figcaption></figure>
{% endcolumn %}
{% endcolumns %}

### Database status <a href="#databases-databasestatus" id="databases-databasestatus"></a>

When you open a database, a colored dot next to its name in the top left of the screen indicates its status:

* **Blue:** The database is being rebuilt.
* **Green:** The database is available.
* **Red:** The latest rebuild failed, so the data might be out of date.

Hover over the dot for more information.

<div align="left"><figure><img src="https://900295827-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F7pj8v25BOyqZTdG5mdD1%2Fuploads%2Fgit-blob-e8931df124d5e89d8958d3c363cd76192546a3b0%2F3260088468.png?alt=media" alt="" width="308"><figcaption></figcaption></figure></div>

### Suspended databases

Databases that have not been used for a long time can become *suspended*. When you open a suspended database, a warning message appears and the database rebuild starts automatically. You don't need to take any further action. The database should be available with updated data in around five minutes.


---

# 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.phocassoftware.com/basics/getting-started/databases.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.
