Search 501 building
materials instantly.

Specs, pricing, and carbon data for windows, doors, insulation and more. Free API — no credit card, no sales call.

Try the Explorer → Documentation

<\!-- Social proof stats bar --> <\!-- Live inline demo -->

Live Demo Search the database — no signup required

GET /v1/products

Run a search above to see the live API response...

{
  "data": [
    { "name": "...", "u_value": 0.30, "price_min_usd": 450 },
    ...
  ],
  "pagination": { "total": 501, "limit": 5 }
}

<\!-- Before/After code -->

                        
                        before
                    
                        // The old way

                        1. Google "Andersen 400 series specs"

                        2. Download 47-page PDF catalog

                        3. Find page 23, table 4

                        4. Copy values into spreadsheet

                        5. Repeat for 200 more products

                        6. Data is stale by next quarter

                        // Time: 3 days

                        // Accuracy: questionable

→

                        
                        after
                    
                        GET /v1/products?category=windows

                            &manufacturer=andersen&max_u_value=0.30

                        {

                          "data": [{

                            "name": "Andersen 400 Series Casement",

                            "u_value": 0.30,

                            "shgc": 0.27,

                            "price_min_usd": 450

                          }, ...]

                        }

<\!-- How it works -->

How it works

We ingest the mess

Manufacturer catalogs, spec sheets, pricing tables, government databases. We crawl, parse, and structure data from sources that were never designed to be queried.

AI structures it

LLMs extract attributes, normalize units, reconcile conflicts, and produce clean, typed data. Every record traceable to its source document.

You query it

Clean REST API. Filterable by performance specs, material, price, certifications. Drop it into your construction software, procurement tool, AI agent, or estimating workflow.

<\!-- CTA mid-page -->

Ready to get started?

Get your free API key and start building. No credit card, no sales call.

Get Free API Key →

<\!-- Endpoints -->

API endpoints

GET /v1/products Search, filter & paginate all products GET /v1/products/:slug Single product by slug GET /v1/categories Categories with subcategories & counts GET /v1/manufacturers Manufacturers with product counts GET /v1/stats Database statistics & averages

<\!-- Query params -->

Query parameters

Filter, search, and sort on /v1/products

Full-text search across names, descriptions, manufacturers

q=triple+pane+casement

Every industry has data that's hard to find. We make it queryable.

Substrata is the data infrastructure layer for industries the internet forgot to index. Starting with construction.