MCP App Store
by KeenEthics
RETGAS icon

RETGAS MCP Server for ChatGPT

By Beaver Soluciones Digitales S.A.S.

Overview

RETGAS is the management platform for gas inspection bodies in Colombia. This plugin lets an inspection body ask about its own operation in plain language, read-only, with the same permissions and sites each user has in the RETGAS web app. Ask about active inspectors, who is ready for field work, certificates and competencies about to expire, equipment calibration, vehicles and documents; visits and inspection reports by inspector, site, service type or month, and where reports are returned or annulled; deliveries to gas distributors; whether an inspector is correctly set up for the mobile app and which devices are authorized; and step-by-step help on using the web and mobile apps. You sign in with your RETGAS account; there are no API keys to copy. The plugin never writes data, never runs free-form SQL and never returns personal data of gas service customers or free-text notes.

How to connect

  1. ChatGPT: Open the RETGAS listing in the ChatGPT app directory and choose Connect. ChatGPT listing RETGAS exposes 30 tools here.

Tools

aggregate_records

ChatGPT
Computes counts and other aggregations over one entity, optionally grouped by up to three fields (dates grouped by day, week, month, quarter or year). Only rows of the sites in the person scope are counted. Read-only.

compare_periods

ChatGPT
Compares one metric between two periods (periodA is the baseline) and/or between two sites, computed by the server with the same rules as aggregate_records: both values, the absolute change (B minus A) and the percent change over A (empty when A is 0). Metrics: reports (inspection reports issued), annulled_reports, visits_executed (Conforme, NoConforme or Ausente), review_returns (visits returned in review and still open) and distributor_failures (deliveries with status Error). Periods are by visit date. Each metric requires the permission of its entity and only counts the person's sites. Read-only.

describe_entity

ChatGPT
Describes one entity: its fields with type, description, supported filter operators, whether they can be grouped or sorted, and which aggregations they support; the maximum rows per page; the rules the entity imposes, if any (aggregateOnly, minGroupCount, allowedPeriods, requiredRange); and the sites the person can see (siteScope). Read-only.

form_equipment_requirements

ChatGPT
Lists the equipment categories each active inspection form requires, with the gas, installation and service types for which each one applies. With an inspector, it also returns the equipment assigned to them (latest movement is an assignment, phones excluded) and, per form, the missing categories; duplicated categories block the report and expired calibrations are reported as a warning. Requires the Equipos.Ver permission; the inspector has to belong to the sites in scope. Read-only.

get_connection

ChatGPT
Reports which RetGas organization (inspection body) the assistant is connected to, on behalf of which person, with which role, sites and permissions, and until when the connection lasts. Useful at the start of a conversation, to know which organization the other tools act on. The organization is fixed by the connection: working with a different one requires connecting RetGas again. Read-only.

get_form

ChatGPT
Returns the definition of one inspection form, found by its name or id. fields are the fields the inspector fills in, each with its label, code, type, section, allowed options and, for table fields, its columns: columnDetails pairs each column code (the key a row uses) with its visible title and options; a condition reads them with getValueFromItems, as text. appFields are the values the mobile app sends with every inspection (inspection price, distributor, dates, airtightness readings and more), read as form.<code> with their own type; generalFields is the former name of the same list. Each field carries its source and a celExample. A field of type itemFormulario is not filled in by the inspector: it carries linkedTo, the code of the field it copies (usually from another form of the same inspection, such as who attends the visit from the main report), and RetGas fills it in before running the rules, so a condition reads it with getValueFromItems like any other field; in a simulation it is given its value directly. It is the form definition only, with no inspection data. These are the values a validation rule can check and the ones the simulation cases fill in. A name that matches several forms returns the candidates. Requires the RetGas permission to view validation rules. Read-only.

get_module_access_requirements

