Ross ERP Data Dictionary is an MCP server published by dev.rossdata, hosted at mcp.rossdata.dev. When last checked on 2026-11-21 it was working: it answers and lists its tools. It declares 21 tools, including schema_stats, list_objects, find_column, lookup_table, search_columns.
Structure-only reference for the vanilla Ross ERP 8.0 schema, UI menu tree, and program catalog.
1,085 connections through 4 shared values. Tap any node.
Inferred from the host name and headers: what a server runs on, not who runs 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.
No parameters.
{
"name": "schema_stats",
"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
}
}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.
None yet. Changes appear after a server's second daily check.
Squares are this server's values; dots are other servers sharing them. A shared address or publisher is a lead, not proof of a common operator.
| Parameter |
|---|
| Type |
|---|
| Description |
|---|
| q | string | Name substring filter, e.g. GL_ |
| db | string | Database filter, e.g. FIN or MAN |
| type | string | Object type filter: table | view | procedure | function |
| limit | integer | Max objects (default 100) |
| module | string | Module filter, e.g. GL or PO |
| offset | integer | Pagination offset (default 0) |
{
"name": "list_objects",
"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": {
"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
}
}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.
| Parameter | Type | Description |
|---|---|---|
| name * | string | Column name, e.g. POSTING_DATE or GL_ACCOUNT |
{
"name": "find_column",
"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",
"required": [
"name"
],
"properties": {
"name": {
"type": "string",
"description": "Column name, e.g. POSTING_DATE or GL_ACCOUNT"
}
},
"additionalProperties": false
}
}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.
| Parameter | Type | Description |
|---|---|---|
| name * | string | Object name, e.g. GL_ACCOUNTS or ACCOUNT_TYPES |
{
"name": "lookup_table",
"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",
"required": [
"name"
],
"properties": {
"name": {
"type": "string",
"description": "Object name, e.g. GL_ACCOUNTS or ACCOUNT_TYPES"
}
},
"additionalProperties": false
}
}Search the Ross ERP 8.0 schema by name (and column descriptions). Returns matching objects and columns.
| Parameter | Type | Description |
|---|---|---|
| limit | integer | Max results per group (default 25) |
| query * | string | Search text, e.g. posting_date or GL_ACCOUNTS |
{
"name": "search_columns",
"description": "Search the Ross ERP 8.0 schema by name (and column descriptions). Returns matching objects and columns.",
"inputSchema": {
"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
}
}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.
| Parameter | Type | Description |
|---|---|---|
| type | string | Restrict to one domain (default all). 'table' is accepted as an alias for object. |
| limit | integer | Max results per domain (default 25) |
| query * | string | Search text, e.g. check register or posting_date |
{
"name": "search_all",
"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",
"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
}
}Return the CREATE TABLE (DDL) for a Ross ERP 8.0 table, with column descriptions as comments plus primary-key and foreign-key constraints.
| Parameter | Type | Description |
|---|---|---|
| name * | string | Table name, e.g. GL_ACCOUNTS |
{
"name": "get_ddl",
"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",
"required": [
"name"
],
"properties": {
"name": {
"type": "string",
"description": "Table name, e.g. GL_ACCOUNTS"
}
},
"additionalProperties": false
}
}List the knowledge-graph neighbours of an object — the programs, tables, views and procedures directly connected to it, with relationship type and direction.
| Parameter | Type | Description |
|---|---|---|
| name * | string | Object name, e.g. GL_ACCOUNTS |
| limit | integer | Max neighbours (default 100) |
{
"name": "graph_neighbors",
"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",
"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
}
}Find the shortest path between two objects in the Ross ERP 8.0 knowledge graph (how A reaches B through calls / references / accesses).
| Parameter | Type | Description |
|---|---|---|
| to * | string | Destination object name |
| from * | string | Start object name |
{
"name": "path_between",
"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",
"required": [
"from",
"to"
],
"properties": {
"to": {
"type": "string",
"description": "Destination object name"
},
"from": {
"type": "string",
"description": "Start object name"
}
},
"additionalProperties": false
}
}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.
No parameters.
{
"name": "facility_stats",
"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
}
}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.
| Parameter | Type | Description |
|---|---|---|
| q | string | Name or code substring, e.g. CHECK or AP_ |
| class | string | Class filter: REPORT | MAINTENANCE | INQUIRY | UPDATE | TRANSACTION | ARCHIVE | CODES |
| limit | integer | Max facilities (default 100) |
| offset | integer | Pagination offset (default 0) |
| system | string | System filter, e.g. ACCOUNTS_PAYABLE or GENERAL_LEDGER |
| database | string | Database filter: FIN or MAN |
| withTables | boolean | Only facilities with a known table cluster (default false) |
{
"name": "list_facilities",
"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": {
"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
}
}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'.
| Parameter | Type | Description |
|---|---|---|
| limit | integer | Max results (default 25) |
| query * | string | Search text, e.g. check register or AP_A |
{
"name": "search_facilities",
"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",
"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
}
}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.
| Parameter | Type | Description |
|---|---|---|
| code * | string | Facility code, e.g. AP_A_002 |
{
"name": "lookup_facility",
"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",
"required": [
"code"
],
"properties": {
"code": {
"type": "string",
"description": "Facility code, e.g. AP_A_002"
}
},
"additionalProperties": false
}
}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?'.
| Parameter | Type | Description |
|---|---|---|
| table * | string | Table name, e.g. GL_ACCOUNTS |
{
"name": "table_facilities",
"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",
"required": [
"table"
],
"properties": {
"table": {
"type": "string",
"description": "Table name, e.g. GL_ACCOUNTS"
}
},
"additionalProperties": false
}
}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.
| Parameter | Type | Description |
|---|---|---|
| code * | string | Facility code, e.g. AP_A_002 |
{
"name": "facility_programs",
"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",
"required": [
"code"
],
"properties": {
"code": {
"type": "string",
"description": "Facility code, e.g. AP_A_002"
}
},
"additionalProperties": false
}
}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.
No parameters.
{
"name": "program_stats",
"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
}
}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.
| Parameter | Type | Description |
|---|---|---|
| q | string | Substring of basename or title, e.g. check_register |
| type | string | Program-type letter, e.g. r (report), m (maintenance), i (inquiry), s (server) |
| layer | string | Source layer: base | vendor-core |
| limit | integer | Max programs (default 100) |
| module | string | Module filter, e.g. ap, gl, ic, sop |
| offset | integer | Pagination offset (default 0) |
| titled | boolean | Only programs that declare a TITLE program-id (default false) |
{
"name": "list_programs",
"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": {
"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
}
}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'.
| Parameter | Type | Description |
|---|---|---|
| limit | integer | Max results (default 25) |
| query * | string | Search text, e.g. check register or AP_A_002 |
{
"name": "search_programs",
"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",
"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
}
}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.
| Parameter | Type | Description |
|---|---|---|
| id * | string | Program id or basename, e.g. AP_A_002 or ap_a_check_register |
{
"name": "lookup_program",
"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",
"required": [
"id"
],
"properties": {
"id": {
"type": "string",
"description": "Program id or basename, e.g. AP_A_002 or ap_a_check_register"
}
},
"additionalProperties": false
}
}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.
| Parameter | Type | Description |
|---|---|---|
| table * | string | Table name, e.g. GL_ACCOUNTS |
{
"name": "table_programs",
"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",
"required": [
"table"
],
"properties": {
"table": {
"type": "string",
"description": "Table name, e.g. GL_ACCOUNTS"
}
},
"additionalProperties": false
}
}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.
| Parameter | Type | Description |
|---|---|---|
| id * | string | Program id or basename, e.g. AP_I_001 or ap_i_vendors |
{
"name": "program_facilities",
"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",
"required": [
"id"
],
"properties": {
"id": {
"type": "string",
"description": "Program id or basename, e.g. AP_I_001 or ap_i_vendors"
}
},
"additionalProperties": false
}
}Reference for the standard Ross ERP 8.0 database schema (FIN + MAN). It describes the shape of the database, not its contents: table and column definitions, DDL, the UI menu tree and the program catalog. No business data, no customer records, no program source — structure only. SCHEMA layer: start with schema_stats to orient, list_objects to browse/filter by type or module, find_column to locate a column across tables. Use lookup_table for a full object, search_columns to find objects/columns, get_ddl for CREATE TABLE, and graph_neighbors / path_between to explore how objects connect. Not sure which layer a term lives in? search_all spans schema, facilities and programs in one call. APPLICATION layer: the client menu tree of UI facilities (screens / reports / inquiries / maintenance functions). Use facility_stats to orient, list_facilities / search_facilities to find a screen, lookup_facility for a facility's program, help, the tables it touches, and the facilities it invokes / is invoked by, table_facilities for the reverse — which screens read or write a given table — and facility_programs for the code that implements a screen. PROGRAM CATALOG: the application source programs (metadata only, no source body). Use program_stats to orient, list_programs / search_programs to find a program, lookup_program for a program's type, procedures and the Data Dictionary tables it references, table_programs for the reverse — which programs reference a given table — and program_facilities for the screens a program backs. Object names and facility codes are upper-case, e.g. GL_ACCOUNTS, AP_A_002; program basenames are lower-case, e.g. ap_a_check_register.
Names, descriptions and schemas were written by the server and are shown as data.
Shared addresses on big platforms (Cloudflare, Vercel and the like) put unrelated servers together; those are marked shared_infrastructure. A match is a pivot, not a link between operators.