Description

PR #1606 changed the database configuration interface from database.name (single string) to
database.names (dictionary with ClpDbNameType.CLP and ClpDbNameType.SPIDER keys). The MCP
server was not updated to use this new interface, causing an AttributeError on startup.

This PR updates clp_connector.py to use the new interface.

Checklist

• The PR satisfies the contribution guidelines.
• This is a breaking change and that has been indicated in the PR title, OR this isn't a
  breaking change.
• Necessary docs have been updated, OR no docs need to be updated.

Validation performed

1. Built the project:

   task

2. Configured the MCP server in build/clp-package/etc/clp-config.yaml:

   mcp_server:
     host: localhost
     port: 8000

3. Started the CLP package:

   cd build/clp-package
   ./sbin/start-clp.sh

4. Compressed sample logs:

   ./sbin/compress.sh --timestamp=timestamp ~/samples/postgresql.jsonl

   Output:

   2025-12-19T05:44:33.210 INFO [compress] Compression job 1 submitted.
   2025-12-19T05:44:35.214 INFO [compress] Compressed 392.84MB into 9.94MB (39.53x). Speed: 211.48MB/s.
   2025-12-19T05:44:35.715 INFO [compress] Compression finished.
   2025-12-19T05:44:35.715 INFO [compress] Compressed 392.84MB into 9.94MB (39.53x). Speed: 183.57MB/s.
   

5. Verified the MCP server is alive:

   curl http://localhost:8000/health

   Output:

   OK
   

6. Initialized an MCP session:

   curl -i -X POST http://localhost:8000/mcp \
     -H "Content-Type: application/json" \
     -H "Accept: application/json, text/event-stream" \
     -d '{
       "jsonrpc": "2.0",
       "id": 1,
       "method": "initialize",
       "params": {
         "protocolVersion": "2024-11-05",
         "capabilities": {},
         "clientInfo": {"name": "test", "version": "1.0"}
       }
     }'

   Output (note the mcp-session-id header):

   HTTP/1.1 200 OK
   ...
   mcp-session-id: 539a40d16a584d40b4c1bf100df7ad0a
   ...
   event: message
   data: {"jsonrpc":"2.0","id":1,"result":{"protocolVersion":"2024-11-05",...,"serverInfo":{"name":"clp-mcp-server","version":"2.14.1"}}}
   

7. Listed available MCP tools:

   curl -X POST http://localhost:8000/mcp \
     -H "Content-Type: application/json" \
     -H "Accept: application/json, text/event-stream" \
     -H "Mcp-Session-Id: 539a40d16a584d40b4c1bf100df7ad0a" \
     -d '{
       "jsonrpc": "2.0",
       "id": 2,
       "method": "tools/list",
       "params": {}
     }'

   Output:

   event: message
   data: {"jsonrpc":"2.0","id":2,"result":{"tools":[{"name":"get_instructions",...},{"name":"get_nth_page",...},{"name":"hello_world",...},{"name":"search_by_kql",...},{"name":"search_by_kql_with_timestamp_range",...}]}}
   

8. Invoked the get_instructions tool (required before other tools):

   curl -X POST http://localhost:8000/mcp \
     -H "Content-Type: application/json" \
     -H "Accept: application/json, text/event-stream" \
     -H "Mcp-Session-Id: 539a40d16a584d40b4c1bf100df7ad0a" \
     -d '{
       "jsonrpc": "2.0",
       "id": 4,
       "method": "tools/call",
       "params": {
         "name": "get_instructions",
         "arguments": {}
       }
     }'

   Output:

   event: message
   data: {"jsonrpc":"2.0","id":4,"result":{"content":[{"type":"text","text":"You are an AI assistant for querying the CLP log database using CLP-KQL (CKQL)..."}],...,"isError":false}}
   

9. Invoked the search_by_kql tool:

   curl -X POST http://localhost:8000/mcp \
     -H "Content-Type: application/json" \
     -H "Accept: application/json, text/event-stream" \
     -H "Mcp-Session-Id: 539a40d16a584d40b4c1bf100df7ad0a" \
     -d '{
       "jsonrpc": "2.0",
       "id": 5,
       "method": "tools/call",
       "params": {
         "name": "search_by_kql",
         "arguments": {
           "kql_query": "1"
         }
       }
     }'

   Output:

   event: message
   data: {"jsonrpc":"2.0","id":5,"result":{"content":[{"type":"text","text":"{\"items\":[\"timestamp: 2023-03-27T00:31:55.999Z, message: {...}\\n, link: http://localhost:4000/streamFile?...\",...],\"num_total_pages\":4,\"num_total_items\":38,\"num_items_per_page\":10,\"has_next\":true,\"has_previous\":false}"}],...,"isError":false}}
   

   ✅ Observed results are getting returned.

Summary by CodeRabbit

• Refactor
  • Updated internal database configuration handling to improve code organization and maintainability. This change does not affect user-facing functionality or application behaviour.

_{✏️ Tip: You can customize this high-level summary in your review settings.}