erp-report-engine
Server Configuration
Describes the environment variables required to run the server.
| Name | Required | Description | Default |
|---|---|---|---|
| ERP_DB_URL | Yes | Database connection URL (e.g., mssql+pyodbc://user:pass@host/db?driver=...). Must be set as environment variable, never in config file. |
Instructions
Guidance the server publishes about itself, which clients place ahead of the tool catalog so the model reads it before choosing anything.
This server publishes no instructions, or was last inspected before Glama recorded them.
Capabilities
Features and capabilities supported by this server
Protocol revision2025-11-25
| Capability | Details |
|---|---|
| tools | {
"listChanged": false
} |
| prompts | {
"listChanged": false
} |
| resources | {
"subscribe": false,
"listChanged": false
} |
| experimental | {} |
Tools
Functions exposed to the LLM to take actions
| Name | Description |
|---|---|
| describe_modelA | List the canonical entities and columns you can query, and the active profile. |
| weekly_reportA | The weekly KPI briefing with findings, data-quality gate, source reconciliation and SQL audit trail. |
| reconcileA | Reconcile each entity's fetched row count against an independent COUNT(*) of the source. |
| agingA | Receivables aging: open balances bucketed by days past due, the overdue share, and the customers who owe the most overdue. Empty if the profile maps no receivables. |
| check_queryA | Check whether a SQL statement would pass the read-only guard, without running it. |
| queryA | Run a read-only SELECT/WITH query over the canonical entities and return the rows. |
Prompts
Interactive templates invoked by user choice
| Name | Description |
|---|---|
No prompts | |
Resources
Contextual data attached and managed by the client
| Name | Description |
|---|---|
No resources | |
TDQS
Scored across 6 tools
Each tool targets a distinct action: describe_model provides metadata, weekly_report generates a KPI briefing, reconcile verifies counts, aging produces a specific receivables report, check_query validates SQL, and query runs read-only queries. There is no overlap in purpose.
Tool names follow inconsistent patterns: describe_model and check_query use verb_noun, weekly_report and aging are nouns, while reconcile and query are bare verbs. The lack of a uniform convention makes it less predictable which names are actions versus report objects.
Six tools is well-scoped for an ERP report engine, covering schema discovery, query execution, validation, reconciliation, and two standard reports without unnecessary bloat or thinness.
The server covers metadata, generic querying, SQL validation, data reconciliation, and two specific report types. While additional standard ERP reports could be included, the generic query tool provides a path to access any data, so the surface is fairly complete.