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.
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
What you can ask
How many new customers signed up in September, and how does that compare with August?
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.
Which ten products had the most returns last quarter?
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.
