Web-based AI SQL Playground and connecting to Postgres from the browser

Neon has developed a web-based AI SQL playground for Postgres that allows users to connect to a Neon Postgres database and employ an AI assistant to generate SQL queries using natural language. This project emerged from an internal AI hackathon and utilizes OpenAI’s gpt-3.5-turbo model to generate SQL queries efficiently. The playground, which is now live, can connect to other Postgres databases via a WebSocket-to-TCP proxy using the Neon serverless driver, thus overcoming the limitations of browsers not supporting TCP connections. The platform is open source, allowing users to report bugs or request features, and it supports a user-friendly interface where users can manage database connections, view schemas, and interact with the AI for query generation. The Neon team is also working on an HTTP-based driver to further enhance connectivity options, and they encourage feedback from users to refine the platform.