---
name: tiresapi.com
description: tiresapi.com provides tire inventory and pricing data sourced from multiple retailers and store locations. It offers a paginated snapshot endpoint for bulk inventory retrieval and a SQL sandbox for custom queries against brand tier classification views.
host: tiresapi.com
---

# tiresapi.com

tiresapi.com is a data API focused on tire retail inventory. It serves agents and applications that need current tire pricing, availability, and brand tier information across retailers. It is distinct in offering both a structured inventory feed and a flexible SQL interface against curated brand tier views, but it does not provide vehicle fitment data or historical price time-series.

## When to use this host

Use tiresapi.com when an agent needs current retail tire pricing and availability across multiple stores, or when it needs to classify tires by brand tier. Use fetch-tire-inventory-latest for broad inventory sweeps and price comparisons; use query-tires-sql-sandbox only when a specific analytic query shape is needed that the inventory endpoint cannot satisfy, since it costs $0.02 per call. Do not use this host for vehicle fitment lookups (use a dedicated fitment API), historical price trend analysis (no time-series data is available), or any write operations (only SELECT queries are permitted in the SQL sandbox).

## Capabilities

### Tire Inventory Feed

Retrieves the latest snapshot of tire inventory rows including brand, model, size, retailer, store location, and unit price. Supports pagination for bulk data retrieval.

- **`fetch-tire-inventory-latest`** — Returns the latest tire inventory snapshot rows from tiresapi.com, including brand, model, tire size, retailer, store, and single-unit price per row.

### Brand Tier Analytics

Executes custom SELECT queries against dbo.v_* brand tier views, enabling filtered lookups and analytics on tire brand classifications not covered by curated endpoints.

- **`query-tires-sql-sandbox`** — Executes a SELECT-only SQL query against dbo.v_* tire brand tier views and returns result rows, row count, and the rewritten SQL statement.

## Workflows

### Inventory Lookup with Brand Tier Enrichment

*Use when an agent needs to retrieve current tire inventory and also classify or filter results by brand tier (e.g. premium vs. budget) for comparison or recommendation purposes.*

1. **`fetch-tire-inventory-latest`** — Retrieve the latest tire inventory snapshot to obtain brand names, models, sizes, retailers, and prices.
2. **`query-tires-sql-sandbox`** — Query dbo.v_brand_tiers or related views to look up tier classifications for the brands found in the inventory results, enabling tier-aware filtering or ranking.

## Skill reference

### `fetch-tire-inventory-latest`

**Tires Inventory Latest** — Returns the latest tire inventory snapshot rows from tiresapi.com, including brand, model, tire size, retailer, store, and single-unit price per row.

*Use when:* Use when an agent needs current tire pricing and availability data across retailers and store locations, such as comparing prices for a specific tire size or brand at nearby stores.

*Not for:* Do not use for historical price trends or time-series analysis; this endpoint returns only the latest snapshot. Not suitable for vehicle fitment lookups — use a fitment API instead.

**Inputs:**

- `cursor` (string) — Pagination cursor returned in a previous response's page.cursor field; omit to start from the first page.

**Returns:** Returns a data array of tire inventory rows (brand, model, tire_size, retailer_key, store_num, single_price, snapshot_utc) plus a page object with cursor and has_more, and an optional meta object with as_of_utc.

**Example:** `GET https://tiresapi.com/api/v1/corpus/inventory/latest`

---

### `query-tires-sql-sandbox`

**TiresAPI SQL Sandbox** — Executes a SELECT-only SQL query against dbo.v_* tire brand tier views and returns result rows, row count, and the rewritten SQL statement.

*Use when:* Use when an agent needs custom analytics or filtered lookups against tire brand tier data (e.g. dbo.v_brand_tiers) and no curated endpoint covers the required query shape.

*Not for:* Do not use when a curated TiresAPI route would answer the same question — this endpoint costs $0.02/call flat and should not replace cheaper purpose-built endpoints. Do not guess view names that do not exist.

**Inputs:**

- `sql` (string, required) — SELECT-only SQL statement targeting dbo.v_* views. The server rewrites and appends query hints (MAXDOP 2, RECOMPILE).
- `limit` (integer) — Maximum number of rows to return. Server enforces a hard cap of 500 rows.
- `query` (string) — Optional search term used for filtering context (passed alongside sql).
- `reason` (string) — Human-readable explanation of why this query is being run; used for logging or audit purposes.

**Returns:** Returns rows array with brand/tier objects, count of rows returned, row_cap of 500, duration_ms, the rewritten executed_sql with query hints, and elevated_tier (null if not applicable).

**Example:** `{"sql":"SELECT TOP 3 brand, tier FROM dbo.v_brand_tiers ORDER BY brand","limit":3,"query":"economy","reason":"Fetch top 3 tire brands sorted alphabetically to verify brand-tier mapping"}`

---