No credit cardStart free
·3 min read·Raw Takes

Your Dashboard is a URL

You just ran a SQL query and you want someone else to see the result as a chart. Not a screenshot in Slack. Not a CSV attached to an email. A live chart that updates when the data changes.

It's Very Cool, and We Are Very Proud About It, It is Only Three commands

bash
# Save the query
rq queries create mrr --sql "SELECT month, revenue FROM billing.mrr"
# Turn it into a chart
rq charts create mrr --query mrr --type line --x month --y revenue
# Publish it
rq charts publish mrr
# -> https://rawquery.dev/c/abc123

That link works for anyone. No login. No account. No "request access." You have the link, you see the chart. If you don't, you don't. Want a password? Add --password when you publish.

Pages: multiple charts, one link

A page is a list of charts on a CSS grid. You pick the column count, you list the charts, you set the span if you want something wider. No drag and drop. No canvas. No builder.

bash
rq pages create weekly-kpis --columns 3 \
--charts mrr:3,churn,signups,arpu,ltv,cac
rq pages publish weekly-kpis
# -> https://rawquery.dev/p/xyz789

Six charts, three columns, one URL. Add --refresh 300 and it can auto-refresh. That is an added cost per query, but that is fine if you think it's fine.

Not a BI tool

Charts are a saved query plus rendering. We do not have chart editors, no filter dropdowns, no drill-down. This covers the 80% case where someone just needs to see a number or share a trend, without installing a separate product.

When you need more, rawquery speaks Postgres over the wire protocol. Point Metabase or Grafana at it.

It's also an API

Every saved query is also a REST endpoint. The same query that powers your chart can serve JSON to your app, your Slack bot, or your agent.

bash
# The chart runs this query
rq queries run mrr -f json
# Your app calls the same query via API
curl -H "X-API-Key: rq_..." \
https://api.rawquery.dev/api/v1/workspaces/{id}/saved-queries/mrr/run

One query, three outputs: a chart for humans, an API for machines, a CLI for you and your agent. That's a nice feature - we think.


Raw Takes Short reads on things we built and why they matter (to us). No thought leadership.