Database Cheat Sheets

The commands, queries and functions you look up every week, one scannable page per database. Every entry is copy-paste ready.

Chroma

Clients, collections, where filters, get vs query, embeddings

Read CSV and Parquet, CLI commands, SQL functions, exports, Python

Query DSL, bool queries, aggregations, KQL and the REST API

Filter expressions, JSON and array filters, PyMilvus search

mongosh commands for queries, updates, aggregation and backups

mysql commands for users, queries, joins, backups and TiDB

psql meta commands, roles, \copy, pg_dump, EXPLAIN and locks

Filters, match and range conditions, payload indexes, query_points

redis-cli commands for keys, TTLs, hashes, streams and JSON

sqlite3 dot commands, CSV import, upserts, dates, JSON, PRAGMAs