# Databases

We support different databases: PostgreSQL, MySQL, SQL Server, and Redshift.

<figure><img src="/files/VU3A2njpCtzjoMUQWQhq" alt=""><figcaption></figcaption></figure>

## &#x20;Collecting data from a database:

To collect data from a database and create a chart, follow these steps:

1. Test and save your credentials for the database.
2. Write a query or use our AI chatbot to generate a query for you.
3. Run the query and view the data.
4. Define a data pipeline to handle filters, date formats, calculations, and other requirements.
5. Save the dataset.
6. Create a dashboard and add charts connected to the dataset.

## Security recommendation:&#x20;

For security purposes, we recommend the following:

1. [Create a user with read-only permissions.](/product-docs/overview/credentials/databases/postgressql/create-a-read-only-user-in-postgresql.md)
2. Grant the necessary privileges to the read-only user, ensuring they only have read access to specific tables.
3. Whitelist our IP addresses in your firewall to allow direct connections from BI.P.EYE servers to the database servers. 34.231.210.203, 18.204.26.186


---

# 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.bipeye.com/product-docs/overview/credentials/databases.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.