Show HN: Sourcetable – AI Spreadsheet and Data Platform
Sourcetable is an AI-native spreadsheet that integrates with various data sources, featuring an AI copilot for non-technical users, enabling real-time data analysis and handling large datasets efficiently.
Sourcetable is an AI-native spreadsheet designed to integrate seamlessly with various data sources, including databases like Postgres and MySQL, as well as over 100 business applications such as Stripe and Google Analytics. It features an AI copilot that assists users in performing spreadsheet tasks and conducting database-centric analyses, including SQL writing and automatic chart creation. Targeted primarily at analysts, operators, and finance professionals in small to medium-sized businesses, Sourcetable offers a no-code solution for data reporting and analysis, allowing users to interact directly with their data without needing extensive technical knowledge. The platform supports real-time data updates and can handle large datasets, making it a robust alternative to traditional spreadsheet tools. Founded by Eoin and Andrew, who have backgrounds in operations and deep learning, Sourcetable aims to provide a comprehensive data infrastructure that enhances productivity and simplifies data management. The platform is built for speed and scalability, utilizing advanced technologies such as LLMs and various backend systems to ensure efficient performance. Users can start experimenting with Sourcetable by uploading CSV files and leveraging its AI capabilities for data analysis and reporting.
- Sourcetable integrates with multiple databases and business applications for real-time data analysis.
- It features an AI copilot that assists with spreadsheet tasks and SQL writing.
- The platform is designed for non-technical users, making data access easier for business teams.
- Sourcetable can handle large datasets, surpassing limitations of traditional spreadsheet tools.
- The founders have extensive experience in operations and technical roles, informing the platform's development.
Related
Show HN: Anyquery – A SQL query engine for anything (CSV, GitHub, Airtable,etc.)
Anyquery is a command-line tool for executing SQL queries across various data sources, supporting multiple operating systems and formats, with features for data integration and open-source licensing under AGPL v3.
Postgres.new: In-browser Postgres with an AI interface
postgres.new is an in-browser Postgres sandbox that integrates AI assistance for managing databases, supporting features like CSV imports, report generation, and semantic search, with future cost-effective deployments planned.
From Shell to Excel – with a little bit of HTTPS
csvbase is an open-source web database that allows users to manage data via HTTP requests, supporting formats like Parquet and XLSX, and prioritizing ease of use and compatibility.
Launch HN: Trellis (YC W24) – AI-powered workflows for unstructured data
Trellis is an AI-powered ETL tool that converts unstructured data into structured SQL formats, addressing enterprise data management challenges, particularly in financial services, using advanced AI techniques for optimization.
Show HN: Visualize database schemas with a single query
ChartDB is an open-source web tool for visualizing and editing database schemas, supporting instant schema import and AI-generated DDL scripts, compatible with multiple databases, and offering community support.
The most useful aspect was that I could ask "what was the total contributed amount between January and June of 2020" and get an accurate answer for that as well. Since the date column is provided as an "MM/DD/YYYY" string, I would normally have to do some boilerplate work to sanitize this.
For my particular use case, the charting aspect left a few things to be desired - once I grouped campaign donations by contributor, I could only see the first 10 rows in the AI response, with no option to expand the output. But overall I was truly blown away that something like this is even possible for a small team to build.
> Niching down, if you work in operations at a <50 person startup or SMB and your company relies on a Postgres or MySQL database, Sourcetable is an affordable reporting tool with turnkey data infrastructure that doesn’t require code or engineers to set up.
With the rise of AI, companies like Tembo that help you set up all in one databases, and tools like this, I'm increasingly of the mind that many companies should start bringing things like analytics and observability in-house. I don't see the need to pay Mixpanel or Datadog thousands of dollars per month when a self-serve solution that relies on tried and true tech is more or less at your fingertips.
I'm already using Retool for these kinds of tasks- what does sourcetable do that I can't already do with Retool?
edit: also, did you build your own spreadsheet engine, or use an off-the-shelf one? (also will it be open source ;P)
- Fundamental gap in skillset, in that if you want to have ultimate flexibility to slice and dice the data and report on whatever you’re seeking, you’ve ultimately needed SQL skills in the past (which isn’t rocket science, but also isn’t something most accounting users can run with on their own).
- Fundamental desire of users to work with unstructured data. This goes back at least as far as Excel vs Lotus Improv in the early 90’s. Joel Spolsky talked about this, how they were terrified that Lotus Improv was going to kill Excel, because Improv was built to work with structured data, which users could then query and ask questions of to get any answer they want. But it turned out, as they observed people using both apps, there were zero users that used 100% normalized, structure data.
- Imperfect translation between spreadsheet and database. I’ve seen these work well 99.9% of the time, but at some point a column gets added or something that throws off formulas. And 0.1% error is basically catastrophic in accounting.
Maybe LLMs help overcome these challenges. Wish you luck.
https://www.dropbox.com/scl/fi/np92pyo0eb0zphysc9wwz/screens...
If i want to enable a simple internal web application (say React) with ability for users to manage master data tables, their schemas, and PK-FK relationships using a simple lookup -- as close to a simple spreadsheet as possible (upload and download CSV or view/edit data in a spreadsheet view) ... what are some good components or libraries that I can utilize?
I like that it's able to infer information from the context of the cells, e.g. being able to run a query across continents when the data only contains the country.
Being able to ask it to interpret the results is helpful, it would be cool if it automatically told you if there was enough data to have statistical significance in the conclusions it was presenting.
How did you build so many integrations so fast?
Selfishly, would love to see Streak (CRM) integration as well.
Related
Show HN: Anyquery – A SQL query engine for anything (CSV, GitHub, Airtable,etc.)
Anyquery is a command-line tool for executing SQL queries across various data sources, supporting multiple operating systems and formats, with features for data integration and open-source licensing under AGPL v3.
Postgres.new: In-browser Postgres with an AI interface
postgres.new is an in-browser Postgres sandbox that integrates AI assistance for managing databases, supporting features like CSV imports, report generation, and semantic search, with future cost-effective deployments planned.
From Shell to Excel – with a little bit of HTTPS
csvbase is an open-source web database that allows users to manage data via HTTP requests, supporting formats like Parquet and XLSX, and prioritizing ease of use and compatibility.
Launch HN: Trellis (YC W24) – AI-powered workflows for unstructured data
Trellis is an AI-powered ETL tool that converts unstructured data into structured SQL formats, addressing enterprise data management challenges, particularly in financial services, using advanced AI techniques for optimization.
Show HN: Visualize database schemas with a single query
ChartDB is an open-source web tool for visualizing and editing database schemas, supporting instant schema import and AI-generated DDL scripts, compatible with multiple databases, and offering community support.