Skip to main content
Glama
CDataSoftware

CData Sync MCP Server

Official

get_table_columns

Retrieve column details like names, data types, and keys for a specific table in CData Sync to understand table structure for data synchronization and ETL processes.

Instructions

Get column details for a specific table including names, data types, and keys.

RETURNS: Array of column objects with name, type, nullable, and key information.

COMMON ERRORS:

  • "Table not found" - Use exact name from get_connection_tables

  • "Connection not found" - Verify connection name

  • "Access denied" - Check table permissions

Input Schema

TableJSON Schema
NameRequiredDescriptionDefault
connectionNameYesConnection containing the table
tableYesTable name using exact name from get_connection_tables (include schema if needed, e.g., 'dbo.Customers')
workspaceIdNoWorkspace ID to use for this operation. Overrides the default workspace. Use 'default' for the default workspace or a UUID for specific workspaces.
Behavior4/5

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

With no annotations provided, the description carries the full burden of behavioral disclosure. It effectively describes the return format ('Array of column objects with name, type, nullable, and key information') and common errors that reveal behavioral traits like permission requirements and exact naming conventions. This adds valuable context beyond the input schema, though it could mention rate limits or side effects if applicable.

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 appropriately sized and front-loaded, with the core purpose stated first, followed by returns and errors in clear sections. Every sentence earns its place by providing essential information without redundancy, making it easy to scan and understand quickly.

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?

Given the tool's moderate complexity (3 parameters, no output schema, no annotations), the description is largely complete. It covers purpose, returns, and common errors, which helps an agent use the tool correctly. However, it could improve by mentioning potential side effects or performance considerations, though the lack of output schema is mitigated by detailing the return format.

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

Parameters3/5

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

The schema description coverage is 100%, so the input schema already documents all three parameters thoroughly. The description does not add significant meaning beyond the schema, such as explaining parameter interactions or usage nuances. It references parameters indirectly in error messages but doesn't enhance their semantics, warranting the baseline score of 3.

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's purpose with specific verbs ('Get column details') and resources ('for a specific table'), distinguishing it from siblings like get_connection_tables (which lists tables) or execute_query (which runs queries). It explicitly mentions what details are retrieved: names, data types, and keys.

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?

The description provides clear context for when to use this tool (to get column metadata for a specific table) and includes implicit guidance via error messages (e.g., use exact table names from get_connection_tables). However, it does not explicitly state when not to use it or name alternatives among siblings, such as get_connection_tables for table lists instead of column details.

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/CDataSoftware/cdata-sync-mcp-server'

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