tables_db_create_index
Create database indexes to optimize query performance by specifying columns for faster data retrieval in Appwrite tables.
Instructions
Creates an index on the columns listed. Your index should include all the columns you will query in a single request.
Input Schema
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
| database_id | Yes | Database ID. | |
| table_id | Yes | Table ID. You can create a new table using the Database service [server integration](https://appwrite.io/docs/references/cloud/server-dart/tablesDB#createTable). | |
| key | Yes | Index Key. | |
| type | Yes | Index type. | |
| columns | Yes | Array of columns to index. Maximum of 100 columns are allowed, each 32 characters long. | |
| orders | No | Array of index orders. Maximum of 100 orders are allowed. | |
| lengths | No | Length of index. Maximum of 100 |
Implementation Reference
- Executes the logic for all tools, including 'tables_db_create_index', by calling the bound method of the Appwrite TablesDB.create_index with 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)}")]
- Dynamically generates tool definitions and input schemas for all public methods of the TablesDB service, creating the 'tables_db_create_index' tool from TablesDB.create_index method with schema from type hints and docstrings.def list_tools(self) -> Dict[str, Dict]: """Lists all available tools for this service""" tools = {} for name, func in inspect.getmembers(self.service, predicate=inspect.ismethod): if name.startswith('_'): # Skip private methods continue original_func = func.__func__ # Skip if not from the service's module if original_func.__module__ != self.service.__class__.__module__: continue # Get the overridden name if it exists tool_name = self._method_name_overrides.get(name, f"{self.service_name}_{name}") docstring = parse(original_func.__doc__) signature = inspect.signature(original_func) type_hints = get_type_hints(original_func) properties = {} required = [] 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) tool_definition = Tool( name=tool_name, description=f"{docstring.short_description or "No description available"}", inputSchema={ "type": "object", "properties": properties, "required": required } ) tools[tool_name] = { "definition": tool_definition, "function": func } return tools
- src/mcp_server_appwrite/server.py:70-71 (registration)Registers the TablesDB Appwrite service as 'tables_db', enabling all its methods as prefixed MCP tools like 'tables_db_create_index'.if args.tables_db: tools_manager.register_service(Service(TablesDB(client), "tables_db"))
- src/mcp_server_appwrite/tool_manager.py:10-14 (registration)ToolManager.register_service populates the tools registry by calling service.list_tools(), including the 'tables_db_create_index' 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/server.py:99-101 (registration)MCP server.list_tools() handler that returns all registered tools, including 'tables_db_create_index'.@server.list_tools() async def handle_list_tools() -> list[types.Tool]: return tools_manager.get_all_tools()