Use cases

SQL Server, in natural language

The same principle as PostgreSQL: business questions translated into read-only SQL.

Management

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

Gescon builds the query, runs it against the replica, and shows the exact SQL.

Sales

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

An actionable list: 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.

Operations

«How many orders are pending shipment?»

Returns the count and the list, with the status of each.

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