sqlite-inspector
Проверка консистентности данных в SQLite базах данных MikoPBX после операций REST API. Использовать при валидации результатов API, отладке проблем с данными, проверке связей внешних ключей или инспектировании CDR записей для тестирования.
Security Assessment
About sqlite-inspector
The sqlite-inspector skill is designed to provide quick and efficient verification of SQLite databases used by MikoPBX after performing REST API operations. This skill ensures data consistency, validates foreign key relationships, and checks referential integrity within the database, which is critical for maintaining the accuracy and integrity of the data after API interactions. It also helps debug data issues at the lowest level of the database, making it a valuable tool for troubleshooting and testing.
FAQ
How do I verify that a REST API operation has correctly modified the database?
You can use this skill to execute SQL queries within the MikoPBX Docker container, checking if the database was updated correctly after operations like create, update, or delete via the API.
Can this skill validate foreign key relationships?
Yes, the skill includes functionality to validate foreign key relationships between tables, ensuring referential integrity within the database.
Do I need a special environment to use this skill?
This skill requires access to a MikoPBX Docker container and uses the `sqlite3` command to execute queries inside the container.
Can I use this skill to inspect CDR records?
Yes, the skill allows you to inspect Call Detail Records (CDR) stored in the database, which can be useful for verifying call routing and testing call history.
What format can I expect the query results in?
You can receive query results in multiple formats including column-based (default), JSON (for script processing), and CSV for exports.
Install sqlite-inspector
Quick Setup:
- Copy the skill folder to
.claude/skills/ - Claude will automatically detect and use the skill
Repository
mikopbx/Core