Toast Analytics Connector

The Toast Analytics API provides an enterprise reporting and analytics service, and includes operations that retrieve information for all restaurants, or a subset of restaurants, in a management group, create requests for reporting data, and retrieve the reporting data.

4.8 on G2

Weld · Data Sources

Toast Analytics

Toast AnalyticsYour warehouseLive

analytics_aggregated_sales23 columnsSynced

analytics_menu23 columnsSynced

analytics_check21 columnsSynced

analytics_labor18 columnsSyncing

analytics_labor_by_employee18 columnsQueued

Lands in

snowflake

bigquery

databricks

Agent context over MCP

How it works

Set up in minutes.
No code, no maintenance.

Toast Analytics

Toast Analytics

Data source

Authenticating...

Ready to connect

Overview

Toast Analytics in your warehouse.
Ready for your agents.

The Toast Analytics API provides an enterprise reporting and analytics service, and includes operations that retrieve information for all restaurants, or a subset of restaurants, in a management group, create requests for reporting data, and retrieve the reporting data. Weld's Toast Analytics connector is fully managed: it extracts data from Toast Analytics, loads it into your warehouse, and keeps it in sync. The data lands in a clean, documented schema with agent context attached, so analysts can query it with SQL or dbt, and agents can query it over the Weld MCP server without guessing at tables or joins.

Agent context

Toast Analytics data schema.
The map your agents read.

Every table, field and relationship Weld syncs from Toast Analytics is served to agents as context over MCP, so they pick the right tables and join on the right keys.

tables: 13
fields: 214

Loading diagram…

analytics_aggregated_sales

restaurant_guid

void_orders_count

discount_order_count

open_orders_count

closed_orders_count

analytics_check

restaurant_guid

order_opened_date

check_paid_date_time

check_modified_date_time

analytics_guest_by_payment

restaurant_guid

restaurant_name

restaurant_location_name

restaurant_location_code

card_fingerprint

analytics_labor

restaurant_guid

restaurant_name

restaurant_location_name

restaurant_location_code

analytics_labor_by_employee

restaurant_guid

restaurant_name

restaurant_location_name

restaurant_location_code

analytics_labor_by_job

restaurant_guid

restaurant_name

restaurant_location_name

restaurant_location_code

restaurant_guid

restaurant_name

restaurant_location_name

restaurant_location_code

net_sales_amount

gross_sales_amount

discount_amount

analytics_menu_by_menu

restaurant_guid

restaurant_name

restaurant_location_name

restaurant_location_code

net_sales_amount

gross_sales_amount

analytics_menu_by_menu_item

restaurant_guid

restaurant_name

restaurant_location_name

restaurant_location_code

net_sales_amount

gross_sales_amount

analytics_payout_by_payments

restaurant_guid

restaurant_name

restaurant_location_name

restaurant_location_code

analytics_payout_by_sales_date

restaurant_guid

restaurant_name

restaurant_location_name

restaurant_location_code

transaction_count

analytics_payout_by_settled_date

restaurant_guid

restaurant_name

restaurant_location_name

restaurant_location_code

sales_period_start_date_time

sales_period_end_date_time

transaction_count

analytics_restaurants_information

restaurant_guid

restaurant_name

Open the schema explorer Open the full schema explorer

Models

Toast Analytics models.
What the numbers mean.

Open-source SQL that turns the raw Toast Analytics tables into the reports people ask about. Deploy them in Weld and your agent queries the definitions, not guesses.

Open the models

Weld MCP server

Ask your agent.
It already knows Toast Analytics.

Connect Claude, Cursor, ChatGPT or your own agent to Weld over MCP. It reads the Toast Analytics context, finds the tables it needs and queries your warehouse.

Agent contextToast Analytics tables, fields and joins
QuerySQL against your warehouse
OperateCheck, rerun and refresh syncs

Set up the MCP server

Claude CodeOpus 5

ConnectedWeld MCPAgent contextToast Analyticstables13fields214

>

How many analytics_aggregated_sales rows do we have in our Toast Analytics data?

Reading the Toast Analytics context first, so the query uses the right tables and keys.

●weld·search_available_references

⎿raw.toast_analytics.analytics_aggregated_sales

+ 12 more Toast Analytics tables

●weld·get_reference_schema

⎿analytics_aggregated_sales · 23 columns

restaurant_guid, business_date

●weld·run_query

⎿select count(*) from {{raw.toast_analytics.analytics_aggregated_sales}}

submitted

●weld·get_query_status

⎿DONE

●weld·get_query_result

⎿rows returned

✓Answered from Toast Analytics data in your warehouse

>Ask about your Toast Analytics dataMCP

Destinations

Load Toast Analytics into any warehouse.
Set up in minutes, no code.

Resources

Everything you need.
To get started.

Connect your agents

Set up Claude, Cursor, ChatGPT or Codex against your Weld workspace.

Weld Connect API

Build custom connectors

Use the Weld Connect API to build and publish your own connector.

Common questions

Answers to frequently asked questions about Weld connectors.

Weld Connect API

Set it up in code.
One REST API.

Use the Weld Connect REST API to create Toast Analytics connections, configure ELT syncs, and manage pipelines entirely through code. Built for embedding, automation, and CI/CD workflows.

Explore Weld Connect API reference

POST/elt_syncs

# Create a Toast Analytics ELT sync
curl -X POST https://connect.weld.app/elt_syncs \
  -H "x-api-key: $API_KEY" \
  -d '{
    "connection_id": "conn_abc123",
    "integration_id": "toast-analytics",
    "destination_schema_name": "toast-analytics_data",
    "sync_interval": "0 * * * *"
  }'
▌

FAQ

Common questions.
About connectors.

Still have a question?

All connector and sync questions

Put your Toast Analytics data to work.

Connect Toast Analytics, pick a warehouse, and your agents can query it today. Free for 14 days, no credit card.

Toast Analytics

Source

Weld

MCPAgents

Start for free Talk to us

Connectors

Explore more connectors.
300+ and counting.

View all connectors