← Back to Skills Marketplace
Mc Db Discovery
by
Guillaume Maka
· GitHub ↗
· v1.0.0
· MIT-0
33
Downloads
0
Stars
0
Active Installs
1
Versions
Install in OpenClaw
/install mc-db-discovery
Description
Systematic workflow to locate and verify the Mission Control SQLite database when path assumptions fail, and reconcile frontend/backend schema mismatches.
README (SKILL.md)
- Step 1: When DB file not found at expected path, trace createDb() calls in server code to find the resolvedPath (defaults to ~/.mc/data/mission-control.db).
- Step 2: Verify DB existence with: ls -la ~/.mc/data/mission-control.db
- Step 3: Inspect schema with: sqlite3 ~/.mc/data/mission-control.db ".schema tasks"
- Step 4: Check actual column names (e.g., 'state' vs 'status'); adjust frontend types or backend schema accordingly.
- Step 5: Validate data inserted correctly: sqlite3 ~/.mc/data/mission-control.db "SELECT * FROM tasks ORDER BY timestamp DESC LIMIT 5;"
- Pitfall: The frontend Task interface may use 'status' while the DB uses 'state'; always verify before debugging application logic.
How to Use
- Make sure OpenClaw is installed (local or Docker)
- Run the install command in chat:
/install mc-db-discovery - After installation, invoke the skill by name or use
/mc-db-discovery - Provide required inputs per the skill's parameter spec and get structured output
Version History
v1.0.0
Initial release providing a systematic workflow for locating, verifying, and troubleshooting the Mission Control SQLite database.
- Guides users to trace createDb() calls to find the actual database path.
- Details steps to verify the database file and inspect its schema.
- Helps reconcile frontend/backend schema mismatches, especially with differing column names (e.g., 'state' vs 'status').
- Includes commands to validate database structure and recent data.
- Highlights common pitfalls in frontend-backend integration.
Metadata
Frequently Asked Questions
What is Mc Db Discovery?
Systematic workflow to locate and verify the Mission Control SQLite database when path assumptions fail, and reconcile frontend/backend schema mismatches. It is an AI Agent Skill for Claude Code / OpenClaw, with 33 downloads so far.
How do I install Mc Db Discovery?
Run "/install mc-db-discovery" in the OpenClaw or Claude Code chat to install it in one step — no extra setup required.
Is Mc Db Discovery free?
Yes, Mc Db Discovery is completely free, licensed under MIT-0. You can download, install and use it at no cost.
Which platforms does Mc Db Discovery support?
Mc Db Discovery is cross-platform and runs anywhere OpenClaw / Claude Code is available (cross-platform).
Who created Mc Db Discovery?
It is built and maintained by Guillaume Maka (@guillaumemaka); the current version is v1.0.0.
More Skills