Intelligence

Tequery

Querying company data without knowing the database.

Plain-language queries · read-only access · on-premise install · works with different language models

Ask for a demo How it works

The user asks

“How many accounts opened last quarter still have incomplete anti-money-laundering documentation?”

Query generated and run

SELECT a.branch, COUNT(*)
FROM accounts a JOIN kyc k ON k.account_id = a.id
WHERE a.opened_on >= … AND k.status <> 'COMPLETE'
GROUP BY a.branch

Illustrative example. The query depends on the database structure and on what the application being queried holds.

Read-only accessqueries never change the data
Traceabilityquestion, query and user are recorded
On-premise installthe data stays inside the boundary the company sets
Works with different modelscloud models or models installed in-house

The context

Getting at the data usually takes a specialist.

The information the business needs is usually already in the systems, but finding it means knowing the applications, the databases and how they relate.

Every request goes through IT

Most requests for information need a technical team to find the right data and run the query.

The knowledge sits with a handful of people

How the applications and databases are built is usually known only to a few specialists.

Becoming self-sufficient takes time

Before you can search on your own you have to learn the naming, the codes and the relationships between the data.

Hard to retrace how a figure was produced

When a result is shared without the query behind it, checking where it came from — or reproducing it later — becomes difficult.

How it works

From the question to an answer you can check.

Tequery reads a request written in plain language, turns it into a query the database understands, and returns the result together with everything needed to check what was actually run.

PHASE 01PHASE 02 PHASE 03PHASE 04 Question Requestinterpreted Queryexecuted Checkable result The user asks inplain language. The request is matchedto the correspondingdata structures. The query runs withoutchanging any data. The answer comes with the queryand the tracking information. READ-ONLY ACCESS — BOUNDARY SET BY THE COMPANY Usable without knowingSQL Works with models alreadyin use Respects the existingaccess profiles Supports audit and verification

The record

Every answer stays checkable.

Each request can be tied to the query that ran, the user who asked and the moment it happened, which is what verification and control need.

Simpler access to the information

Information can be searched without knowing the technical structure of the database.

  • Requests in plain language
  • Less dependence on technical support for the simpler queries
  • New users productive sooner
Operations view

Results documented and checkable

Every answer can be verified through the query generated and the information recorded while it ran.

  • A record of the queries run
  • Results reproducible later
  • Support for audit and compliance
Compliance view

The infrastructure stays under your control

The language model, how it is installed and how it runs are all decided according to the organisation’s own technology policy.

  • On-premise install
  • Works with different language models
  • Uses the access profiles already defined
IT view

The boundary

What the system does, and what you do.

AspectWhat Tequery doesWhat stays with you
DataReads, never writesThe applications and their data stay where they are
PermissionsRespects the access profiles already in placeManaging the user accounts
Data modelMaps the questions onto the real structuresOwnership of the model and the applications
LLMWorks with different models, cloud or in-houseChoosing the model
TrackingRecords the question, the query and the userThe retention and audit policies

Frequently asked questions

The questions we are asked
most about Tequery.

Any other questions?
Tequery installs on-premise and reads the data without writing to it. Where the requests are processed depends on the language model: with a model installed in-house nothing leaves the company boundary; with a cloud model the boundary and the processing rules are agreed with IT and compliance.
Every answer is shown together with the query that produced it, so the result can be checked instead of taken on trust. The queries are read-only, so a mistake produces at worst a figure to correct, never a changed record.
No: access is read-only by design, and it respects the authorisation profiles already in place. Through Tequery a user sees exactly what they would be allowed to see anywhere else.
No. Tequery is a layer on top of the applications you already have: nothing has to be moved. If you then want a unified data platform, that is a project of its own — the ground covered by frAIme — but it is not a prerequisite.
Tequery respects the authorisation profiles already defined, and governance stays with you: which data can be queried, which profiles are enabled and how long the record is kept are all configured with IT and compliance before go-live.

Keep exploring

The other Add Value products

Reach the data without filing a technical request.