Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1uA51a-00ALRf-1Z for pgadmin-hackers@arkaria.postgresql.org; Wed, 30 Apr 2025 10:50:46 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1uA51Y-00DFFx-2e for pgadmin-hackers@arkaria.postgresql.org; Wed, 30 Apr 2025 10:50:45 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1uA51X-00DFCM-F5 for pgadmin-hackers@lists.postgresql.org; Wed, 30 Apr 2025 10:50:44 +0000 Received: from mail-vs1-xe29.google.com ([2607:f8b0:4864:20::e29]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1uA51V-000KvO-0q for pgadmin-hackers@postgresql.org; Wed, 30 Apr 2025 10:50:42 +0000 Received: by mail-vs1-xe29.google.com with SMTP id ada2fe7eead31-4c325981002so293777137.3 for ; Wed, 30 Apr 2025 03:50:41 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=enterprisedb.com; s=google; t=1746010240; x=1746615040; darn=postgresql.org; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=/wOGDTUzjAO9D0e3k7YxZ6p0qDMzzu/lKMpR2Oy/WaA=; b=lh/vytTfPHQ3ppXPCcF1wtZpRy2ruf4sCnOYmflWeCFM6QHBPjZHx6oRhe6uxsrLoM Qptxur7Ni40txRZ5chBQZFBIhksGpsO0dSZ7LwYOrj6SIV1l7eaodptqUJApXlTguFl+ 8A6MJImx9QuPqNuhPiJaXKM3DVl3Rjq3VmgPqGeBEfQBg2CCaKnVDjsHi7rU9hDmWSr2 F6Ar1TqS3u/0sqh2U5jswwlp9WfVE4zb1ZYXjdDjKYTJLMv4SMUIBJnqs+5yM1aB0V9h SQ3UHXcXv+LR4YsWUWkUjW4JN8DtnUIYIKt6lA6RjFuoTUCgIAdEhXdZpx5JrQQERqHe 7syg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1746010240; x=1746615040; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:x-gm-message-state:from:to:cc:subject:date:message-id :reply-to; bh=/wOGDTUzjAO9D0e3k7YxZ6p0qDMzzu/lKMpR2Oy/WaA=; b=oW6hiWtJj8NbbmrLPfM/+vZ2gaMQVQlB5TK5tcmjCmlFH6N8ELn1CBBCtPQvTAqnxh 34a/EDzHOzszHALWOBylMhoRE7LqkVAlLsYhRsmODo+yNrZ+6CgYv5kZn7JbyKIhxlxe L8uHLq/WXCn6eOuHvMFWpGxdJZDM30qrVznN+KPJYL688kr1H02SyTd3VeO85LoPdNBB hKVx3uzCeQhAiyjhiNCeTKMdyACfbW44B7UO6ZsqLWAeJv6sFYq89iK45dRHLPIHDYI8 VDPwGqz3NbEgb/PIpJxOHoDTqtqRDoL9zsGZi6aR5zBI2vKaJirUZtjlNL7XDl0HB7ll hAQg== X-Gm-Message-State: AOJu0Ywr+sdhrif/5/VoUtGDbwJC2HMujLMnIDCdQcJ3KY8hMZt3v4o+ cPdIUbkAyFXsbB7YuAycav+rj3/XTS6DW7aINW+XVPs7s3ii5Em651i7gmYuKLLznFbhVQiO5DV BBsLYHAkOq0dmRNxwJykQwyJthTkntbkf5BTNnuIre3k7G2ON6w== X-Gm-Gg: ASbGncs4rivDimhpmVm5Ygn36Pa3ODZs7NBqJW6YJMIfeHK3QgjoUHbJBPFJQTmyoHf Ha9pgYu4m3onkNl53NUHywTbCpeawgtTs81YQpE/N/nH9NU182+ygtvjRpYy4uGJx8+4KfXx0Em 4HaDf/Z3gMdukv114OvpIaartE47npZB7NJoPp7l3Fy7AA0CJcPoMGpw== X-Google-Smtp-Source: AGHT+IG3Tzb27Bn7IRhM3BKq8XZqz2lHaRi3NJEw8Ht7IH+v1laccXBr5jxuSyOBGuO9FVtp5NlnijFAMYfJF9ISkiM= X-Received: by 2002:a05:6102:5493:b0:4c4:e0cc:fb39 with SMTP id ada2fe7eead31-4dad35d6a7dmr1532666137.12.1746010240420; Wed, 30 Apr 2025 03:50:40 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: Aditya Toshniwal Date: Wed, 30 Apr 2025 16:20:02 +0530 X-Gm-Features: ATxdqUGbz2PwyaaqsNBqrrRuxwddX7__6H4N-umGaO64nkJuL-ZeMX2yM5hNkUc Message-ID: Subject: Re: Proposal: Adding Text-to-SQL Feature with OpenAI API Integration to pgAdmin 4 To: Yusuf Ali Nazlum Cc: pgadmin-hackers@postgresql.org Content-Type: multipart/alternative; boundary="00000000000027a7910633fcb0c6" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --00000000000027a7910633fcb0c6 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable 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=E2=80=AFPM Yusuf Ali Nazlum 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 o= n > 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 t= o > proceed with contributing to pgAdmin. Specifically, I=E2=80=99d appreciat= e 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 feedbac= k > and hope to contribute to making pgAdmin even more powerful! > > Best regards > > YusufAli > Co-Founder, CTO > ------------------------------ > A: > > 1443. Cd. No:25B D:194, 06530 =C3=87ankaya/Ankara > P: (0312) 963 19 63 > E: info@rexven.com > www.rexven.com > > > > > [image: Afi=C5=9F] > --=20 Thanks, Aditya Toshniwal pgAdmin Hacker | Sr. Staff SDE II | *enterprisedb.com* "Don't Complain about Heat, Plant a TREE" --00000000000027a7910633fcb0c6 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Hi=C2=A0Yusuf,

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

=
On Mon, Apr 28, 2025 at 1:38=E2=80=AFPM Yusuf Ali Nazlum <yusuf.nazlum@rexven.com> wr= ote:
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 a= rtificial intelligence and data analytics, having worked on various AI-driv= en projects, including government initiatives in Turkey. I am reaching out = to discuss a potential contribution to pgAdmin 4, as I am excited about enh= ancing its capabilities with a new feature.

=
= I propose adding a Text-to-SQL query generation feature to pgAdmin, inspired by tool= s like Cursor. This feature would allow users to connect their own OpenAI A= PI key to generate SQL queries from natural language input. A critical comp= onent of this feature would be a mechanism to securely send database schema= information to the OpenAI model to ensure accurate query generation. To ac= hieve this, I am considering approaches such as implementing a RAG (Retr= ieval-Augmented Generation) pattern or using filtering methods to optimize schema handl= ing and improve query accuracy.

My plan is t= o start by developing a Proof of Concept (PoC) to validate the feature's feasibil= ity 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 requ= irements into SQL queries.

I would love to h= ear your thoughts on this idea and any guidance on how to proceed with cont= ributing to pgAdmin. Specifically, I=E2=80=99d appreciate feedback on:

  • The feasibilit= y of integrating external APIs like OpenAI into pgAdmin.
  • Best practices for handli= ng schema data securely in this context.
  • Any existing work or plugins in pgAdmin= that might overlap with this feature.
I am eager to collab= orate with the pgAdmin community and follow the contribution guidelines to = ensure a smooth process. Please let me know if there are specific steps I s= hould take to kickstart this, such as opening a GitHub issue or discussing = further details here.

Thank you for your ti= me and consideration. I look forward to your feedback and hope to contribut= e to making pgAdmin even more powerful!

Bes= t regards

=
3D""
YusufAli
=C2=A0Co-Founder, CTO
A:=C2=A0

1443. Cd. No:25B D:194, 06530 =C3=87ankaya/Ankara
P:=C2=A0 (0312) 963 19 63
E:=C2=A0 info@rexven.com
www.rexven.com
<= a href=3D"http://linkedin.com/in/yusuf-ali-nazlum-a6077923a" target=3D"_bla= nk">3D"" <= a href=3D"https://twitter.com/rexvencom" target=3D"_blank">3D"" <= a href=3D"https://www.youtube.com/@rexvencom/featured" target=3D"_blank"> <= a href=3D"https://www.instagram.com/rexvencom/" target=3D"_blank">=3D""


--
Thanks,
Aditya Toshniw= al
pgAdmin Hacker=C2=A0| Sr. Staff SDE II=C2= =A0| enterprisedb.com
"Don't Complain about Heat, Plant a TREE"
--00000000000027a7910633fcb0c6--