Teradata MCP Server

Instructions

Implementation Reference

• src/teradata_mcp_server/tools/tmpl/tmpl_tools.py:20-47 (handler)

  The handler function that implements the core logic of the 'tmpl_nameOfTool' MCP tool. It takes a Teradata connection and an optional string argument, executes a placeholder SQL query, formats the results, and returns a response with metadata.

  def handle_tmpl_nameOfTool(conn: TeradataConnection, argument: str | None, *args, **kwargs):
      """
      <description of what the tool is for>
  
      Arguments:
        arguments - arguments to analyze
  
      Returns:
        ResponseType: formatted response with query results + metadata
      """
      logger.debug(f"Tool: handle_tmpl_nameOfTool: Args: argument: {argument}")
  
      with conn.cursor() as cur:
          if argument == "":
              logger.debug("No argument provided")
              rows = cur.execute("Teradata query goes here;")
          else:
              logger.debug(f"Argument provided: {argument}")
              rows = cur.execute(f"Teradata query goes here with argument {argument};")
          data = rows_to_json(cur.description, rows.fetchall())
          metadata = {
              "tool_name": "tmpl_nameOfTool",
              "argument": argument,
              "rows": len(data)
          }
          logger.debug(f"Tool: handle_tmpl_nameOfTool: metadata: {metadata}")
          return create_response(data, metadata)