mrtimo
Joined 15 years ago
Karma
368
Submissions
141
Member since
Sep 27
Recent submissions
Comment · 26 days ago
Comment · 1 month ago
Malloy is an alternative to dbt, they have a similar product called Malloyyo [1], and Publisher [3], you can also the chat with HN data demo they have [4].
DBTCharts says you can serve charts locally, but it seems they want you to use their hosting service in production. Whereas, Malloyyo / Publisher are free to use anywhere. If you like college football checkout how I visualize drive data in [2], made with Malloyyo.
[1] - https://github.com/malloydata/malloyyo [2] - https://mrtimo.github.io/cfb-games/games-2026.html?%24SEASON... [3] - https://github.com/malloydata/publisher [4] - https://community.credibledata.com/hackernews
Comment · 1 month ago
It said I clicked on water a few times when I had not... Maybe it was a canal? Very cool.
Comment · 2 months ago
Check out malloyyo on github
Comment · 2 months ago
I've moved from python/polars/pandas to DuckDB and have not looked back
Comment · 2 months ago
The article mentions a dataset of names given to people in the USA. This is a fun name explorer WASM based on that data. 811 people in the USA have named their baby 'Diesel': https://docs.malloydata.dev/malloyyo-babynames/name_explorer...
Comment · 3 months ago
you should checkout https://github.com/malloydata/malloyyo - it's great at what you trying to do.
Comment · 3 months ago
Thanks for sharing, and thanks for making the video you shared. A couple thoughts. Is PostGIS king in this area? I've been liking duckDB as it does not require a server. Is there a good alternative to PostGIS in the duckDB world? Maybe just plain GeoParquet files read in through duckDB?
In the example in your video are any special GEOMETRY functions being used in the underlying SQL? Or, could your data just have been in plain postgres?
A similar product GeoSQL is Malloy which puts a semantic layer on top of your data for better LLM understanding. Malloyyo gives you an MCP server for precise and auditable interaction with your data.
Comment · 4 months ago
Thanks for sharing all this. Where is the submission page on claude / openAI to submit MCP servers to their directories?
Comment · 4 months ago
Question: I have an MCP server that is working well with Auth (Google Only), running on vercel. What benefit would I get from running it on manufact?
On monetizing my MCP... How do the different MCP "Stores" handle this? Do some take a cut? Or are they agnostic? Does manufact help with monetization?
Comment · 6 months ago
Can it be run as a static site(github pages) ?
Comment · 6 months ago
This is awesome. Is your code open source? It would be cool to make a textbook for SQL in this format.
Comment · 6 months ago
If you are a data scientist or do anything with data... duckdb is like a swiss army knife. So many great ways it can help your workflow. The original video from CMU in 2020 [1] is a classic. Minutes 3-8 present a good argument for adding duckdb to your data cleaning/processing workflow.
And if you want to add a semantic layer on top of data, Malloy [2] is my favorite so far (it has duckdb built in):
[1]: https://www.youtube.com/watch?v=PFUZlNQIndo [2]: https://docs.malloydata.dev/documentation/
Comment · 8 months ago
Nice work. Have you blogged about how you built it?
Here is an example [1] of visualizing college football games. Here are all the queries, and semantic model that power all the visualizations [2] Here is the AI generated typescript/react that does the visualizations [3]. The Malloy ecosystem has Malloyyo and Publisher which are replacements for PowerBI and Tableau and Looker. Here is another example for visualizing global trade [4].
[1] - https://mrtimo.github.io/cfb-games/games-2026.html?week=Week... [2] - https://github.com/mrtimo/cfb-games/blob/main/drives.malloy [3] - https://github.com/mrtimo/cfb-games/blob/main/dashboards/gam... [4] - https://tradeexplorer.org/