Ross ERP Data Dictionary

by rossdata.dev · remote · no sign-in to list tools · v1.0.0 · published by dev.rossdata

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

Changes · 8

Compare Registry entry

21 tools: 8 change things and 13 only read.

Scanned Oct 21, 2026

Deletes or cancels0Claude Code: deny
Can't be undone0Claude Code: ask
Changes things8Claude Code: ask: see these tools
Only reads13Claude Code: allow: see these tools

No check matched anything in the tool definitions. No finding is not a safety guarantee. How the checks work.

claude mcp add --transport http data-dictionary https://mcp.rossdata.dev/mcp

Tools

Open a tool for its reasons and full description. Descriptions are the publisher's own words, shown as they are.

21 tools

Changes things 8Creates or changes something that can be changed back.Claude Code: ask

facility_programsCross-link a UI facility to the program(s) that implement it — 'what code runs this screen?'.No findings
Why it is in this group
- The input takes a statement or command to run (input.code), which can change anything it can reach.
Description, as the server wrote it
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 tables and call graph). Metadata only — no source body.
facility_statsOverview 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 b…No findings
Why it is in this group
- Nothing in its name or description says what it does, so it is counted as a write.
Description, as the server wrote it
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 orient before browsing facilities.
lookup_facilityFull 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 w…No findings
Why it is in this group
- The name "lookup_facility" says "lookup": a word for reading.
- The input takes a statement or command to run (input.code), which can change anything it can reach.
Description, as the server wrote it
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 invokes (calls) and the facilities that invoke it (calledBy), parsed from the program source.
program_facilitiesReverse of facility_programs: which UI facilities (menu screens / reports / inquiries) a program backs — 'what screens does this program run?'.No findings
Why it is in this group
- Nothing in its name or description says what it does, so it is counted as a write.
Description, as the server wrote it
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 / titleId match label.
program_statsOverview 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 Di…No findings
Why it is in this group
- Nothing in its name or description says what it does, so it is counted as a write.
Description, as the server wrote it
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 edges), base vs vendor-core split, program→program call-graph counts (programs with outbound calls, total call edges) and how many back a menu facility, plus the module and type breakdowns. Use this first to orient before browsing programs.
schema_statsOverview 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.No findings
Why it is in this group
- Nothing in its name or description says what it does, so it is counted as a write.
Description, as the server wrote it
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.
table_facilitiesReverse 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 (faciliti…No findings
Why it is in this group
- Nothing in its name or description says what it does, so it is counted as a write.
Description, as the server wrote it
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 or write this table?'.
table_programsReverse lookup: which standard Ross ERP 8.0 programs reference a given table (validated against the Data Dictionary).No findings
Why it is in this group
- Nothing in its name or description says what it does, so it is counted as a write.
Description, as the server wrote it
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.

Only reads 13Looks things up and changes nothing.Claude Code: allow

find_columnLook 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.No findings
Why it is in this group
- The name "find_column" says "find": a word for reading.
Description, as the server wrote it
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.
get_ddlReturn the CREATE TABLE (DDL) for a Ross ERP 8.0 table, with column descriptions as comments plus primary-key and foreign-key constraints.No findings
Why it is in this group
- The name "get_ddl" says "get": a word for reading.
Description, as the server wrote it
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_neighborsList the knowledge-graph neighbours of an object — the programs, tables, views and procedures directly connected to it, with relationship type and direction.No findings
Why it is in this group
- The description's first verb is "list": a word for reading.
Description, as the server wrote it
List the knowledge-graph neighbours of an object — the programs, tables, views and procedures directly connected to it, with relationship type and direction.
list_facilitiesBrowse and filter Ross ERP 8.0 UI facilities (menu screens/functions).No findings
Why it is in this group
- The name "list_facilities" says "list": a word for reading.
Description, as the server wrote it
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.
list_objectsBrowse and filter Ross ERP 8.0 objects (tables / views / procedures / functions).No findings
Why it is in this group
- The name "list_objects" says "list": a word for reading.
Description, as the server wrote it
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.
list_programsBrowse and filter Ross ERP 8.0 programs (application source, metadata only).No findings
Why it is in this group
- The name "list_programs" says "list": a word for reading.
Description, as the server wrote it
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 basename/title; paginate with limit/offset. Returns summaries — use lookup_program for full detail.
lookup_programFull detail for one Ross ERP 8.0 program, by TITLE program-id (e.g.No findings
Why it is in this group
- The name "lookup_program" says "lookup": a word for reading.
Description, as the server wrote it
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 IN.../LOCK=WRITE update, an ADD, or a DELETE) with a writeCount — its call graph (the programs it invokes and the programs that invoke it, from PERFORM "GEM<mod>:<prog>"), the menu facilities it backs, and — for programs with no TITLE label — a display name carried from the menu facility's registry description. Metadata only — no source body.
lookup_tableFull 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 t…No findings
Why it is in this group
- The name "lookup_table" says "lookup": a word for reading.
Description, as the server wrote it
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.
path_betweenFind the shortest path between two objects in the Ross ERP 8.0 knowledge graph (how A reaches B through calls / references / accesses).No findings
Why it is in this group
- The description's first verb is "find": a word for reading.
Description, as the server wrote it
Find the shortest path between two objects in the Ross ERP 8.0 knowledge graph (how A reaches B through calls / references / accesses).
search_allCross-domain search in one call — spans schema objects, columns, UI facilities and programs at once.No findings
Why it is in this group
- The name "search_all" says "search": a word for reading.
Description, as the server wrote it
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 all); limit is per domain.
search_columnsSearch the Ross ERP 8.0 schema by name (and column descriptions).No findings
Why it is in this group
- The name "search_columns" says "search": a word for reading.
Description, as the server wrote it
Search the Ross ERP 8.0 schema by name (and column descriptions). Returns matching objects and columns.
search_facilitiesSearch Ross ERP 8.0 UI facilities by code, name, help text, program or tag.No findings
Why it is in this group
- The name "search_facilities" says "search": a word for reading.
Description, as the server wrote it
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'.
search_programsSearch Ross ERP 8.0 programs by basename, TITLE program-id, title, module or type.No findings
Why it is in this group
- The name "search_programs" says "search": a word for reading.
Description, as the server wrote it
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'.

