Query Table

🚀 mcp_query_table Project Documentation

This project, mcp_query_table, provides functionalities for querying and handling data. It supports different modes of operation and offers useful tips for debugging and usage.

🚀 Quick Start

MCP Support

Ensure that you can execute python -m mcp_query_table -h in the console. If not, you may need to run pip install mcp_query_table first.

You can configure the following settings in Cline. Here, command is the absolute path of python, and timeout is the timeout period in seconds. Since the response time in various AI platforms often exceeds 1 minute, a large timeout value is required.

STDIO Mode

{
  "mcpServers": {
    "mcp_query_table": {
      "timeout": 300,
      "command": "D:\\Users\\Kan\\miniconda3\\envs\\py312\\python.exe",
      "args": [
        "-m",
        "mcp_query_table",
        "--format",
        "markdown",
        "--endpoint",
        "http://127.0.0.1:9222",
        "--executable_path",
        "C:\\Program Files\\Google\\Chrome\\Application\\chrome.exe"
      ]
    }
  }
}

SSE Mode

First, start the MCP service by executing the following command in the console:

python -m mcp_query_table --format markdown --transport sse --port 8000 --endpoint http://127.0.0.1:9222

Then, you can connect to the MCP service:

{
  "mcpServers": {
    "mcp_query_table": {
      "timeout": 300,
      "url": "http://127.0.0.1:8000/sse"
    }
  }
}

💻 Usage Examples

Debugging with MCP Inspector

npx @modelcontextprotocol/inspector python -m mcp_query_table --format markdown --endpoint http://127.0.0.1:9222

Opening the browser and turning pages can be time - consuming, which may cause the MCP Inspector page to time out. You can use http://localhost:5173/?timeout=300000 to set the timeout to 300 seconds.

This is the first attempt to write an MCP project, and there may be various issues. Everyone is welcome to communicate.

MCP Usage Tips

1. Ranking the top 100 stocks with the largest increase in 2024 by their total market capitalization on December 31, 2024. The results from three websites are different:

   • Flush: Displays 2201 stocks. The top 5 are Industrial and Commercial Bank of China, Agricultural Bank of China, China Mobile, PetroChina, and China Construction Bank.
   • Tongdaxin: Displays 100 stocks. The top 5 are Cambricon Technologies, Zhengdan Co., Ltd., Huijin Technology, Wanfeng Auto Holding, and Airong Software.
   • Eastmoney: Displays 100 stocks. The top 5 are Hygon Information, Cambricon Technologies, Kuang - chi Technology, Runze Technology, and New Fiber Optic Network.

2. Large language models have weak ability to split questions. Therefore, you should ask questions reasonably to ensure that the query conditions are not changed. The 2nd and 3rd methods below are recommended:

   • Ranking the top 100 stocks with the largest increase in 2024 by their total market capitalization on December 31, 2024.

     Large language models are very likely to split this sentence, resulting in a single - step query being divided into multiple - step queries.

   • Query from Eastmoney "Ranking the top 100 stocks with the largest increase in 2024 by their total market capitalization on December 31, 2024".

     Use quotation marks to avoid splitting.

   • Query from the Eastmoney sector "The industry sector with the worst increase last year", and then query the top 5 stocks with the best increase in this sector last year.

     Divide the query into two steps: first query the sector, then query the stocks. However, it is best not to make it fully automatic because the model does not understand the difference between "Today's increase" and "Interval increase" in the first - step result, and interactive correction is needed.

📚 Documentation

Support for Streamlit

It enables querying financial data on the same page and manually inputting it into AI for in - depth analysis. Refer to the README.md file in the streamlit directory.

📄 References

• Selenium webdriver cannot attach to the edge instance, and the --remote - debugging - port option of edge is invalid
• MCP Protocol Documentation