Numeracy is a SQL pad that makes writing, iterating, and visualizing faster at every step of your analysis. Version 2.0 includes the launch of parameters that let you avoid writing convoluted SQL syntax, beautiful dashboards, and hundreds of refinements to the query editor.
In getting Bright solar off the ground, I've tried several tools from psql, pgcli, pgweb, Metabase and finally Periscope. For quick analysis, nothing even compares to the raw speed of Numeracy.
Numeracy gets out of my way and lets me write SQL, but goes above and beyond. The automatically calculated column statistics of any query have already helped me identify and fix data bugs I wasn't even looking for, and the "record view" for JSONB types is singlehandedly saving my vision.
This is the simple SQL tool I've been looking for since the first time I used phpMyAdmin, and is steadily replacing my BI use cases too.
Pros:Fast. Beautiful. Fast. Column statistics are incredibly useful.
Cons:Historically is has been dashboarding, can't wait to try it out in 2.0.
The whole engineering team at ZenSourcer team loves how easy Numeracy makes it to write queries, whether that’s to quickly debug a customer issue or throw together a quick analytics dashboard.
Pros:The fastest way to query a database. I haven’t opened psql since I started using Numeracy!
Cons:I wish they could auto-import our chart.io dashboards instead of recreating them manually.
Our entire team has been using Numeracy for a year+ -- it's been rock solid and many of us use it daily. Don't know where we would be without it!
Pros:the fastest, easiest, most collaborative way to query a database
Cons:there's nothing out there as good as this for what it does
Linear
I've been using Numeracy for the last 6 months to track analytics on a wide range of metrics in a SAAS service.
Having built KPI dashboards for my own startups several times in the past I wish Numeracy had existed back then – with less than an hours work you can have a dashboard that aggregates data from across your application. You'll refer to it every day to help you make core business decisions.
Pros:Beautiful design, just the right amount of features
Cons:Still need to brush up on SQL skills to use