This is not a safety rating, and no finding is not a safety guarantee. The groups and findings come from fixed checks of the tool definitions the server returned on the date shown, not from its code or what it does when called. How the checks work.

Install

Pinned to version 1.0.0. Values in angle brackets are yours to fill in.

claude mcp add --transport http data-dictionary https://mcp.rossdata.dev/mcp

Run in a terminal.

Claude Code permissions

Allow the reads, ask before a change, deny the deletes. Paste into .claude/settings.json.

.claude/settings.json

{
  "permissions": {
    "allow": [
      "mcp__data-dictionary__list_objects",
      "mcp__data-dictionary__find_column",
      "mcp__data-dictionary__lookup_table",
      "mcp__data-dictionary__search_columns",
      "mcp__data-dictionary__search_all",
      "mcp__data-dictionary__get_ddl",
      "mcp__data-dictionary__graph_neighbors",
      "mcp__data-dictionary__path_between",
      "mcp__data-dictionary__list_facilities",
      "mcp__data-dictionary__search_facilities",
      "mcp__data-dictionary__list_programs",
      "mcp__data-dictionary__search_programs",
      "mcp__data-dictionary__lookup_program"
    ],
    "ask": [
      "mcp__data-dictionary__schema_stats",
      "mcp__data-dictionary__facility_stats",
      "mcp__data-dictionary__lookup_facility",
      "mcp__data-dictionary__table_facilities",
      "mcp__data-dictionary__facility_programs",
      "mcp__data-dictionary__program_stats",
      "mcp__data-dictionary__table_programs",
      "mcp__data-dictionary__program_facilities"
    ],
    "deny": []
  }
}

Tools that only read are allowed, tools that change things ask first, tools that delete or cancel are denied. It assumes the server is installed as data-dictionary. Review it before you use it.

Keep track

Get told when this server's tools change: a new tool, a new description, a new class.

https://anlyon.dev/servers/dev.rossdata/data-dictionary/changes.xml

An Atom feed. Works in any feed reader or Slack's RSS app.

Anlyon alternative

8 of these tools change something. Run those as governed actions.

Declare what an action changes, and Anlyon puts it under a shared limit, binds every approval to the exact request, and grades the outcome. It works on any HTTPS API you can describe as an action.

Anlyon does not run, proxy or govern this MCP server. A tool your own code calls directly is not routed through Anlyon and is not governed by it.

Import an OpenAPI spec →

Compare with other servers for the same product.

Source: MCP Registry. Synced Oct 21, 2026, 18:12 UTC.

For agents: Markdown · JSON · report this listing