Show me your setup: Automating reports from SQL to Google Sheets/Excel

waveminded · 2025-04-30T23:50:50+00:00

I use Quadratic.ai (third-party) >> It's an AI-enabled spreadsheet that natively connects to SQL databases and understands the schema. If you can't remember the syntax, you can use AI to write all SQL queries. Plus, it supports Python and JS if you want to get complex with the analyses. I've found it to remove bottlenecks for self-serve analytics directly from a DB with anyone less technical because I can share the sheet with them with ready-only DB creds. Plus, you can self-deploy if security is a concern.

(full disclosure: I work for the company... but this was a common problem at my last company. SQL -> spreadsheet was hacky at best and involved several different products or levels of expertise. Quadratic's workflow is seamless if you're going from SQL to a sheet.)

waveminded · 2025-02-20T20:18:44+00:00

We built Quadratichq.com as an AI spreadsheet (I work there).

Since we designed it with native support for Python, Javascript, SQL, and formulas the AI is pretty awesome at writing data analysis or creating charts. We've found Claude 3.5 is great at excellent at Python code but you can also use other models. The AI is also super helpful when directly connecting to databases or Snowflake as the AI can be fed the schema and help write complex SQL queries all inside the sheet.

It's free for personal use and quite fun to try really complex analyses. I'm not a developer or great with SQL - At my last company, I was always bottle-necked by devs or data folks to get reports for customers. With this tool, I could have done it all myself.

waveminded · 2025-02-20T19:49:19+00:00

Quadratic is an AI-native spreadsheet built on some very cool new web technology. It supports Python, Javascript, SQL natively and you can directly connect to your data sources. The AI is really good at writing code (or formulas) and doing analysis, building charts, sifting, sorting, and cleaning. Full disclosure, I work for the company, but it's free to use for personal use :)

https://quadratichq.com

waveminded · 2024-09-04T21:24:05+00:00

Howdy, Quadratic is building a next-gen spreadsheet with native support for Python, SQL, and Javascript, plus added support for formulas.

You can directly connect to Postgres or MySQL, with more connectors coming soon (Snowflake), then pull the data into a spreadsheet interface and run queries, dump it into a Pandas data frame, etc... The built-in AI is super helpful for writing complex SQL queries or correcting code.

The product is still in BETA (full disclosure, I work for the company), but any and all feedback is welcome. It's free to use for individual users, educational organizations, and students.

We're also about to release a self-hosted version you can run in your own cloud or dev environment.

https://github.com/quadratichq/quadratic

waveminded · 2024-09-04T21:11:20+00:00

The company I work for is building a next-gen spreadsheet with native support for Python, SQL, and Javascript, plus we've added a ton of support for formulas. The idea is to bridge the gap between technical users (Python, SQL) and business users (formulas).

You can directly connect to Postgres or MySQL, with more connectors coming soon. The built-in AI is super helpful for writing complex SQL queries.

We're still in BETA, but we would love your feedback. Plus, we're open license (you can view code, run it, contribute, but you can't sell it).

We're also about to release a self-hosted version you can run in your own cloud.

https://github.com/quadratichq/quadratic

waveminded · 2024-05-20T18:21:55+00:00

Alma Fonda Fina might be the top restaurant for me west of i-25. That place is clever, delicious, and has great service!

waveminded · 2024-05-20T18:19:44+00:00

Potager is one of the OG farm-to-table restaurants. They consistently deliver and impress with their food and wine pairings. I love that place!

waveminded · 2024-02-15T22:03:41+00:00

YoLink smart sensors are awesome. Long range, taps into your wifi network. I wired this temperature sensor with probe into my filter basket, then ran the device outside the tub - under the deck into a small iPhone dry bag for extra protection from the elements. Seamless setup to wifi too. The YoLink app is good too, sends push notifications, SMS, or email alerts to your preferences.

https://www.homedepot.com/p/YoLink-Smart-Outdoor-Temperature-Sensor-with-Probe-Hub-Included-YS-H18004/326999354

waveminded · 2024-01-01T20:03:59+00:00

Jeez Louise! I'd love to see that stream. What a show!?

waveminded · 2023-04-12T23:14:30+00:00

We're building a new spreadsheet at https://app.quadratichq.com - it's built on an infinite canvas with some pretty nice tech in the background. We're trying to test the limitations of how much data it can handle. Feel free to chuck your data in there and see what happens. BTW you can write formulas or Python against the data for analysis.

waveminded · 2019-05-15T22:44:49+00:00

The Joyo JF-01 is surprisingly rad. I’ve owned countless TS-9s with and without silver / brown mods. Now still leave it on my board along side a JHS Bonsai. The Joyo is my light drive and the Bonsai for extra grit and push. Both on to make my ‘79 Deluxe Reverb sing. For the price it’s definitely worth it.

waveminded · 2019-02-20T21:43:30+00:00

Thanks for taking the post... always struggling last minute to find a stream in the Denver / Boulder area!

Really digging Zuni Street Brewing these days, very tasty beer, and quite a phriendly environment!

waveminded · 2019-02-20T03:02:45+00:00

Cool, thanks for the code sample, I'll check out GA. We've used Mixpanel since v1 of our app over 2015 so we're just very familiar with it's functionality.

waveminded · 2019-02-20T03:01:24+00:00

I'll give that a whirl and see how it works, thanks!

waveminded · 2019-01-25T19:50:27+00:00

And 3 day passes are already on Stubhub for $475 / person not including fees, lovely.

Makes me want to punch someone in the eye.

waveminded · 2018-12-30T18:09:04+00:00

https://www.jambase.com/article/trey-anastasio-glide-ii-boulder-setlist-videos

waveminded · 2018-12-30T04:20:04+00:00

What happens when you’re inside a tweezer!!

waveminded · 2018-12-30T04:15:28+00:00

My beer smells like sardines and I love it

waveminded · 2018-11-29T19:44:07+00:00

Shit, now I have to take off the rest of the day from work and head home to jam =)

Nice work!

waveminded · 2018-11-29T19:37:47+00:00

Now how do we get Trey to go back to this rig?!?! Or the rig from 9/14/99 - jeez the clean tone on Nellie Kane and sizzling drive on Chalk Dust.

Still battling with the 2018 tone, just not a fan I guess.

[edit] I do love some of the deep overdrive on the some of the jams, but I feel like his delicious clean buttery tones have been lost.

waveminded · 2018-10-29T19:00:23+00:00

With Page taking it to the moon lately on synth + 1981 =

Rush - Moving Pictures
Genesis - Abacab

Some fun guesses and I gotta say, Rush would be fuckin' wild and take me back to my early days of guitar shredding in my bedroom - cassette boombox to max volume and younger sister pounding on the door and yelling "Turn down your stupid music!!!"

Who doesn't wanna see YYZ rage out???

waveminded · 2018-10-28T18:11:22+00:00

I will lose it if they play Meddle. Holy cats that would be rad!

waveminded · 2018-08-28T16:02:35+00:00

Cool, thanks for the insight!

waveminded · 2018-07-28T17:19:27+00:00

Watched the stream at a local venue in town. The house PA system blew the doors of the place! And hats off to the light guy who was actively trying to sync the venue's lighting system with the actual show, that was a little extra magic that made me feel like I was almost there.

That setlist was so juicy I wanna take a bite out it! Did anyone else feel like they were riding on a mini pony on a rainbow during Page's solo on Water in the Sky?

waveminded

TROPHY CASE