Connect Lightspeed Retail to your AI agents.
Connect Lightspeed Retail data to AI agents with Combined. Explore users, customers, audit, source setup, MCP access and read-only business queries.
Put Lightspeed Retail records to work in the agent you already use. Combined syncs business data into a managed data layer and exposes scoped, read-only queries through MCP.
Start with 5 million MAR without a card; usage after the trial is $5 per million MAR, with no monthly minimum. Combined offers 1,125 connectors across catalog sources and connectors generated through desktop automation.
How to connect Lightspeed Retail to Combined
- Add your source. Open Connected Apps in Combined and select Lightspeed Retail. Use the account or workspace that contains the records you want to analyze.
- Authorize access. Complete the connection flow and choose the required permissions. The setup reference below shows the upstream source's configurable fields; the Combined flow may handle some of them for you.
- Select datasets and sync. Choose the relevant data, set any available history filters, and wait for the first successful sync.
- Grant your agent access. Use the Set up or Access workspace to connect your agent through MCP and scope it to the sources it needs.
- Ask a first question. Discover the synced schema, check freshness, and run a bounded read-only query. Then add another source for a cross-app analysis.
The onboarding guide covers the workspace flow. Prepare these Lightspeed Retail settings before connecting:
| Setting | When needed | Input |
|---|---|---|
| API Key | Required by source schema | Credential entered in the connection flow |
| Subdomain | Required by source schema | string |
Authentication choices are alternatives. Supply the settings for your selected method; enter credentials in the connection flow, rather than in an agent prompt.
Lightspeed Retail datasets you can evaluate
This reference comes from the upstream source catalog and connector definition, version 0.0.63. Your account permissions, selected streams and successful sync determine what your agent can query. Discover the actual table and field names in Combined before writing SQL.
| Dataset | Record key | Update field | Example fields |
|---|---|---|---|
users | id | Inspect sync configuration | version, account_type, created_at, display_name, email (18 fields in reference) |
customers | id | Inspect sync configuration | version, balance, created_at, customer_code, customer_group_id (13 fields in reference) |
audit | id | Inspect sync configuration | type, action, created_at, data, id (9 fields in reference) |
brands | id | Inspect sync configuration | version, id, name |
attributes | id | Inspect sync configuration | id, is_deprecated, name |
taxes | id | Inspect sync configuration | version, display_name, id, is_default, name (6 fields in reference) |
tags | id | Inspect sync configuration | version, id, name |
suppliers | id | Inspect sync configuration | version, contact, default_markup, id, name (6 fields in reference) |
serial_numbers | id | Inspect sync configuration | version, code, id, outlet_id, product_id |
sales | id | Inspect sync configuration | version, adjustments, attributes, created_at, customer_id (27 fields in reference) |
registers | id | Inspect sync configuration | version, ask_for_note_on_save, ask_for_user_on_sale, attributes, button_layout_id (21 fields in reference) |
quotes | id | Inspect sync configuration | created_at, customer_id, expired_at, id, loyalty (16 fields in reference) |
services | id | Inspect sync configuration | agenda, created_at, id, retailer_id, sale_id (8 fields in reference) |
promotions | id | Inspect sync configuration | description, action, channels, condition, customer_group_ids (15 fields in reference) |
products | id | Inspect sync configuration | version, type, description, active, attributes (40 fields in reference) |
product_categories | id | Inspect sync configuration | PayloadID, category_path, id, leaf_category, name (6 fields in reference) |
price_books | id | Inspect sync configuration | version, adjustment, adjustment_type, created_at, default_display_price (14 fields in reference) |
payment_types | id | Inspect sync configuration | version, config, created_at, disabled, gateway (11 fields in reference) |
outlets | id | Inspect sync configuration | version, attributes, currency, currency_symbol, default_tax_id (9 fields in reference) |
inventory | id | Inspect sync configuration | version, average_cost, current_amount, id, inventory_level (7 fields in reference) |
fulfillments | id | Inspect sync configuration | created_at, id, line_items, outlet_id, sale_id (7 fields in reference) |
customer_groups | id | Inspect sync configuration | version, created_at, group_id, id, name (7 fields in reference) |
consignments | id | Inspect sync configuration | version, type, consignment_date, created_at, due_at (19 fields in reference) |
consignment_products | product_id | Inspect sync configuration | version, cost, count, created_at, is_included (8 fields in reference) |
A cursor tracks changes for a source stream. It is not automatically the right date for a business metric: invoice date, close date and record-update date can answer different questions.
Useful Lightspeed Retail questions for your AI agent
Start with the datasets you have granted. These prompts turn the referenced schema into checks and summaries; the agent should verify each field against your synced data.
- Count distinct users using id and check for duplicate keys.
- Count distinct customers using id and check for duplicate keys.
- Count distinct audit using id and check for duplicate keys.
- Count distinct brands using id and check for duplicate keys.
Combine Lightspeed Retail with another business app
Connect the second source, identify a maintained customer, account or project mapping, and aggregate each dataset before joining. Keep unmatched records visible and define the reporting window. The CRM-and-billing worked example includes runnable SQL demonstrating how a many-to-many join can double the result.
Use Lightspeed Retail data in Claude Code, Cursor or another MCP client
Once the source is synced, the agent connects to Combined's MCP interface. Use the generated account-specific configuration from your workspace, keep credentials local, and grant only the sources needed for the task. Follow the Claude Code walkthrough or the MCP setup reference.
Use Combined to analyze my Lightspeed Retail data.
List my granted sources, discover the datasets and describe their fields.
Look for datasets corresponding to users, customers, audit, brands, attributes, taxes.
Check the last successful sync and report the available date coverage.
Propose three useful questions based on the fields actually available.
For the question I choose, run read-only SQL over the complete matching dataset.
Use a bounded result; include source names, time window and query receipt.
Ask for a missing join key or metric definition instead of inventing one.Download this Lightspeed Retail guide as Markdown to use alongside your agent instructions.
Which Lightspeed Retail connection fits the task?
Managed data for complete questions across apps
Choose Combined when you want to analyze synced records, calculate totals, or join Lightspeed Retail with other business data without operating a separate ingestion and query stack. The agent works with your source grants and read-only SQL access.
Application tools for live operations
For a task that must change Lightspeed Retail immediately, evaluate its available API, native agent tools or desktop workflow. Keep application-action permissions separate from read-only analytics access. A live lookup and an aggregate over synced history solve different jobs.
Desktop-generated connectors for workflows beyond the catalog
Combined's 1,125-connector coverage includes connections generated through computer use. Choose this route when the workflow depends on an application's desktop or browser interface, and establish the fields, access and refresh behavior for that connection.
Read the direct MCP versus managed data comparison and compare business-data MCP options.
Troubleshoot your Lightspeed Retail connection
- Authorization fails: check the selected authentication method, credential validity, source permissions and target account.
- The wrong records appear: verify the workspace, account, project or domain selected in the source settings.
- A dataset is absent: check whether it is enabled and permitted for your account, then inspect discovery and sync status.
- The agent cannot query it: confirm the source is included in the agent's grant and that its sync succeeded.
- A total looks wrong: inspect record keys, duplicate rows, time zones, currencies and join fanout before changing the prompt.
Source details reviewed September 10, 2026. Lightspeed Retail upstream connector documentation · Versioned connector definition. See also Combined Sources and data freshness for AI agents.