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.
A Zapier integration easily pushes data from various apps.
Enjoy a superior SQL editing experience, with syntax highlighting, column name autocompletion and validation.
Querycafe runs the latest SQLite engine with added extensions for JSON, advanced aggregations and statistics.
Building auto-updating interactive charts takes only a couple of clicks.
Support for more extensive visualizations is on the roadmap.
You can share query results and charts with anyone with publicly accessible links. Easily embed the share links in other apps like Notion.
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.
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
}'