Ross ERP Data Dictionary
dev.rossdata/data-dictionary · v1.0.0 · MCP 2025-11-25
Structure-only reference for the vanilla Ross ERP 8.0 schema, UI menu tree, and program catalog.
Reachability
reachable
checked 2026-08-05 05:30 UTC
Registry status active
Tools pinned 21
7f9233116519
Tools last changed
unchanged since first capture 2026-08-05
Provenance
Registry namespace dev.rossdata
(domain verified by the official registry)
Website
https://rossdata.dev
Remote endpoints
https://mcp.rossdata.dev/mcp (streamable-http)
Observed changes
| When (UTC) | Event | Detail |
|---|---|---|
| 2026-08-05 05:30 | first capture | 21 tools pinned |
Pinned tool definitions (21)
| Tool | Description |
|---|---|
| schema_stats | Overview of the Ross ERP 8.0 schema in one call: object counts by type, module list, total/distinct columns, audit-twin pairs, and the top tables/columns/modules. Use this first to orient before drilling in. |
| list_objects | Browse and filter Ross ERP 8.0 objects (tables / views / procedures / functions). Filter by type, database, module, or a name substring; paginate with limit/offset. Returns object summaries — use lookup_table for full detail. |
| find_column | Look up a single column by exact name across the whole Ross ERP 8.0 schema: its description, valid values, notes, every table that carries it, and any foreign-key roles it plays. |
| lookup_table | Full schema for a Ross ERP 8.0 object (table / view / procedure / function): columns with type, nullability, keys, descriptions and valid values, foreign keys in and out, related tables, and usage. |
| search_columns | Search the Ross ERP 8.0 schema by name (and column descriptions). Returns matching objects and columns. |
| search_all | Cross-domain search in one call — spans schema objects, columns, UI facilities and vanilla programs at once. Use this when you don't yet know which layer a term lives in (e.g. 'check register' is a screen, a program and a table). Scope... |
| get_ddl | Return the CREATE TABLE (DDL) for a Ross ERP 8.0 table, with column descriptions as comments plus primary-key and foreign-key constraints. |
| graph_neighbors | List the knowledge-graph neighbours of an object — the programs, tables, views and procedures directly connected to it, with relationship type and direction. |
| path_between | Find the shortest path between two objects in the Ross ERP 8.0 knowledge graph (how A reaches B through calls / references / accesses). |
| facility_stats | Overview of the Ross ERP 8.0 application layer — the client menu tree of UI facilities (screens, reports, inquiries, maintenance functions): total facilities, and their breakdown by system (e.g. ACCOUNTS_PAYABLE), database (FIN/MAN) and... |
| list_facilities | Browse and filter Ross ERP 8.0 UI facilities (menu screens/functions). Filter by system, database, class, a name/code substring, or withTables (only facilities whose table cluster is known); paginate with limit/offset. Returns summaries... |
| search_facilities | Search Ross ERP 8.0 UI facilities by code, name, help text, program or tag. Use this to find the screen/report for a task, e.g. 'check register' or 'purchase order receipts'. |
| lookup_facility | Full detail for one Ross ERP 8.0 UI facility by code: its name, system, database, class, GEMBASE program, help text, menu paths, the physical table cluster it touches — core (the working set the screen is built on) and reference... |
| table_facilities | Reverse lookup: which UI facilities (screens/reports/programs) touch a given Ross ERP 8.0 table — split into core (facilities whose working set includes it) and reference (facilities that use it as a control/lookup), each with how many... |
| facility_programs | Cross-link a UI facility to the vanilla program(s) that implement it — 'what code runs this screen?'. Each program carries a match label: declared (named by the facility's menu entry, authoritative) or titleId (TITLE id equals the... |
| program_stats | Overview of the Ross ERP 8.0 program catalog — every vanilla application-source program (metadata only, no source body): total programs, how many declare a TITLE id, how many carry Data Dictionary table links, total program→table edges,... |
| list_programs | Browse and filter Ross ERP 8.0 vanilla programs (application source, metadata only). Filter by module (ap, gl, ic, sop, ...), type (a=archive, i=inquiry, m=maintenance, r=report, s=server, l=load, u=utility, ...), layer (base |... |
| search_programs | Search Ross ERP 8.0 vanilla programs by basename, TITLE program-id, title, module or type. Use this to find the program behind a task, e.g. 'check register' or 'ap_a'. |
| lookup_program | Full detail for one Ross ERP 8.0 vanilla program, by TITLE program-id (e.g. AP_A_002) or source basename (e.g. ap_a_check_register): its module, type, layer, declared title, internal PROCEDURE_FORM procedures, the Data Dictionary tables... |
| table_programs | Reverse lookup: which vanilla Ross ERP 8.0 programs reference a given table (validated against the Data Dictionary). Answers 'what code touches this table?' — complements table_facilities (which answers 'what screens touch it?').... |
| program_facilities | Reverse of facility_programs: which UI facilities (menu screens / reports / inquiries) a vanilla program backs — 'what screens does this program run?'. One program often serves several facilities. Lookup by TITLE id (e.g. AP_I_001) or... |
Get alerted when this changes.
Email the moment dev.rossdata/data-dictionary drifts, dies, or revives.
Status badge
[](https://toolpin.dev/servers/dev.rossdata/data-dictionary)
Maintain this server? Add the badge to your README. It links your users to this live status page.