{"id":"dev.rossdata/data-dictionary","slug":"dev-rossdata-data-dictionary","title":"Ross ERP Data Dictionary","description":"Structure-only reference for the vanilla Ross ERP 8.0 schema, UI menu tree, and program catalog.","version":"1.0.0","publisher":{"kind":"domain","id":"rossdata.dev","label":"rossdata.dev","url":"https://rossdata.dev"},"website":"https://rossdata.dev","repository":"","remotes":[{"type":"streamable-http","url":"https://mcp.rossdata.dev/mcp"}],"packages":[],"published":"2026-08-04","updated":"2026-08-04","status":"online","auth":"","latency_ms":964,"checked":"2026-11-19","uptime":100,"checks":3,"tools":[{"name":"schema_stats","title":"","description":"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.","read_only":false},{"name":"list_objects","title":"","description":"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.","read_only":false},{"name":"find_column","title":"","description":"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.","read_only":false},{"name":"lookup_table","title":"","description":"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.","read_only":false},{"name":"search_columns","title":"","description":"Search the Ross ERP 8.0 schema by name (and column descriptions). Returns matching objects and columns.","read_only":false},{"name":"search_all","title":"","description":"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.","read_only":false},{"name":"get_ddl","title":"","description":"Return the CREATE TABLE (DDL) for a Ross ERP 8.0 table, with column descriptions as comments plus primary-key and foreign-key constraints.","read_only":false},{"name":"graph_neighbors","title":"","description":"List the knowledge-graph neighbours of an object — the programs, tables, views and procedures directly connected to it, with relationship type and direction.","read_only":false},{"name":"path_between","title":"","description":"Find the shortest path between two objects in the Ross ERP 8.0 knowledge graph (how A reaches B through calls / references / accesses).","read_only":false},{"name":"facility_stats","title":"","description":"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.","read_only":false},{"name":"list_facilities","title":"","description":"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.","read_only":false},{"name":"search_facilities","title":"","description":"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'.","read_only":false},{"name":"lookup_facility","title":"","description":"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.","read_only":false},{"name":"table_facilities","title":"","description":"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?'.","read_only":false},{"name":"facility_programs","title":"","description":"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.","read_only":false},{"name":"program_stats","title":"","description":"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, ","read_only":false},{"name":"list_programs","title":"","description":"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.","read_only":false},{"name":"search_programs","title":"","description":"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'.","read_only":false},{"name":"lookup_program","title":"","description":"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 inv","read_only":false},{"name":"table_programs","title":"","description":"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.","read_only":false},{"name":"program_facilities","title":"","description":"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.","read_only":false}],"server_info":{"name":"rossdata.dev","version":"1.0.0"},"category":"web-search","tags":["design"],"kind":"remote","source":"registry","submitted":{},"first_party":true,"domain_rank":null,"score":100,"indexable":true,"first_seen":"2026-08-04","stars":0,"badges":[],"sponsor":null,"page":"https://agentsindex.org/agents/dev-rossdata-data-dictionary/"}