Skip to main content
Glama
appwrite

Appwrite MCP Server

Official
by appwrite

tables_db_list_transactions

Retrieve transaction records from Appwrite databases using query parameters to filter and organize data for monitoring or analysis.

Instructions

List transactions across all databases.

Input Schema

TableJSON Schema
NameRequiredDescriptionDefault
queriesNoArray of query strings generated using the Query class provided by the SDK. [Learn more about queries](https://appwrite.io/docs/queries).

Implementation Reference

  • The universal tool handler that calls the registered service method for 'tables_db_list_transactions', which is TablesDB.list_transactions().
    @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 the tool schema and definition for 'tables_db_list_transactions' based on the TablesDB.list_transactions method signature, type hints, and docstring.
    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
  • Registers the TablesDB service with name 'tables_db', enabling dynamic tool generation including 'tables_db_list_transactions'.
    if args.tables_db:
        tools_manager.register_service(Service(TablesDB(client), "tables_db"))
  • Default registration of TablesDB service if no other services specified.
    if not any([args.databases, args.tables_db, args.users, args.teams, args.storage,
                args.functions, args.messaging, args.locale, args.avatars, args.sites]):
        tools_manager.register_service(Service(TablesDB(client), "tables_db"))
Behavior2/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. 'List transactions' implies a read-only operation, but it doesn't specify whether this requires authentication, what permissions are needed, whether results are paginated, or what format the output takes. For a tool that presumably returns potentially sensitive transaction data, this is a significant gap in behavioral context.

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 a single, efficient sentence that states exactly what the tool does with zero wasted words. It's appropriately sized for a simple list operation and gets straight to the point without unnecessary elaboration.

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

Completeness2/5

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

Given the lack of annotations and output schema, the description is insufficiently complete. For a tool that lists transactions across databases, the description should address scope (all databases vs specific ones), output format, potential limitations, or security considerations. The current description leaves too many contextual questions unanswered for effective tool selection and invocation.

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%, with the single parameter 'queries' fully documented in the schema. The description doesn't add any parameter-specific information beyond what's already in the schema. According to the guidelines, when schema coverage is high (>80%), the baseline score is 3 even with no param info in the description.

Input schemas describe structure but not intent. Descriptions should explain non-obvious parameter relationships and valid value ranges.

Purpose4/5

Does the description clearly state what the tool does and how it differs from similar tools?

The description clearly states the action ('List') and resource ('transactions across all databases'), making the purpose immediately understandable. It distinguishes this tool from other list operations (like list_tables, list_rows) by specifying it's for transactions. However, it doesn't explicitly differentiate from 'tables_db_get_transaction' which retrieves a single transaction, so it's not fully sibling-distinctive.

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

Usage Guidelines2/5

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

The description provides no guidance on when to use this tool versus alternatives. It doesn't mention when to use 'tables_db_get_transaction' for single transactions, or how this differs from other list operations. There's no context about prerequisites, filtering capabilities, or typical use cases.

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/appwrite/mcp-for-api'

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