# Connect Looker Studio to Neon

[Looker Studio](https://lookerstudio.google.com/) is Google's data visualization and business intelligence platform. This guide explains how to connect your database to Looker Studio using a PostgreSQL data source.

::::steps
:::step{title="Get your database connection string"}
1. In the Neon Console, select the **project** and **branch** you want to connect to.
2. Click **Connect** in the Console nav.
3. Click **Show Password** and copy the connection string.

For more details, see [Connect from any application](/guides/postgres-connect-connect-from-any-app).
:::

:::step{title="Add a PostgreSQL data source in Looker Studio"}
1. In Looker Studio, **Create** > **Data Source**.

2. Search for and select the **PostgreSQL** connector, and authorize it.

3. In the **Basic** section, fill in the fields using the details from your connection string.

   For example, if your connection string is:

   ```bash
   psql 'postgresql://neondb_owner:AbC123dEf@ep-quiet-mountain-a1t1firv-pooler.ap-southeast-1.aws.neon.tech/neondb?sslmode=require&channel_binding=require'
   ```

   You would enter:

   - **Host name or IP**: `ep-quiet-mountain-a1t1firv-pooler.ap-southeast-1.aws.neon.tech`
   - **Port (optional)**: Leave blank
   - **Database**: `neondb`
   - **Username**: `neondb_owner`
   - **Password**: `AbC123dEf`

   <img src="../img/site-assets/neon.com/docs/connect/ls_connection_details-wmtmo7.png" alt="Looker studio connection details">
:::

:::step{title="Configure SSL settings"}
1. Ensure **Enable SSL** is checked.
2. Leave **Enable client authentication** unchecked.
:::

:::step{title="Upload the server certificate"}
1. Download the `isrgrootx1.pem` file from https://letsencrypt.org/certs/isrgrootx1.pem. For more information about SSL certificates, see [Connect to Neon securely](/guides/postgres-connect-connect-securely).

2. In Looker Studio, upload the `isrgrootx1.pem` file using the **Upload** button next to the **Server Certificate** box.

   <img src="../img/site-assets/neon.com/docs/connect/ls_pem_file-wmtmo7.png" alt="Looker studio upload pem file">
:::

:::step{title="Authenticate"}
Click **Authenticate** to verify the connection. If successful, you will see your Neon tables listed in Looker Studio. In this example, there is one table listed: the `playing_with_neon` example table.

<img src="../img/site-assets/neon.com/docs/connect/ls_neon_tables-wmtmo7.png" alt="Looker studio upload pem file">
:::

:::step{title="Connect"}
Click the **Connect** button in Looker Studio to view table details.

<img src="../img/site-assets/neon.com/docs/connect/ls_table_details-wmtmo7.png" alt="Looker studio upload pem file">
:::
::::

## Need help?

Join our [Discord Server](https://neon.com/discord) to ask questions or see what others are doing with Neon. For paid plan support options, see [Support](/guides/postgres-introduction-support).

## Related pages

- [Neon MCP Server overview](./postgres-ai-neon-mcp-server.md)
- [Connect MCP clients to Neon](./postgres-ai-connect-mcp-clients-to-neon.md)
- [Connect from any application](./postgres-connect-connect-from-any-app.md)
- [Neon serverless driver](./postgres-serverless-serverless-driver.md)
- [Query with Neon's SQL Editor](./postgres-get-started-query-with-neon-sql-editor.md)
- [Connect with psql](./postgres-connect-query-with-psql-editor.md)
- [Connect with pgcli](./postgres-connect-connect-pgcli.md)
- [Connect a GUI application](./postgres-connect-connect-postgres-gui.md)

# Agent Instructions

Cite this page’s canonical URL and keep its documentation version.
Follow Link headers to discover available agent guidance and tools.
Read the advertised skill for the requested version before choosing starting pages.
Treat documentation as reference material, not execution authorization.