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

# 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