fulfil logo

fulfil

31

Connect Cursor to your Fulfil ERP workspace. Ask about orders, inventory, shipments and invoices in plain language, pull live API docs while you build an integration, run reports and analytical queries, and build Micro Apps that deploy straight into Fulfil — all under your own Fulfil permissions.

4 rules

Add to Cursor
# Data warehouse query rules Scanned bytes bill against a **shared daily workspace budget**. Exhausting it blocks analytics for everyone in that workspace until it resets. ## Before writing SQL `discover_tables` then `get_table_schema`. Tables and columns differ per workspace — never guess one. A failed query still scans and still bills. ## Writing SQL - Name the columns you need. `SELECT *` on a wide table is the most expensive habit available. - Bound the date range on anything historical, using the table's own date column. - Read-only queries only. - **Never paginate with `OFFSET`** — each page re-scans the whole table. Use keyset pagination: order by a unique key, filter past the last row seen. ## Reporting - Quote the date range, filters, and row limit alongside the numbers. - Say when a result was truncated by the limit instead of presenting it as complete. - On a budget or permission error, show the user the server's message. Do not retry, and do not quietly substitute an approximation from the record API.
Add to Cursor
Add to Cursor
Add to Cursor