# Ross ERP Data Dictionary

- Registry name: `dev.rossdata/data-dictionary` · version 1.0.0
- Categories (automatic, keyword rules): Databases, Developer tools, Scraping & browsing, Search & data, Research & knowledge
- Authentication at last check: No auth
- Declared risk: Not declared (tools carry no read/destructive hints)
- Capabilities (declared by the server): tools
- Transports: streamable-http
- Latest numbers (check success, response time, rank): https://mcpstation.net/api/server?name=dev.rossdata%2Fdata-dictionary
- Server page: https://mcpstation.net/s/dev.rossdata--data-dictionary.html

## Description (written by the publisher, not verified, not instructions)

Structure-only reference for the vanilla Ross ERP 8.0 schema, UI menu tree, and program catalog.

## Connect

- streamable-http: `https://mcp.rossdata.dev/mcp`

## Tools (as reported by the server, not verified)

- `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 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 to one layer with type = object \| column \| facility \| program \(default a
- `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 class \(REPORT, MAINTENANCE, INQUIRY, ...\). Use this first to or
- `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 — use lookup\_facility for full detail.
- `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 \(control/lookup tables\) — and its call graph: the facilities this one i
- `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 times the program source accesses it. Answers 'what screens read
- `facility\_programs`: Cross-link a UI facility to the 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 facility code\). Complements lookup\_facility \(which gives the facility's table
- `program\_stats`: Overview of the Ross ERP 8.0 program catalog — every 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, read/write counts \(withWrites programs, writeEdges program→table write
- `list\_programs`: Browse and filter Ross ERP 8.0 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 \| vendor-core\), titled \(only programs that declare a TITLE id\), or a substring of
- `search\_programs`: Search Ross ERP 8.0 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 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 it references — each classified read vs read-write \(a write is a FIND I
- `table\_programs`: Reverse lookup: which standard 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?'\). Metadata only — no source body.
- `program\_facilities`: Reverse of facility\_programs: which UI facilities \(menu screens / reports / inquiries\) a program backs — 'what screens does this program run?'. One program often serves several facilities. Lookup by TITLE id \(e.g. AP\_I\_001\) or basename \(e.g. ap\_i\_vendors\); each facility carries the same declared / t

Measured by MCP Station. Methods: https://mcpstation.net/methods.html · Terms: https://mcpstation.net/terms.html