ChatGPT
For a RetGas web screen or module, given by its menu name (Equipos, Usuarios) or route (/users), returns the permission that opens it and the permissions of its actions (add, edit, delete, annul, export). With user, it also tells whether that user can open it and which permissions the user is missing. Effective access is the user's own permission list: the role only pre-fills it when the user is created or edited in RetGas web. Mobile app inspectors do not use these permissions. Changes are made in RetGas web (Usuarios), not through this connector. Permissions flagged hiddenByOrganization are hidden from the web menu by the organization settings but still grant access. Requires the Usuarios.Ver permission and covers the whole organization, as the RetGas web users screen. Personal data such as email, phone or ID number is not returned. Read-only.

get_support_article

ChatGPT
Returns one RetGas help article in full by its id, for example an id listed in the related articles of a search result. It does not read the organization's data. Read-only.

get_user_permissions

ChatGPT
Returns the effective permissions of one user grouped by module with readable labels, the RetGas web screens the user can open, and the differences with the template of the role (extra and missing permissions). Effective access is the user's own permission list: the role only pre-fills it when the user is created or edited in RetGas web. Mobile app inspectors do not use these permissions. Changes are made in RetGas web (Usuarios), not through this connector. Permissions flagged hiddenByOrganization are hidden from the web menu by the organization settings but still grant access. Requires the Usuarios.Ver permission and covers the whole organization, as the RetGas web users screen. Personal data such as email, phone or ID number is not returned. Read-only.

get_validation_rule

ChatGPT
Returns one validation rule in full: name, description, message the inspector sees, whether it is active, the forms it applies to, the form fields its condition looks at (with their labels), its condition (expression) and its version, which update_validation_rule expects. Requires the RetGas permission to view validation rules. Read-only. The people using it are inspection specialists, not programmers: results are explained to them in plain Spanish, by form and field names.

get_validation_rule_effectiveness

