# ggsql

19 Hacker News commenters recommended ggsql and 2 criticized it, November 2025 to November 2026. It was recommended in 4 of 13 months. It meets the Hacker Approved badge rule.

**Verdict:** Lets you plot charts directly from SQL using a ggplot-style layered grammar. Main caveat: critics say the docs are thin and it adds little beyond R or Python.

## Why people recommend it

- Plots charts directly from SQL (3 comments): "Brings plotting to Sql instead of “transforming” sql for plotting." ([source](https://news.ycombinator.com/item?id=47833906)) "plotting directly from SQL would be great" ([source](https://news.ycombinator.com/item?id=47834991)) "There’s certainly some benefit in a declarative language for creating charts from SQL. Obviously this doesn’t do anything that you can’t also do easily in R or Python" ([source](https://news.ycombinator.com/item?id=47839148))
- Useful for agents and dbt (3 comments): "implements it as SQL user defined functions which is even more agent friendly" ([source](https://news.ycombinator.com/item?id=49133743)) "I think this could be incredible for agentic analytics." ([source](https://news.ycombinator.com/item?id=47834790)) "I like it. I can see a world where these visuals become my serving layer in dbt." ([source](https://news.ycombinator.com/item?id=47839925))
- Fits ggplot and Posit ecosystem (2 comments): "I love ggsql, the team behind it, ggplot and the tidyverse in general!" ([source](https://news.ycombinator.com/item?id=49707998)) "ggsql looks great for Posit's ecosystem (ggplot2 and plotnine)." ([source](https://news.ycombinator.com/item?id=47862974))
- Promising general visualization standard (2 comments): "this is a very promising idea for the visualization standardisation" ([source](https://news.ycombinator.com/item?id=47844859)) "it has potential as a general solution for that space between data" ([source](https://news.ycombinator.com/item?id=47845680))

## What people warn about

- Documentation is incomplete (2 comments): "A notable omission in the ggsql docs: I cannot find any mention of the possible outputs." ([source](https://news.ycombinator.com/item?id=47838102)) "Please just document the library itself before making a bunch of videos" ([source](https://news.ycombinator.com/item?id=47836590))

## Alternatives hackers recommend

- [ChartGPU](https://hackerapproved.com/p/chartgpu.md): 35 recommend
- [ggplot2](https://hackerapproved.com/p/ggplot2.md): 29 recommend
- [plotnine](https://hackerapproved.com/p/plotnine.md): 22 recommend
- [Matplotlib](https://hackerapproved.com/p/matplotlib.md): 17 recommend
- [Flint visualization language](https://hackerapproved.com/p/flint.md): 15 recommend

## Cite as

Hacker Approved, "ggsql", https://hackerapproved.com/p/ggsql/ (counts from 1,795,640 Hacker News comments, November 2025 to November 2026).