Generate formatted analytical reports from the DotMac Omni CRM database via safe SQL queries.
npx skills add https://github.com/michaelayoade/dotmac_crm --skill db-report
Please help me install this Agent Skill. Skill: db-report Source: https://github.com/michaelayoade/dotmac_crm/tree/main/.claude/skills/db-report Command: npx skills add https://github.com/michaelayoade/dotmac_crm --skill db-report
It helps you turn Omni CRM database data into polished, decision-ready analytical reports without manually writing and formatting complex queries.
Ask for a specific report and scope, for example: "Generate a CRM pipeline health report for the last 90 days with a chart of stage counts by month."
High-intent search queries and answers about installing and using this skill.
You can generate CRM analytics reports by translating plain English report requests into safe SQL queries, which then output structured markdown summaries, detail tables, and observations. This process handles recurring analytics tasks like ticket SLA and pipeline health automatically.
Tracking CRM pipeline health involves querying your database for stage counts and conversion metrics over a specific time period, then formatting the results into a structured report. You can also generate Chart.js snippets to visualize time-series and comparison data for pipeline health.
Yes, when your database analytics request involves a time-series or comparison dimension, the system can optionally emit Chart.js-ready JavaScript code. This allows you to directly visualize metrics like subscriber churn or ticket volume over time in your dashboard.
Database reporting standardizes formatting by applying NGN currency, percentages, and durations consistently across all outputs. It also ensures data accuracy by automatically filtering soft-deleted rows using the is_active = true condition in all SQL queries.
Yes, database reporting requires using the omni-db MCP server's execute_sql function to run all SQL queries against the DotMac Omni CRM database. This integration ensures queries are executed safely and return data for your analytical reports.
Automated database reporting covers ticket SLA compliance, pipeline health, inbox performance, agent presence, subscriber churn, project delivery, and fiber build-out progress. These pre-built analytical templates pull metrics directly from the Omni CRM database.
interflownexManage user roles and inspect security configurations in AlloyDB Omni instances.
Sir-chawakornLoad CSV, JSON, or Excel files for cleaning, aggregation, and chart generation with pandas, matplotlib, seaborn, and Chart.js.
iankikuDesign analytics systems, generate SQL queries, plan event tracking, and build dashboards.
autostay-krAnalyze subscription business health using MRR, churn, and unit economics metrics.
