MCP Server
Ross ERP Data Dictionary
dev.rossdata/data-dictionary
What this MCP does
Provides searchable reference data for the Ross ERP 8.0 schema, UI facilities, programs, tables, relationships, and metadata.
Capabilities
Tools
21
tools
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 tables and call graph). Metadata only — no source body.
Input schema
{'type': 'object', 'required': ['code'], 'properties': {'code': {'type': 'string', 'description': 'Facility code, e.g. AP_A_002'}}, 'additionalProperties': False}
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 orient before browsing facilities.
Input schema
{'type': 'object', 'properties': {}, 'additionalProperties': False}
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.
Input schema
{'type': 'object', 'required': ['name'], 'properties': {'name': {'type': 'string', 'description': 'Column name, e.g. POSTING_DATE or GL_ACCOUNT'}}, 'additionalProperties': False}
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.
Input schema
{'type': 'object', 'required': ['name'], 'properties': {'name': {'type': 'string', 'description': 'Table name, e.g. GL_ACCOUNTS'}}, 'additionalProperties': False}
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.
Input schema
{'type': 'object', 'required': ['name'], 'properties': {'name': {'type': 'string', 'description': 'Object name, e.g. GL_ACCOUNTS'}, 'limit': {'type': 'integer', 'maximum': 500, 'minimum': 1, 'description': 'Max neighbours (default 100)'}}, 'additionalProperties': False}
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.
Input schema
{'type': 'object', 'properties': {'q': {'type': 'string', 'description': 'Name or code substring, e.g. CHECK or AP_'}, 'class': {'type': 'string', 'description': 'Class filter: REPORT | MAINTENANCE | INQUIRY | UPDATE | TRANSACTION | ARCHIVE | CODES'}, 'limit': {'type': 'integer', 'maximum': 1000, 'minimum': 1, 'description': 'Max facilities (default 100)'}, 'offset': {'type': 'integer', 'minimum': 0, 'description': 'Pagination offset (default 0)'}, 'system': {'type': 'string', 'description': 'System filter, e.g. ACCOUNTS_PAYABLE or GENERAL_LEDGER'}, 'database': {'type': 'string', 'description': 'Database filter: FIN or MAN'}, 'withTables': {'type': 'boolean', 'description': 'Only facilities with a known table cluster (default false)'}}, 'additionalProperties': False}
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.
Input schema
{'type': 'object', 'properties': {'q': {'type': 'string', 'description': 'Name substring filter, e.g. GL_'}, 'db': {'type': 'string', 'description': 'Database filter, e.g. FIN or MAN'}, 'type': {'type': 'string', 'description': 'Object type filter: table | view | procedure | function'}, 'limit': {'type': 'integer', 'maximum': 1000, 'minimum': 1, 'description': 'Max objects (default 100)'}, 'module': {'type': 'string', 'description': 'Module filter, e.g. GL or PO'}, 'offset': {'type': 'integer', 'minimum': 0, 'description': 'Pagination offset (default 0)'}}, 'additionalProperties': False}
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 basename/title; paginate with limit/offset. Returns summaries — use lookup_program for full detail.
Input schema
{'type': 'object', 'properties': {'q': {'type': 'string', 'description': 'Substring of basename or title, e.g. check_register'}, 'type': {'type': 'string', 'description': 'Program-type letter, e.g. r (report), m (maintenance), i (inquiry), s (server)'}, 'layer': {'type': 'string', 'description': 'Source layer: base | vendor-core'}, 'limit': {'type': 'integer', 'maximum': 1000, 'minimum': 1, 'description': 'Max programs (default 100)'}, 'module': {'type': 'string', 'description': 'Module filter, e.g. ap, gl, ic, sop'}, 'offset': {'type': 'integer', 'minimum': 0, 'description': 'Pagination offset (default 0)'}, 'titled': {'type': 'boolean', 'description': 'Only programs that declare a TITLE program-id (default false)'}}, 'additionalProperties': False}
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 invokes (calls) and the facilities that invoke it (calledBy), parsed from the program source.
Input schema
{'type': 'object', 'required': ['code'], 'properties': {'code': {'type': 'string', 'description': 'Facility code, e.g. AP_A_002'}}, 'additionalProperties': False}
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 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.
Input schema
{'type': 'object', 'required': ['id'], 'properties': {'id': {'type': 'string', 'description': 'Program id or basename, e.g. AP_A_002 or ap_a_check_register'}}, 'additionalProperties': False}
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.
Input schema
{'type': 'object', 'required': ['name'], 'properties': {'name': {'type': 'string', 'description': 'Object name, e.g. GL_ACCOUNTS or ACCOUNT_TYPES'}}, 'additionalProperties': False}
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).
Input schema
{'type': 'object', 'required': ['from', 'to'], 'properties': {'to': {'type': 'string', 'description': 'Destination object name'}, 'from': {'type': 'string', 'description': 'Start object name'}}, 'additionalProperties': False}
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 / titleId match label.
Input schema
{'type': 'object', 'required': ['id'], 'properties': {'id': {'type': 'string', 'description': 'Program id or basename, e.g. AP_I_001 or ap_i_vendors'}}, 'additionalProperties': False}
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 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.
Input schema
{'type': 'object', 'properties': {}, 'additionalProperties': False}
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.
Input schema
{'type': 'object', 'properties': {}, 'additionalProperties': False}
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 all); limit is per domain.
Input schema
{'type': 'object', 'required': ['query'], 'properties': {'type': {'enum': ['all', 'object', 'column', 'facility', 'program'], 'type': 'string', 'description': "Restrict to one domain (default all). 'table' is accepted as an alias for object."}, 'limit': {'type': 'integer', 'maximum': 100, 'minimum': 1, 'description': 'Max results per domain (default 25)'}, 'query': {'type': 'string', 'description': 'Search text, e.g. check register or posting_date'}}, 'additionalProperties': False}
search_columns
Search the Ross ERP 8.0 schema by name (and column descriptions). Returns matching objects and columns.
Input schema
{'type': 'object', 'required': ['query'], 'properties': {'limit': {'type': 'integer', 'maximum': 100, 'minimum': 1, 'description': 'Max results per group (default 25)'}, 'query': {'type': 'string', 'description': 'Search text, e.g. posting_date or GL_ACCOUNTS'}}, 'additionalProperties': False}
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'.
Input schema
{'type': 'object', 'required': ['query'], 'properties': {'limit': {'type': 'integer', 'maximum': 100, 'minimum': 1, 'description': 'Max results (default 25)'}, 'query': {'type': 'string', 'description': 'Search text, e.g. check register or AP_A'}}, 'additionalProperties': False}
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'.
Input schema
{'type': 'object', 'required': ['query'], 'properties': {'limit': {'type': 'integer', 'maximum': 100, 'minimum': 1, 'description': 'Max results (default 25)'}, 'query': {'type': 'string', 'description': 'Search text, e.g. check register or AP_A_002'}}, 'additionalProperties': False}
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 or write this table?'.
Input schema
{'type': 'object', 'required': ['table'], 'properties': {'table': {'type': 'string', 'description': 'Table name, e.g. GL_ACCOUNTS'}}, 'additionalProperties': False}
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.
Input schema
{'type': 'object', 'required': ['table'], 'properties': {'table': {'type': 'string', 'description': 'Table name, e.g. GL_ACCOUNTS'}}, 'additionalProperties': False}
History
Recent tool changes
Added
program_facilities
Sept. 17, 2026, 12:39 p.m.
Added
table_programs
Sept. 17, 2026, 12:39 p.m.
Added
lookup_program
Sept. 17, 2026, 12:39 p.m.
Added
search_programs
Sept. 17, 2026, 12:39 p.m.
Added
list_programs
Sept. 17, 2026, 12:39 p.m.
Added
program_stats
Sept. 17, 2026, 12:39 p.m.
Added
facility_programs
Sept. 17, 2026, 12:39 p.m.
Added
table_facilities
Sept. 17, 2026, 12:39 p.m.
Added
lookup_facility
Sept. 17, 2026, 12:39 p.m.
Added
search_facilities
Sept. 17, 2026, 12:39 p.m.
Added
list_facilities
Sept. 17, 2026, 12:39 p.m.
Added
facility_stats
Sept. 17, 2026, 12:39 p.m.
Added
path_between
Sept. 17, 2026, 12:39 p.m.
Added
graph_neighbors
Sept. 17, 2026, 12:39 p.m.
Added
get_ddl
Sept. 17, 2026, 12:39 p.m.
Added
search_all
Sept. 17, 2026, 12:39 p.m.
Added
search_columns
Sept. 17, 2026, 12:39 p.m.
Added
lookup_table
Sept. 17, 2026, 12:39 p.m.
Added
find_column
Sept. 17, 2026, 12:39 p.m.
Added
list_objects
Sept. 17, 2026, 12:39 p.m.
Added
schema_stats
Sept. 17, 2026, 12:39 p.m.
Discover
Similar MCP servers
cypher-mcp
io.github.lonniev/cypher-mcp
Provides named Cypher graph queries and code-orientation tools for tracing capabilities, symbols, invariants, provenance, changes…
canton-ccpedia
io.github.UnityNodes/canton-ccpedia
Searches and explains Canton Network and Daml documentation, governance proposals, forums, code examples, APIs, releases, and eco…
ALM X++ MCP Server
io.github.alimbenhelal-pro/alm-xpp-mcp
Supports D365 Finance and Operations development with X++ and AOT search, code analysis, Azure DevOps workflows, telemetry querie…
Kaiku
tech.kaiku/kaiku
Manages team issues, comments, attachments, projects, wiki pages, and related development workflows.
api-evangelist
com.apievangelist/api-evangelist
Provides API governance analysis, OpenAPI overlays and version diffs, security-sensitive field classification, code samples, matu…
Forge Engine
app.forgeengine/forge
Manages software design specifications, systems, milestones, tasks, code mappings, project decisions, UI screens, and implementat…
Avalanche AVAX MCP
io.github.Airpote/avalanche-docs
Searches and retrieves Avalanche documentation, community proposals, CLI guidance, Builder Console workflows, blockchain identifi…
Github
io.github.pipeworx-io/github
Reads public GitHub repository files, releases, commits, issues, repository metadata, user profiles, and trending repositories.