Individual skill
sage200-assistant
Sage 200 Evolution / Pastel Evolution ERP assistant for consultants and integrators. Use for anything Sage 200 Evolution or Pastel Evolution, even if the user only says "Evolution", "Pastel", a table name (Client, Vendor, StkItem, InvNum, PostGL, _btblInvoiceLines, any _etbl/_btbl/_rtbl table), the SDK assembly (Pastel.Evolution.dll) or an SDK type (DatabaseContext, Customer, Supplier, InventoryTransaction, GLTransaction). Capabilities - (1) SQL / data dictionary: verified read-only T-SQL views and queries against an Evolution company database using the bundled dictionary (689 tables, every column, keys, Sage's own table descriptions), and "what table/field holds X". (2) SDK / C# against the Pastel Evolution .NET SDK: the RecordBase load/set/Save() pattern, posting documents, transactions, from a bundled class and enum reference. More capabilities (versions and upgrades) are added over time, so trigger on any Evolution question in an ERP context and route to the matching capability.
skills/sage200-assistant/SKILL.md
Source commit d68ce04e18d0702432eaf5ec1bbead8e03d0fa79
What was checked
- Matches the observed repository HEAD
- Yes
- Scanner rules are current
- No
- Repository scan complete
- No
- Skill scan complete
- No
- Observed behavior
- Not checked yet
- Last checked
- Nov 7, 2026
These are observations at the recorded commit, not a guarantee of safety. Review the source before running it.
Install this skill
Choose an agent in your Stack or copy a command below. Commands fetch the pinned commit and copy only this skill directory. Existing destinations are refused. Copying a command does not install anything.
An install command is unavailable: current rules, complete repository and skill scans, an eligible behavior level and a permitted license are required.
Repository context
- Repository stars (not skill ratings)
- 10
- Repository last updated
- Oct 21, 2026
- License
- MIT
Observed agent integration: claude-code
- accpac Repository topic
- agent-skills Repository topic
- claude-code Repository topic
- claude-skills Repository topic
- erp Repository topic
- sage300 Repository topic
- sql-server Repository topic
- sapb1 Repository topic
- sapbusinessone Repository topic
- claude Repository topic
- data Derived category
- data-databases Derived category
Files and excerpt
File metadata and permitted, redacted excerpts come from the recorded scan. Source links are pinned to that commit.
Browse files
.claude-plugin/plugin.jsonasset · 1,101 bytesMAINTENANCE.mddoc · 7,830 bytesREADME.mddoc · 6,092 bytesSKILL.mdcore · 15,948 bytesSKILL.mdcore · 15,948 bytesevals/evals.jsonasset · 7,312 bytesicon.pngasset · 99,173 bytesreferences/dictionary/INDEX.mddoc · 5,549 bytesreferences/dictionary/conventions.mddoc · 13,702 bytesreferences/dictionary/dict/Add-on-modules.mddoc · 110,534 bytesreferences/dictionary/dict/Application-metadata.mddoc · 12,210 bytesreferences/dictionary/dict/Business-modules.mddoc · 95,665 bytesreferences/dictionary/dict/Contact-Management.mddoc · 56,718 bytesreferences/dictionary/dict/Core.mddoc · 94,405 bytesreferences/dictionary/dict/Delivery-Management.mddoc · 4,279 bytesreferences/dictionary/dict/Evolution-extended.mddoc · 192,974 bytesreferences/dictionary/dict/Municipal-Billing.mddoc · 27,058 bytesreferences/dictionary/dict/Retail-POS.mddoc · 34,892 bytesreferences/dictionary/dict/Site-specific-and-snapshots.mddoc · 27,447 bytesreferences/sdk/INDEX.mddoc · 2,422 bytesreferences/sdk/api/INDEX.mddoc · 16,097 bytesreferences/sdk/api/classes-01.mddoc · 149,555 bytesreferences/sdk/api/classes-02.mddoc · 148,568 bytesreferences/sdk/api/classes-03.mddoc · 69,868 bytesreferences/sdk/common-mistakes.mddoc · 3,378 bytesreferences/sdk/enums/INDEX.mddoc · 10,431 bytesreferences/sdk/enums/enums-01.mddoc · 36,256 bytesreferences/sdk/sdk-guide.mddoc · 9,423 bytesscripts/build_sdk_ref.pyruns · 22,761 bytesscripts/bundle_util.pyruns · 2,393 bytesscripts/dump_enums.ps1runs · 2,520 bytesscripts/package_skill.pyruns · 3,261 bytes
Read excerpt
# Sage 200 Evolution Assistant
Reference-backed assistant for Sage 200 Evolution (Pastel Evolution) consultants and integrators. The rule that
makes it trustworthy: **every material claim — a table, column, key, class, property, method, enum value,
connection or posting step — comes from a bundled reference (or, for anything newer, a fresh check against the
client's database or installed SDK), and is cited** — never from memory alone. Column names, document-type values
and SDK member names are exactly the things a model guesses plausibly and wrongly.
## 1. Route the request
| Request looks like | Go to |
|---|---|
| a view, query, report extract, "what table/field holds X", how two tables join, what a column means | § 3 SQL |
| generate or fix **C# against the Pastel Evolution .NET SDK** (`Pastel.Evolution`) — connect via `DatabaseContext`, load/create a record and `Save()`, post a transaction (inventory, GL, cashbook, order/invoice), run inside a transaction, "what class/property/enum holds X in the SDK" | § 4 SDK |