Labsco
truaxki logo

MCP Variance Log

β˜… 4

from truaxki

Logs statistical variations and unusual events in conversation structures to a SQLite database.

πŸ”₯πŸ”₯βœ“ VerifiedFreeQuick setup

MCP Variance Log

Agentic tool that looks for statistical variations in conversation structure and logs unusual events to a SQLite database. Built using the Model Context Protocol (MCP), this system is designed to be used with Claude Desktop or other MCP-compatible clients.

Variance Log MCP server

Tools

Monitoring

  • log-query: Tracks conversation patterns
    • HIGH: Common interactions (not logged)
    • MEDIUM: Unusual patterns (logged)
    • LOW: Critical events (priority logged)

Query

  • read-logs: View logs with filtering
  • read_query: Execute SELECT queries
  • write_query: Execute INSERT/UPDATE/DELETE
  • create_table: Create tables
  • list_tables: Show all tables
  • describe_table: Show table structure

Located at data/varlog.db relative to installation.

Schema

CREATE TABLE chat_monitoring (
    log_id INTEGER PRIMARY KEY AUTOINCREMENT,
    timestamp DATETIME DEFAULT CURRENT_TIMESTAMP,
    session_id TEXT NOT NULL,
    user_id TEXT NOT NULL,
    interaction_type TEXT NOT NULL,
    probability_class TEXT CHECK(probability_class IN ('HIGH', 'MEDIUM', 'LOW')),
    message_content TEXT NOT NULL,
    response_content TEXT NOT NULL,
    context_summary TEXT,
    reasoning TEXT
);

Support

Issues: GitHub Issues