mcp-azure-tablestorage

Instructions

Implementation Reference

• src/index.ts:236-269 (handler)

  The handler function for the get_table_schema tool. It creates a TableClient for the given table, iterates over all entities, collects unique property names and their types (using typeof), builds a schema map, and returns it as JSON text content.

  private async handleGetTableSchema(args: GetSchemaArgs) {
    const tableClient = TableClient.fromConnectionString(
      this.connectionString,
      args.tableName
    );
  
    const propertyMap = new Map<string, Set<string>>();
    const iterator = tableClient.listEntities();
    
    for await (const entity of iterator) {
      Object.entries(entity).forEach(([key, value]) => {
        if (!propertyMap.has(key)) {
          propertyMap.set(key, new Set());
        }
        propertyMap.get(key)?.add(typeof value);
      });
    }
  
    const schema = Object.fromEntries(
      Array.from(propertyMap.entries()).map(([key, types]) => [
        key,
        Array.from(types),
      ])
    );
  
    return {
      content: [
        {
          type: 'text',
          text: JSON.stringify(schema, null, 2),
        },
      ],
    };
  }

• src/index.ts:115-128 (registration)

  Registration of the get_table_schema tool in the ListTools response, including name, description, and JSON inputSchema.

  {
    name: 'get_table_schema',
    description: 'Get property names and types from a table',
    inputSchema: {
      type: 'object',
      properties: {
        tableName: {
          type: 'string',
          description: 'Name of the table to analyze',
        },
      },
      required: ['tableName'],
    },
  },

• src/index.ts:159-166 (registration)

  Dispatch case in the CallToolRequestHandler that validates the tableName argument and invokes the handleGetTableSchema method.

  case 'get_table_schema':
    const schemaArgs = request.params.arguments as Record<string, unknown>;
    if (typeof schemaArgs?.tableName !== 'string') {
      throw new McpError(ErrorCode.InvalidParams, 'tableName is required and must be a string');
    }
    return await this.handleGetTableSchema({
      tableName: schemaArgs.tableName
    });

• src/index.ts:22-24 (schema)

  TypeScript interface defining the input arguments for the get_table_schema handler.

  interface GetSchemaArgs {
    tableName: string;
  }