MCP Variance Log

MIT License

Overview InspectNew Endpoints Schema Related Servers Reviews Score

read_query

Execute SELECT queries on the MCP Variance Log's SQLite database to analyze chat monitoring data, including interaction types, probabilities, and summaries for insights.

Instructions

Execute a SELECT query on the SQLite database

            Schema Reference:
            Table: chat_monitoring
            Fields:
            - log_id (INTEGER PRIMARY KEY)
            - timestamp (DATETIME)
            - session_id (TEXT)
            - user_id (TEXT)
            - interaction_type (TEXT)
            - probability_class (TEXT: HIGH, MEDIUM, LOW)
            - message_content (TEXT)
            - response_content (TEXT)
            - context_summary (TEXT)
            - reasoning (TEXT)

            Example:
            SELECT timestamp, probability_class, context_summary 
            FROM chat_monitoring 
            WHERE probability_class = 'LOW'
            LIMIT 5;
            

Input Schema

Name	Required	Description	Default
`query`	Yes	SELECT SQL query to execute

Input Schema (JSON Schema)

{
  "properties": {
    "query": {
      "description": "SELECT SQL query to execute",
      "type": "string"
    }
  },
  "required": [
    "query"
  ],
  "type": "object"
}

This server cannot be installed

Other Tools from MCP Variance Log

Related Tools

write_query
@truaxki/mcp-variance-log
list_tables
@truaxki/mcp-variance-log
read-logs
@truaxki/mcp-variance-log
query_data
@sam2332/mcp-quick-sqlite3
create_table
@truaxki/mcp-variance-log
describe_table
@truaxki/mcp-variance-log

MCP directory API

We provide all the information about MCP servers via our MCP API.

curl -X GET 'https://glama.ai/api/mcp/v1/servers/truaxki/mcp-variance-log'

If you have feedback or need assistance with the MCP directory API, please join our Discord server