Search papers, labs, and topics across Lattice.
This paper introduces Jailbreak, a novel approach that bypasses traditional database drivers by directly reading storage files and materializing data as in-memory columnar buffers, leveraging Large Language Models (LLMs) for code synthesis. By regenerating operator-specific table reading components from database file formats specified in their source code and documentation, Jailbreak significantly enhances analytical workloads. The method achieves up to 27x speedups in end-to-end analytical throughput compared to JDBC/ODBC-based baselines, demonstrating its effectiveness across various query engines and database systems.
Bypassing database drivers can lead to up to 27x speedups in analytical workloads by directly reading storage files with LLM-assisted code synthesis.
Analytical workloads operating on data stored in external database systems face a fundamental bottleneck: data access is guarded entirely by the database driver, like JDBC or ODBC, forcing all reads through query execution and other driver layers that are not designed for bulk columnar analytics. We present Jailbreak, an approach that bypasses the database engine entirely by reading storage files directly and materializing data as in-memory columnar buffers. Jailbreak's key insight is that database file formats, while complex, are fully specified by their source code and documentation, artifacts that Large Language Models (LLMs) can ingest to regenerate operator-specific table reading components without human-engineered parsing logic. Jailbreak leverages LLM-assisted code synthesis for database storage decoding, turning a traditionally opaque format into a directly queryable artifact. We evaluate Jailbreak on PostgreSQL and MySQL storage files, targeting analytical snapshot scenarios common in read replicas and offline processing pipelines. The generated reader produces Apache Arrow buffers consumable directly by most of the widely known query engines, including DuckDB, Apache Spark, and GPU-accelerated frameworks such as cuDF and Spark RAPIDS. We validate correctness against JDBC/ODBC-based baselines using the TPC-H benchmark across all query results, and demonstrate significant performance improvements in end-to-end analytical throughput, achieving up to 27x speedups. Our results showcase that LLM-assisted storage reader synthesis is a viable and generalizable methodology for breaking data lock-in across database systems, with applications beyond PostgreSQL and MySQL for any system whose file format is available to the LLM from documentation or source code.
