{
  "notice": "bxzxxr MCP archive: a record of what public MCP servers declared when we listed them (we never call their tools). It is data, not a rating: nothing here says a server is safe, secure, verified or trustworthy, and a server can change after we looked. Secrets we detected are redacted; redacted tool lists are withheld and only their hash is shown.",
  "infrastructure": {
    "host": "energetica.ar",
    "site": "energetica.ar",
    "addresses": [
      {
        "address": "187.77.58.165",
        "endpoints": 1,
        "shared_infrastructure": false,
        "network": {
          "asn": 47583,
          "name": "AS-HOSTINGER - Hostinger Operations UAB",
          "prefix": "187.77.32.0/19",
          "country": "LT"
        }
      }
    ],
    "addresses_recorded": true,
    "address_history": [
      {
        "addresses": [
          "187.77.58.165"
        ],
        "first_seen": "2026-11-22T07:12:02.420Z",
        "last_seen": "2026-11-22T07:12:02.420Z",
        "checks": 1
      }
    ],
    "hosting": [],
    "software": [],
    "server_info": {
      "name": "energetica-data",
      "version": "3.0.0",
      "protocol_version": "2025-06-18"
    },
    "headers": {},
    "auth": null
  },
  "related": {
    "same_address": {
      "total": 0,
      "sample": []
    },
    "same_site": {
      "total": 0,
      "sample": []
    },
    "same_tool_list": {
      "total": 0,
      "sample": []
    },
    "same_publisher": {
      "publisher": "ar.energetica",
      "total": 0,
      "sample": []
    },
    "same_repository": null,
    "note": "Shared addresses on big platforms (Cloudflare, Vercel and the like) put unrelated servers together; those are marked shared_infrastructure. A match is a pivot, not a link between operators."
  },
  "endpoint": {
    "id": "4495",
    "server_name": "ar.energetica/data",
    "url": "https://energetica.ar/api/mcp",
    "host": "energetica.ar",
    "transport": "streamable-http",
    "last_checked_at": "2026-11-22T07:12:02.420Z",
    "last_state": "listed",
    "last_detail": null,
    "consecutive_failures": 0,
    "current_sha": "7dee8280b7e265bda91d99512dbca7ab54d2d3adc5a750882faba1e74b7be7e2",
    "first_listed_at": "2026-11-21T06:10:12.495Z",
    "created_at": "2026-11-21T05:00:09.593Z",
    "resolved_addresses": [
      "187.77.58.165"
    ]
  },
  "server": {
    "name": "ar.energetica/data",
    "title": "Energetica — Argentine Oil & Gas Data",
    "description": "Argentine oil & gas data — 40+ curated tables: production, wells, prices, investments, trade.",
    "version": "3.0.0",
    "registry_status": "active",
    "repository_url": null,
    "website_url": "https://energetica.ar/mcp",
    "published_at": "2026-10-19T14:15:49.135Z",
    "updated_at": "2026-10-19T14:15:49.135Z",
    "first_seen": "2026-11-21T05:00:08.976Z"
  },
  "other_endpoints": [],
  "intel": {
    "capabilities": [
      "runs-code"
    ],
    "evm_addresses": [],
    "chains": [],
    "tokens": [],
    "computed_at": "2026-11-22T14:54:06.311Z"
  },
  "needs_sign_in": false,
  "reachability": {
    "window_days": 30,
    "checks": 2,
    "answered": 2,
    "answered_percent": 100,
    "avg_listing_latency_ms": 1325,
    "first_check_in_window": "2026-11-21T06:10:12.495Z",
    "consecutive_failures_now": 0,
    "days": [
      {
        "day": "2026-11-21",
        "checks": 1,
        "answered": 1,
        "last_state": "listed"
      },
      {
        "day": "2026-11-22",
        "checks": 1,
        "answered": 1,
        "last_state": "listed"
      }
    ]
  },
  "tool_list": {
    "sha256": "7dee8280b7e265bda91d99512dbca7ab54d2d3adc5a750882faba1e74b7be7e2",
    "tools": 14,
    "resources": 0,
    "prompts": 0,
    "first_seen": "2026-11-21T06:10:13.908Z",
    "tool_names": [
      "describe_data",
      "resolve_entity",
      "query_production",
      "query_wells",
      "get_well",
      "get_area",
      "get_company",
      "rank_entities",
      "query_completions",
      "query_reserves",
      "query_investments",
      "query_prices",
      "query_trade",
      "execute_sql"
    ],
    "declared": {
      "tools": [
        {
          "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
          }
        },
        {
          "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
          }
        },
        {
          "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
          }
        },
        {
          "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
          }
        },
        {
          "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
          }
        },
        {
          "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
          }
        },
        {
          "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
          }
        },
        {
          "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
          }
        },
        {
          "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
          }
        },
        {
          "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
          }
        },
        {
          "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
          }
        },
        {
          "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
          }
        },
        {
          "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
          }
        },
        {
          "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
          }
        }
      ],
      "tools_omitted": 0,
      "resources": [],
      "prompts": []
    },
    "instructions": "Energética: Argentine oil & gas, energy and macro data from official sources, rebuilt daily.\n\nHow to work:\n- Start with describe_data (tables, periods, tool per table, warnings, last complete month). Prefer curated tools; execute_sql for the rest.\n- Entity filters take exact names; close ones are resolved (see notes), ambiguous ones fail with candidates. Join several with \"|\". resolve_entity finds names.\n- Names and values are in Spanish (NEUQUINA, formacion lowercase: 'vaca muerta').\n- 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.\n- In SQL, totals without wells: agg_produccion_mensual (1M rows), not produccion_mensual (18M).\n\nDomain rules:\n- produccion_mensual: one row per well and month; prod_petroleo_m3 (m³), prod_gas_miles_m3 (thousand m³). 1 m³ = 6.2898 bbl.\n- 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.\n- Active well (by registry state, pozos.tipo_estado): Extracción Efectiva, En Inyección Efectiva, Otras Situación Activo.\n- 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.\n- GOR = prod_gas_miles_m3 × 1000 / prod_petroleo_m3 (m³/m³).\n- Water cut = 100 × water / (water + oil), as a ratio of sums over the group, not an average of wells.\n- BOE = oil m³ × 6.2898 + gas thousand m³ × 5.8858 (6,000 ft³ of gas = 1 BOE).\n- 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).\n- 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.\n- reservas: Horizon: end of useful life. unidad mixes Mm3 (oil, thousand m³) and MMm3 (gas, million m³): never sum across units.\n- fracturas: empresa_informante = operator at the time of the job; pozos.empresa = current operator.\n- cammesa_generacion: Intraday power samples (MW) with gaps, not monthly energy. region 'Total SADI' is the system total: do not add regions.\n- balanza_comercial: periodo is an integer YYYYMM."
  },
  "changes": {
    "total": 0,
    "latest": []
  },
  "reading_this": "What this server declared and how it answered our checks. Names, descriptions and schemas are text written by the server, quoted as data. Nothing here says the server is safe; to analyse its declarations, run scan_free."
}