Skip to main content
Glama
vishnu27597

Sandbox GSTR-1 MCP Server

by vishnu27597

convert_excel_to_sandbox_payload

Converts GSTR-1 Excel data into the JSON payload format required by Sandbox.co save_gstr1_data API for GST return submission.

Instructions

Convert a GSTR-1 Excel file (output of the unified-gstr1 skill) into the JSON payload format required by the Sandbox.co save_gstr1_data() API.

Reads the b2b, b2cl, b2cs, and hsn sheets from the Excel file and maps each row to the corresponding Sandbox.co API structure.

Args: excel_path: Absolute path to the GSTR-1 Excel file

Returns: Dict with the formatted payload ready to pass to save_gstr1_data(), or an error dict.

Input Schema

TableJSON Schema
NameRequiredDescriptionDefault
excel_pathYes

Output Schema

TableJSON Schema
NameRequiredDescriptionDefault
resultYes

Schema Changelog

Changes observed during successful MCP inspections.

  1. First observedv1.0.0

TDQS

A4.4/5.0
Behavior4/5

Does the description disclose side effects, auth requirements, rate limits, or destructive behavior?

With no annotations, the description carries the behavioral burden. It discloses the read operation on specific sheets, the mapping behavior, and the return type including an error-dict case. It does not mention edge conditions like missing sheets, but the core side-effect-free conversion behavior is clearly communicated.

Agents need to know what a tool does to the world before calling it. Descriptions should go beyond structured annotations to explain consequences.

Conciseness5/5

Is the description appropriately sized, front-loaded, and free of redundancy?

The description is front-loaded with the core purpose, then gives the concrete sheets and a compact Args/Returns structure. Every sentence contributes useful information with no filler.

Shorter descriptions cost fewer tokens and are easier for agents to parse. Every sentence should earn its place.

Completeness4/5

Given the tool's complexity, does the description cover enough for an agent to succeed on first attempt?

For a single-parameter conversion tool, the description is nearly complete: it states the input, the transformation scope, and the return format, and an output schema exists. It could be slightly stronger by noting that the tool does not call the API itself, but the phrase 'ready to pass' already implies that.

Complex tools with many parameters or behaviors need more documentation. Simple tools need less. This dimension scales expectations accordingly.

Parameters4/5

Does the description clarify parameter syntax, constraints, interactions, or defaults beyond what the schema provides?

Schema coverage is 0%, but the description compensates by explaining that excel_path must be an absolute path to the GSTR-1 Excel file. This adds real meaning beyond the schema's bare 'Excel Path' label, though it could add slight detail such as expected file extension.

Input schemas describe structure but not intent. Descriptions should explain non-obvious parameter relationships and valid value ranges.

Purpose5/5

Does the description clearly state what the tool does and how it differs from similar tools?

The description states a specific verb ('Convert'), a precise input (GSTR-1 Excel file from unified-gstr1 skill), and a precise output (JSON payload for Sandbox.co save_gstr1_data). It also names the sheets read, making the scope unambiguous and differentiating it from sibling tools that actually submit or check returns.

Agents choose between tools based on descriptions. A clear purpose with a specific verb and resource helps agents select the right tool.

Usage Guidelines4/5

Does the description explain when to use this tool, when not to, or what alternatives exist?

It clearly positions the tool in the workflow: input is the output of unified-gstr1, and output is ready for save_gstr1_data(). This tells an agent when to call it even though it does not explicitly list exclusions or alternatives.

Agents often have multiple tools that could apply. Explicit usage guidance like "use X instead of Y when Z" prevents misuse.