Skip to main content
Glama
Aryan-Jhaveri

Statistics Canada MCP Server

insert_data_into_table

Append rows to an existing SQLite table to merge data from multiple API calls or add new time periods, keeping your datasets up to date.

Instructions

Appends rows (list of dicts) into an ALREADY EXISTING SQLite table. Use this only to add more data to a table that was previously created.

For the common "fetch API data then store" workflow, use create_table_from_data or fetch_vectors_to_database instead — both create the table AND insert data in a single call, so you do NOT need to call this tool after them.

This tool is useful when:

  • You want to merge data from multiple API calls into one table

  • You're appending new time periods to an existing dataset

Args: table_input: Object containing table_name and data (list of dicts).

Returns: Dict[str, str]: A dictionary indicating success (with row count) or failure.

IMPORTANT: In your final response to the user, you MUST cite the source of the data you are inserting if it comes from an API call (e.g., "Data from Product ID 123456").

Input Schema

TableJSON Schema
NameRequiredDescriptionDefault
dataYesData to insert, as a list of dictionaries.
table_nameYesName for the SQL table (alphanumeric and underscores recommended).
Behavior4/5

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

With no annotations, the description carries the full burden. It discloses that the table must already exist, that the operation appends rows, and that it returns a success/failure dict. It also adds an important caveat about citing the data source. However, it doesn't cover error scenarios such as non-existent tables or schema mismatches, keeping it slightly below a perfect score.

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

Conciseness4/5

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

The description is well-structured and front-loaded with the primary purpose. It includes separate sections for usage, arguments, returns, and an important note. It is reasonably concise, though the inaccurate parameter explanation slightly reduces clarity, keeping it from a perfect score.

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

Completeness3/5

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

The description covers purpose, usage, return type, and an agent instruction about citing sources. However, the inaccurate parameter description and lack of error handling details leave gaps. Given the tool's simplicity, the description is adequate but could be more accurate and thorough, so a score of 3 is appropriate.

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

Parameters2/5

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

Although the schema has 100% coverage for both parameters, the description's Args section inaccurately describes a single 'table_input' object containing table_name and data, while the actual schema defines flat top-level properties. This misleading parameter explanation actively harms understanding rather than adding value, warranting a score below the 3 baseline.

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 clearly states the tool 'Appends rows (list of dicts) into an ALREADY EXISTING SQLite table.' It uses a specific verb and resource, and explicitly distinguishes itself from sibling tools like create_table_from_data and fetch_vectors_to_database by emphasizing it is only for adding data to an existing table.

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

Usage Guidelines5/5

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

Provides explicit when-to-use guidance: useful for merging data from multiple API calls or appending new time periods. It also explicitly says when NOT to use it, directing users to alternative tools that both create and insert in one call, making the usage context unmistakable.

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

Install Server

Other Tools

Latest Blog Posts

MCP directory API

We provide all the information about MCP servers via our MCP API.

curl -X GET 'https://glama.ai/api/mcp/v1/servers/Aryan-Jhaveri/mcp-statcan'

If you have feedback or need assistance with the MCP directory API, please join our Discord server