Panther MCP Server

Instructions

Implementation Reference

• src/mcp_panther/panther_mcp_core/tools/data_lake.py:577-625 (handler)

  The primary handler and registration for the 'list_databases' MCP tool. Decorated with @mcp_tool and implements the core logic by executing LIST_DATABASES_QUERY.

  @mcp_tool(
      annotations={
          "permissions": all_perms(Permission.DATA_ANALYTICS_READ),
          "readOnlyHint": True,
      }
  )
  async def list_databases() -> Dict[str, Any]:
      """List all available datalake databases in Panther.
  
      Returns:
          Dict containing:
          - success: Boolean indicating if the query was successful
          - databases: List of databases, each containing:
              - name: Database name
              - description: Database description
          - message: Error message if unsuccessful
      """
  
      logger.info("Fetching datalake databases")
  
      try:
          # Execute the query using shared client
          result = await _execute_query(LIST_DATABASES_QUERY, {})
  
          # Get query data
          databases = result.get("dataLakeDatabases", [])
  
          if not databases:
              logger.warning("No databases found")
              return {"success": False, "message": "No databases found"}
  
          logger.info(f"Successfully retrieved {len(databases)} results")
  
          # Format the response
          return {
              "success": True,
              "status": "succeeded",
              "databases": databases,
              "stats": {
                  "database_count": len(databases),
              },
          }
      except Exception as e:
          logger.error(f"Failed to fetch database results: {str(e)}")
          return {
              "success": False,
              "message": f"Failed to fetch database results: {str(e)}",
          }

• src/mcp_panther/panther_mcp_core/queries.py:88-95 (helper)

  GraphQL query definition used by list_databases tool to retrieve the list of available data lake databases.

  LIST_DATABASES_QUERY = gql("""
  query ListDatabases {
      dataLakeDatabases {
          name
          description
      }
  }
  """)