Re: Proposal: Adding Text-to-SQL Feature with OpenAI API Integration to pgAdmin 4

Hi Yusuf,

Sounds exciting. I would suggest creating a proposal document with more
details which can be reviewed.

On Mon, Apr 28, 2025 at 1:38 PM Yusuf Ali Nazlum <yusuf(dot)nazlum(at)rexven(dot)com>
wrote:

> Dear pgAdmin Hackers Community,
>
> My name is Yusuf Ali, and I am the CTO of Rexven, a Turkey-based startup
> providing e-commerce solutions. I am a software developer with a strong
> background in artificial intelligence and data analytics, having worked on
> various AI-driven projects, including government initiatives in Turkey. I
> am reaching out to discuss a potential contribution to pgAdmin 4, as I am
> excited about enhancing its capabilities with a new feature.
>
> I propose adding a Text-to-SQL query generation feature to pgAdmin,
> inspired by tools like Cursor. This feature would allow users to connect
> their own OpenAI API key to generate SQL queries from natural language
> input. A critical component of this feature would be a mechanism to
> securely send database schema information to the OpenAI model to ensure
> accurate query generation. To achieve this, I am considering approaches
> such as implementing a RAG (Retrieval-Augmented Generation) pattern or
> using filtering methods to optimize schema handling and improve query
> accuracy.
>
> My plan is to start by developing a Proof of Concept (PoC) to validate
> the feature's feasibility and iteratively refine it based on technical
> constraints and community feedback. I believe this addition could
> significantly enhance pgAdmin's usability, especially for users who need to
> quickly translate complex requirements into SQL queries.
>
> I would love to hear your thoughts on this idea and any guidance on how to
> proceed with contributing to pgAdmin. Specifically, I’d appreciate feedback
> on:
>
>
> - The feasibility of integrating external APIs like OpenAI into
> pgAdmin.
> - Best practices for handling schema data securely in this context.
> - Any existing work or plugins in pgAdmin that might overlap with this
> feature.
>
> I am eager to collaborate with the pgAdmin community and follow the
> contribution guidelines to ensure a smooth process. Please let me know if
> there are specific steps I should take to kickstart this, such as opening a
> GitHub issue or discussing further details here.
>
> Thank you for your time and consideration. I look forward to your feedback
> and hope to contribute to making pgAdmin even more powerful!
>
> Best regards
>
> YusufAli
> Co-Founder, CTO
> ------------------------------
> A:
>
> 1443. Cd. No:25B D:194, 06530 Çankaya/Ankara
> P: (0312) 963 19 63
> E: info(at)rexven(dot)com
> www.rexven.com
> <http://linkedin.com/in/yusuf-ali-nazlum-a6077923a>
> <https://twitter.com/rexvencom>
> <https://www.youtube.com/@rexvencom/featured>
> <https://www.instagram.com/rexvencom/>
> [image: Afiş] <https://community.rexven.com/topluluk-paketleri/>
>

--
Thanks,
Aditya Toshniwal
pgAdmin Hacker | Sr. Staff SDE II | *enterprisedb.com*
<https://www.enterprisedb.com/>
"Don't Complain about Heat, Plant a TREE"