Schema-aware Postgres extension for natural language queries using GPT

Query OpenAI’s GPT-3 from directly inside your database

open-source agentic AI data assistant for the next generation of AI + Data products. - eosphoros-ai/DB-GPT

Hey there! I’ve been working on DB Pilot for the last couple of months, and I recently added an AI assistant powered by GPT 3.5 to help you write SQL queries tailored to your DB schema. Simply ask what data you are looking for - GPT will figure out which tables to use, how to join them, and then write a query for you. The AI assistant knows which tables and columns exist in your database, meaning it can write queries specific to your schema. Besides that, it doesn't have access to any actual data from your database though, meaning your data doesn't get exposed to OpenAI.

This extension let's you write PRQL functions in PostgreSQL. When I first saw PRQL on Hacker News a few months ago, I was immediately captivated by the idea, yet equally disappointed that there was no integration for PostgreSQL. Having previous experience with writing PostgreSQL extensions in C, I thought this was a great opportunity to try out the pgrx framework and decided to integrate PRQL with PostgreSQL myself. The maintainers of both PRQL and pgrx were very nice to work with. Thanks guys.

Query and visualize your data using OpenAI from your phone

Last summer we faced a conundrum at my company, Tiger Data, a Postgres cloud vendor whose main business is in timeseries data. We were trying to grow our business towards emerging AI-centric workloads and wanted to provide a state-of-the-art hybrid search stack in Postgres. We'd already built pgvectorscale in house with the goal of scaling semantic search beyond pgvector's main memory limitations. We just needed a scalable ranked keyword search solution too. The problem: core Postgres doesn't provide this; the leading Postgres BM25 extension, ParadeDB, is guarded behind AGPL; developing our…