# EPA Envirofacts table query

Reads rows from an EPA Envirofacts table filtered on one column, e.g. tri_facility (Toxics Release Inventory facilities), frs_facility_site. Needs table, column and value.

Reads rows from an EPA Envirofacts table filtered on one column, e.g. tri_facility (Toxics Release Inventory facilities), frs_facility_site (Facility Registry Service), sems_active_sites (Superfund). Choose rows as a first:last range of at most 100 rows.

- Tool ID: `epa/envirofacts-query`
- Provider: [EPA](/providers/epa.md)
- Capability: [Knowledge & research](/tools/knowledge.md)
- Price: no charge per call
- Authentication: an authorised Agentik workspace is required for execution, including zero-price tools.

## Pricing contract

No charge per call. A workspace is still needed so your agent can call it.


```json
{
  "model": "per_call",
  "amountUsd": 0
}
```

## Complete input schema


```json
{
  "type": "object",
  "properties": {
    "table": {
      "type": "string",
      "pattern": "^[a-z][a-z0-9_]{1,63}$",
      "description": "Envirofacts table name, e.g. 'tri_facility'"
    },
    "column": {
      "type": "string",
      "pattern": "^[a-z][a-z0-9_]{1,63}$",
      "description": "Column to filter, e.g. 'state_abbr'"
    },
    "operator": {
      "type": "string",
      "enum": [
        "=",
        "!=",
        "<",
        ">",
        "beginning",
        "containing"
      ],
      "default": "=",
      "description": "Filter operator, e.g. 'containing'"
    },
    "value": {
      "type": "string",
      "minLength": 1,
      "maxLength": 120,
      "description": "Filter value (often upper case), e.g. 'VT'"
    },
    "first_row": {
      "type": "integer",
      "minimum": 0,
      "maximum": 100000,
      "default": 0,
      "description": "First row index (0-based), e.g. 0"
    },
    "last_row": {
      "type": "integer",
      "minimum": 0,
      "maximum": 100099,
      "default": 9,
      "description": "Last row index (inclusive, at most first_row + 99), e.g. 9"
    }
  },
  "required": [
    "table",
    "column",
    "value"
  ],
  "additionalProperties": false
}
```

## Published example

This is the provider tool’s published example. Replace example values with the user’s requested inputs, respecting the schema; do not execute an example merely to test a connection.


```json
{
  "tool_id": "epa/envirofacts-query",
  "input": {
    "table": "tri_facility",
    "column": "state_abbr",
    "value": "VT",
    "first_row": 0,
    "last_row": 2
  }
}
```

## Execute and retrieve

Inspect again before execution, explain the price and obtain the required authority. Use MCP run_tool or POST /v1/run with this tool ID, valid input and an idempotency key. Save the returned run ID and follow the actual state. If Agentik answers that the tool is temporarily unavailable, do not retry it blindly; use discovery to propose an alternative.

A partial or uncertain result can still have consumed provider resources. Consult [billing](/docs/billing.md), [idempotency](/docs/idempotency.md) and [asynchronous results](/docs/async.md).

Licence: US Government public data (public domain).

Attribution: Data from the U.S. Environmental Protection Agency (Envirofacts).

[Provider documentation](https://www.epa.gov/enviro/envirofacts-data-service-api)

[REST inspection](https://api.agentik.cc/v1/tools/epa/envirofacts-query) · [OpenAPI](/openapi.json) · [Connection guide](/connect.md)

---

[HTML page](/providers/epa/envirofacts-query) · [Agent index](/llms.txt)