asg017/sqlite-vec
Adds find-the-closest-match to SQLite as one small portable file, with no server and nothing to compile.
gristlabs/grist-core
A self-hosted spreadsheet with real column types, references between tables and Python formulas, stored as portable per-document files.
tursodatabase/turso
A rewrite of SQLite in Rust that reads the same files and has not yet reached version 1.0.
frectonz/sql-studio
One command opens a browser page that explores any of nine kinds of database, including CSV and Parquet files.
supervc-stack/VectorChord 💎 hidden gem
A disk-friendly vector index for PostgreSQL built on RaBitQ, so similarity search is not limited by memory.
timescale/pgvectorscale
A PostgreSQL extension that makes similarity search work on more data than fits in memory.
johnkerl/miller
Does what awk, cut, sort and join do, but by column name instead of column position, on CSV, TSV, JSON and JSON Lines.
ankane/pghero
A web dashboard for PostgreSQL that names the slow queries, the missing indexes, the unused ones, table sizes, connections and locks.
sqldef/sqldef
Four command-line tools that keep one file describing the database you want and apply exactly the difference against the live one.
ankane/pgslice 💎 hidden gem
A command-line tool that builds a partitioned copy of a large PostgreSQL table beside the original and swaps them, without taking the database down.
OpenRefine/OpenRefine
A local workbench for cleaning a messy table, best known for clustering near-duplicate values so they can be merged in one pass.
k1LoW/tbls
Reads a live database and writes its documentation as Markdown with generated diagrams, then lints the schema against rules you set.
pgmoneta/pgmoneta 💎 hidden gem
Full and incremental PostgreSQL backups with continuous write-ahead log shipping and point-in-time recovery, written in C for low memory use.
wal-g/wal-g
Backup and restore for several database systems, straight into cloud storage, able to rewind to any point in time.
azimuttapp/azimutt 💎 hidden gem
It draws the real shape of a database so you can explore it instead of guessing.
cybertec-postgresql/pgwatch 💎 hidden gem
A monitoring service that collects PostgreSQL metrics continuously, stores them in a PostgreSQL database of its own, and shows them through Grafana dashboards that arrive ready-made.
unum-cloud/usearch
A single-header similarity search and clustering engine for vectors, usable from ten languages and embedded inside ClickHouse and DuckDB.
ankane/dexter 💎 hidden gem
Reads your slow PostgreSQL queries, tests candidate indexes without building any of them, and prints the ones that would actually help.
benbjohnson/litestream
Streams a SQLite database to S3-compatible object storage as it changes, so it can be restored to a chosen moment after a failure.
noborus/trdsql 💎 hidden gem
Runs SQL queries directly against CSV, LTSV, JSON, YAML and TBLN files, with no database involved.
dalibo/pg_activity
A top-like terminal screen showing every query a PostgreSQL server is running right now, with the ability to cancel one.
HypoPG/hypopg 💎 hidden gem
Creates an index that does not really exist, so PostgreSQL can tell you whether a real one would be used.
darold/pgFormatter 💎 hidden gem
Lays out an unreadable SQL query so a person can read it, from the command line or as a web page.
tconbeer/harlequin
A full SQL editor that runs inside a terminal window, with a schema sidebar, autocompletion and query history.
okbob/pspg 💎 hidden gem
It makes the tables your database prints readable, with the headings pinned in place.
dalibo/pev2
Draws a PostgreSQL query plan as a tree with timings and row counts, and marks the step that is actually costing you the time.
xataio/pgroll
Applies PostgreSQL schema changes as two-phase migrations, so old and new versions of your code both keep working while the change is in progress and one command undoes it.
darold/pgbadger
It reads PostgreSQL's own log file and produces one HTML page naming the slowest queries, in order.
electric-sql/pglite
The real PostgreSQL engine compiled to WebAssembly, so it runs inside a JavaScript program or a browser tab with no server at all.
pola-rs/polars
A Rust-based dataframe library with a Python interface — multi-core, lazy, and able to work through files larger than memory.
timescale/timescaledb
A PostgreSQL extension for time-series data — automatic time chunking, compression of old chunks, and continuous aggregates.
unionai-oss/pandera
Schema validation for DataFrames — the error that fires before a backtest quietly reports a fictional edge.
perspective-dev/perspective
WebAssembly data grid and charts for large or streaming datasets — pivot two hundred thousand trades in the browser.
posit-dev/great-tables 💎 hidden gem
Display tables in Python with titles, spanners, footnotes and real number formatting — from a pandas or Polars frame.
smithyhq/sqladmin 💎 hidden gem
A SQLAlchemy admin panel mounted inside the FastAPI app he already runs — support without a psql prompt.
paradedb/paradedb
BM25 and full-text search that live inside Postgres, not in a separate Elasticsearch cluster that also needs backups.
simonw/datasette
sqlite-utils fills the database. Datasette lets you (or, if you point it at the world, anyone) browse and query it.
evidence-dev/evidence
Business intelligence as Markdown files with SQL in them, building to a static site — a dashboard Claude Code can write.
simonw/sqlite-utils 💎 hidden gem
Pours JSON and CSV into a real SQLite database with no schema design, then indexes it and adds full-text search.
marimo-team/marimo
Reactive Python notebook stored as a plain .py file — no hidden execution order, and `marimo run` serves it as a web app.
pgvector/pgvector
Vector search as an ordinary SQL query inside the Postgres he already runs. No new server, no new backup story.
No repository in this area carries every tag you picked.
Get the next edition in your inbox
A dozen repositories, opened and checked. The licence read, the last release dated, and the ones that did not make it named with the reason. It is the half most lists leave out.
No tracking pixels. One click to leave. The archive stays free either way.
We use your address to send the edition and nothing else. Confirm by email, leave in one click. How we handle it.