MCP Variance Log

MIT License

Overview InspectNew Schema Related Servers Reviews Score

read_query

Execute SELECT queries on the MCP Variance Log SQLite database to analyze chat monitoring data, including timestamps, probability classes, and context summaries, for identifying unusual conversation patterns.

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"
}

You must be authenticated.

Other Tools from MCP Variance Log

Related Tools

create_table
@truaxki/mcp-variance-log
describe_table
@truaxki/mcp-variance-log
write_query
@truaxki/mcp-variance-log
list_tables
@truaxki/mcp-variance-log
read-logs
@truaxki/mcp-variance-log

ID: acqq8twrk6