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