# PostgreSQL

## Set up a PostgreSQL connection

When inside a workbook, click **View** > **Databases**, then click the **+** icon and follow the on-screen instructions.

![Create a PostgreSQL connection](https://4179539225-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MZqboFGZzD87nn7oPsm%2Fuploads%2FfKKI6h3gzU7095gEGMvj%2FScreenshot%202023-06-30%20at%2013.54.50.png?alt=media\&token=4f81cea1-7a83-4fa0-b95d-cf82f084d402)

For detailed instructions, see [connect-your-data-to-workspace](https://datalab-docs.datacamp.com/connect-to-data/connect-your-data-to-workspace "mention").

If you want to experiment with PostgreSQL without setting up a connection, you can use our sample database with Lego data ([source](https://rebrickable.com/downloads/)). 

## Query a PostgreSQL database

You can now query your PostgreSQL database with a [sql-cell](https://datalab-docs.datacamp.com/work/sql-cell "mention"). Select it in the **Select source** dropdown in the top left corner of a SQL cell, or select the sample PostgreSQL database.

<figure><img src="https://4179539225-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MZqboFGZzD87nn7oPsm%2Fuploads%2FhzaRsDokRalmtrNLC2j3%2FScreenshot%202023-06-28%20at%2015.22.18.png?alt=media&#x26;token=f0bc7441-58f4-45a9-af7c-7fecd5b561f3" alt=""><figcaption><p>Example of a SQL cell using the <code>Lego</code> sample database connection. The query result is available as <code>df</code>.</p></figcaption></figure>

###