Use cases

Query PostgreSQL without writing SQL

Whoever doesn't write SQL stops waiting for a report. Whoever does stops writing the same one three times.

Management

«How much did we bill per customer last quarter?»

Gescon builds the query, returns the table, and shows the exact SQL it ran.

Sales

«Which accounts haven't ordered anything in 90 days?»

An actionable list, not a report: name, last order, and amount.

Data

«Where does this number come from?»

Every answer comes with the query, the tables touched, and the execution time.

Finance

«What's the average margin per product line this month?»

Gescon joins the necessary tables and returns the calculation with the SQL visible.

What it brings

Read-only, and in plain sight

The connector can't modify data even by mistake: the user it runs as has no permission to.

Dedicated database user

Created by your team, with SELECT permission and nothing else.

Schemas and tables you authorise

The rest of the schema is invisible to Gescon.

The query, always visible

Every answer shows the SQL that produced it, so it can be audited.

Row and time limits

Queries are cut off before they can affect performance.

Connection to a replica

We recommend pointing to a read replica, not production.

Setup

Create the read-only userYour systems team creates it with minimal permissions.

Authorise the connectionHost, port, and schemas. Via tunnel or authorised IP.

Validate with three questionsCheck the SQL it generates before opening it to the team.

Requirements

Estimated connection time: 45 min

Same family