Sentiment Distribution
Top Agents by Call Volume
Voice of Customer: Top Objections
Frequent keywords from negative sentiment calls
🛡️ Security Playground
Test the read-only security layer.
Try SELECT * FROM audio_detail LIMIT 5 ✅ or DROP TABLE audio_features ❌
❓ Example Questions for the RAG Chatbot
Click any question to send it to the chatbot
📊 Sentiment Analysis
Powered by get_sentiment_distribution
👤 Agent Performance
Powered by get_agent_performance_metrics
📞 Concurrent Call Analysis
Powered by get_max_concurrent_calls
📋 Call Outcomes
Powered by run_read_only_query
🔬 Advanced Queries
Powered by run_read_only_query — any SELECT is allowed
About TruInsights MCP
TruInsights is a secure, AI-powered call center analytics platform built on the Model Context Protocol (MCP). It allows AI agents and humans to query call data through natural language, while enforcing strict read-only security at the core level.
🔒 Core Layer
core/security.py — SQL firewall that blocks INSERT, UPDATE, DELETE, DROP.
core/auth.py — API key validation.
core/server.py — Base MCP server with security built in.
🔧 Project Layer
projects/truinsights/server.py — Defines the MCP Tools that AI agents can call.
Tools include run_read_only_query, get_sentiment_distribution, etc.
💾 Data Layer
scripts/load_json_db.py — ETL script that ingests 23+ JSON dump files into
SQLite.
Database: truinsights.db
🛠️ Available MCP Tools
| Tool | Description |
|---|---|
run_read_only_query |
Execute any SELECT query securely. Blocks all data-modifying statements. |
get_sentiment_distribution |
Returns sentiment breakdown for pie charts. |
get_agent_performance_metrics |
Top agents ranked by call volume and average duration. |
get_top_objections |
Finds frequent objection keywords from negative sentiment calls. |
get_max_concurrent_calls |
Peak simultaneous calls using event-based overlap analysis. |
list_available_tables |
Lists all tables in the database. |
get_table_schema |
Returns column names and types for any table. |
🔌 Access Methods
📊 This Dashboard
python api.py → http://localhost:8000
🔍 MCP Inspector
npx @modelcontextprotocol/inspector python projects/truinsights/server.py
🤖 Claude Desktop
Add to claude_desktop_config.json
🌐 SSE API
python projects/truinsights/run_sse.py → http://localhost:8000/sse