memFrame: A Pandas-Style API That Compiles to SQL for DuckDB, PostgreSQL, and ClickHouse

Lumpy_Vermicelli8869 · reddit · 2026-08-20

memFrame is an open-source dataframe API that compiles operations to SQL — Python/DataFrame API → SQL → DuckDB / PostgreSQL / ClickHouse — keeping computation inside the database instead of pulling data into pandas.

It currently covers inspection, selection, cleaning, statistics, arithmetic, and visualization; groupby, window functions, sorting, and filtering are next, released incrementally so existing features get publicly tested first. It also ships a built-in multiagent architecture for chatting with data in natural language. The author is asking for technical feedback from pandas/SQL users.

Original post →

More from coding & agent

coding & agent channel →