Generate optimized SQL queries for BI dashboards with Russian field labels.
npx skills add https://github.com/modus-bi/dtp-bi-dashboards --skill generate-sql
Please help me install this Agent Skill. Skill: generate-sql Source: https://github.com/modus-bi/dtp-bi-dashboards/tree/main/skills/generate-sql Command: npx skills add https://github.com/modus-bi/dtp-bi-dashboards --skill generate-sql
This Skill generates optimized SQL queries for BI dashboards, ensuring correct sorting, appropriate data types (::INTEGER), rounded values, and Russian field names for clear chart legends.
Ask for a BI SQL query (e.g., "top-10 regions by revenue") and receive a ready-to-run SQL template.
High-intent search queries and answers about installing and using this skill.
SQL query generation for BI dashboards uses predefined patterns like Top-N and Time Series while enforcing ORDER BY, ::INTEGER casting, and ROUND functions to ensure optimized, dashboard-ready outputs with correct data types and sorting.
Available SQL patterns for dashboard-ready data extraction include Top-N rankings, Time Series tracking, Year-over-Year comparisons, percentage distributions, correlations, and cohorts. These templates provide structured analytic datasets that feed directly into BI visuals.
Handling NULL values and rounding in BI SQL queries involves applying enforced data-quality rules, including NULL handling logic, ROUND functions for decimal precision, and ::INTEGER casting to ensure clean, chart-ready datasets.
Yes, you can generate SQL queries with localized Russian field labels by using locale-friendly aliases like AS "Регион" directly in the query, producing clear Russian chart legends for BI dashboards without manual translation.
The best way to write a Year-over-Year comparison query for a dashboard is to use a predefined YoY SQL pattern that enforces proper ORDER BY sorting and data-type casting. This produces optimized, dashboard-ready datasets for time-based comparisons.
BI dashboard SQL queries fail to sort or round values correctly when missing ORDER BY clauses or ROUND functions disrupt data formatting. Enforcing syntax, performance, and data-quality rules like ::INTEGER casting and NULL handling resolves these output errors.
ai-integr8torExplore database schemas to discover tables, columns, and relationships.
modus-biGenerate PostgreSQL queries for BI dashboards with ordering, rounding, and Russian aliases.
robkiskCreate and update Databricks AI/BI dashboards with SQL validation and deployment.
luokai25Analyze data with SQL, Python, and visualization tools for dashboards.
