Energetica — Argentine Oil & Gas Data

Query monthly oil, gas, and water production data from Argentine hydrocarbon wells. Data covers 2006-present with ~18M records. Can be filtered and grouped by basin, company, geological formation, and time period.

{
  "type": "object",
  "properties": {
    "cuenca": {
      "description": "Basin name filter (e.g. NEUQUINA, GOLFO SAN JORGE, CUYANA, AUSTRAL, NOROESTE)",
      "type": "string"
    },
    "empresa": {
      "description": "Operating company filter (e.g. YPF, PAN AMERICAN ENERGY, VISTA, TECPETROL)",
      "type": "string"
    },
    "formacion": {
      "description": "Geological formation filter (e.g. VACA MUERTA, D-129, CENTENARIO)",
      "type": "string"
    },
    "fecha_desde": {
      "description": "Start date YYYY-MM (e.g. 2020-01)",
      "type": "string"
    },
    "fecha_hasta": {
      "description": "End date YYYY-MM (e.g. 2025-12)",
      "type": "string"
    },
    "agrupar_por": {
      "description": "Group results by dimension. Default: mes",
      "type": "string",
      "enum": [
        "mes",
        "anio",
        "cuenca",
        "empresa",
        "formacion"
      ]
    },
    "recurso": {
      "description": "Resource type filter. Default: todos",
      "type": "string",
      "enum": [
        "petroleo",
        "gas",
        "agua",
        "todos"
      ]
    }
  },
  "$schema": "https://json-schema.org/draft/2020-12/schema"
}

Search and filter Argentine oil & gas wells. Returns well location, type, status, cumulative production, and technical data. ~50,000 wells available.

{
  "type": "object",
  "properties": {
    "empresa": {
      "description": "Operating company filter",
      "type": "string"
    },
    "cuenca": {
      "description": "Basin filter (NEUQUINA, GOLFO SAN JORGE, etc.)",
      "type": "string"
    },
    "provincia": {
      "description": "Province filter (NEUQUEN, CHUBUT, MENDOZA, etc.)",
      "type": "string"
    },
    "tipo_recurso": {
      "description": "Resource type",
      "type": "string",
      "enum": [
        "PETROLEO",
        "GAS",
        "AMBOS"
      ]
    },
    "tipo_estado": {
      "description": "Well status (e.g. Activo, Inactivo, Abandonado)",
      "type": "string"
    },
    "formacion": {
      "description": "Geological formation",
      "type": "string"
    },
    "con_produccion": {
      "description": "Only wells with cumulative production > 0",
      "type": "boolean"
    },
    "limit": {
      "description": "Max results, default 100",
      "type": "number",
      "minimum": 1,
      "maximum": 1000
    }
  },
  "$schema": "https://json-schema.org/draft/2020-12/schema"
}

Query international and local energy prices. Includes WTI, Brent, Henry Hub (daily), Argentine crude prices (Escalante, Medanito), and exchange rates (official, blue, MEP, CCL).

{
  "type": "object",
  "properties": {
    "serie": {
      "type": "string",
      "enum": [
        "WTI",
        "BRENT",
        "HENRY_HUB",
        "ESCALANTE",
        "MEDANITO",
        "USD_OFICIAL",
        "USD_BLUE",
        "USD_MEP",
        "USD_CCL"
      ],
      "description": "Price series to query"
    },
    "fecha_desde": {
      "description": "Start date YYYY-MM-DD",
      "type": "string"
    },
    "fecha_hasta": {
      "description": "End date YYYY-MM-DD",
      "type": "string"
    },
    "frecuencia": {
      "description": "Frequency aggregation. Default: diario for intl prices, mensual for local",
      "type": "string",
      "enum": [
        "diario",
        "mensual",
        "anual"
      ]
    }
  },
  "required": [
    "serie"
  ],
  "$schema": "https://json-schema.org/draft/2020-12/schema"
}

Query upstream oil & gas investments in Argentina by company, basin, and year. Data includes drilling, completion, and infrastructure expenditure in millions USD.

{
  "type": "object",
  "properties": {
    "empresa": {
      "description": "Company filter",
      "type": "string"
    },
    "cuenca": {
      "description": "Basin filter",
      "type": "string"
    },
    "anio_desde": {
      "description": "Start year",
      "type": "number"
    },
    "anio_hasta": {
      "description": "End year",
      "type": "number"
    },
    "concepto": {
      "description": "Investment concept (e.g. perforacion, terminacion, infraestructura)",
      "type": "string"
    }
  },
  "$schema": "https://json-schema.org/draft/2020-12/schema"
}

Query Argentina hydrocarbon trade balance (exports/imports). Covers crude oil (HS 2709), refined products (HS 2710), and natural gas (HS 2711). Values in FOB USD.

{
  "type": "object",
  "properties": {
    "anio": {
      "description": "Filter by year",
      "type": "number"
    },
    "flow": {
      "description": "Trade flow direction",
      "type": "string",
      "enum": [
        "export",
        "import"
      ]
    },
    "producto": {
      "description": "Product category",
      "type": "string",
      "enum": [
        "crude",
        "refined",
        "gas"
      ]
    }
  },
  "$schema": "https://json-schema.org/draft/2020-12/schema"
}

Get the database schema and metadata. Returns table names, columns, types, descriptions, units, and example values. Use this to understand what data is available before querying.

{
  "type": "object",
  "properties": {
    "tabla": {
      "description": "Specific table name. Omit to get all tables.",
      "type": "string"
    }
  },
  "$schema": "https://json-schema.org/draft/2020-12/schema"
}

Execute arbitrary read-only SQL against the DuckDB database. Only SELECT and WITH statements are allowed. Use get_schema first to understand available tables and columns. Available on Professional tier and above.

{
  "type": "object",
  "properties": {
    "sql": {
      "type": "string",
      "description": "SQL query (SELECT or WITH only)"
    }
  },
  "required": [
    "sql"
  ],
  "$schema": "https://json-schema.org/draft/2020-12/schema"
}

Get the latest data available in each table — last period, date range, and total records. Use this to understand how current the data is.

{
  "type": "object",
  "properties": {},
  "$schema": "https://json-schema.org/draft/2020-12/schema"
}