querycafe
A data tool built for small business
Bring business data scattered in various sources to one place, run SQL queries on them, and share results with others.
Scales beyond Excel. Simpler than Tableau.
Features
Import data from CSVs, APIs and web sites
Querycafe makes it easy to bring all business data to a single source. Be it JSON APIs, CSVs, or legacy data you need to scrape off web pages, Querycafe supports them all.
There's also a Zapier integration to easily push data from various apps.
Fully loaded SQL
Querycafe gives a superior SQL experience, with syntax highlighting, column name autocompletion and validation.
It runs the latest SQLite engine with added extensions for JSON, advanced aggregations and statistics.
Interactive charts
Building auto-updating interactive charts with Querycafe takes only a couple of clicks.
Support for more extensive visualizations is on the roadmap.
Share and embed results
You can share query results and charts with anyone with publicly accessible links. You can easily embed them in other apps like Notion.
curl --location --request POST 'https://api.query.cafe/v1/add_records' \
--header 'Authorization: Bearer ' \
--header 'Content-Type: application/json' \
--data-raw '{
"table": "sales",
"columns": ["customer_id", "sku", "amount_in_usd", "created_at"],
"rows": [
["5665", "ck2020-09091", 1200, 1600323812],
...
["3450", "ck2020-09125", 4500, 1600323322],
],
"overwrite": false
}'
Easy to use API
Use Querycafe's API to customize it to match your workflow and integrate with your existing systems. You can use your favorite language to talk to the API.
Pricing
$100/year
or $12/month
- Access to all the features & integrations
- 30-day free trial (no credit card required)
- Secure payment processing via Stripe
- Tax invoices for business reimbursements
