{"repo":"Airsequel/SQLiteGPT","free":true,"listed":false,"github":"https://github.com/Airsequel/SQLiteGPT","clone":"git clone https://github.com/Airsequel/SQLiteGPT.git","description":"SQL function for SQLite to directly query OpenAI's ChatGPT","language":"Rust","stars":29,"topics":["gpt","llm","openai","sql","sqlite","chatgpt","ai","gpt-5"],"license":null,"category":"databases-storage","readme_excerpt":"SQLiteGPT SQLite loadable extension that exposes a gpt() SQL function for querying OpenAI's chat completions API directly from SQL. Implemented in Rust with rusqlite. Build This produces target/release/libsqlitegpt.dylib on macOS, libsqlitegpt.so on Linux, or sqlitegpt.dll on Windows. Usage The extension's entry point is derived from the file name, so plain .load ./target/release/libsqlitegpt resolves to sqlite3 sqlitegpt init . Configuration Environment variable Default Purpose -------------------- ---------------- ------------------------------------------- OPENAI API KEY (required) OpenAI API key OPENAI MODEL gpt-5.4-mini Chat completions model SQLITEGPT NO CACHE (unset) Set to any value to disable response caching Notes - gpt() is synchronous: each row blocks on the HTTP round-trip. For non-trivial result sets this is slow and consumes API credits per row. - Responses are cached in-process by (model, prompt) . Repeating an identical prompt within the same SQLite session reuses the prior answer. Set SQLITEGPT NO CACHE to disable. - The HTTP client uses a 60s global timeout, so a hung request cannot stall a query indefinitely. - NULL input propagates: gpt(NULL) returns NULL without contacting OpenAI. - The function is registered with SQLITE DIRECTONLY , so it cannot be invoked from views, triggers, CHECK / DEFAULT clauses, expression/partial indexes, or generated columns. This prevents a hostile database file from triggering network calls (and API spend) just by being opene","default_branch":null,"files":null,"tree":[],"storefront":"/r/Airsequel","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/Airsequel/SQLiteGPT/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}