{"repo":"plasma-umass/sqlwrite","free":true,"listed":false,"github":"https://github.com/plasma-umass/sqlwrite","clone":"git clone https://github.com/plasma-umass/sqlwrite.git","description":"SQLwrite: AI in your DBMS! Automatically converts natural language queries to SQL.","language":"C","stars":126,"topics":["database","sql","sqlite3"],"license":"Apache-2.0","category":"databases-storage","readme_excerpt":"SQLwrite by Emery Berger Integrates AI into your database: automatically converts natural language queries into SQL, and then runs the SQL query. As far as we are aware, this is the first integration of LLMs to enable natural language queries into a production database manager. Currently works as an extension to SQLite3 (more to come). In addition to generating queries, SQLwrite also produces suggestions to improve query performance (e.g., creating new indices). Supported AI Providers SQLwrite supports two AI backends: Option 1: OpenAI (GPT-4) Get a key at: https://platform.openai.com/account/api-keys Option 2: AWS Bedrock (Claude) Or use the AWS credentials file ( /.aws/credentials ): AWS Bedrock uses Claude 3 Sonnet by default. Ensure you have enabled Claude model access in your AWS Bedrock console. Examples These example queries use a large SQLite database with multiple tables: Getting started Basic queries Queries with JOINs Complex query synthesis with multiple JOINs Natural languages besides English! Installation CMake Build (Recommended) Build Options Option Description -------- ------------- -DUSE BUNDLED SQLITE=ON Use bundled SQLite amalgamation -DUSE SYSTEM SQLITE=ON Use system-installed SQLite -DUSE SYSTEM FMT=ON Use system fmt library Legacy Makefile Build Ubuntu Usage After building, run the SQLite shell with sqlwrite built-in: The ask() function is automatically available - no need to load the extension: Loading as Extension You can also load sqlwrite into any S","default_branch":null,"files":null,"tree":[],"storefront":"/r/plasma-umass","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/plasma-umass/sqlwrite/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."}