{"data":{"name":"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","websiteUrl":"https://rossdata.dev","repositoryUrl":null,"remotes":[{"url":"https://mcp.rossdata.dev/mcp","type":"streamable-http"}],"packages":[],"status":"active","isLatest":true,"publishedAt":"2026-08-04T08:37:16.990Z","updatedAt":"2026-08-04T08:37:16.990Z","source":"official-registry","verification":"official","confidence":100,"stars":null,"sources":[{"stars":null,"title":"Ross ERP Data Dictionary","source":"official-registry","sourceId":"dev.rossdata/data-dictionary","updatedAt":"2026-08-04T08:37:16.990Z","confidence":100,"websiteUrl":"https://rossdata.dev","description":"Structure-only reference for the vanilla Ross ERP 8.0 schema, UI menu tree, and program catalog.","verification":"official","repositoryUrl":null}],"toolIndex":{"tools":[{"serverName":"dev.rossdata/data-dictionary","endpointFingerprint":"56db3f5735c8f8a8d9cebe506d30e0072cd491ff28c3d3dcb34591502edcfa27","name":"facility_programs","title":null,"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.","inputSchema":{"type":"object","properties":{"code":{"type":"string","description":"Facility code, e.g. AP_A_002"}},"required":["code"],"additionalProperties":false},"annotations":null,"definitionHash":"2aa07cdeb3c94457743f593546dd854033ecb7fcd5493844d944382872892ec8","schemaStatus":"valid","origin":"official-registry","observedAt":"2026-11-17T22:46:01.632Z","metadataTrust":"untrusted"},{"serverName":"dev.rossdata/data-dictionary","endpointFingerprint":"56db3f5735c8f8a8d9cebe506d30e0072cd491ff28c3d3dcb34591502edcfa27","name":"facility_stats","title":null,"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.","inputSchema":{"type":"object","properties":{},"additionalProperties":false},"annotations":null,"definitionHash":"63d4fc09ab1b259543b821ffb3e857104a64c40bb40469fabff50c63be3bfa22","schemaStatus":"valid","origin":"official-registry","observedAt":"2026-11-17T22:46:01.632Z","metadataTrust":"untrusted"},{"serverName":"dev.rossdata/data-dictionary","endpointFingerprint":"56db3f5735c8f8a8d9cebe506d30e0072cd491ff28c3d3dcb34591502edcfa27","name":"find_column","title":null,"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.","inputSchema":{"type":"object","properties":{"name":{"type":"string","description":"Column name, e.g. POSTING_DATE or GL_ACCOUNT"}},"required":["name"],"additionalProperties":false},"annotations":null,"definitionHash":"5a2e3a2cfd1e7cf5d05a7b353a573f58503f714777cd6671932563c344ca31cb","schemaStatus":"valid","origin":"official-registry","observedAt":"2026-11-17T22:46:01.632Z","metadataTrust":"untrusted"},{"serverName":"dev.rossdata/data-dictionary","endpointFingerprint":"56db3f5735c8f8a8d9cebe506d30e0072cd491ff28c3d3dcb34591502edcfa27","name":"get_ddl","title":null,"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.","inputSchema":{"type":"object","properties":{"name":{"type":"string","description":"Table name, e.g. GL_ACCOUNTS"}},"required":["name"],"additionalProperties":false},"annotations":null,"definitionHash":"c3d063d5f75895c780dcda666ffb8d9d466a1a60e3f104d8fe537ca4dac6d489","schemaStatus":"valid","origin":"official-registry","observedAt":"2026-11-17T22:46:01.632Z","metadataTrust":"untrusted"},{"serverName":"dev.rossdata/data-dictionary","endpointFingerprint":"56db3f5735c8f8a8d9cebe506d30e0072cd491ff28c3d3dcb34591502edcfa27","name":"graph_neighbors","title":null,"description":"List the knowledge-graph neighbours of an object — the programs, tables, views and procedures directly connected to it, with relationship type and direction.","inputSchema":{"type":"object","properties":{"name":{"type":"string","description":"Object name, e.g. GL_ACCOUNTS"},"limit":{"type":"integer","minimum":1,"maximum":500,"description":"Max neighbours (default 100)"}},"required":["name"],"additionalProperties":false},"annotations":null,"definitionHash":"3977f1fd7c0716f5bdfe81f63192273fc0702aabf08474b4c2cffae01c075c69","schemaStatus":"valid","origin":"official-registry","observedAt":"2026-11-17T22:46:01.632Z","metadataTrust":"untrusted"},{"serverName":"dev.rossdata/data-dictionary","endpointFingerprint":"56db3f5735c8f8a8d9cebe506d30e0072cd491ff28c3d3dcb34591502edcfa27","name":"list_facilities","title":null,"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.","inputSchema":{"type":"object","properties":{"system":{"type":"string","description":"System filter, e.g. ACCOUNTS_PAYABLE or GENERAL_LEDGER"},"database":{"type":"string","description":"Database filter: FIN or MAN"},"class":{"type":"string","description":"Class filter: REPORT | MAINTENANCE | INQUIRY | UPDATE | TRANSACTION | ARCHIVE | CODES"},"q":{"type":"string","description":"Name or code substring, e.g. CHECK or AP_"},"withTables":{"type":"boolean","description":"Only facilities with a known table cluster (default false)"},"limit":{"type":"integer","minimum":1,"maximum":1000,"description":"Max facilities (default 100)"},"offset":{"type":"integer","minimum":0,"description":"Pagination offset (default 0)"}},"additionalProperties":false},"annotations":null,"definitionHash":"7fef7970b540b5c9b25e2e07cb1c0b6e908130667851d55dc84a3ec21a511638","schemaStatus":"valid","origin":"official-registry","observedAt":"2026-11-17T22:46:01.632Z","metadataTrust":"untrusted"},{"serverName":"dev.rossdata/data-dictionary","endpointFingerprint":"56db3f5735c8f8a8d9cebe506d30e0072cd491ff28c3d3dcb34591502edcfa27","name":"list_objects","title":null,"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.","inputSchema":{"type":"object","properties":{"type":{"type":"string","description":"Object type filter: table | view | procedure | function"},"db":{"type":"string","description":"Database filter, e.g. FIN or MAN"},"module":{"type":"string","description":"Module filter, e.g. GL or PO"},"q":{"type":"string","description":"Name substring filter, e.g. GL_"},"limit":{"type":"integer","minimum":1,"maximum":1000,"description":"Max objects (default 100)"},"offset":{"type":"integer","minimum":0,"description":"Pagination offset (default 0)"}},"additionalProperties":false},"annotations":null,"definitionHash":"0e07c254dfdaa1e8e5de301442684eb7cb6405027f33ca4a2ea82017fd1faacc","schemaStatus":"valid","origin":"official-registry","observedAt":"2026-11-17T22:46:01.632Z","metadataTrust":"untrusted"},{"serverName":"dev.rossdata/data-dictionary","endpointFingerprint":"56db3f5735c8f8a8d9cebe506d30e0072cd491ff28c3d3dcb34591502edcfa27","name":"list_programs","title":null,"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.","inputSchema":{"type":"object","properties":{"module":{"type":"string","description":"Module filter, e.g. ap, gl, ic, sop"},"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"},"titled":{"type":"boolean","description":"Only programs that declare a TITLE program-id (default false)"},"q":{"type":"string","description":"Substring of basename or title, e.g. check_register"},"limit":{"type":"integer","minimum":1,"maximum":1000,"description":"Max programs (default 100)"},"offset":{"type":"integer","minimum":0,"description":"Pagination offset (default 0)"}},"additionalProperties":false},"annotations":null,"definitionHash":"be33095c31ed6f033875f206d677fa0c5531c9d8b558599cb957b6fae6675efc","schemaStatus":"valid","origin":"official-registry","observedAt":"2026-11-17T22:46:01.632Z","metadataTrust":"untrusted"},{"serverName":"dev.rossdata/data-dictionary","endpointFingerprint":"56db3f5735c8f8a8d9cebe506d30e0072cd491ff28c3d3dcb34591502edcfa27","name":"lookup_facility","title":null,"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.","inputSchema":{"type":"object","properties":{"code":{"type":"string","description":"Facility code, e.g. AP_A_002"}},"required":["code"],"additionalProperties":false},"annotations":null,"definitionHash":"d0ce6b9b984940030896d649a6deefa700436a805641cab7b3c9fdb9c2913ed1","schemaStatus":"valid","origin":"official-registry","observedAt":"2026-11-17T22:46:01.632Z","metadataTrust":"untrusted"},{"serverName":"dev.rossdata/data-dictionary","endpointFingerprint":"56db3f5735c8f8a8d9cebe506d30e0072cd491ff28c3d3dcb34591502edcfa27","name":"lookup_program","title":null,"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 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.","inputSchema":{"type":"object","properties":{"id":{"type":"string","description":"Program id or basename, e.g. AP_A_002 or ap_a_check_register"}},"required":["id"],"additionalProperties":false},"annotations":null,"definitionHash":"67abec12691138c12cd624c62150a6da049ffbaf489436dbd22a5db901085a22","schemaStatus":"valid","origin":"official-registry","observedAt":"2026-11-17T22:46:01.632Z","metadataTrust":"untrusted"},{"serverName":"dev.rossdata/data-dictionary","endpointFingerprint":"56db3f5735c8f8a8d9cebe506d30e0072cd491ff28c3d3dcb34591502edcfa27","name":"lookup_table","title":null,"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.","inputSchema":{"type":"object","properties":{"name":{"type":"string","description":"Object name, e.g. GL_ACCOUNTS or ACCOUNT_TYPES"}},"required":["name"],"additionalProperties":false},"annotations":null,"definitionHash":"21ec6b654ac4b231be92fbdc23e27f5898b7b78f1bc43c37df2158c709bfb0d4","schemaStatus":"valid","origin":"official-registry","observedAt":"2026-11-17T22:46:01.632Z","metadataTrust":"untrusted"},{"serverName":"dev.rossdata/data-dictionary","endpointFingerprint":"56db3f5735c8f8a8d9cebe506d30e0072cd491ff28c3d3dcb34591502edcfa27","name":"path_between","title":null,"description":"Find the shortest path between two objects in the Ross ERP 8.0 knowledge graph (how A reaches B through calls / references / accesses).","inputSchema":{"type":"object","properties":{"from":{"type":"string","description":"Start object name"},"to":{"type":"string","description":"Destination object name"}},"required":["from","to"],"additionalProperties":false},"annotations":null,"definitionHash":"53685a1615d2b629bf3864d0316086b2da524bbe1978aab4344da7dfe857bd62","schemaStatus":"valid","origin":"official-registry","observedAt":"2026-11-17T22:46:01.632Z","metadataTrust":"untrusted"},{"serverName":"dev.rossdata/data-dictionary","endpointFingerprint":"56db3f5735c8f8a8d9cebe506d30e0072cd491ff28c3d3dcb34591502edcfa27","name":"program_facilities","title":null,"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.","inputSchema":{"type":"object","properties":{"id":{"type":"string","description":"Program id or basename, e.g. AP_I_001 or ap_i_vendors"}},"required":["id"],"additionalProperties":false},"annotations":null,"definitionHash":"2a73b1ff20d57091b401430bb6d5299e01babf89cbec4a200fe97cebfefb4c51","schemaStatus":"valid","origin":"official-registry","observedAt":"2026-11-17T22:46:01.632Z","metadataTrust":"untrusted"},{"serverName":"dev.rossdata/data-dictionary","endpointFingerprint":"56db3f5735c8f8a8d9cebe506d30e0072cd491ff28c3d3dcb34591502edcfa27","name":"program_stats","title":null,"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, total call edges) and how many back a menu facility, plus the module and type breakdowns. Use this first to orient before browsing programs.","inputSchema":{"type":"object","properties":{},"additionalProperties":false},"annotations":null,"definitionHash":"c34649f2d990864064521fe7fcaba2589531662695478703a06162d04ecd7aea","schemaStatus":"valid","origin":"official-registry","observedAt":"2026-11-17T22:46:01.632Z","metadataTrust":"untrusted"},{"serverName":"dev.rossdata/data-dictionary","endpointFingerprint":"56db3f5735c8f8a8d9cebe506d30e0072cd491ff28c3d3dcb34591502edcfa27","name":"schema_stats","title":null,"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.","inputSchema":{"type":"object","properties":{},"additionalProperties":false},"annotations":null,"definitionHash":"8f329ccf880fb71964e4284aa95b050a204f1568905771359930a4a71a4fb90d","schemaStatus":"valid","origin":"official-registry","observedAt":"2026-11-17T22:46:01.632Z","metadataTrust":"untrusted"},{"serverName":"dev.rossdata/data-dictionary","endpointFingerprint":"56db3f5735c8f8a8d9cebe506d30e0072cd491ff28c3d3dcb34591502edcfa27","name":"search_all","title":null,"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.","inputSchema":{"type":"object","properties":{"query":{"type":"string","description":"Search text, e.g. check register or posting_date"},"type":{"type":"string","enum":["all","object","column","facility","program"],"description":"Restrict to one domain (default all). 'table' is accepted as an alias for object."},"limit":{"type":"integer","minimum":1,"maximum":100,"description":"Max results per domain (default 25)"}},"required":["query"],"additionalProperties":false},"annotations":null,"definitionHash":"6a3e5677190d5f6251a7fce7fe97fbfcb8cc7051ec6e1a69d9f85ba28b844daa","schemaStatus":"valid","origin":"official-registry","observedAt":"2026-11-17T22:46:01.632Z","metadataTrust":"untrusted"},{"serverName":"dev.rossdata/data-dictionary","endpointFingerprint":"56db3f5735c8f8a8d9cebe506d30e0072cd491ff28c3d3dcb34591502edcfa27","name":"search_columns","title":null,"description":"Search the Ross ERP 8.0 schema by name (and column descriptions). Returns matching objects and columns.","inputSchema":{"type":"object","properties":{"query":{"type":"string","description":"Search text, e.g. posting_date or GL_ACCOUNTS"},"limit":{"type":"integer","minimum":1,"maximum":100,"description":"Max results per group (default 25)"}},"required":["query"],"additionalProperties":false},"annotations":null,"definitionHash":"3a31458dff5e51674a058cc2238096a06335809e5619ae4a8217dc11981c6c7d","schemaStatus":"valid","origin":"official-registry","observedAt":"2026-11-17T22:46:01.632Z","metadataTrust":"untrusted"},{"serverName":"dev.rossdata/data-dictionary","endpointFingerprint":"56db3f5735c8f8a8d9cebe506d30e0072cd491ff28c3d3dcb34591502edcfa27","name":"search_facilities","title":null,"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'.","inputSchema":{"type":"object","properties":{"query":{"type":"string","description":"Search text, e.g. check register or AP_A"},"limit":{"type":"integer","minimum":1,"maximum":100,"description":"Max results (default 25)"}},"required":["query"],"additionalProperties":false},"annotations":null,"definitionHash":"d9326b1cff348c87d07e06c96d813fe7b9e22862ff6fc1a0e930fc54ea9f5a38","schemaStatus":"valid","origin":"official-registry","observedAt":"2026-11-17T22:46:01.632Z","metadataTrust":"untrusted"},{"serverName":"dev.rossdata/data-dictionary","endpointFingerprint":"56db3f5735c8f8a8d9cebe506d30e0072cd491ff28c3d3dcb34591502edcfa27","name":"search_programs","title":null,"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'.","inputSchema":{"type":"object","properties":{"query":{"type":"string","description":"Search text, e.g. check register or AP_A_002"},"limit":{"type":"integer","minimum":1,"maximum":100,"description":"Max results (default 25)"}},"required":["query"],"additionalProperties":false},"annotations":null,"definitionHash":"a840bf387f6710c69ce3c72ef314ab5efd5c68db730b9c0cabf400a9c5ea91fc","schemaStatus":"valid","origin":"official-registry","observedAt":"2026-11-17T22:46:01.632Z","metadataTrust":"untrusted"},{"serverName":"dev.rossdata/data-dictionary","endpointFingerprint":"56db3f5735c8f8a8d9cebe506d30e0072cd491ff28c3d3dcb34591502edcfa27","name":"table_facilities","title":null,"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?'.","inputSchema":{"type":"object","properties":{"table":{"type":"string","description":"Table name, e.g. GL_ACCOUNTS"}},"required":["table"],"additionalProperties":false},"annotations":null,"definitionHash":"518b338df3aabd56f1438591e80edb86043946a2a64880835fc50f6bfa9c3b79","schemaStatus":"valid","origin":"official-registry","observedAt":"2026-11-17T22:46:01.632Z","metadataTrust":"untrusted"},{"serverName":"dev.rossdata/data-dictionary","endpointFingerprint":"56db3f5735c8f8a8d9cebe506d30e0072cd491ff28c3d3dcb34591502edcfa27","name":"table_programs","title":null,"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.","inputSchema":{"type":"object","properties":{"table":{"type":"string","description":"Table name, e.g. GL_ACCOUNTS"}},"required":["table"],"additionalProperties":false},"annotations":null,"definitionHash":"8b3525b9e4498aef85ec231546688c115b724dd893c8a7cdae4acbcfdf02b456","schemaStatus":"valid","origin":"official-registry","observedAt":"2026-11-17T22:46:01.632Z","metadataTrust":"untrusted"}],"endpoints":[{"endpointFingerprint":"56db3f5735c8f8a8d9cebe506d30e0072cd491ff28c3d3dcb34591502edcfa27","protocol":"streamable-http","status":"indexed","toolCount":21,"observedAt":"2026-11-17T22:46:01.632Z"}],"authentication":"unknown"},"connectionConfigurations":{"status":"ready","authentication":"not embedded","clients":{"Claude Desktop":{"mcpServers":{"dev.rossdata/data-dictionary":{"url":"https://mcp.rossdata.dev/mcp"}}},"Cursor":{"mcpServers":{"dev.rossdata/data-dictionary":{"url":"https://mcp.rossdata.dev/mcp"}}},"VS Code":{"servers":{"dev.rossdata/data-dictionary":{"type":"http","url":"https://mcp.rossdata.dev/mcp"}}}}},"resourceType":"mcp-server","callable":true,"runtime":{"callable":true,"protocols":["mcp"]},"interfaces":[{"protocol":"mcp","transport":"streamable-http","url":"https://mcp.rossdata.dev/mcp"}],"profile":{"apiVersion":"1","schemaVersion":"1","id":"mcp-server:dev.rossdata%2Fdata-dictionary","resourceType":"mcp-server","canonicalUrl":"https://www.agentsjunction.com/api/v1/servers/dev.rossdata%2Fdata-dictionary","name":"dev.rossdata/data-dictionary","description":"Structure-only reference for the vanilla Ross ERP 8.0 schema, UI menu tree, and program catalog.","interfaces":[{"protocol":"mcp","transport":"streamable-http","url":"https://mcp.rossdata.dev/mcp"}],"capabilities":[],"identity":{"source":"official-registry","websiteUrl":"https://rossdata.dev","repositoryUrl":null,"version":"1.0.0"},"verification":{"state":"official","confidence":100},"operations":{"resourceType":"mcp-server","name":"dev.rossdata/data-dictionary","status":"online","lastCheckedAt":"2026-11-20T08:18:24.231Z","lastSuccessfulCheck":"2026-11-20T08:18:24.231Z","latencyMs":116,"consecutiveFailures":0,"isStale":false,"checks":{"endpointReachable":true,"protocolValid":true,"agentCardValid":null,"mcpHandshakeValid":true},"lastSeen":null,"lastSuccessfulInteraction":null,"lastHealthCheck":"2026-11-20T08:18:24.231Z","source":{"type":"health-check","url":null},"observedAt":"2026-11-20T08:18:24.231Z"},"security":null,"timestamps":{"createdAt":"2026-08-04T08:37:16.990Z","updatedAt":"2026-08-04T08:37:16.990Z","observedAt":"2026-11-20T08:18:24.231Z"},"compatibility":{"serverVersion":"1.0.0","protocolVersions":[{"protocol":"mcp","version":null}]}}}}