Alternatives

Products that do what SQLite query inside a Bash function does

Part of the workflow for building my website is the generation of a table in tab-separated column format (.tsv). The source data is found in four other .tsv files. I use an SQLite query to perform a 4-way join and write out the new table. For convenience, I wrote a script that encapsulates the query inside a Bash function. The example below illustrates this technique. repertoire() { pushd $CMM_SOURCES/_data sqlite3 <<EOS .headers on .mode tabs .import category.tsv category .import composition.tsv composition .import concert.tsv concert .import program.tsv program .once repertoire.tsv…

1
SQL Workbench▲186
In-browser SQL Workbench for data querying & visualization
2024
2GD
Google Drive to SQLite▲305
Here's the repo: https://github.com/simonw/google-drive-to-sqlite The README is using a trick I'm increasingly leaning on: parts of that document - the --help output and the example database schema - are automatically generated using Cog: https://nedbatchelder.com/code/cog and https://til.simonwillison.net/python/cog-to-update-help-in-r...
2022 · simonwillison.net
3
Equals Import Scripts▲337
A spreadsheet with SQL, JavaScript, and Python built in
2022
4
ClaySQL▲141
Run SQL queries directly in Google Sheets
2021
5
TABLUM.IO▲159
Turn CSV, XML & JSON into a live analysis-ready SQL database
2023
6SS
SPyQL – SQL with Python in the middle▲105
SPyQL (https://github.com/dcmoura/spyql) is SQL with Python in the middle, an open-source project fully written in Python for making command-line data processing more intuitive, readable and powerful. Try mixing in the same pot: a SQL SELECT for providing the structure, Python expressions for defining transformations and conditions, the essence of awk as a data-processing language, and the JSON handling capabilities of jq. How does a SPyQL query looks like? $ spyql “ IMPORT pendulum AS p SELECT (p.now() - p.from_timestamp(purchase_ts)).in_days() AS days_ago, sum_agg(price…
2022 · github.com
7SS
SQLite-S3-query – Python function to query a SQLite database on S3▲38
2021 · github.com
8MI
Mongita is to MongoDB as SQLite is to SQL▲126
2021 · github.com
9SV
SQL Viewer – UI for uber/queryparser, written in Haskell▲88
2018 · github.com
10CP
Csql – Python lib for composeable SQL queries▲89
2020 · github.com
11JG
JinjaSQL – Generate SQL Queries using a Jinja Template▲77
2016 · github.com
12SI
sqlite-import-csv (short shell script using SQLite to import CSV file)▲8
2021 · github.com
13
SQL query for CSV▲85
Analyze CSV records using sql syntax right in your browser
2022
14CQ
ClangQL – Query C++ codebases using SQLite▲73
2021 · github.com
15
Database Sensei▲83
Generate arduous database queries in a snap
2023
16DS
Describe SQL using natural language, and execute against real data▲66
I played around with GPT-3 to build this demo. Select a public BigQuery dataset and describe your query in natural English, then edit the generated SQL as needed and execute it. https://app.tabbydata.com/sql-assistant-demo
2021
17RL
repere – Local-first SQL data explorer using DuckDB WASM▲5
Repere lets you drop CSV/JSON/Parquet/XLSX files into your browser and immediately query them with full DuckDB SQL. Nothing gets uploaded, everything runs locally via DuckDB WASM. Unlike Excel and Google Sheet it can handles millions of rows easily. Features: - Filter, sort, join, pivot across multiple files Every transformation becomes a node in a visual pipeline (DAG) - Full undo/redo, real-time recomputation - Export results or replay pipelines on new files with the same schema - Works offline - Sparklines, themes and charts
Jan 2026 · repere.ai
18SS
SQLYac – Structured SQL files you can run from the terminal▲5
Inspired by .http files and HTTPYac, SQLYac lets you write executable SQL documentation with variables, safety prompts, and per-query targeting. Instead of scattered .sql files or copy-pasting into clients, write annotated queries once and pipe them to any sql database client. Variables get substituted, destructive queries can prompt for confirmation, and your schema stays documented alongside actual queries. For example, if you have a `queries.sql` file like this: --- -- @name QueryWithVariables SELECT * FROM orders o, users u WHERE u.id=@user_id AND u.active=@active AND o.status=@status…
Oct 2025 · github.com
19
WinSQLite Editor▲2
Lightweight & intuitive GUI editor for SQLite databases
30d ago
20SE
SQLxport – Export SQL Query Results to Parquet, CSV, and S3▲5
Introducing sqlxport: export SQL query results to Parquet/CSV in seconds — and optionally upload to S3 or MinIO. Works with PostgreSQL & Redshift CLI-first, cloud-friendly Great for data pipelines and engineers
2025 · github.com
21BI
BigBash.it – Turn your SQL query into a bash one-liner▲7
2016 · bigbash.it
22DQ
Dbxlite – Query 100M+ rows in a browser tab, no install▲5
What started as a Claude Code experiment turned into a browser-native SQL workbench I now use daily. Runs DuckDB WASM entirely in your browser. No backend, no installation, no signup. - Query local files (CSV, Parquet, Excel) – data never leaves your machine - Handles 100M+ rows, 50GB+ files in a browser tab - Full UI: Monaco editor, schema explorer, spreadsheet-style results grid - Share SQL via URL – anyone can run your query instantly - BigQuery connector built-in (Snowflake coming) v0.2 – actively developing. Feedback welcome. GitHub (MIT):…
Dec 2025 · sql.dbxlite.com
23ST
Sqlitebiter – tool to convert CSV/JSON/Excel/Google-Sheets to SQLite▲16
2016 · github.com
24ST
SQL to C translator for SQLite▲6
2015 · alpinejoe.github.io

Ranked by how close each launch is in meaning, then by votes. Refine with a description →