ChatGPT
Returns, for the last 7, 30 or 90 days, the validation rules that blocked the most distinct inspection documents (top 20), each with its description, whether it is active, the forms it is linked to today, the blocked documents per week and, when the person can also view inspectors, per inspector by name (inspectors outside the person's sites are grouped as others). RetGas does not record the form or visit of each block, so there is no count per form. Only aggregated counts: no documents, emails or other personal data. Optionally limited to one rule. It is the one for explaining a trend or where blocks concentrate; get_validation_rule_metrics instead covers every rule that blocked, with the date of its last block. Requires the RetGas permission to view validation rules. Read-only.

get_validation_rule_history

ChatGPT
Lists the saved versions of a validation rule (version number and date), newest first. Requires the RetGas permission to view validation rules. Read-only.

get_validation_rule_metrics

ChatGPT
Returns, for the last 7, 30 or 90 days, how many distinct inspection documents each validation rule blocked and when it last did, with the rule description. Only aggregated counts: no documents and no personal data. Optionally limited to one rule. It covers every rule that blocked in the range, with the date of its last block; get_validation_rule_effectiveness instead gives the top 20 with their trend per week, per inspector and their linked forms. Requires the RetGas permission to view validation rules. Read-only.

get_visit_timeline

ChatGPT
Returns the chronological history of one inspection visit and its reports: requested, created, assigned and executed dates, inspector, automatic photo validation result, each report with its act number and consecutive, review and verification, returns, annulment with its reason and whether it was reissued, replacement acts, deliveries to the gas distributor with their status and error category, and the SICERCO stage. Each event has a date (empty when RetGas does not record it), a kind, a plain Spanish label, the inspector when the event is theirs, and a status. diagnosis lists in Spanish what looks pending or failed. Search by act number, visit id or distributor order number (exactly one); when several visits match, candidates lists them and no timeline is returned. Sections this organization does not expose yet are listed in unavailable. Requires the Visitas.Ver permission and only covers the person's sites. Who verified or annulled, free-text comments and gas customer data are not returned. Read-only.

list_cel_functions

ChatGPT
Returns the catalog of RetGas functions a rule condition (a CEL expression) can call, with their parameters, return type and examples. A condition returns a text (empty means the rule passes, any other text is the message the inspector sees) or a bool (true means it passes). This is material for writing the condition, which the people using the connector normally do not see. Requires the RetGas permission to view validation rules. Read-only.

list_entities

ChatGPT
Lists the RetGas entities the connected person can query through describe_entity, query_records and aggregate_records, with a short description of each. Entities the person has no permission for in RetGas are not listed. Read-only.

list_form_validation_rules

ChatGPT
Lists the links between validation rules and inspection forms, from either side (exactly one of form or ruleId). With form, found by its name or id: each rule linked to it with its name, the message the inspector sees, whether the rule is active, whether its link to this form is active, and the link id. With ruleId: each form the rule is linked to, by name, with the link id and whether the link is active. A rule runs on a form only when both are active. Requires the RetGas permission to view validation rules. Read-only. The people using it are inspection specialists, not programmers: results are explained to them in plain Spanish, by form and field names.

list_forms

ChatGPT
Lists the inspection forms of the organization with their name, file name, id and whether they are active. query filters by name. get_form returns the fields of one of them. Requires the RetGas permission to view validation rules. Read-only.

list_inspector_devices

ChatGPT
Lists the mobile phones registered in the RetGas app by the inspectors of the organization, with the inspector, site, brand, model, app version, whether the device is authorized and when it was authorized. Only the last 4 characters of the device identifier are returned. Meant for support, together with inspector_setup_check, when an inspector cannot sign in or does not see their visits: a missing or unauthorized device is one of the causes. Only devices of inspectors in the person's sites are listed. Read-only.

list_report_fields

ChatGPT
Lists what an Excel report of the RetGas web module can contain: the data sets, their fields, date fields and conditions, the app fields and, with form, the fields of that inspection form. With headers (the column titles of a template, in order) it matches each one to a field as matched, ambiguous or unmatched; unmatched data is requested from RetGas support. Personal fields are masked in previews. Requires the RetGas permission to view report settings. Read-only.

list_reports

ChatGPT
Lists the Excel reports configured in the RetGas web module: name, description, whether it is active, its columns, how many people can generate it, whether it was created through this connector and whether it can still be changed here. With report, only that one and, if the connector created it, its definition. Requires the RetGas permission to view report settings. Read-only.

list_roles

ChatGPT
Lists the roles of the organization with their permission template grouped by module and how many users have each role. Roles with a duplicated name are flagged: RetGas web cannot tell them apart. Effective access is the user's own permission list: the role only pre-fills it when the user is created or edited in RetGas web. Mobile app inspectors do not use these permissions. Changes are made in RetGas web (Usuarios), not through this connector. Permissions flagged hiddenByOrganization are hidden from the web menu by the organization settings but still grant access. Requires the Usuarios.Ver permission and covers the whole organization, as the RetGas web users screen. Personal data such as email, phone or ID number is not returned. Read-only.

list_users_access

ChatGPT
Lists the RetGas web users of the organization with role, main site, extra sites, whether they are active, how many permissions they hold, and whether their permissions differ from the template of their role (permissions added and missing). Filters by role, site, active, a permission they hold and part of the name. Effective access is the user's own permission list: the role only pre-fills it when the user is created or edited in RetGas web. Mobile app inspectors do not use these permissions. Changes are made in RetGas web (Usuarios), not through this connector. Permissions flagged hiddenByOrganization are hidden from the web menu by the organization settings but still grant access. Requires the Usuarios.Ver permission and covers the whole organization, as the RetGas web users screen. Personal data such as email, phone or ID number is not returned. Read-only.

list_validation_rules

ChatGPT
Lists the validation rules of the organization: the checks RetGas runs on an inspection form before the inspector can send it. Each item has the rule name and description, the message the inspector sees when it blocks, whether it is active, the forms it applies to by name, its id, version and a short summary. query searches the code, description, message and form names. Requires the RetGas permission to view validation rules. Read-only. The people using it are inspection specialists, not programmers: results are explained to them in plain Spanish, by form and field names.

preview_report

ChatGPT
Builds a report definition and reads up to 5 real rows, with personal data masked and form or app columns shown as filled in when the Excel file is generated. from and to (YYYY-MM-DD) default to the last 30 days and cannot exceed maxRangeDays: 31 when the report uses form or app data, 366 otherwise. notes explain what the preview leaves out. The definition is usually agreed with the person one decision at a time: what each row is, the columns, the date of the range, sites, conditions and order. previewId, valid for 30 minutes, is what save_report requires for this exact definition. Requires the RetGas permissions to view report settings and visits. Read-only.

preview_validation_expression

ChatGPT
Simulates a draft rule condition (CEL expression) against up to 20 situations, without saving anything, as the form simulator of the RetGas web platform does. Each situation gives field values by label or code, optionally of a form named in form. Per situation the result says whether the rule passes or blocks, the message the inspector would see, the fields that decided it and whether that matched expectPass; a condition that is not valid comes back with where the problem is. App values (appFields of get_form) go in fields and form fields in items; a condition that reads an app value as a form field comes back with appFieldHints, and one that reads an app value that does not exist is not simulated. A condition passes when it returns true or an empty text, and blocks on false or on any other text, which becomes the message. Codes are case sensitive. An app value that was not sent is null, so form.valorRevision == null tests for it, while has(form.valorRevision) is true even when it is empty. Numbers are compared as numbers (form.valorRevision != 90000.0, not "90000"). In table rows, -1 means not filled in. A value missing from the form fields may still be an app value. Catalog functions (list_cel_functions) are preferred over hand-written loops. Requires the RetGas permission to view validation rules. Read-only. The people using it are inspection specialists, not programmers: results are explained to them in plain Spanish, by form and field names.

query_records

ChatGPT
Returns rows of one entity with the chosen fields, filtered and sorted, one page at a time. Only rows of the sites in the person scope are returned. hasMore and nextOffset tell whether another page exists. Dates are YYYY-MM-DD; next_days and last_days count from today in Colombia time. Read-only.

search_support_articles

ChatGPT
Searches the RetGas help center: short articles on how to use the RetGas web platform and the RetGas mobile app, and how to solve their common errors (sync, reports, payment method, isometric drawings, SICERCO uploads, access and passwords, among others). Each result carries the full article text, its title and the ids of related articles. The articles are the source for any steps given: an answer built from them cites the article by title and does not add steps that are not in it. This tool does not read the organization's data (inspections, reports, people); the other tools cover that. When nothing matches, the result is empty and includes a hint. Read-only.

test_validation_rule

ChatGPT
Simulates a saved validation rule against up to 20 situations, without changing anything. Same situations and result as preview_validation_expression; field labels resolve against the forms the rule is linked to, or against the form given in form, and app values (appFields of get_form) go in fields with their type, for example a number for valorRevision. Requires the RetGas permission to view validation rules. Read-only. The people using it are inspection specialists, not programmers: results are explained to them in plain Spanish, by form and field names.

who_has_permission

ChatGPT
Lists the users who hold one permission, given by its name (InformeInspeccion.Anular), its label or the name or route of a web screen (the permission that opens it). When the text matches several permissions, the result lists them as candidates. Effective access is the user's own permission list: the role only pre-fills it when the user is created or edited in RetGas web. Mobile app inspectors do not use these permissions. Changes are made in RetGas web (Usuarios), not through this connector. Permissions flagged hiddenByOrganization are hidden from the web menu by the organization settings but still grant access. Requires the Usuarios.Ver permission and covers the whole organization, as the RetGas web users screen. Personal data such as email, phone or ID number is not returned. Read-only.

Capabilities

Interactive

Example Prompts

Click any prompt to copy it.

Similar Apps

Listed on MCP App Store

Listed on MCP App Store

Add this badge to your site or README. It links to this page.

HTML

<a href="https://mcp-app-store.keenethics-labs.com/app/retgas"><img src="https://mcp-app-store.keenethics-labs.com/badges/listed-on-mcp-app-store.svg" alt="Listed on MCP App Store" width="220" height="44"></a>

Markdown

[![Listed on MCP App Store](https://mcp-app-store.keenethics-labs.com/badges/listed-on-mcp-app-store.svg)](https://mcp-app-store.keenethics-labs.com/app/retgas)