---
title: "PostgreSQL: ask your database in plain words · Adea"
description: "Adea reads your PostgreSQL database through a user that can only read, and answers your questions with the numbers and the query behind them."
url: https://adea.app/integrations/postgres
---

# Ask your PostgreSQL database a question in plain words.

Give Adea a read-only user and ask about orders, customers or revenue the way you would ask a colleague. You get the answer and the query it came from.

[Connect PostgreSQL](https://adea.app/signup) [Read the setup guide](https://adea.app/docs/connect-database)

You can connect PostgreSQL today.

## What Adea reads from PostgreSQL

- The tables and views you allow, with their columns and keys
- Row counts and totals, read with plain SELECT queries
- Read replicas, so your main database stays untouched
- Schemas you pick, so internal tables stay out of reach

## How it connects

A user that can only read

[Read the setup guide](https://adea.app/docs/connect-database)

## What you can ask

You ask

How many new customers signed up in September, and how does that compare with August?

Adea answers

1,284 in September against 1,119 in August, up 15 percent. The jump came in the last week, with 412 sign-ups after the 24th.

You ask

Which ten products had the most returns last quarter?

Adea answers

The ten together account for 2,031 of 3,460 returns, 59 percent. The trail jacket alone has 388, about one in nine of its sales.

## Questions about PostgreSQL

### How does Adea get into my PostgreSQL database?

You create a user that can only read and give Adea its details. Adea checks that the user truly cannot write before it reads anything, and connects from fixed addresses you can allow in your firewall.

### Can Adea change or delete anything in the database?

No. Adea only reads. The user has no write rights, and Adea tests that when you connect.

### Which tables does Adea see?

Only the schemas and tables you allow. Adea reads the data to answer questions and shows the query behind every answer, so you can check it.

## Coming from a BI tool on PostgreSQL?

[Adea vs Metabase](https://adea.app/vs/metabase) [Adea vs Power BI](https://adea.app/vs/power-bi) [Adea vs Looker Studio](https://adea.app/vs/looker-studio) [Adea vs Tableau](https://adea.app/vs/tableau) [Adea vs Mode](https://adea.app/vs/mode) [Adea vs Hex](https://adea.app/vs/hex) [Adea vs Sigma](https://adea.app/vs/sigma) [Adea vs Omni](https://adea.app/vs/omni) [Adea vs ThoughtSpot](https://adea.app/vs/thoughtspot) [Adea vs Databox](https://adea.app/vs/databox)

## Other sources like this

[MySQL](https://adea.app/integrations/mysql) [MariaDB](https://adea.app/integrations/mariadb) [Microsoft SQL Server](https://adea.app/integrations/sqlserver) [All sources](https://adea.app/integrations)

## What do you want to know?

[Start free](https://adea.app/signup) [Book 20 minutes](mailto:hello@adea.app?subject=20%20minutes%20about%20Adea)