MCP 服务器

Energetica — Argentine Oil & Gas Data

ar.energetica/data
数据与分析 科学与工程 公开且可连接 MCP 2025-11-25

此 MCP 可以做什么

Provides queryable Argentine oil and gas datasets covering production, wells, prices, investments, trade, and related database metadata.

execute_sql
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', '$schema': 'https://json-schema.org/draft/2020-12/schema', 'required': ['sql'], 'properties': {'sql': {'type': 'string', 'description': 'SQL query (SELECT or WITH only)'}}}
get_data_freshness
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', '$schema': 'https://json-schema.org/draft/2020-12/schema', 'properties': {}}
get_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', '$schema': 'https://json-schema.org/draft/2020-12/schema', 'properties': {'tabla': {'type': 'string', 'description': 'Specific table name. Omit to get all tables.'}}}
query_investments
Query upstream oil & gas investments in Argentina by company, basin, and year. Data includes drilling, completion, and infrastructure expenditure in millions USD.
输入模式
{'type': 'object', '$schema': 'https://json-schema.org/draft/2020-12/schema', 'properties': {'cuenca': {'type': 'string', 'description': 'Basin filter'}, 'empresa': {'type': 'string', 'description': 'Company filter'}, 'concepto': {'type': 'string', 'description': 'Investment concept (e.g. perforacion, terminacion, infraestructura)'}, 'anio_desde': {'type': 'number', 'description': 'Start year'}, 'anio_hasta': {'type': 'number', 'description': 'End year'}}}
query_prices
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', '$schema': 'https://json-schema.org/draft/2020-12/schema', 'required': ['serie'], 'properties': {'serie': {'enum': ['WTI', 'BRENT', 'HENRY_HUB', 'ESCALANTE', 'MEDANITO', 'USD_OFICIAL', 'USD_BLUE', 'USD_MEP', 'USD_CCL'], 'type': 'string', 'description': 'Price series to query'}, 'frecuencia': {'enum': ['diario', 'mensual', 'anual'], 'type': 'string', 'description': 'Frequency aggregation. Default: diario for intl prices, mensual for local'}, 'fecha_desde': {'type': 'string', 'description': 'Start date YYYY-MM-DD'}, 'fecha_hasta': {'type': 'string', 'description': 'End date YYYY-MM-DD'}}}
query_production
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', '$schema': 'https://json-schema.org/draft/2020-12/schema', 'properties': {'cuenca': {'type': 'string', 'description': 'Basin name filter (e.g. NEUQUINA, GOLFO SAN JORGE, CUYANA, AUSTRAL, NOROESTE)'}, 'empresa': {'type': 'string', 'description': 'Operating company filter (e.g. YPF, PAN AMERICAN ENERGY, VISTA, TECPETROL)'}, 'recurso': {'enum': ['petroleo', 'gas', 'agua', 'todos'], 'type': 'string', 'description': 'Resource type filter. Default: todos'}, 'formacion': {'type': 'string', 'description': 'Geological formation filter (e.g. VACA MUERTA, D-129, CENTENARIO)'}, 'agrupar_por': {'enum': ['mes', 'anio', 'cuenca', 'empresa', 'formacion'], 'type': 'string', 'description': 'Group results by dimension. Default: mes'}, 'fecha_desde': {'type': 'string', 'description': 'Start date YYYY-MM (e.g. 2020-01)'}, 'fecha_hasta': {'type': 'string', 'description': 'End date YYYY-MM (e.g. 2025-12)'}}}
query_trade
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', '$schema': 'https://json-schema.org/draft/2020-12/schema', 'properties': {'anio': {'type': 'number', 'description': 'Filter by year'}, 'flow': {'enum': ['export', 'import'], 'type': 'string', 'description': 'Trade flow direction'}, 'producto': {'enum': ['crude', 'refined', 'gas'], 'type': 'string', 'description': 'Product category'}}}
query_wells
Search and filter Argentine oil & gas wells. Returns well location, type, status, cumulative production, and technical data. ~50,000 wells available.
输入模式
{'type': 'object', '$schema': 'https://json-schema.org/draft/2020-12/schema', 'properties': {'limit': {'type': 'number', 'maximum': 1000, 'minimum': 1, 'description': 'Max results, default 100'}, 'cuenca': {'type': 'string', 'description': 'Basin filter (NEUQUINA, GOLFO SAN JORGE, etc.)'}, 'empresa': {'type': 'string', 'description': 'Operating company filter'}, 'formacion': {'type': 'string', 'description': 'Geological formation'}, 'provincia': {'type': 'string', 'description': 'Province filter (NEUQUEN, CHUBUT, MENDOZA, etc.)'}, 'tipo_estado': {'type': 'string', 'description': 'Well status (e.g. Activo, Inactivo, Abandonado)'}, 'tipo_recurso': {'enum': ['PETROLEO', 'GAS', 'AMBOS'], 'type': 'string', 'description': 'Resource type'}, 'con_produccion': {'type': 'boolean', 'description': 'Only wells with cumulative production > 0'}}}
已添加
get_data_freshness
2026年9月17日 07:58
已添加
execute_sql
2026年9月17日 07:58
已添加
get_schema
2026年9月17日 07:58
已添加
query_trade
2026年9月17日 07:58
已添加
query_investments
2026年9月17日 07:58
已添加
query_prices
2026年9月17日 07:58
已添加
query_wells
2026年9月17日 07:58
已添加
query_production
2026年9月17日 07:58