Server definition

Hash: sha256:7b8b5068d66ab9f1afb11f62274cb841d2ff210fc00ddb129717b1689d4af0a5
What it is: What a remote MCP server returned when asked what it offers: 21 tools

The blob, as servednamed by its sha256

{
  "instructions": "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.",
  "tools": [
    {
      "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": {
        "additionalProperties": false,
        "properties": {
          "code": {
            "description": "Facility code, e.g. AP_A_002",
            "type": "string"
          }
        },
        "required": [
          "code"
        ],
        "type": "object"
      },
      "name": "facility_programs",
      "outputSchema": 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": {
        "additionalProperties": false,
        "properties": {},
        "type": "object"
      },
      "name": "facility_stats",
      "outputSchema": 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": {
        "additionalProperties": false,
        "properties": {
          "name": {
            "description": "Column name, e.g. POSTING_DATE or GL_ACCOUNT",
            "type": "string"
          }
        },
        "required": [
          "name"
        ],
        "type": "object"
      },
      "name": "find_column",
      "outputSchema": 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": {
        "additionalProperties": false,
        "properties": {
          "name": {
            "description": "Table name, e.g. GL_ACCOUNTS",
            "type": "string"
          }
        },
        "required": [
          "name"
        ],
        "type": "object"
      },
      "name": "get_ddl",
      "outputSchema": 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": {
        "additionalProperties": false,
        "properties": {
          "limit": {
            "description": "Max neighbours (default 100)",
            "maximum": 500,
            "minimum": 1,
            "type": "integer"
          },
          "name": {
            "description": "Object name, e.g. GL_ACCOUNTS",
            "type": "string"
          }
        },
        "required": [
          "name"
        ],
        "type": "object"
      },
      "name": "graph_neighbors",
      "outputSchema": 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": {
        "additionalProperties": false,
        "properties": {
          "class": {
            "description": "Class filter: REPORT | MAINTENANCE | INQUIRY | UPDATE | TRANSACTION | ARCHIVE | CODES",
            "type": "string"
          },
          "database": {
            "description": "Database filter: FIN or MAN",
            "type": "string"
          },
          "limit": {
            "description": "Max facilities (default 100)",
            "maximum": 1000,
            "minimum": 1,
            "type": "integer"
          },
          "offset": {
            "description": "Pagination offset (default 0)",
            "minimum": 0,
            "type": "integer"
          },
          "q": {
            "description": "Name or code substring, e.g. CHECK or AP_",
            "type": "string"
          },
          "system": {
            "description": "System filter, e.g. ACCOUNTS_PAYABLE or GENERAL_LEDGER",
            "type": "string"
          },
          "withTables": {
            "description": "Only facilities with a known table cluster (default false)",
            "type": "boolean"
          }
        },
        "type": "object"
      },
      "name": "list_facilities",
      "outputSchema": 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": {
        "additionalProperties": false,
        "properties": {
          "db": {
            "description": "Database filter, e.g. FIN or MAN",
            "type": "string"
          },
          "limit": {
            "description": "Max objects (default 100)",
            "maximum": 1000,
            "minimum": 1,
            "type": "integer"
          },
          "module": {
            "description": "Module filter, e.g. GL or PO",
            "type": "string"
          },
          "offset": {
            "description": "Pagination offset (default 0)",
            "minimum": 0,
            "type": "integer"
          },
          "q": {
            "description": "Name substring filter, e.g. GL_",
            "type": "string"
          },
          "type": {
            "description": "Object type filter: table | view | procedure | function",
            "type": "string"
          }
        },
        "type": "object"
      },
      "name": "list_objects",
      "outputSchema": 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": {
        "additionalProperties": false,
        "properties": {
          "layer": {
            "description": "Source layer: base | vendor-core",
            "type": "string"
          },
          "limit": {
            "description": "Max programs (default 100)",
            "maximum": 1000,
            "minimum": 1,
            "type": "integer"
          },
          "module": {
            "description": "Module filter, e.g. ap, gl, ic, sop",
            "type": "string"
          },
          "offset": {
            "description": "Pagination offset (default 0)",
            "minimum": 0,
            "type": "integer"
          },
          "q": {
            "description": "Substring of basename or title, e.g. check_register",
            "type": "string"
          },
          "titled": {
            "description": "Only programs that declare a TITLE program-id (default false)",
            "type": "boolean"
          },
          "type": {
            "description": "Program-type letter, e.g. r (report), m (maintenance), i (inquiry), s (server)",
            "type": "string"
          }
        },
        "type": "object"
      },
      "name": "list_programs",
      "outputSchema": 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": {
        "additionalProperties": false,
        "properties": {
          "code": {
            "description": "Facility code, e.g. AP_A_002",
            "type": "string"
          }
        },
        "required": [
          "code"
        ],
        "type": "object"
      },
      "name": "lookup_facility",
      "outputSchema": 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": {
        "additionalProperties": false,
        "properties": {
          "id": {
            "description": "Program id or basename, e.g. AP_A_002 or ap_a_check_register",
            "type": "string"
          }
        },
        "required": [
          "id"
        ],
        "type": "object"
      },
      "name": "lookup_program",
      "outputSchema": 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": {
        "additionalProperties": false,
        "properties": {
          "name": {
            "description": "Object name, e.g. GL_ACCOUNTS or ACCOUNT_TYPES",
            "type": "string"
          }
        },
        "required": [
          "name"
        ],
        "type": "object"
      },
      "name": "lookup_table",
      "outputSchema": 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": {
        "additionalProperties": false,
        "properties": {
          "from": {
            "description": "Start object name",
            "type": "string"
          },
          "to": {
            "description": "Destination object name",
            "type": "string"
          }
        },
        "required": [
          "from",
          "to"
        ],
        "type": "object"
      },
      "name": "path_between",
      "outputSchema": 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": {
        "additionalProperties": false,
        "properties": {
          "id": {
            "description": "Program id or basename, e.g. AP_I_001 or ap_i_vendors",
            "type": "string"
          }
        },
        "required": [
          "id"
        ],
        "type": "object"
      },
      "name": "program_facilities",
      "outputSchema": 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": {
        "additionalProperties": false,
        "properties": {},
        "type": "object"
      },
      "name": "program_stats",
      "outputSchema": 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": {
        "additionalProperties": false,
        "properties": {},
        "type": "object"
      },
      "name": "schema_stats",
      "outputSchema": 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": {
        "additionalProperties": false,
        "properties": {
          "limit": {
            "description": "Max results per domain (default 25)",
            "maximum": 100,
            "minimum": 1,
            "type": "integer"
          },
          "query": {
            "description": "Search text, e.g. check register or posting_date",
            "type": "string"
          },
          "type": {
            "description": "Restrict to one domain (default all). 'table' is accepted as an alias for object.",
            "enum": [
              "all",
              "object",
              "column",
              "facility",
              "program"
            ],
            "type": "string"
          }
        },
        "required": [
          "query"
        ],
        "type": "object"
      },
      "name": "search_all",
      "outputSchema": null
    },
    {
      "description": "Search the Ross ERP 8.0 schema by name (and column descriptions). Returns matching objects and columns.",
      "inputSchema": {
        "additionalProperties": false,
        "properties": {
          "limit": {
            "description": "Max results per group (default 25)",
            "maximum": 100,
            "minimum": 1,
            "type": "integer"
          },
          "query": {
            "description": "Search text, e.g. posting_date or GL_ACCOUNTS",
            "type": "string"
          }
        },
        "required": [
          "query"
        ],
        "type": "object"
      },
      "name": "search_columns",
      "outputSchema": 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": {
        "additionalProperties": false,
        "properties": {
          "limit": {
            "description": "Max results (default 25)",
            "maximum": 100,
            "minimum": 1,
            "type": "integer"
          },
          "query": {
            "description": "Search text, e.g. check register or AP_A",
            "type": "string"
          }
        },
        "required": [
          "query"
        ],
        "type": "object"
      },
      "name": "search_facilities",
      "outputSchema": 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": {
        "additionalProperties": false,
        "properties": {
          "limit": {
            "description": "Max results (default 25)",
            "maximum": 100,
            "minimum": 1,
            "type": "integer"
          },
          "query": {
            "description": "Search text, e.g. check register or AP_A_002",
            "type": "string"
          }
        },
        "required": [
          "query"
        ],
        "type": "object"
      },
      "name": "search_programs",
      "outputSchema": 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": {
        "additionalProperties": false,
        "properties": {
          "table": {
            "description": "Table name, e.g. GL_ACCOUNTS",
            "type": "string"
          }
        },
        "required": [
          "table"
        ],
        "type": "object"
      },
      "name": "table_facilities",
      "outputSchema": 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": {
        "additionalProperties": false,
        "properties": {
          "table": {
            "description": "Table name, e.g. GL_ACCOUNTS",
            "type": "string"
          }
        },
        "required": [
          "table"
        ],
        "type": "object"
      },
      "name": "table_programs",
      "outputSchema": null
    }
  ]
}

Verify it yourself

curl -s https://api.teppi.xyz/v1/evidence/sha256:7b8b5068d66ab9f1afb11f62274cb841d2ff210fc00ddb129717b1689d4af0a5 | sha256sum