Wherobots

{
  "checks": {
    "action_safety_probe": {
      "details": {
        "auth_present": false,
        "confirmation_signals": [],
        "safeguard_count": 0,
        "summary": {
          "bulk_access_tools": 0,
          "capability_distribution": {},
          "destructive_tools": 0,
          "egress_tools": 0,
          "exec_tools": 0,
          "high_risk_tools": 0,
          "risk_distribution": {
            "critical": 0,
            "high": 0,
            "low": 0,
            "medium": 0
          },
          "secret_tools": 0,
          "tool_count": 0
        }
      },
      "latency_ms": null,
      "status": "ok"
    },
    "advanced_capabilities_probe": {
      "details": {
        "capabilities": {
          "completions": false,
          "elicitation": false,
          "prompts": false,
          "resource_links": false,
          "resources": false,
          "roots": false,
          "sampling": false,
          "structured_outputs": false
        },
        "enabled": [],
        "enabled_count": 0,
        "initialize_capability_keys": [
          "experimental",
          "prompts",
          "resources",
          "tasks",
          "tools"
        ]
      },
      "latency_ms": null,
      "status": "missing"
    },
    "connector_publishability_probe": {
      "details": {
        "blockers": [
          "tools_list",
          "server_card",
          "tool_surface"
        ],
        "criteria": {
          "action_safety": true,
          "auth_flow": true,
          "connector_replay": true,
          "initialize": true,
          "protocol_version": true,
          "remote_transport": true,
          "request_association": true,
          "server_card": false,
          "session_resume": true,
          "step_up_auth": true,
          "tool_surface": false,
          "tools_list": false,
          "transport_compliance": true
        },
        "high_risk_tools": 0,
        "tool_count": 0,
        "transport": "streamable-http"
      },
      "latency_ms": null,
      "status": "error"
    },
    "connector_replay_probe": {
      "details": {
        "reason": "no_tools"
      },
      "latency_ms": null,
      "status": "missing"
    },
    "determinism_probe": {
      "details": {
        "reason": "tools_list_unavailable"
      },
      "latency_ms": null,
      "status": "missing"
    },
    "initialize": {
      "details": {
        "headers": {
          "content-type": "text/event-stream",
          "mcp-session-id": "4572e25af5ee46fbb96d316559a7ff95"
        },
        "http_status": 200,
        "payload": {
          "id": 1,
          "jsonrpc": "2.0",
          "result": {
            "capabilities": {
              "experimental": {},
              "prompts": {
                "listChanged": true
              },
              "resources": {
                "listChanged": true,
                "subscribe": false
              },
              "tasks": {
                "cancel": {},
                "list": {},
                "requests": {
                  "prompts": {
                    "get": {}
                  },
                  "resources": {
                    "read": {}
                  },
                  "tools": {
                    "call": {}
                  }
                }
              },
              "tools": {
                "listChanged": true
              }
            },
            "instructions": "\n# Wherobots MCP Server - Spatial Data & Analytics\n\nYou are connected to the Wherobots MCP server, which provides tools for exploring\nspatial data catalogs, searching documentation, and executing spatial SQL queries.\n\n## \u26a0\ufe0f MANDATORY WORKFLOW - Follow This Order\n\n### Step 1: Search Documentation FIRST\nBefore attempting ANY query or code generation, ALWAYS call `search_documentation_tool`\nto understand available spatial functions, syntax, and best practices.\n\n### Step 2: Explore the Catalog\nUnderstand what data is available before writing queries:\n1. `list_catalogs_tool` - See all available catalogs\n2. `list_databases_tool(catalog)` - See databases in a catalog\n3. `list_tables_tool(catalog, database)` - See tables in a database\n4. `describe_table_tool(catalog, database, table)` - Get schema for tables you'll query\n\n### Step 3: Generate and Test SQL\nALWAYS test queries with SQL before generating application code:\n1. `generate_spatial_query_tool(prompt)` - Generate SQL from natural language\n2. `execute_query_tool(query, limit=10)` - Test with small LIMIT first\n3. Iterate on SQL until results are correct\n\n### Step 4: Generate Code (Only After SQL Works)\nOnly generate application code AFTER you have:\n- Searched relevant documentation\n- Explored and described the relevant tables\n- Successfully tested the SQL query\n\n## \ud83d\udd11 Key Principles\n\n### All Data Processing Via MCP Tools\n- Do NOT attempt to process spatial data locally\n- Use Wherobots tools for all data operations - the compute happens server-side\n- Return summarized results to the user, not raw data dumps\n\n### Read-Only Operations\n- All queries must be read-only (SELECT statements)\n- Write operations (INSERT, UPDATE, DELETE, etc.) are blocked\n\n### Pagination for Large Results\n- Always use `limit` and `offset` parameters for large result sets\n- Start with `limit=10` for testing, increase as needed\n\n## \ud83d\udcda Tool Reference\n\n### Documentation Tools\n- `search_documentation_tool(query)` - Search Wherobots docs for functions, syntax, examples\n\n### Catalog Tools  \n- `list_catalogs_tool()` - List all available data catalogs\n- `list_databases_tool(catalog)` - List databases in a catalog\n- `list_tables_tool(catalog, database)` - List tables in a database\n- `describe_table_tool(catalog, database, table)` - Get table schema\n- `list_hierarchy_tool()` - Get full hierarchy (managed catalogs only, DEPRECATED)\n\n### Query Tools\n- `generate_spatial_query_tool(user_prompt)` - Generate SQL from natural language\n- `execute_query_tool(query, limit, offset)` - Execute SQL and return results\n\n## \ud83d\udca1 Best Practices\n\n1. **Documentation-Driven Development**: Search docs before writing queries\n2. **Schema-Aware Queries**: Always describe tables before referencing them\n3. **Iterative Testing**: Start with simple queries, add complexity gradually\n4. **Error Analysis**: If a query fails, check schema and docs before retrying\n",
            "protocolVersion": "2025-03-26",
            "serverInfo": {
              "name": "Wherobots MCP Server",
              "version": "2.14.5"
            }
          }
        },
        "url": "https://api.cloud.wherobots.com/mcp/"
      },
      "latency_ms": 317.65,
      "status": "ok"
    },
    "interactive_flow_probe": {
      "details": {
        "oauth_supported": false,
        "prompt_available": false,
        "risk_hits": [],
        "safe_hits": []
      },
      "latency_ms": null,
      "status": "missing"
    },
    "oauth_authorization_server": {
      "details": {
        "reason": "no_authorization_server"
      },
      "latency_ms": null,
      "status": "missing"
    },
    "oauth_protected_resource": {
      "details": {
        "error": "Client error '404 Not Found' for url 'https://api.cloud.wherobots.com/.well-known/oauth-protected-resource'\nFor more information check: https://developer.mozilla.org/en-US/docs/Web/HTTP/Status/404",
        "url": "https://api.cloud.wherobots.com/.well-known/oauth-protected-resource"
      },
      "latency_ms": 229.93,
      "status": "error"
    },
    "official_registry_probe": {
      "details": {
        "direct_match": true,
        "official_peer_count": 1,
        "registry_identifier": "com.wherobots/mcp-server",
        "registry_source": "official_registry"
      },
      "latency_ms": null,
      "status": "ok"
    },
    "openid_configuration": {
      "details": {
        "reason": "no_authorization_server"
      },
      "latency_ms": null,
      "status": "missing"
    },
    "probe_noise_resilience": {
      "details": {
        "headers": {
          "content-type": "application/json",
          "strict-transport-security": "max-age=31536000; includeSubDomains"
        },
        "http_status": 404,
        "url": "https://api.cloud.wherobots.com/robots.txt"
      },
      "latency_ms": 223.67,
      "status": "ok"
    },
    "prompt_get": {
      "details": {
        "reason": "not_advertised"
      },
      "latency_ms": null,
      "status": "missing"
    },
    "prompts_list": {
      "details": {
        "error": "Client error '400 Bad Request' for url 'https://api.cloud.wherobots.com/mcp'\nFor more information check: https://developer.mozilla.org/en-US/docs/Web/HTTP/Status/400",
        "headers": {
          "content-type": "application/json",
          "mcp-session-id": "d35c0fc69f4445268a6d8c841e70ccb3"
        },
        "http_status": 400,
        "payload": {},
        "reason": "not_advertised",
        "url": "https://api.cloud.wherobots.com/mcp/"
      },
      "latency_ms": 302.96,
      "status": "missing"
    },
    "protocol_version_probe": {
      "details": {
        "claimed_version": "2025-03-26",
        "lag_days": 244,
        "latest_known_version": "2025-11-25",
        "releases_behind": 2,
        "validator_protocol_version": "2025-03-26"
      },
      "latency_ms": null,
      "status": "warning"
    },
    "provenance_divergence_probe": {
      "details": {
        "direct_official_match": true,
        "drift_fields": [],
        "metadata_document_count": 1,
        "registry_homepage": null,
        "registry_repository": null,
        "registry_title": null,
        "registry_version": null,
        "server_card_homepage": null,
        "server_card_repository": null,
        "server_card_title": null,
        "server_card_version": null
      },
      "latency_ms": null,
      "status": "ok"
    },
    "request_association_probe": {
      "details": {
        "reason": "no_request_association_capabilities_advertised"
      },
      "latency_ms": null,
      "status": "missing"
    },
    "resource_read": {
      "details": {
        "reason": "not_advertised"
      },
      "latency_ms": null,
      "status": "missing"
    },
    "resources_list": {
      "details": {
        "error": "Client error '400 Bad Request' for url 'https://api.cloud.wherobots.com/mcp'\nFor more information check: https://developer.mozilla.org/en-US/docs/Web/HTTP/Status/400",
        "headers": {
          "content-type": "application/json",
          "mcp-session-id": "6499f473be504b1bb123c69566aeaf78"
        },
        "http_status": 400,
        "payload": {},
        "reason": "not_advertised",
        "url": "https://api.cloud.wherobots.com/mcp/"
      },
      "latency_ms": 307.62,
      "status": "missing"
    },
    "server_card": {
      "details": {
        "error": "Client error '404 Not Found' for url 'https://api.cloud.wherobots.com/.well-known/mcp/server-card.json'\nFor more information check: https://developer.mozilla.org/en-US/docs/Web/HTTP/Status/404",
        "url": "https://api.cloud.wherobots.com/.well-known/mcp/server-card.json"
      },
      "latency_ms": 376.45,
      "status": "error"
    },
    "session_resume_probe": {
      "details": {
        "headers": {
          "content-type": "text/event-stream",
          "mcp-session-id": "4572e25af5ee46fbb96d316559a7ff95"
        },
        "http_status": 200,
        "payload": {
          "id": 301,
          "jsonrpc": "2.0",
          "result": {
            "tools": [
              {
                "_meta": {
                  "_fastmcp": {
                    "tags": []
                  }
                },
                "annotations": {
                  "readOnlyHint": true,
                  "title": "List Wherobots Catalogs"
                },
                "description": "List all catalogs available for users.\n\n\u26a0\ufe0f WORKFLOW: Call this after search_documentation_tool.\nStart your catalog exploration here to discover available data sources.\n\n\ud83d\udccb PREREQUISITES:\n- Call search_documentation_tool first to understand what you're looking for\n\n\ud83d\udccb NEXT STEPS after this tool:\n1. Use list_databases_tool to explore databases in a catalog\n2. Use list_tables_tool to find tables in a database\n3. Use describe_table_tool to get table schemas\n\nThis tool retrieves all available catalogs accessible with the provided API key.\nIt is typically used as the first step in exploring the data hierarchy.\nThis tool will fetch both managed catalogs, as well as external catalogs. (e.g., on Databricks)\n\nParameters\n----------\nctx : Context\n    FastMCP context (injected automatically)\n\nReturns\n-------\nCatalogListOutput\n    A structured object containing catalog information.\n    - 'catalogs': List of catalog names.\n    - 'count': Number of catalogs found.\n\nExample Usage for LLM:\n- When user asks for available catalogs.\n- Example User Queries and corresponding Tool Calls:\n\n- User: \"What catalogs are available?\"\n- Tool Call: list_catalogs()\n\n- User: \"Show me all the data sources\"\n- Tool Call: list_catalogs()",
                "inputSchema": {
                  "properties": {},
                  "type": "object"
                },
                "name": "list_catalogs_tool",
                "outputSchema": {
                  "properties": {
                    "catalogs": {
                      "description": "List of catalog names.",
                      "items": {
                        "type": "string"
                      },
                      "type": "array"
                    },
                    "count": {
                      "description": "Total number of catalogs.",
                      "type": "integer"
                    }
                  },
                  "required": [
                    "catalogs",
                    "count"
                  ],
                  "type": "object"
                },
                "title": "List Wherobots Catalogs"
              },
              {
                "_meta": {
                  "_fastmcp": {
                    "tags": []
                  }
                },
                "annotations": {
                  "readOnlyHint": true,
                  "title": "List Wherobots Catalog Databases"
                },
                "description": "List all databases in a given catalog.\n\n\u26a0\ufe0f WORKFLOW: Call this after list_catalogs_tool to explore a specific catalog.\n\n\ud83d\udccb PREREQUISITES:\n- Call search_documentation_tool first to understand what you're looking for\n- Call list_catalogs_tool to discover available catalogs\n\n\ud83d\udccb NEXT STEPS after this tool:\n1. Use list_tables_tool to find tables in a database\n2. Use describe_table_tool to get table schemas before writing queries\n\nThis tool retrieves all databases within a specified catalog.\n\nParameters\n----------\ncatalog : str\n    The name of the catalog.\nctx : Context\n    FastMCP context (injected automatically)\n\nReturns\n-------\nDatabaseListOutput\n    A structured object containing database information.\n    - 'catalog': The catalog name.\n    - 'databases': List of database names.\n    - 'count': Number of databases found.\n\nExample Usage for LLM:\n- When user asks for a specific catalog's databases.\n- Example User Queries and corresponding Tool Calls:\n\n- User: \"List all databases in the 'wherobots' catalog.\"\n- Tool Call: list_databases('wherobots')\n\n- User: \"What databases are in the foursquare catalog?\"\n- Tool Call: list_databases('foursquare')",
                "inputSchema": {
                  "properties": {
                    "catalog": {
                      "type": "string"
                    }
                  },
                  "required": [
                    "catalog"
                  ],
                  "type": "object"
                },
                "name": "list_databases_tool",
                "outputSchema": {
                  "properties": {
                    "catalog": {
                      "description": "Name of the catalog.",
                      "type": "string"
                    },
                    "count": {
                      "description": "Total number of databases.",
                      "type": "integer"
                    },
                    "databases": {
                      "description": "List of database names.",
                      "items": {
                        "type": "string"
                      },
                      "type": "array"
                    }
                  },
                  "required": [
                    "catalog",
                    "databases",
                    "count"
                  ],
                  "type": "object"
                },
                "title": "List Wherobots Catalog Databases"
              },
              {
                "_meta": {
                  "_fastmcp": {
                    "tags": []
                  }
                },
                "annotations": {
                  "readOnlyHint": true,
                  "title": "List Wherobots Catalog Tables"
                },
                "description": "List all tables in a given database.\n\n\u26a0\ufe0f WORKFLOW: Call this after list_databases_tool to find tables in a database.\n\n\ud83d\udccb PREREQUISITES:\n- Call search_documentation_tool first\n- Call list_catalogs_tool and list_databases_tool to navigate to the database\n\n\ud83d\udccb NEXT STEPS after this tool:\n1. Use describe_table_tool to get the schema of tables you want to query\n2. Use generate_spatial_query_tool to create SQL using the schema\n3. Use execute_query_tool to test the query\n\nThis tool retrieves all tables within a specified database in a catalog. It is used to explore\nthe final level of the data hierarchy before accessing table schemas.\n\nParameters\n----------\ncatalog : str\n    The name of the catalog.\ndatabase : str\n    The name of the database.\nctx : Context\n    FastMCP context (injected automatically)\n\nReturns\n-------\nTableListOutput\n    A structured object containing table information.\n    - 'catalog': The catalog name.\n    - 'database': The database name.\n    - 'tables': List of table names.\n    - 'count': Number of tables found.\n\nExample Usage for LLM:\n- When user asks for a specific database's tables.\n- Example User Queries and corresponding Tool Calls:\n\n- User: \"List all tables in the 'default' database of the 'wherobots' catalog.\"\n- Tool Call: list_tables('wherobots', 'default')\n\n- User: \"What tables are in the overture database?\"\n- Tool Call: list_tables('wherobots_open_data', 'overture')",
                "inputSchema": {
                  "properties": {
                    "catalog": {
                      "type": "string"
                    },
                    "database": {
                      "type": "string"
                    }
                  },
                  "required": [
                    "catalog",
                    "database"
                  ],
                  "type": "object"
                },
                "name": "list_tables_tool",
                "outputSchema": {
                  "properties": {
                    "catalog": {
                      "description": "Name of the catalog.",
                      "type": "string"
                    },
                    "count": {
                      "description": "Total number of tables.",
                      "type": "integer"
                    },
                    "database": {
                      "description": "Name of the database.",
                      "type": "string"
                    },
                    "tables": {
                      "description": "List of table names.",
                      "items": {
                        "type": "string"
                      },
                      "type": "array"
                    }
                  },
                  "required": [
                    "catalog",
                    "database",
                    "tables",
                    "count"
                  ],
                  "type": "object"
                },
                "title": "List Wherobots Catalog Tables"
              },
              {
                "_meta": {
                  "_fastmcp": {
                    "tags": []
                  }
                },
                "annotations": {
                  "readOnlyHint": true,
                  "title": "List Wherobots Managed Catalog Hierarchy"
                },
                "description": "Get complete hierarchy of catalogs, databases, and tables.\n\n\u26a0\ufe0f WORKFLOW: Use this for a quick overview of all managed catalogs.\nFor external catalogs, use list_catalogs_tool instead.\n\n\ud83d\udccb PREREQUISITES:\n- Call search_documentation_tool first to understand what data you need\n\n\ud83d\udccb NEXT STEPS after this tool:\n1. Use describe_table_tool to get schemas of tables you want to query\n2. Use list_catalogs_tool to discover external catalogs not shown here\n\nThis tool provides a comprehensive view of all available assets in the Wherobots system,\nincluding their hierarchical relationships. It can be used to retrieve\ninformation about all catalogs, list all databases within those catalogs,\nand enumerate all tables within each database.\n\n***\nIMPORTANT LIMITATION:\n- This tool is being DEPRECATED, but is the only way to get a full hierarchy in one call.\n- This tool ONLY shows catalogs managed within Wherobots.\n- External catalogs (e.g., on Databricks, other cloud platforms) are NOT visible in this hierarchy.\n- If the user mentions specific catalog names that don't appear in the results, they may be\n  external catalogs that need to be accessed differently.\n- ALWAYS call list_catalogs_tool before or after calling this tool.\n***\n\nParameters\n----------\nctx : Context\n    FastMCP context (injected automatically)\n\nReturns\n-------\nHierarchyListOutput\n    A structured object containing the hierarchy of catalogs, databases, and tables.\n    - 'hierarchy': A dictionary representing the hierarchical structure, where keys are catalog names.\n              Each catalog entry contains a dictionary of its databases.\n              Each database entry includes a list of its tables.\n              Each table entry contains its name.\n    - 'summary': A dictionary providing counts of total catalogs, databases, and tables.\n\nExample Usage for LLM:\n- When user asks for a general overview of data, or specific items across multiple catalogs/databases.\n- Example User Queries and corresponding Tool Calls:\n\n- User: \"List all tables in the 'default' database of the 'wherobots' catalog AND in the 'overture_maps_foundation' database of 'wherobots_open_data'.\"\n- Tool Call: list_hierarchy()\n\n- User: \"Show me all databases in 'wherobots' and 'wherobots_open_data' catalogs.\"\n- Tool Call: list_hierarchy()\n\n- User: \"What data is available?\"\n- Tool Call: list_hierarchy()",
                "inputSchema": {
                  "properties": {},
                  "type": "object"
                },
                "name": "list_hierarchy_tool",
                "outputSchema": {
                  "$defs": {
                    "CatalogInfo": {
                      "properties": {
                        "databases": {
                          "additionalProperties": {
                            "$ref": "#/$defs/DatabaseInfo"
                          },
                          "description": "Databases in the catalog.",
                          "type": "object"
                        }
                      },
                      "required": [
                        "databases"
                      ],
                      "type": "object"
                    },
                    "DatabaseInfo": {
                      "properties": {
                        "tables": {
                          "description": "List of tables in the database.",
                          "items": {
                            "$ref": "#/$defs/TableInfo"
                          },
                          "type": "array"
                        }
                      },
                      "required": [
                        "tables"
                      ],
                      "type": "object"
                    },
                    "HierarchySummary": {
                      "properties": {
                        "catalogs_count": {
                          "description": "Total number of catalogs.",
                          "type": "integer"
                        },
                        "databases_count": {
                          "description": "Total number of databases.",
                          "type": "integer"
                        },
                        "tables_count": {
                          "description": "Total number of tables.",
                          "type": "integer"
                        }
                      },
                      "required": [
                        "catalogs_count",
                        "databases_count",
                        "tables_count"
                      ],
                      "type": "object"
                    },
                    "TableInfo": {
                      "properties": {
                        "name": {
                          "description": "Name of the table.",
                          "type": "string"
                        }
                      },
                      "required": [
                        "name"
                      ],
                      "type": "object"
                    }
                  },
                  "properties": {
                    "hierarchy": {
                      "additionalProperties": {
                        "$ref": "#/$defs/CatalogInfo"
                      },
                      "description": "Catalog hierarchy.",
                      "type": "object"
                    },
                    "summary": {
                      "$ref": "#/$defs/HierarchySummary",
                      "description": "Summary of the hierarchy."
                    }
                  },
                  "required": [
                    "hierarchy",
                    "summary"
                  ],
                  "type": "object"
                },
                "title": "List Wherobots Managed Catalog Hierarchy"
              },
              {
                "_meta": {
                  "_fastmcp": {
                    "tags": []
                  }
                },
                "annotations": {
                  "readOnlyHint": true,
                  "title": "Describe Wherobots Catalog Table"
                },
                "description": "Describe a specific table.\n\n\u26a0\ufe0f WORKFLOW: ALWAYS call this before writing queries that reference a table.\nUnderstanding the schema is essential for writing correct SQL queries.\n\n\ud83d\udccb PREREQUISITES:\n- Call search_documentation_tool first\n- Use list_catalogs_tool, list_databases_tool, list_tables_tool to find the table\n\n\ud83d\udccb NEXT STEPS after this tool:\n1. Use generate_spatial_query_tool to create SQL using the schema\n2. Use execute_query_tool to test the query\n\nThis tool retrieves the schema of a specified table, including column names and types.\nIt is used to understand the structure of a table before querying or analysis.\n\nParameters\n----------\ncatalog : str\n    The name of the catalog.\ndatabase : str\n    The name of the database.\ntable : str\n    The name of the table.\nctx : Context\n    FastMCP context (injected automatically)\n\nReturns\n-------\nTableDescriptionOutput\n    A structured object containing the table schema information.\n    - 'schema': The schema of the table, which may include column names, types, and other metadata.\n\nExample Usage for LLM:\n- When user asks for the schema of a specific table.\n- Example User Queries and corresponding Tool Calls:\n\n- User: \"What is the schema of the 'users' table in the 'default' database of the 'wherobots' catalog?\"\n- Tool Call: describe_table('wherobots', 'default', 'users')\n\n- User: \"Describe the buildings table structure\"\n- Tool Call: describe_table('wherobots_open_data', 'overture', 'buildings')",
                "inputSchema": {
                  "properties": {
                    "catalog": {
                      "type": "string"
                    },
                    "database": {
                      "type": "string"
                    },
                    "table": {
                      "type": "string"
                    }
                  },
                  "required": [
                    "catalog",
                    "database",
                    "table"
                  ],
                  "type": "object"
                },
                "name": "describe_table_tool",
                "outputSchema": {
                  "$defs": {
                    "NestedField": {
                      "properties": {
                        "doc": {
                          "anyOf": [
                            {
                              "type": "string"
                            },
                            {
                              "type": "null"
                            }
                          ],
                          "default": null
                        },
                        "id": {
                          "type": "integer"
                        },
                        "name": {
                          "type": "string"
                        },
                        "required": {
                          "anyOf": [
                            {
                              "type": "boolean"
                            },
                            {
                              "type": "null"
                            }
                          ],
                          "default": false
                        },
                        "type": {
                          "anyOf": [
                            {
                              "type": "string"
                            },
                            {
                              "additionalProperties": true,
                              "type": "object"
                            }
                          ]
                        }
                      },
                      "required": [
                        "id",
                        "name",
                        "type"
                      ],
                      "type": "object"
                    }
                  },
                  "properties": {
                    "schema": {
                      "description": "Table schema fields",
                      "items": {
                        "$ref": "#/$defs/NestedField"
                      },
                      "type": "array"
                    }
                  },
                  "required": [
                    "schema"
                  ],
                  "type": "object"
                },
                "title": "Describe Wherobots Catalog Table"
              },
              {
                "_meta": {
                  "_fastmcp": {
                    "tags": []
                  }
                },
                "annotations": {
                  "readOnlyHint": true,
                  "title": "Generate Spatial SQL Query"
                },
                "description": "Generate a spatial query based on the provided content.\n\n\u26a0\ufe0f WORKFLOW: Call this ONLY after exploring docs and catalog.\nFor best results, ensure you have already:\n1. Called search_documentation_tool for relevant spatial functions\n2. Used catalog tools to identify available tables\n3. Called describe_table_tool for tables you want to query\n\n\ud83d\udccb PREREQUISITES (strongly recommended):\n- search_documentation_tool: Understand available spatial functions\n- list_catalogs_tool / list_tables_tool: Find relevant tables\n- describe_table_tool: Know the schema of tables you'll query\n\n\ud83d\udccb NEXT STEPS after this tool:\n1. Use execute_query_tool with limit=10 to TEST the query first\n2. Iterate on the query if results are incorrect\n3. Only generate application code AFTER SQL is validated\n\nThis tool allows user to translate their request into a spatial query.\n\nParameters\n----------\nuser_prompt : str\n    The user's request or description of the spatial query they want to generate.\nctx : Context\n    FastMCP context (injected automatically)\n\nReturns\n-------\nQueryGenerationSummaryOutput\n    A structured object containing the generated spatial query.\n\nExample Usage for LLM:\n- When user asks to generate a spatial query based on their request.\n- When a user asks for information, statistics or analysis on data that is in tables\n  within one or more of the catalogs they have access to in Wherobots.\n- Example User Queries and corresponding Tool Calls:\n\n- User: \"Generate a SQL query to count buildings in California using Overture data.\"\n- Tool Call: generate_spatial_query(\"Generate a SQL query to count buildings in California using Overture data.\")\n\n- User: \"How can I find all parks within 5km of downtown Seattle?\"\n- Tool Call: generate_spatial_query(\"How can I find all parks within 5km of downtown Seattle?\")",
                "inputSchema": {
                  "properties": {
                    "user_prompt": {
                      "type": "string"
                    }
                  },
                  "required": [
                    "user_prompt"
                  ],
                  "type": "object"
                },
                "name": "generate_spatial_query_tool",
                "outputSchema": {
                  "properties": {
                    "next_step": {
                      "default": "Call execute_query_tool with limit=10 to test this query before using it in code.",
                      "description": "Recommended next action in the workflow.",
                      "type": "string"
                    },
                    "query": {
                      "description": "The generated spatial query.",
                      "type": "string"
                    }
                  },
                  "required": [
                    "query"
                  ],
                  "type": "object"
                },
                "title": "Generate Spatial SQL Query"
              },
              {
                "_meta": {
                  "_fastmcp": {
                    "tags": []
                  }
                },
                "annotations": {
                  "title": "Execute SQL Query"
                },
                "description": "Run the SQL query on a Wherobots catalog.\n\n\u26a0\ufe0f WORKFLOW: ALWAYS test queries with this tool before generating code.\nUse limit=10 or limit=100 for initial testing to validate query logic.\n\n\ud83d\udccb PREREQUISITES (required for reliable results):\n- search_documentation_tool: Understand correct SQL syntax\n- describe_table_tool: Verify table schema and column names\n- generate_spatial_query_tool: Generate the SQL (recommended)\n\n\ud83d\udccb NEXT STEPS after this tool:\n- If query SUCCEEDS: Increase limit or remove it for full results\n- If query FAILS: Use sql_debug_workflow prompt, check schema, retry\n- Only generate application code AFTER SQL is validated and working\n\nThis tool allows users to execute SQL queries against the Wherobots catalog.\nIt is typically used for data retrieval and analysis. Supports pagination\nfor large result sets.\n\n***\nRemember:\n- Ensure the output can be serialized to JSON.\n- If query execution fails, analyze the error and provide a meaningful message to the user.\n- Use limit and offset parameters for large result sets to avoid timeouts.\n- Queries have a maximum execution time (configurable via settings or x-query-timeout header).\n- The runtime ID can be customized via the x-runtime-id header (default: tiny).\n- The runtime region can be customized via the x-runtime-region header (default: aws-us-west-2).\n- The server sends periodic heartbeat messages during long-running queries to keep the connection alive.\n- If the client disconnects, the query will be cancelled to avoid wasting resources.\n***\n\nParameters\n----------\nquery : str\n    The SQL query to be executed.\nctx : Context\n    FastMCP context (injected automatically)\nlimit : int | None\n    Optional maximum number of rows to return (default: 1000, max: 10000)\noffset : int | None\n    Optional number of rows to skip for pagination (default: 0)\n\nReturns\n-------\nQueryExecutionOutput\n    A structured object containing the results of the query execution.\n    - 'success': Whether the query executed successfully\n    - 'row_count': Number of rows returned\n    - 'data': Query results as a list of dictionaries\n    - 'query': The executed SQL query\n    - 'error': Whether an error occurred\n    - 'error_type': Type of error (if any)\n    - 'error_message': Error message (if any)\n    - 'execution_status': Status of execution\n\nExample Usage for LLM:\n- When user asks to run a specific SQL query.\n- Example User Queries and corresponding Tool Calls:\n\n- User: \"Run the following SQL query: SELECT * FROM buildings WHERE state = 'California';\"\n- Tool Call: execute_query('SELECT * FROM buildings WHERE state = 'California';')\n\n- User: \"Execute this query with only the first 100 results\"\n- Tool Call: execute_query('SELECT * FROM large_table;', limit=100)\n\n- User: \"Get the next page of results\"\n- Tool Call: execute_query('SELECT * FROM large_table;', limit=100, offset=100)",
                "inputSchema": {
                  "properties": {
                    "limit": {
                      "anyOf": [
                        {
                          "type": "integer"
                        },
                        {
                          "type": "null"
                        }
                      ],
                      "default": null
                    },
                    "offset": {
                      "anyOf": [
                        {
                          "type": "integer"
                        },
                        {
                          "type": "null"
                        }
                      ],
                      "default": null
                    },
                    "query": {
                      "type": "string"
                    }
                  },
                  "required": [
                    "query"
                  ],
                  "type": "object"
                },
                "name": "execute_query_tool",
                "outputSchema": {
                  "properties": {
                    "data": {
                      "description": "Query result data",
                      "items": {
                        "additionalProperties": true,
                        "type": "object"
                      },
                      "type": "array"
                    },
                    "error": {
                      "anyOf": [
                        {
                          "type": "boolean"
                        },
                        {
                          "type": "null"
                        }
                      ],
                      "default": null,
                      "description": "Whether an error occurred"
                    },
                    "error_message": {
                      "anyOf": [
                        {
                          "type": "string"
                        },
                        {
                          "type": "null"
                        }
                      ],
                      "default": null,
                      "description": "Error message if any"
                    },
                    "error_type": {
                      "anyOf": [
                        {
                          "type": "string"
                        },
                        {
                          "type": "null"
                        }
                      ],
                      "default": null,
                      "description": "Type of error if any"
                    },
                    "execution_status": {
                      "anyOf": [
                        {
                          "type": "string"
                        },
                        {
                          "type": "null"
                        }
                      ],
                      "default": null,
                      "description": "Execution status"
                    },
                    "next_step": {
                      "anyOf": [
                        {
                          "type": "string"
                        },
                        {
                          "type": "null"
                        }
                      ],
                      "default": null,
                      "description": "Recommended next action based on results or errors."
                    },
                    "query": {
                      "description": "The executed SQL query",
                      "type": "string"
                    },
                    "row_count": {
                      "description": "Number of rows returned",
                      "type": "integer"
                    },
                    "success": {
                      "default": true,
                      "description": "Whether the query execution was successful",
                      "type": "boolean"
                    }
                  },
                  "required": [
                    "row_count",
                    "data",
                    "query"
                  ],
                  "type": "object"
                },
                "title": "Execute SQL Query"
              },
              {
                "_meta": {
                  "_fastmcp": {
                    "tags": []
                  }
                },
                "annotations": {
                  "readOnlyHint": true,
                  "title": "Search Wherobots Documentation"
                },
                "description": "Search the Wherobots documentation.\n\n\u26a0\ufe0f WORKFLOW: This should be your FIRST tool call for any query task.\nBefore writing queries, ALWAYS search documentation to understand:\n- Available spatial functions and their syntax\n- Best practices and common patterns\n- Example queries for similar use cases\n\n\ud83d\udccb NEXT STEPS after this tool:\n1. Use catalog tools (list_catalogs, list_databases, list_tables) to find data\n2. Use describe_table_tool to understand table schemas\n3. Use generate_spatial_query_tool to create SQL queries\n\nThis tool searches the official Wherobots documentation to find relevant\ninformation about spatial functions, data formats, best practices, and more.\nIt's useful when users need help understanding Wherobots features or syntax.\n\nParameters\n----------\nquery : str\n    The search query string\nctx : Context\n    FastMCP context (injected automatically)\npage_size : int | None\n    Optional number of results to return (default: 10)\n\nReturns\n-------\nDocumentationSearchOutput\n    A structured object containing documentation search results.\n    - 'results': List of DocumentResult objects, each containing:\n        - 'content': The documentation content snippet\n        - 'path': The URL path to the documentation page\n        - 'metadata': Additional metadata about the result\n\nExample Usage for LLM:\n- When user asks about Wherobots features, functions, or syntax\n- When generating queries and need context about spatial functions\n- Example User Queries and corresponding Tool Calls:\n\n- User: \"How do I use ST_INTERSECTS in Wherobots?\"\n- Tool Call: search_documentation(\"ST_INTERSECTS spatial function\")\n\n- User: \"What spatial functions are available for distance calculations?\"\n- Tool Call: search_documentation(\"spatial distance functions\")\n\n- User: \"How do I connect to Wherobots from Python?\"\n- Tool Call: search_documentation(\"Python connection API\")\n\nFor the best way to understand how to use spatial SQL in Wherobots, refer to the following Wherobots Documentation:\n- Writing Effective Spatial Queries in Wherobots: https://docs.wherobots.com/develop/write-spatial-queries\n- Writing Effective Spatial Queries in Wherobots complete example sub-section: https://docs.wherobots.com/develop/write-spatial-queries#complete-example:-counting-baseball-stadiums-in-the-us\n\nThe complete example demonstrates:\n- Starting the `SedonaContext`\n- Using `wkls` where applicable\n- Loading spatial data from Wherobots tables\n- Using the correct schema from wherobots_open_data spatial catalogs\n- Writing spatial SQL queries effectively",
                "inputSchema": {
                  "properties": {
                    "page_size": {
                      "anyOf": [
                        {
                          "type": "integer"
                        },
                        {
                          "type": "null"
                        }
                      ],
                      "default": null
                    },
                    "query": {
                      "type": "string"
                    }
                  },
                  "required": [
                    "query"
                  ],
                  "type": "object"
                },
                "name": "search_documentation_tool",
                "outputSchema": {
                  "$defs": {
                    "DocumentResult": {
                      "properties": {
                        "content": {
                          "description": "Document content",
                          "type": "string"
                        },
                        "metadata": {
                          "additionalProperties": true,
                          "description": "Arbitrary metadata",
                          "type": "object"
                        },
                        "path": {
                          "description": "Document path or URL",
                          "type": "string"
                        }
                      },
                      "required": [
                        "content",
                        "path"
                      ],
                      "type": "object"
                    }
                  },
                  "properties": {
                    "results": {
                      "description": "List of search results",
                      "items": {
                        "$ref": "#/$defs/DocumentResult"
                      },
                      "type": "array"
                    }
                  },
                  "required": [
                    "results"
                  ],
                  "type": "object"
                },
                "title": "Search Wherobots Documentation"
              }
            ]
          }
        },
        "requested_protocol_version": "2025-03-26",
        "resumed": true,
        "session_id_present": true,
        "transport": "streamable-http",
        "url": "https://api.cloud.wherobots.com/mcp/"
      },
      "latency_ms": 231.18,
      "status": "ok"
    },
    "step_up_auth_probe": {
      "details": {
        "auth_required_checks": [],
        "broad_scopes": [],
        "challenge_headers": [],
        "minimal_scope_documented": false,
        "oauth_present": false,
        "scope_specificity_ratio": 0.0,
        "step_up_signals": [],
        "supported_scopes": []
      },
      "latency_ms": null,
      "status": "missing"
    },
    "tool_snapshot_probe": {
      "details": {
        "reason": "no_tools"
      },
      "latency_ms": null,
      "status": "missing"
    },
    "tools_list": {
      "details": {
        "error": "Client error '400 Bad Request' for url 'https://api.cloud.wherobots.com/mcp'\nFor more information check: https://developer.mozilla.org/en-US/docs/Web/HTTP/Status/400",
        "headers": {
          "content-type": "application/json",
          "mcp-session-id": "759c9fc869dc4ecdb8d3171763c2a40e"
        },
        "http_status": 400,
        "payload": {},
        "url": "https://api.cloud.wherobots.com/mcp/"
      },
      "latency_ms": 311.58,
      "status": "error"
    },
    "transport_compliance_probe": {
      "details": {
        "bad_protocol_error": null,
        "bad_protocol_headers": {
          "content-type": "application/json",
          "mcp-session-id": "4572e25af5ee46fbb96d316559a7ff95"
        },
        "bad_protocol_payload": {
          "error": {
            "code": -32600,
            "message": "Bad Request: Unsupported protocol version: 1999-99-99. Supported versions: 2024-11-05, 2025-03-26, 2025-06-18, 2025-11-25"
          },
          "id": "server-error",
          "jsonrpc": "2.0"
        },
        "bad_protocol_status_code": 400,
        "delete_error": null,
        "delete_status_code": 200,
        "expired_session_error": null,
        "expired_session_status_code": 404,
        "issues": [
          "missing_protocol_header"
        ],
        "last_event_id_visible": false,
        "protocol_header_present": false,
        "requested_protocol_version": "2025-03-26",
        "session_id_present": true,
        "transport": "streamable-http"
      },
      "latency_ms": 321.07,
      "status": "warning"
    },
    "utility_coverage_probe": {
      "details": {
        "completions": {
          "advertised": false,
          "live_probe": "not_executed",
          "sample_target": null
        },
        "initialize_capability_keys": [
          "experimental",
          "prompts",
          "resources",
          "tasks",
          "tools"
        ],
        "pagination": {
          "metadata_signal": false,
          "next_cursor_methods": [],
          "supported": false
        },
        "tasks": {
          "advertised": true,
          "http_status": 400,
          "probe_status": "error"
        }
      },
      "latency_ms": 164.51,
      "status": "warning"
    }
  },
  "failures": {
    "oauth_authorization_server": {
      "reason": "no_authorization_server"
    },
    "oauth_protected_resource": {
      "error": "Client error '404 Not Found' for url 'https://api.cloud.wherobots.com/.well-known/oauth-protected-resource'\nFor more information check: https://developer.mozilla.org/en-US/docs/Web/HTTP/Status/404",
      "url": "https://api.cloud.wherobots.com/.well-known/oauth-protected-resource"
    },
    "openid_configuration": {
      "reason": "no_authorization_server"
    },
    "server_card": {
      "error": "Client error '404 Not Found' for url 'https://api.cloud.wherobots.com/.well-known/mcp/server-card.json'\nFor more information check: https://developer.mozilla.org/en-US/docs/Web/HTTP/Status/404",
      "url": "https://api.cloud.wherobots.com/.well-known/mcp/server-card.json"
    },
    "tools_list": {
      "error": "Client error '400 Bad Request' for url 'https://api.cloud.wherobots.com/mcp'\nFor more information check: https://developer.mozilla.org/en-US/docs/Web/HTTP/Status/400",
      "headers": {
        "content-type": "application/json",
        "mcp-session-id": "759c9fc869dc4ecdb8d3171763c2a40e"
      },
      "http_status": 400,
      "payload": {},
      "url": "https://api.cloud.wherobots.com/mcp/"
    }
  },
  "remote_url": "https://api.cloud.wherobots.com/mcp/",
  "server_card_payload": null,
  "server_identifier": "com.wherobots/mcp-server"
}