tables_db_update_datetime_column

Modify a datetime column's properties in Appwrite database tables, including requirements and default values, without affecting existing data.

Instructions

Update a date time column. Changing the default value will not update already existing rows.

Input Schema

TableJSON Schema

Name	Required	Description
`database_id`	Yes	Database ID.
`table_id`	Yes	Table ID.
`key`	Yes	Column Key.
`required`	Yes	Is column required?
`default`	Yes	Default value for column when not provided. Cannot be set when column is required.
`new_key`	No	New Column Key.

Implementation Reference

src/mcp_server_appwrite/server.py:70-72 (registration)
Registers the TablesDB Appwrite service with name 'tables_db'. This service dynamically generates MCP tools for each public method, prefixed with 'tables_db_', so 'update_datetime_column' becomes 'tables_db_update_datetime_column'.
```
if args.tables_db:
    tools_manager.register_service(Service(TablesDB(client), "tables_db"))
if args.users:
```

src/mcp_server_appwrite/server.py:103-122 (handler)

Generic handler for all MCP tools. For 'tables_db_update_datetime_column', it retrieves the bound method from TablesDB.update_datetime_column and executes it with the provided arguments.

@server.call_tool()
async def handle_call_tool(
    name: str, arguments: dict | None
) -> list[types.TextContent | types.ImageContent | types.EmbeddedResource]:
    
    try:
        tool_info = tools_manager.get_tool(name)
        if not tool_info:
            raise McpError(f"Tool {name} not found")
        
        bound_method = tool_info["function"]
        result = bound_method(**(arguments or {}))
        if hasattr(result, 'to_dict'):
            result_dict = result.to_dict()
            return [types.TextContent(type="text", text=str(result_dict))]
        return [types.TextContent(type="text", text=str(result))]
    except AppwriteException as e:
        return [types.TextContent(type="text", text=f"Appwrite Error: {str(e)}")]
    except Exception as e:
        return [types.TextContent(type="text", text=f"Error: {str(e)}")]

src/mcp_server_appwrite/service.py:112-120 (schema)

Dynamically generates the JSON schema for the tool's input parameters based on the Appwrite method's type hints, docstring, and signature. Used for all tools including this one.

tool_definition = Tool(
    name=tool_name,
    description=f"{docstring.short_description or "No description available"}",
    inputSchema={
        "type": "object",
        "properties": properties,
        "required": required
    }
)

src/mcp_server_appwrite/tool_manager.py:10-13 (registration)
ToolManager.register_service adds the tools from a service (including all tables_db tools) to the global registry used by list_tools and call_tool.
```
def register_service(self, service: Service):
    """Register a new service and its tools"""
    self.services.append(service)
    self.tools_registry.update(service.list_tools())
```

src/mcp_server_appwrite/service.py:97-111 (schema)

Parses method parameters to build 'properties' and 'required' for the inputSchema of each tool.

for param_name, param in signature.parameters.items():
    if param_name == 'self':
        continue

    param_type = type_hints.get(param_name, str)
    properties[param_name] = self.python_type_to_json_schema(param_type)
    properties[param_name]["description"] = f"Parameter '{param_name}'"
    
    for doc_param in docstring.params:
        if doc_param.arg_name == param_name:
            properties[param_name]["description"] = doc_param.description

    if param.default is param.empty:
        required.append(param_name)

Appwrite MCP Server