GenDB

Run `npx skills add SolidLao/GenDB --all -g -y` in your terminal to install all skills in this suite globally.

GenDB takes your database schema, SQL queries, data files, and hardware specs, then generates optimized standalone executables for each query. It outperforms general-purpose engines like DuckDB and PostgreSQL by tailoring code to your exact data and hardware.

Instead of running queries through a general-purpose engine, GenDB generates custom C++ code that exploits your exact data distributions, join selectivities, and hardware characteristics. It runs 2.8x faster than DuckDB on TPC-H and 5x faster on real-world financial data.

GenDB is evaluated on OLAP workloads including TPC-H and SEC-EDGAR financial filings data. It works best for recurring analytical queries where the one-time generation cost pays off over many repeated executions.

GenDB supports multiple providers including Claude and OpenAI Codex, selectable via a simple command-line flag. It is designed so additional providers can be added easily.