Compare REST API results with MikoPBX SQLite database tables to identify data integrity gaps.
npx skills add https://github.com/mikopbx/Core --skill sqlite-inspector
Please help me install this Agent Skill. Skill: sqlite-inspector Source: https://github.com/mikopbx/Core/tree/main/.claude/skills/sqlite-inspector Command: npx skills add https://github.com/mikopbx/Core --skill sqlite-inspector
Quick verification of data consistency in SQLite databases and referential integrity after REST API operations.
Use docker exec to query /cf/conf/mikopbx.db and/or CDR databases; supports multiple output formats.
High-intent search queries and answers about installing and using this skill.
Database integrity verification compares REST API results against your SQLite database to catch data consistency gaps. Query the MikoPBX database using docker exec with sqlite3 to inspect tables like m_Extensions, m_Sip, m_Providers, and CDR records, then cross-reference API responses to identify mismatches or missing data.
Yes. Run sqlite3 queries inside your Docker container against /cf/conf/mikopbx.db to inspect foreign key relationships across m_Extensions, m_Sip, m_Providers, m_IncomingRoutingTable, m_OutgoingRoutingTable, and m_CallQueues. This reveals broken references and orphaned records.
Query the cdr_general and cdr tables directly via docker exec and sqlite3 to inspect call records for routing accuracy and data gaps. Compare results with API endpoints to identify where CDR entries diverge from expected state.
Yes. The Skill requires both docker and sqlite3 to execute queries inside your MikoPBX container and access the /cf/conf/mikopbx.db file. These are listed as core dependencies for running database verification.
The Skill supports multiple output formats when querying SQLite databases via docker exec. Specify your preferred format (e.g., CSV, JSON, or table) in the sqlite3 command to tailor results for downstream analysis or reporting.
Verify database consistency when API operations complete but you suspect data didn't persist correctly, when debugging foreign key violations, or during testing to confirm that database state matches expected API outcomes before deployment.
mikopbxObtain JWT Bearer tokens for the MikoPBX REST API v3 via curl.
team-telnyxGenerate and retrieve Telnyx usage reports with Ruby SDK examples.
seb1nDeploy trained machine learning models via REST APIs, Docker, and Kubernetes.
vishalsachdevInstall and configure a Claude Code skill tracking system with hook scripts and JSONL logs.
