Energetica — Argentine Oil & Gas Data is an MCP server published by ar.energetica, hosted at energetica.ar. When last checked on 2026-11-22 it was working: it answers and lists its tools. It declares 14 tools, including describe_data, resolve_entity, query_production, query_wells, get_well.
Argentine oil & gas data — 40+ curated tables: production, wells, prices, investments, trade.
Nothing else in the archive shares these values.
Squares are this server's values; dots are other servers sharing them. A shared address or publisher is a lead, not proof of a common operator.
Inferred from the host name and headers: what a server runs on, not who runs it.
Start here. Every table and view: description, period, rows, tool to use, warnings, and the last complete production month. With tablas, also their columns. Example: {tablas: ['pozos']}.
| Parameter | Type | Description |
|---|---|---|
| tablas | array | Tables or views whose columns you need |
| max_rows | number |
{
"name": "describe_data",
"title": "Data catalog",
"description": "Start here. Every table and view: description, period, rows, tool to use, warnings, and the last complete production month. With tablas, also their columns. Example: {tablas: ['pozos']}.",
"inputSchema": {
"type": "object",
"$schema": "https://json-schema.org/draft/2020-12/schema",
"properties": {
"tablas": {
"type": "array",
"items": {
"type": "string"
},
"maxItems": 6,
"minItems": 1,
"description": "Tables or views whose columns you need"
},
"max_rows": {
"type": "number",
"minimum": 1
}
}
},
"outputSchema": {
"type": "object",
"$schema": "https://json-schema.org/draft/2020-12/schema",
"required": [
"columns",
"rows",
"meta"
],
"properties": {
"meta": {
"type": "object",
"required": [
"returned",
"truncated",
"max_rows",
"sources",
"query_ms"
],
"properties": {
"sql": {
"type": "string"
},
"notes": {
"type": "array",
"items": {
"type": "string"
}
},
"sources": {
"type": "array",
"items": {
"type": "string"
}
},
"max_rows": {
"type": "number"
},
"query_ms": {
"type": "number"
},
"returned": {
"type": "number"
},
"truncated": {
"type": "boolean"
},
"definitions": {
"type": "array",
"items": {
"type": "string"
}
}
},
"additionalProperties": false
},
"rows": {
"type": "array",
"items": {
"type": "array",
"items": {}
}
},
"columns": {
"type": "array",
"items": {
"type": "object",
"required": [
"name",
"type"
],
"properties": {
"name": {
"type": "string"
},
"type": {
"type": "string"
},
"unit": {
"type": "string"
}
},
"additionalProperties": false
}
},
"sections": {
"type": "array",
"items": {
"type": "object",
"required": [
"name",
"columns",
"rows",
"truncated"
],
"properties": {
"name": {
"type": "string"
},
"rows": {
"type": "array",
"items": {
"type": "array",
"items": {}
}
},
"columns": {
"type": "array",
"items": {
"type": "object",
"required": [
"name",
"type"
],
"properties": {
"name": {
"type": "string"
},
"type": {
"type": "string"
},
"unit": {
"type": "string"
}
},
"additionalProperties": false
}
},
"truncated": {
"type": "boolean"
}
},
"additionalProperties": false
}
}
},
"additionalProperties": false
},
"annotations": {
"title": "Data catalog",
"readOnlyHint": true,
"openWorldHint": false,
"idempotentHint": true
}
}Free text → exact names for filters (companies, areas, fields, formations, basins, provinces, wells), with context and last month with production. Example: {texto: 'palmar', tipo: 'yacimiento'}.
| Parameter | Type | Description |
|---|---|---|
| tipo | string | one of ["empresa","area","yacimiento","formacion","cuenca","provincia","pozo"] |
| texto * | string | Name or part of it |
| max_rows | number |
{
"name": "resolve_entity",
"title": "Find companies, areas, fields and wells",
"description": "Free text → exact names for filters (companies, areas, fields, formations, basins, provinces, wells), with context and last month with production. Example: {texto: 'palmar', tipo: 'yacimiento'}.",
"inputSchema": {
"type": "object",
"$schema": "https://json-schema.org/draft/2020-12/schema",
"required": [
"texto"
],
"properties": {
"tipo": {
"enum": [
"empresa",
"area",
"yacimiento",
"formacion",
"cuenca",
"provincia",
"pozo"
],
"type": "string"
},
"texto": {
"type": "string",
"minLength": 2,
"description": "Name or part of it"
},
"max_rows": {
"type": "number",
"minimum": 1
}
}
},
"outputSchema": {
"type": "object",
"$schema": "https://json-schema.org/draft/2020-12/schema",
"required": [
"columns",
"rows",
"meta"
],
"properties": {
"meta": {
"type": "object",
"required": [
"returned",
"truncated",
"max_rows",
"sources",
"query_ms"
],
"properties": {
"sql": {
"type": "string"
},
"notes": {
"type": "array",
"items": {
"type": "string"
}
},
"sources": {
"type": "array",
"items": {
"type": "string"
}
},
"max_rows": {
"type": "number"
},
"query_ms": {
"type": "number"
},
"returned": {
"type": "number"
},
"truncated": {
"type": "boolean"
},
"definitions": {
"type": "array",
"items": {
"type": "string"
}
}
},
"additionalProperties": false
},
"rows": {
"type": "array",
"items": {
"type": "array",
"items": {}
}
},
"columns": {
"type": "array",
"items": {
"type": "object",
"required": [
"name",
"type"
],
"properties": {
"name": {
"type": "string"
},
"type": {
"type": "string"
},
"unit": {
"type": "string"
}
},
"additionalProperties": false
}
},
"sections": {
"type": "array",
"items": {
"type": "object",
"required": [
"name",
"columns",
"rows",
"truncated"
],
"properties": {
"name": {
"type": "string"
},
"rows": {
"type": "array",
"items": {
"type": "array",
"items": {}
}
},
"columns": {
"type": "array",
"items": {
"type": "object",
"required": [
"name",
"type"
],
"properties": {
"name": {
"type": "string"
},
"type": {
"type": "string"
},
"unit": {
"type": "string"
}
},
"additionalProperties": false
}
},
"truncated": {
"type": "boolean"
}
},
"additionalProperties": false
}
}
},
"additionalProperties": false
},
"annotations": {
"title": "Find companies, areas, fields and wells",
"readOnlyHint": true,
"openWorldHint": false,
"idempotentHint": true
}
}Oil, gas and water production (2006–present) by entity and period, grouped by up to 3 dimensions: volumes, BOE, producing/reporting wells, daily rate, GOR, water cut. Example: {area_concesion: "LOMA CAMPANA", fecha_desde: "2025", agrupar_por: ["anio"]}.
| Parameter | Type | Description |
|---|---|---|
| cuenca | string | |
| idpozo | array | |
| empresa | string | |
| max_rows | number | |
| metricas | array | Default petroleo, gas, agua (+ pozos_productores by mes); caudal_diario = volume / calendar days |
| formacion | string | |
| provincia | string | |
| tipo_pozo | string | e.g. Petrolífero, Gasífero |
| yacimiento | string | |
| agrupar_por | array | Up to 3 dimensions; default [mes] |
| fecha_desde | string |
Wells in the registry (~86,000): location, type, current status and operator, cumulative production, first and last month with production, IP30. Example: {provincia: 'Neuquén', subtipo_recurso: 'SHALE', tipo_estado: 'activos'}.
| Parameter | Type | Description |
|---|---|---|
| orden | string | one of ["acumulado","ip30","primera_produccion"] |
| cuenca | string | |
| empresa | string | |
| max_rows | number | |
| formacion | string | |
| provincia | string | |
| tipo_pozo | string | e.g. Petrolífero, Gasífero |
| yacimiento | string | |
| tipo_estado | string | Exact registry status (e.g. Abandonado, Parado Transitoriamente) or 'activos' |
| segun_padron | boolean | |
| tipo_recurso | string | one of ["CONVENCIONAL","NO CONVENCIONAL","SIN RESERVORIO","NO DISCRIMINADO"] |
One well by idpozo or sigla: registry data, IP30/90/180, cumulative volumes, recent GOR and water cut, last 36 months of production, fracture jobs and trajectory. Example: {sigla: 'YPF.Nq.LCa-1001(h)'}.
| Parameter | Type | Description |
|---|---|---|
| sigla | string | Well code; close codes are resolved |
| idpozo | number | |
| max_rows | number |
{
"name": "get_well",
"title": "Well profile",
"description": "One well by idpozo or sigla: registry data, IP30/90/180, cumulative volumes, recent GOR and water cut, last 36 months of production, fracture jobs and trajectory. Example: {sigla: 'YPF.Nq.LCa-1001(h)'}.",
"inputSchema": {
"type": "object",
"$schema": "https://json-schema.org/draft/2020-12/schema",
"properties": {
"sigla": {
"type": "string",
"minLength": 2,
"description": "Well code; close codes are resolved"
},
"idpozo": {
"type": "number"
},
"max_rows": {
"type": "number",
"minimum": 1
}
}
},
"outputSchema": {
"type": "object",
"$schema": "https://json-schema.org/draft/2020-12/schema",
"required": [
"columns",
"rows",
"meta"
],
"properties": {
"meta": {
"type": "object",
"required": [
"returned",
"truncated",
"max_rows",
"sources",
"query_ms"
],
"properties": {
"sql": {
"type": "string"
},
"notes": {
"type": "array",
"items": {
"type": "string"
}
},
"sources": {
"type": "array",
"items": {
"type": "string"
}
},
"max_rows": {
"type": "number"
},
"query_ms": {
"type": "number"
},
"returned": {
"type": "number"
},
"truncated": {
"type": "boolean"
},
"definitions": {
"type": "array",
"items": {
"type": "string"
}
}
},
"additionalProperties": false
},
"rows": {
"type": "array",
"items": {
"type": "array",
"items": {}
}
},
"columns": {
"type": "array",
"items": {
"type": "object",
"required": [
"name",
"type"
],
"properties": {
"name": {
"type": "string"
},
"type": {
"type": "string"
},
"unit": {
"type": "string"
}
},
"additionalProperties": false
}
},
"sections": {
"type": "array",
"items": {
"type": "object",
"required": [
"name",
"columns",
"rows",
"truncated"
],
"properties": {
"name": {
"type": "string"
},
"rows": {
"type": "array",
"items": {
"type": "array",
"items": {}
}
},
"columns": {
"type": "array",
"items": {
"type": "object",
"required": [
"name",
"type"
],
"properties": {
"name": {
"type": "string"
},
"type": {
"type": "string"
},
"unit": {
"type": "string"
}
},
"additionalProperties": false
}
},
"truncated": {
"type": "boolean"
}
},
"additionalProperties": false
}
}
},
"additionalProperties": false
},
"annotations": {
"title": "Well profile",
"readOnlyHint": true,
"openWorldHint": false,
"idempotentHint": true
}
}One concession area: 12-month production and year-on-year change, operators and shares, wells by type and state, top wells and the last 24 months. Example: {area_concesion: 'LOMA CAMPANA'}.
| Parameter | Type | Description |
|---|---|---|
| max_rows | number | |
| area_concesion * | string | Area name; close names are resolved |
{
"name": "get_area",
"title": "Concession area profile",
"description": "One concession area: 12-month production and year-on-year change, operators and shares, wells by type and state, top wells and the last 24 months. Example: {area_concesion: 'LOMA CAMPANA'}.",
"inputSchema": {
"type": "object",
"$schema": "https://json-schema.org/draft/2020-12/schema",
"required": [
"area_concesion"
],
"properties": {
"max_rows": {
"type": "number",
"minimum": 1
},
"area_concesion": {
"type": "string",
"minLength": 2,
"description": "Area name; close names are resolved"
}
}
},
"outputSchema": {
"type": "object",
"$schema": "https://json-schema.org/draft/2020-12/schema",
"required": [
"columns",
"rows",
"meta"
],
"properties": {
"meta": {
"type": "object",
"required": [
"returned",
"truncated",
"max_rows",
"sources",
"query_ms"
],
"properties": {
"sql": {
"type": "string"
},
"notes": {
"type": "array",
"items": {
"type": "string"
}
},
"sources": {
"type": "array",
"items": {
"type": "string"
}
},
"max_rows": {
"type": "number"
},
"query_ms": {
"type": "number"
},
"returned": {
"type": "number"
},
"truncated": {
"type": "boolean"
},
"definitions": {
"type": "array",
"items": {
"type": "string"
}
}
},
"additionalProperties": false
},
"rows": {
"type": "array",
"items": {
"type": "array",
"items": {}
}
},
"columns": {
"type": "array",
"items": {
"type": "object",
"required": [
"name",
"type"
],
"properties": {
"name": {
"type": "string"
},
"type": {
"type": "string"
},
"unit": {
"type": "string"
}
},
"additionalProperties": false
}
},
"sections": {
"type": "array",
"items": {
"type": "object",
"required": [
"name",
"columns",
"rows",
"truncated"
],
"properties": {
"name": {
"type": "string"
},
"rows": {
"type": "array",
"items": {
"type": "array",
"items": {}
}
},
"columns": {
"type": "array",
"items": {
"type": "object",
"required": [
"name",
"type"
],
"properties": {
"name": {
"type": "string"
},
"type": {
"type": "string"
},
"unit": {
"type": "string"
}
},
"additionalProperties": false
}
},
"truncated": {
"type": "boolean"
}
},
"additionalProperties": false
}
}
},
"additionalProperties": false
},
"annotations": {
"title": "Concession area profile",
"readOnlyHint": true,
"openWorldHint": false,
"idempotentHint": true
}
}One operator: 12-month production, national share, year-on-year change, areas, basins, wells, investments, reserves and, if listed, share price and SEC financials. Example: {empresa: 'VISTA ENERGY ARGENTINA SAU'}.
| Parameter | Type | Description |
|---|---|---|
| empresa * | string | Company name; close names are resolved |
| max_rows | number |
{
"name": "get_company",
"title": "Company profile",
"description": "One operator: 12-month production, national share, year-on-year change, areas, basins, wells, investments, reserves and, if listed, share price and SEC financials. Example: {empresa: 'VISTA ENERGY ARGENTINA SAU'}.",
"inputSchema": {
"type": "object",
"$schema": "https://json-schema.org/draft/2020-12/schema",
"required": [
"empresa"
],
"properties": {
"empresa": {
"type": "string",
"minLength": 2,
"description": "Company name; close names are resolved"
},
"max_rows": {
"type": "number",
"minimum": 1
}
}
},
"outputSchema": {
"type": "object",
"$schema": "https://json-schema.org/draft/2020-12/schema",
"required": [
"columns",
"rows",
"meta"
],
"properties": {
"meta": {
"type": "object",
"required": [
"returned",
"truncated",
"max_rows",
"sources",
"query_ms"
],
"properties": {
"sql": {
"type": "string"
},
"notes": {
"type": "array",
"items": {
"type": "string"
}
},
"sources": {
"type": "array",
"items": {
"type": "string"
}
},
"max_rows": {
"type": "number"
},
"query_ms": {
"type": "number"
},
"returned": {
"type": "number"
},
"truncated": {
"type": "boolean"
},
"definitions": {
"type": "array",
"items": {
"type": "string"
}
}
},
"additionalProperties": false
},
"rows": {
"type": "array",
"items": {
"type": "array",
"items": {}
}
},
"columns": {
"type": "array",
"items": {
"type": "object",
"required": [
"name",
"type"
],
"properties": {
"name": {
"type": "string"
},
"type": {
"type": "string"
},
"unit": {
"type": "string"
}
},
"additionalProperties": false
}
},
"sections": {
"type": "array",
"items": {
"type": "object",
"required": [
"name",
"columns",
"rows",
"truncated"
],
"properties": {
"name": {
"type": "string"
},
"rows": {
"type": "array",
"items": {
"type": "array",
"items": {}
}
},
"columns": {
"type": "array",
"items": {
"type": "object",
"required": [
"name",
"type"
],
"properties": {
"name": {
"type": "string"
},
"type": {
"type": "string"
},
"unit": {
"type": "string"
}
},
"additionalProperties": false
}
},
"truncated": {
"type": "boolean"
}
},
"additionalProperties": false
}
}
},
"additionalProperties": false
},
"annotations": {
"title": "Company profile",
"readOnlyHint": true,
"openWorldHint": false,
"idempotentHint": true
}
}Top N wells, areas, companies, fields, basins or formations by production, BOE, GOR, water cut, growth, new wells or IP30/90/180 (raw, per meter, per stage). Example: {entidad: 'pozo', metrica: 'ip30', subtipo_recurso: 'SHALE', tipo_pozo: 'Petrolífero', fecha_desde: '2025', fecha_hasta: '2025'}.
| Parameter | Type | Description |
|---|---|---|
| n | integer | Default 10 |
| orden | string | one of ["desc","asc"] |
| cuenca | string | |
| empresa | string | |
| entidad * | string | one of ["pozo","area","empresa","yacimiento","cuenca","formacion"] |
| metrica * | string | ip*: wells of a first-production cohort (or their average per entity); others over the period |
| max_rows | number | |
| formacion | string | |
| provincia | string | |
| tipo_pozo | string | e.g. Petrolífero, Gasífero |
| yacimiento |
Fracture jobs by year, company (the one that reported the job), area, formation or well: wells, stages, stages per well, lateral length, proppant, water. Example: {formacion: 'vaca muerta', fecha_desde: '2025', agrupar_por: ['empresa']}.
| Parameter | Type | Description |
|---|---|---|
| cuenca | string | |
| empresa | string | |
| max_rows | number | |
| formacion | string | |
| agrupar_por | array | Default anio |
| fecha_desde | string | Completion (end of fracture) from |
| fecha_hasta | string | |
| area_concesion | string | |
| subtipo_reservorio | string | one of ["SHALE","TIGHT"] |
{
"name": "query_completions",
"title": "Fracture jobs (completions)",
"description": "Fracture jobs by year, company (the one that reported the job), area, formation or well: wells, stages, stages per well, lateral length, proppant, water. Example: {formacion: 'vaca muerta', fecha_desde: '2025', agrupar_por: ['empresa']}.",
"inputSchema": {
"type": "object",
"$schema": "https://json-schema.org/draft/2020-12/schema",
"properties": {
"cuenca": {
"type": "string"
},
"empresa": {
"type": "string"
},
"max_rows": {
"type": "number",
"minimum": 1
},
"formacion": {
"type": "string"
},
"agrupar_por": {
"type": "array",
"items": {
"enum": [
"anio",
"empresa",
"area_concesion",
"formacion",
"subtipo_reservorio",
"idpozo"
],
"type": "string"
},
"maxItems": 2,
"description": "Default anio"
},
"fecha_desde": {
"type": "string",
"description": "Completion (end of fracture) from"
},
"fecha_hasta": {
"type": "string"
},
"area_concesion": {
"type": "string"
},
"subtipo_reservorio": {
"enum": [
"SHALE",
"TIGHT"
],
"type": "string"
}
}
},
"outputSchema": {
"type": "object",
"$schema": "https://json-schema.org/draft/2020-12/schema",
"required": [
"columns",
"rows",
"meta"
],
"properties": {
"meta": {
"type": "object",
"required": [
"returned",
"truncated",
"max_rows",
"sources",
"query_ms"
],
"properties": {
"sql": {
"type": "string"
},
"notes": {
"type": "array",
"items": {
"type": "string"
}
},
"sources": {
"type": "array",
"items": {
"type": "string"
}
},
"max_rows": {
"type": "number"
},
"query_ms": {
"type": "number"
},
"returned": {
"type": "number"
},
"truncated": {
"type": "boolean"
},
"definitions": {
"type": "array",
"items": {
"type": "string"
}
}
},
"additionalProperties": false
},
"rows": {
"type": "array",
"items": {
"type": "array",
"items": {}
}
},
"columns": {
"type": "array",
"items": {
"type": "object",
"required": [
"name",
"type"
],
"properties": {
"name": {
"type": "string"
},
"type": {
"type": "string"
},
"unit": {
"type": "string"
}
},
"additionalProperties": false
}
},
"sections": {
"type": "array",
"items": {
"type": "object",
"required": [
"name",
"columns",
"rows",
"truncated"
],
"properties": {
"name": {
"type": "string"
},
"rows": {
"type": "array",
"items": {
"type": "array",
"items": {}
}
},
"columns": {
"type": "array",
"items": {
"type": "object",
"required": [
"name",
"type"
],
"properties": {
"name": {
"type": "string"
},
"type": {
"type": "string"
},
"unit": {
"type": "string"
}
},
"additionalProperties": false
}
},
"truncated": {
"type": "boolean"
}
},
"additionalProperties": false
}
}
},
"additionalProperties": false
},
"annotations": {
"title": "Fracture jobs (completions)",
"readOnlyHint": true,
"openWorldHint": false,
"idempotentHint": true
}
}P1/P2/P3 oil and gas reserves at Dec 31 by year, basin, company and resource type (end of useful life); oil and gas in separate columns. Default: latest year. Example: {anio: [2024], agrupar_por: ['cuenca'], categorias: ['P1']}.
| Parameter | Type | Description |
|---|---|---|
| anio | array | Years; default the latest |
| cuenca | string | |
| empresa | string | |
| max_rows | number | |
| categorias | array | Default P1, P2, P3 |
| agrupar_por | array | Default anio |
| tipo_recurso | string | one of ["CONVENCIONAL","NO CONVENCIONAL","SIN RESERVORIO","NO DISCRIMINADO"] |
{
"name": "query_reserves",
"title": "Hydrocarbon reserves",
"description": "P1/P2/P3 oil and gas reserves at Dec 31 by year, basin, company and resource type (end of useful life); oil and gas in separate columns. Default: latest year. Example: {anio: [2024], agrupar_por: ['cuenca'], categorias: ['P1']}.",
"inputSchema": {
"type": "object",
"$schema": "https://json-schema.org/draft/2020-12/schema",
"properties": {
"anio": {
"type": "array",
"items": {
"type": "integer",
"maximum": 9007199254740991,
"minimum": -9007199254740991
},
"maxItems": 20,
"description": "Years; default the latest"
},
"cuenca": {
"type": "string"
},
"empresa": {
"type": "string"
},
"max_rows": {
"type": "number",
"minimum": 1
},
"categorias": {
"type": "array",
"items": {
"enum": [
"P1",
"P2",
"P3"
],
"type": "string"
},
"minItems": 1,
"description": "Default P1, P2, P3"
},
"agrupar_por": {
"type": "array",
"items": {
"enum": [
"anio",
"cuenca",
"empresa",
"tipo_recurso"
],
"type": "string"
},
"maxItems": 3,
"description": "Default anio"
},
"tipo_recurso": {
"enum": [
"CONVENCIONAL",
"NO CONVENCIONAL",
"SIN RESERVORIO",
"NO DISCRIMINADO"
],
"type": "string"
}
}
},
"outputSchema": {
"type": "object",
"$schema": "https://json-schema.org/draft/2020-12/schema",
"required": [
"columns",
"rows",
"meta"
],
"properties": {
"meta": {
"type": "object",
"required": [
"returned",
"truncated",
"max_rows",
"sources",
"query_ms"
],
"properties": {
"sql": {
"type": "string"
},
"notes": {
"type": "array",
"items": {
"type": "string"
}
},
"sources": {
"type": "array",
"items": {
"type": "string"
}
},
"max_rows": {
"type": "number"
},
"query_ms": {
"type": "number"
},
"returned": {
"type": "number"
},
"truncated": {
"type": "boolean"
},
"definitions": {
"type": "array",
"items": {
"type": "string"
}
}
},
"additionalProperties": false
},
"rows": {
"type": "array",
"items": {
"type": "array",
"items": {}
}
},
"columns": {
"type": "array",
"items": {
"type": "object",
"required": [
"name",
"type"
],
"properties": {
"name": {
"type": "string"
},
"type": {
"type": "string"
},
"unit": {
"type": "string"
}
},
"additionalProperties": false
}
},
"sections": {
"type": "array",
"items": {
"type": "object",
"required": [
"name",
"columns",
"rows",
"truncated"
],
"properties": {
"name": {
"type": "string"
},
"rows": {
"type": "array",
"items": {
"type": "array",
"items": {}
}
},
"columns": {
"type": "array",
"items": {
"type": "object",
"required": [
"name",
"type"
],
"properties": {
"name": {
"type": "string"
},
"type": {
"type": "string"
},
"unit": {
"type": "string"
}
},
"additionalProperties": false
}
},
"truncated": {
"type": "boolean"
}
},
"additionalProperties": false
}
}
},
"additionalProperties": false
},
"annotations": {
"title": "Hydrocarbon reserves",
"readOnlyHint": true,
"openWorldHint": false,
"idempotentHint": true
}
}Upstream oil & gas investments in Argentina by company, basin, year and concept, in millions of USD (drilling, workovers, pipelines, facilities, seismic…). Example: {cuenca: 'NEUQUINA', anio_desde: 2023, concepto: 'perforacion'}.
| Parameter | Type | Description |
|---|---|---|
| cuenca | string | |
| empresa | string | |
| concepto | string | Investment concept, partial match ignoring accents (e.g. 'perforacion', 'reparacion de pozos', 'gasoductos', 'sismica') |
| max_rows | number | |
| anio_desde | number | Year of the sworn statement (DDJJ) |
| anio_hasta | number |
{
"name": "query_investments",
"title": "Upstream investments",
"description": "Upstream oil & gas investments in Argentina by company, basin, year and concept, in millions of USD (drilling, workovers, pipelines, facilities, seismic…). Example: {cuenca: 'NEUQUINA', anio_desde: 2023, concepto: 'perforacion'}.",
"inputSchema": {
"type": "object",
"$schema": "https://json-schema.org/draft/2020-12/schema",
"properties": {
"cuenca": {
"type": "string"
},
"empresa": {
"type": "string"
},
"concepto": {
"type": "string",
"description": "Investment concept, partial match ignoring accents (e.g. 'perforacion', 'reparacion de pozos', 'gasoductos', 'sismica')"
},
"max_rows": {
"type": "number",
"minimum": 1
},
"anio_desde": {
"type": "number",
"description": "Year of the sworn statement (DDJJ)"
},
"anio_hasta": {
"type": "number"
}
}
},
"outputSchema": {
"type": "object",
"$schema": "https://json-schema.org/draft/2020-12/schema",
"required": [
"columns",
"rows",
"meta"
],
"properties": {
"meta": {
"type": "object",
"required": [
"returned",
"truncated",
"max_rows",
"sources",
"query_ms"
],
"properties": {
"sql": {
"type": "string"
},
"notes": {
"type": "array",
"items": {
"type": "string"
}
},
"sources": {
"type": "array",
"items": {
"type": "string"
}
},
"max_rows": {
"type": "number"
},
"query_ms": {
"type": "number"
},
"returned": {
"type": "number"
},
"truncated": {
"type": "boolean"
},
"definitions": {
"type": "array",
"items": {
"type": "string"
}
}
},
"additionalProperties": false
},
"rows": {
"type": "array",
"items": {
"type": "array",
"items": {}
}
},
"columns": {
"type": "array",
"items": {
"type": "object",
"required": [
"name",
"type"
],
"properties": {
"name": {
"type": "string"
},
"type": {
"type": "string"
},
"unit": {
"type": "string"
}
},
"additionalProperties": false
}
},
"sections": {
"type": "array",
"items": {
"type": "object",
"required": [
"name",
"columns",
"rows",
"truncated"
],
"properties": {
"name": {
"type": "string"
},
"rows": {
"type": "array",
"items": {
"type": "array",
"items": {}
}
},
"columns": {
"type": "array",
"items": {
"type": "object",
"required": [
"name",
"type"
],
"properties": {
"name": {
"type": "string"
},
"type": {
"type": "string"
},
"unit": {
"type": "string"
}
},
"additionalProperties": false
}
},
"truncated": {
"type": "boolean"
}
},
"additionalProperties": false
}
}
},
"additionalProperties": false
},
"annotations": {
"title": "Upstream investments",
"readOnlyHint": true,
"openWorldHint": false,
"idempotentHint": true
}
}International and local energy prices: WTI, Brent, Henry Hub (daily, USD), Argentine crude price used for royalties by province (monthly, USD/bbl) and ARS/USD exchange rates (daily). Most recent first. Example: {serie: 'BRENT', fecha_desde: '2024', frecuencia: 'mensual'}.
| Parameter | Type | Description |
|---|---|---|
| serie * | string | one of ["WTI","BRENT","HENRY_HUB","CRUDO_LOCAL","USD_OFICIAL","USD_MAYORISTA","USD_BLUE","USD_MEP","USD_CCL"] |
| max_rows | number | |
| provincia | string | Only CRUDO_LOCAL; omit for every province |
| frecuencia | string | Average; CRUDO_LOCAL is monthly |
| fecha_desde | string | |
| fecha_hasta | string | Inclusive |
{
"name": "query_prices",
"title": "Energy prices and exchange rates",
"description": "International and local energy prices: WTI, Brent, Henry Hub (daily, USD), Argentine crude price used for royalties by province (monthly, USD/bbl) and ARS/USD exchange rates (daily). Most recent first. Example: {serie: 'BRENT', fecha_desde: '2024', frecuencia: 'mensual'}.",
"inputSchema": {
"type": "object",
"$schema": "https://json-schema.org/draft/2020-12/schema",
"required": [
"serie"
],
"properties": {
"serie": {
"enum": [
"WTI",
"BRENT",
"HENRY_HUB",
"CRUDO_LOCAL",
"USD_OFICIAL",
"USD_MAYORISTA",
"USD_BLUE",
"USD_MEP",
"USD_CCL"
],
"type": "string"
},
"max_rows": {
"type": "number",
"minimum": 1
},
"provincia": {
"enum": [
"NEUQUEN",
"CHUBUT",
"MENDOZA",
"SANTA CRUZ",
"SALTA",
"RIO NEGRO",
"LA PAMPA",
"TIERRA DEL FUEGO",
"FORMOSA",
"JUJUY",
"ESTADO NACIONAL"
],
"type": "string",
"description": "Only CRUDO_LOCAL; omit for every province"
},
"frecuencia": {
"enum": [
"diario",
"mensual",
"anual"
],
"type": "string",
"description": "Average; CRUDO_LOCAL is monthly"
},
"fecha_desde": {
"type": "string"
},
"fecha_hasta": {
"type": "string",
"description": "Inclusive"
}
}
},
"outputSchema": {
"type": "object",
"$schema": "https://json-schema.org/draft/2020-12/schema",
"required": [
"columns",
"rows",
"meta"
],
"properties": {
"meta": {
"type": "object",
"required": [
"returned",
"truncated",
"max_rows",
"sources",
"query_ms"
],
"properties": {
"sql": {
"type": "string"
},
"notes": {
"type": "array",
"items": {
"type": "string"
}
},
"sources": {
"type": "array",
"items": {
"type": "string"
}
},
"max_rows": {
"type": "number"
},
"query_ms": {
"type": "number"
},
"returned": {
"type": "number"
},
"truncated": {
"type": "boolean"
},
"definitions": {
"type": "array",
"items": {
"type": "string"
}
}
},
"additionalProperties": false
},
"rows": {
"type": "array",
"items": {
"type": "array",
"items": {}
}
},
"columns": {
"type": "array",
"items": {
"type": "object",
"required": [
"name",
"type"
],
"properties": {
"name": {
"type": "string"
},
"type": {
"type": "string"
},
"unit": {
"type": "string"
}
},
"additionalProperties": false
}
},
"sections": {
"type": "array",
"items": {
"type": "object",
"required": [
"name",
"columns",
"rows",
"truncated"
],
"properties": {
"name": {
"type": "string"
},
"rows": {
"type": "array",
"items": {
"type": "array",
"items": {}
}
},
"columns": {
"type": "array",
"items": {
"type": "object",
"required": [
"name",
"type"
],
"properties": {
"name": {
"type": "string"
},
"type": {
"type": "string"
},
"unit": {
"type": "string"
}
},
"additionalProperties": false
}
},
"truncated": {
"type": "boolean"
}
},
"additionalProperties": false
}
}
},
"additionalProperties": false
},
"annotations": {
"title": "Energy prices and exchange rates",
"readOnlyHint": true,
"openWorldHint": false,
"idempotentHint": true
}
}Argentina hydrocarbon exports and imports by month: crude oil (HS 2709), refined products (HS 2710) and natural gas (HS 2711), FOB USD and kg. Example: {anio: 2025, flow: 'export', producto: 'crude'}.
| Parameter | Type | Description |
|---|---|---|
| anio | number | |
| flow | string | Trade flow direction |
| max_rows | number | |
| producto | string | Product category |
{
"name": "query_trade",
"title": "Hydrocarbon trade balance",
"description": "Argentina hydrocarbon exports and imports by month: crude oil (HS 2709), refined products (HS 2710) and natural gas (HS 2711), FOB USD and kg. Example: {anio: 2025, flow: 'export', producto: 'crude'}.",
"inputSchema": {
"type": "object",
"$schema": "https://json-schema.org/draft/2020-12/schema",
"properties": {
"anio": {
"type": "number"
},
"flow": {
"enum": [
"export",
"import"
],
"type": "string",
"description": "Trade flow direction"
},
"max_rows": {
"type": "number",
"minimum": 1
},
"producto": {
"enum": [
"crude",
"refined",
"gas"
],
"type": "string",
"description": "Product category"
}
}
},
"outputSchema": {
"type": "object",
"$schema": "https://json-schema.org/draft/2020-12/schema",
"required": [
"columns",
"rows",
"meta"
],
"properties": {
"meta": {
"type": "object",
"required": [
"returned",
"truncated",
"max_rows",
"sources",
"query_ms"
],
"properties": {
"sql": {
"type": "string"
},
"notes": {
"type": "array",
"items": {
"type": "string"
}
},
"sources": {
"type": "array",
"items": {
"type": "string"
}
},
"max_rows": {
"type": "number"
},
"query_ms": {
"type": "number"
},
"returned": {
"type": "number"
},
"truncated": {
"type": "boolean"
},
"definitions": {
"type": "array",
"items": {
"type": "string"
}
}
},
"additionalProperties": false
},
"rows": {
"type": "array",
"items": {
"type": "array",
"items": {}
}
},
"columns": {
"type": "array",
"items": {
"type": "object",
"required": [
"name",
"type"
],
"properties": {
"name": {
"type": "string"
},
"type": {
"type": "string"
},
"unit": {
"type": "string"
}
},
"additionalProperties": false
}
},
"sections": {
"type": "array",
"items": {
"type": "object",
"required": [
"name",
"columns",
"rows",
"truncated"
],
"properties": {
"name": {
"type": "string"
},
"rows": {
"type": "array",
"items": {
"type": "array",
"items": {}
}
},
"columns": {
"type": "array",
"items": {
"type": "object",
"required": [
"name",
"type"
],
"properties": {
"name": {
"type": "string"
},
"type": {
"type": "string"
},
"unit": {
"type": "string"
}
},
"additionalProperties": false
}
},
"truncated": {
"type": "boolean"
}
},
"additionalProperties": false
}
}
},
"additionalProperties": false
},
"annotations": {
"title": "Hydrocarbon trade balance",
"readOnlyHint": true,
"openWorldHint": false,
"idempotentHint": true
}
}Run read-only DuckDB SQL (a single SELECT or WITH) over the catalog tables and views. Prefer the curated tools when they fit; call describe_data first for tables and columns. Column names and values are in Spanish. Example: {sql: "SELECT anio, SUM(prod_petroleo_m3) FROM agg_produccion_mensual WHERE formacion = 'vaca muerta' GROUP BY 1 ORDER BY 1"}.
| Parameter | Type | Description |
|---|---|---|
| sql * | string | |
| max_rows | number |
{
"name": "execute_sql",
"title": "Read-only SQL",
"description": "Run read-only DuckDB SQL (a single SELECT or WITH) over the catalog tables and views. Prefer the curated tools when they fit; call describe_data first for tables and columns. Column names and values are in Spanish. Example: {sql: \"SELECT anio, SUM(prod_petroleo_m3) FROM agg_produccion_mensual WHERE formacion = 'vaca muerta' GROUP BY 1 ORDER BY 1\"}.",
"inputSchema": {
"type": "object",
"$schema": "https://json-schema.org/draft/2020-12/schema",
"required": [
"sql"
],
"properties": {
"sql": {
"type": "string",
"minLength": 1
},
"max_rows": {
"type": "number",
"minimum": 1
}
}
},
"outputSchema": {
"type": "object",
"$schema": "https://json-schema.org/draft/2020-12/schema",
"required": [
"columns",
"rows",
"meta"
],
"properties": {
"meta": {
"type": "object",
"required": [
"returned",
"truncated",
"max_rows",
"sources",
"query_ms"
],
"properties": {
"sql": {
"type": "string"
},
"notes": {
"type": "array",
"items": {
"type": "string"
}
},
"sources": {
"type": "array",
"items": {
"type": "string"
}
},
"max_rows": {
"type": "number"
},
"query_ms": {
"type": "number"
},
"returned": {
"type": "number"
},
"truncated": {
"type": "boolean"
},
"definitions": {
"type": "array",
"items": {
"type": "string"
}
}
},
"additionalProperties": false
},
"rows": {
"type": "array",
"items": {
"type": "array",
"items": {}
}
},
"columns": {
"type": "array",
"items": {
"type": "object",
"required": [
"name",
"type"
],
"properties": {
"name": {
"type": "string"
},
"type": {
"type": "string"
},
"unit": {
"type": "string"
}
},
"additionalProperties": false
}
},
"sections": {
"type": "array",
"items": {
"type": "object",
"required": [
"name",
"columns",
"rows",
"truncated"
],
"properties": {
"name": {
"type": "string"
},
"rows": {
"type": "array",
"items": {
"type": "array",
"items": {}
}
},
"columns": {
"type": "array",
"items": {
"type": "object",
"required": [
"name",
"type"
],
"properties": {
"name": {
"type": "string"
},
"type": {
"type": "string"
},
"unit": {
"type": "string"
}
},
"additionalProperties": false
}
},
"truncated": {
"type": "boolean"
}
},
"additionalProperties": false
}
}
},
"additionalProperties": false
},
"annotations": {
"title": "Read-only SQL",
"readOnlyHint": true,
"openWorldHint": false,
"idempotentHint": true
}
}Energética: Argentine oil & gas, energy and macro data from official sources, rebuilt daily. How to work: - Start with describe_data (tables, periods, tool per table, warnings, last complete month). Prefer curated tools; execute_sql for the rest. - Entity filters take exact names; close ones are resolved (see notes), ambiguous ones fail with candidates. Join several with "|". resolve_entity finds names. - Names and values are in Spanish (NEUQUINA, formacion lowercase: 'vaca muerta'). - Results: CSV plus structuredContent. max_rows (any tool): rows to return (default 200, capped by tier); meta.truncated = rows cut; meta.sql adapts to execute_sql; meta.definitions = rules applied. - In SQL, totals without wells: agg_produccion_mensual (1M rows), not produccion_mensual (18M). Domain rules: - produccion_mensual: one row per well and month; prod_petroleo_m3 (m³), prod_gas_miles_m3 (thousand m³). 1 m³ = 6.2898 bbl. - Producing well in a month: prod_petroleo_m3 > 0 or prod_gas_miles_m3 > 0. COUNT(DISTINCT idpozo) without that filter counts reporting wells, not producing ones. - Active well (by registry state, pozos.tipo_estado): Extracción Efectiva, En Inyección Efectiva, Otras Situación Activo. - IP30/IP90/IP180: production is monthly, so these are monthly proxies, not exact daily windows. For each well, its first months with prod_petroleo_m3 > 0: IP30 = oil of the first month / dias_activo; IP90 and IP180 = oil of the first 3 and 6 producing months / their dias_activo (m³/d; ×6.2898 for bbl/d). The well's formation, subtipo and tipo_pozo are those of that first month (shale oil: 'SHALE' and 'Petrolífero'). Precomputed in pozos_metricas. - GOR = prod_gas_miles_m3 × 1000 / prod_petroleo_m3 (m³/m³). - Water cut = 100 × water / (water + oil), as a ratio of sums over the group, not an average of wells. - BOE = oil m³ × 6.2898 + gas thousand m³ × 5.8858 (6,000 ft³ of gas = 1 BOE). - Year-on-year growth = BOE of the 12 months to the period end vs the previous 12 (entities under 1,000 BOE in the previous 12 are left out). - Last complete production month: the latest with ≥ 95 % of the reporting wells of the busiest of its 6 previous months. describe_data reports it; say it is an estimate. - reservas: Horizon: end of useful life. unidad mixes Mm3 (oil, thousand m³) and MMm3 (gas, million m³): never sum across units. - fracturas: empresa_informante = operator at the time of the job; pozos.empresa = current operator. - cammesa_generacion: Intraday power samples (MW) with gaps, not monthly energy. region 'Total SADI' is the system total: do not add regions. - balanza_comercial: periodo is an integer YYYYMM.
Names, descriptions and schemas were written by the server and are shown as data.
Pattern matches on what the server declares. They show what it says it can do, not what it does.
None yet. Changes appear after a server's second daily check.
| fecha_hasta | string | Inclusive |
| tipo_recurso | string | one of ["CONVENCIONAL","NO CONVENCIONAL","SIN RESERVORIO","NO DISCRIMINADO"] |
| area_concesion | string |
| subtipo_recurso | string | one of ["SHALE","TIGHT"] |
{
"name": "query_production",
"title": "Monthly hydrocarbon production",
"description": "Oil, gas and water production (2006–present) by entity and period, grouped by up to 3 dimensions: volumes, BOE, producing/reporting wells, daily rate, GOR, water cut. Example: {area_concesion: \"LOMA CAMPANA\", fecha_desde: \"2025\", agrupar_por: [\"anio\"]}.",
"inputSchema": {
"type": "object",
"$schema": "https://json-schema.org/draft/2020-12/schema",
"properties": {
"cuenca": {
"type": "string"
},
"idpozo": {
"type": "array",
"items": {
"type": "number"
},
"maxItems": 50
},
"empresa": {
"type": "string"
},
"max_rows": {
"type": "number",
"minimum": 1
},
"metricas": {
"type": "array",
"items": {
"enum": [
"petroleo",
"gas",
"agua",
"boe",
"gor",
"water_cut",
"pozos_productores",
"pozos_informantes",
"caudal_diario"
],
"type": "string"
},
"description": "Default petroleo, gas, agua (+ pozos_productores by mes); caudal_diario = volume / calendar days"
},
"formacion": {
"type": "string"
},
"provincia": {
"type": "string"
},
"tipo_pozo": {
"type": "string",
"description": "e.g. Petrolífero, Gasífero"
},
"yacimiento": {
"type": "string"
},
"agrupar_por": {
"type": "array",
"items": {
"enum": [
"mes",
"anio",
"empresa",
"cuenca",
"provincia",
"area_concesion",
"yacimiento",
"formacion",
"tipo_recurso",
"subtipo_recurso",
"tipo_pozo",
"idpozo"
],
"type": "string"
},
"maxItems": 3,
"description": "Up to 3 dimensions; default [mes]"
},
"fecha_desde": {
"type": "string"
},
"fecha_hasta": {
"type": "string",
"description": "Inclusive"
},
"tipo_recurso": {
"enum": [
"CONVENCIONAL",
"NO CONVENCIONAL",
"SIN RESERVORIO",
"NO DISCRIMINADO"
],
"type": "string"
},
"area_concesion": {
"type": "string"
},
"subtipo_recurso": {
"enum": [
"SHALE",
"TIGHT"
],
"type": "string"
}
}
},
"outputSchema": {
"type": "object",
"$schema": "https://json-schema.org/draft/2020-12/schema",
"required": [
"columns",
"rows",
"meta"
],
"properties": {
"meta": {
"type": "object",
"required": [
"returned",
"truncated",
"max_rows",
"sources",
"query_ms"
],
"properties": {
"sql": {
"type": "string"
},
"notes": {
"type": "array",
"items": {
"type": "string"
}
},
"sources": {
"type": "array",
"items": {
"type": "string"
}
},
"max_rows": {
"type": "number"
},
"query_ms": {
"type": "number"
},
"returned": {
"type": "number"
},
"truncated": {
"type": "boolean"
},
"definitions": {
"type": "array",
"items": {
"type": "string"
}
}
},
"additionalProperties": false
},
"rows": {
"type": "array",
"items": {
"type": "array",
"items": {}
}
},
"columns": {
"type": "array",
"items": {
"type": "object",
"required": [
"name",
"type"
],
"properties": {
"name": {
"type": "string"
},
"type": {
"type": "string"
},
"unit": {
"type": "string"
}
},
"additionalProperties": false
}
},
"sections": {
"type": "array",
"items": {
"type": "object",
"required": [
"name",
"columns",
"rows",
"truncated"
],
"properties": {
"name": {
"type": "string"
},
"rows": {
"type": "array",
"items": {
"type": "array",
"items": {}
}
},
"columns": {
"type": "array",
"items": {
"type": "object",
"required": [
"name",
"type"
],
"properties": {
"name": {
"type": "string"
},
"type": {
"type": "string"
},
"unit": {
"type": "string"
}
},
"additionalProperties": false
}
},
"truncated": {
"type": "boolean"
}
},
"additionalProperties": false
}
}
},
"additionalProperties": false
},
"annotations": {
"title": "Monthly hydrocarbon production",
"readOnlyHint": true,
"openWorldHint": false,
"idempotentHint": true
}
}| area_concesion | string |
| con_produccion | boolean |
| subtipo_recurso | string | one of ["SHALE","TIGHT"] |
| primera_produccion_desde | string | First month with oil or gas > 0 (or the registry fecha_primera_prod with segun_padron) |
| primera_produccion_hasta | string |
{
"name": "query_wells",
"title": "Wells search",
"description": "Wells in the registry (~86,000): location, type, current status and operator, cumulative production, first and last month with production, IP30. Example: {provincia: 'Neuquén', subtipo_recurso: 'SHALE', tipo_estado: 'activos'}.",
"inputSchema": {
"type": "object",
"$schema": "https://json-schema.org/draft/2020-12/schema",
"properties": {
"orden": {
"enum": [
"acumulado",
"ip30",
"primera_produccion"
],
"type": "string"
},
"cuenca": {
"type": "string"
},
"empresa": {
"type": "string"
},
"max_rows": {
"type": "number",
"minimum": 1
},
"formacion": {
"type": "string"
},
"provincia": {
"type": "string"
},
"tipo_pozo": {
"type": "string",
"description": "e.g. Petrolífero, Gasífero"
},
"yacimiento": {
"type": "string"
},
"tipo_estado": {
"type": "string",
"description": "Exact registry status (e.g. Abandonado, Parado Transitoriamente) or 'activos'"
},
"segun_padron": {
"type": "boolean"
},
"tipo_recurso": {
"enum": [
"CONVENCIONAL",
"NO CONVENCIONAL",
"SIN RESERVORIO",
"NO DISCRIMINADO"
],
"type": "string"
},
"area_concesion": {
"type": "string"
},
"con_produccion": {
"type": "boolean"
},
"subtipo_recurso": {
"enum": [
"SHALE",
"TIGHT"
],
"type": "string"
},
"primera_produccion_desde": {
"type": "string",
"description": "First month with oil or gas > 0 (or the registry fecha_primera_prod with segun_padron)"
},
"primera_produccion_hasta": {
"type": "string"
}
}
},
"outputSchema": {
"type": "object",
"$schema": "https://json-schema.org/draft/2020-12/schema",
"required": [
"columns",
"rows",
"meta"
],
"properties": {
"meta": {
"type": "object",
"required": [
"returned",
"truncated",
"max_rows",
"sources",
"query_ms"
],
"properties": {
"sql": {
"type": "string"
},
"notes": {
"type": "array",
"items": {
"type": "string"
}
},
"sources": {
"type": "array",
"items": {
"type": "string"
}
},
"max_rows": {
"type": "number"
},
"query_ms": {
"type": "number"
},
"returned": {
"type": "number"
},
"truncated": {
"type": "boolean"
},
"definitions": {
"type": "array",
"items": {
"type": "string"
}
}
},
"additionalProperties": false
},
"rows": {
"type": "array",
"items": {
"type": "array",
"items": {}
}
},
"columns": {
"type": "array",
"items": {
"type": "object",
"required": [
"name",
"type"
],
"properties": {
"name": {
"type": "string"
},
"type": {
"type": "string"
},
"unit": {
"type": "string"
}
},
"additionalProperties": false
}
},
"sections": {
"type": "array",
"items": {
"type": "object",
"required": [
"name",
"columns",
"rows",
"truncated"
],
"properties": {
"name": {
"type": "string"
},
"rows": {
"type": "array",
"items": {
"type": "array",
"items": {}
}
},
"columns": {
"type": "array",
"items": {
"type": "object",
"required": [
"name",
"type"
],
"properties": {
"name": {
"type": "string"
},
"type": {
"type": "string"
},
"unit": {
"type": "string"
}
},
"additionalProperties": false
}
},
"truncated": {
"type": "boolean"
}
},
"additionalProperties": false
}
}
},
"additionalProperties": false
},
"annotations": {
"title": "Wells search",
"readOnlyHint": true,
"openWorldHint": false,
"idempotentHint": true
}
}| string |
| fecha_desde | string | Default: 12 months to fecha_hasta |
| fecha_hasta | string | Inclusive; default the last complete month |
| area_concesion | string |
| subtipo_recurso | string | one of ["SHALE","TIGHT"] |
{
"name": "rank_entities",
"title": "Rankings",
"description": "Top N wells, areas, companies, fields, basins or formations by production, BOE, GOR, water cut, growth, new wells or IP30/90/180 (raw, per meter, per stage). Example: {entidad: 'pozo', metrica: 'ip30', subtipo_recurso: 'SHALE', tipo_pozo: 'Petrolífero', fecha_desde: '2025', fecha_hasta: '2025'}.",
"inputSchema": {
"type": "object",
"$schema": "https://json-schema.org/draft/2020-12/schema",
"required": [
"entidad",
"metrica"
],
"properties": {
"n": {
"type": "integer",
"maximum": 50,
"minimum": 1,
"description": "Default 10"
},
"orden": {
"enum": [
"desc",
"asc"
],
"type": "string"
},
"cuenca": {
"type": "string"
},
"empresa": {
"type": "string"
},
"entidad": {
"enum": [
"pozo",
"area",
"empresa",
"yacimiento",
"cuenca",
"formacion"
],
"type": "string"
},
"metrica": {
"enum": [
"ip30",
"ip90",
"ip180",
"ip30_por_metro",
"ip30_por_etapa",
"petroleo",
"gas",
"agua",
"boe",
"gor",
"water_cut",
"crecimiento_interanual",
"pozos_nuevos"
],
"type": "string",
"description": "ip*: wells of a first-production cohort (or their average per entity); others over the period"
},
"max_rows": {
"type": "number",
"minimum": 1
},
"formacion": {
"type": "string"
},
"provincia": {
"type": "string"
},
"tipo_pozo": {
"type": "string",
"description": "e.g. Petrolífero, Gasífero"
},
"yacimiento": {
"type": "string"
},
"fecha_desde": {
"type": "string",
"description": "Default: 12 months to fecha_hasta"
},
"fecha_hasta": {
"type": "string",
"description": "Inclusive; default the last complete month"
},
"area_concesion": {
"type": "string"
},
"subtipo_recurso": {
"enum": [
"SHALE",
"TIGHT"
],
"type": "string"
}
}
},
"outputSchema": {
"type": "object",
"$schema": "https://json-schema.org/draft/2020-12/schema",
"required": [
"columns",
"rows",
"meta"
],
"properties": {
"meta": {
"type": "object",
"required": [
"returned",
"truncated",
"max_rows",
"sources",
"query_ms"
],
"properties": {
"sql": {
"type": "string"
},
"notes": {
"type": "array",
"items": {
"type": "string"
}
},
"sources": {
"type": "array",
"items": {
"type": "string"
}
},
"max_rows": {
"type": "number"
},
"query_ms": {
"type": "number"
},
"returned": {
"type": "number"
},
"truncated": {
"type": "boolean"
},
"definitions": {
"type": "array",
"items": {
"type": "string"
}
}
},
"additionalProperties": false
},
"rows": {
"type": "array",
"items": {
"type": "array",
"items": {}
}
},
"columns": {
"type": "array",
"items": {
"type": "object",
"required": [
"name",
"type"
],
"properties": {
"name": {
"type": "string"
},
"type": {
"type": "string"
},
"unit": {
"type": "string"
}
},
"additionalProperties": false
}
},
"sections": {
"type": "array",
"items": {
"type": "object",
"required": [
"name",
"columns",
"rows",
"truncated"
],
"properties": {
"name": {
"type": "string"
},
"rows": {
"type": "array",
"items": {
"type": "array",
"items": {}
}
},
"columns": {
"type": "array",
"items": {
"type": "object",
"required": [
"name",
"type"
],
"properties": {
"name": {
"type": "string"
},
"type": {
"type": "string"
},
"unit": {
"type": "string"
}
},
"additionalProperties": false
}
},
"truncated": {
"type": "boolean"
}
},
"additionalProperties": false
}
}
},
"additionalProperties": false
},
"annotations": {
"title": "Rankings",
"readOnlyHint": true,
"openWorldHint": false,
"idempotentHint": true
}
}