ggsql extends SQL so you can write data queries and visualization specs in one composable syntax based on the Grammar of Graphics. It compiles to WebAssembly, works with DuckDB/SQLite and Vega-Lite, and offers an in-browser playground for immediate testing.

Hex is a unified analytics tool that lets technical and non-technical teams query data, build reports, and deploy dashboards using AI-powered agents. It integrates with common data warehouses, dbt metadata, and offers APIs and Slack/Threads embeds to break down silos. Users cite faster insights, self-serve analytics, and significant revenue impact.

The article outlines five steps to turn AI-generated dashboards from eye candy into actionable tools. It covers defining clear questions, matching chart types to those questions, intentional design (colors, layout, context), narrative flow, and thoughtful interactivity. It also shares prompt examples and tips to enforce these rules in any AI charting tool.

mviz is a Claude skill that simplifies the creation of static reports for ad hoc data analysis by converting compact JSON specifications into professional HTML visualizations. It emphasizes a fast, AI-driven workflow that allows users to iterate quickly, generate reports, and utilize a variety of chart types without extensive coding. The tool works seamlessly with data from various sources, including local files and cloud databases.

Superset is a modern, enterprise-ready business intelligence web application designed for data exploration and visualization. It offers a no-code interface, a powerful SQL editor, and support for various SQL databases, making it a flexible alternative to proprietary BI tools. The platform is highly extensible and built for scalability in cloud environments.