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 1uA6P5-00AhVZ-5d for pgadmin-hackers@arkaria.postgresql.org; Wed, 30 Apr 2025 12:19:07 +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 1uA6P2-00DgVa-Sg for pgadmin-hackers@arkaria.postgresql.org; Wed, 30 Apr 2025 12:19:05 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1uA6P2-00DgVC-GP for pgadmin-hackers@lists.postgresql.org; Wed, 30 Apr 2025 12:19:05 +0000 Received: from mail-ua1-x929.google.com ([2607:f8b0:4864:20::929]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1uA6Ox-000MCA-17 for pgadmin-hackers@postgresql.org; Wed, 30 Apr 2025 12:19:01 +0000 Received: by mail-ua1-x929.google.com with SMTP id a1e0cc1a2514c-86dc3482b3dso678118241.0 for ; Wed, 30 Apr 2025 05:18:58 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=enterprisedb.com; s=google; t=1746015537; x=1746620337; 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=Mqg6XUfGAagmEpLvqgT9jJw5zVC+VsA09PrK6mLTmlo=; b=Wty+h+t4Srwf7fYRpSIPB6bNTufJnxEWYAADmFnsiiJfK/7PIxQblCZUA/B7oVX9sU QA5zZJ6R82UDSyLRzxKjbI1+2g3yihKprYyEr7TikBmKj/csKLYPHHam6EQSelyHd5GN Te8vWMO+hqovHjA+MeBgftrfcu8u0jG3tU9FHFX8lRQbzE1FLVL541GRcExhhog3Aia1 nrWwcTx4Xdi+48X3jn9rWqZYuUJklWpwNDsMGm7UjT+7C2wbStcXwoBi4rUxv1e1dMiV gy+Mr4pGbiPH5Ls7QUfdC4YxVhh7u11qQ8SM4n5W/C0c4y50CXForzEXHsY6cWp9DwLr JTfA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1746015537; x=1746620337; 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=Mqg6XUfGAagmEpLvqgT9jJw5zVC+VsA09PrK6mLTmlo=; b=QQa/jImn8wKHHwgM0n0x79AeR4/zVXFveDZ70KikS0nbzw6FY2NadBNGc7x5BjcoQx MsjJl3PQ5wXaUTiWfwx0qzMr+VV02JNh71A2YXirqmnbb4n83biFQcfhT2PeoTTUxK1T PJDlAQ7H1/fEEfvBW40Gh1CAD+0z2LEhlCexYpTLvd89cpdJpv7xe7nngWKgfM/vLqR7 cDRORy9GDI9AHdkfZssaj14laP+vp4+T0YsdSNhxAcyAM5erIP2LeT2o/j8uqBUPGTOP YQkw/MlK49Xv4Ae6Rza3fez8AAvAFNbrVzGpdIhClYscl+j1Hdl6nli3tA5Z8GlkCirE 2umA== X-Gm-Message-State: AOJu0YynVVH1HorHMcUsxjHd458CuEUgugAf+VVEMNnhgXrJIOl1rmH+ RHexMtPv4OaA3kqEnCrJOIEZi4UqsrZoyMqTkXdAKvbJZ4CBrn2GO/kjDNb7VoTfOGxKBUENyCS pHSQXRdR9/X83t+/EDeb2GJb4o3U8wh9J8f79VcwQhLl7FqTQVg== X-Gm-Gg: ASbGncuCtBZvHtUenKYgLo7tJZsh1Zeropux/HnZ6lhrNHKum7XVUjpcX8F9cQOoNZm yuXL02IvwXb4QGu7E184OyFsxDxqugVpcHRrfdYV4g1k7UPAjtPgUXBllWWcb6i8yL13NB5hZsI exWHvNL2VNYawrW1sgGlwvdhQ5SNKAqq5zkiLMyixdTeVT4S+umOR7Xw== X-Google-Smtp-Source: AGHT+IE1M4lXKZ5xB2p94zEY0WXznKT5mGF34mrYe2guP8eFyh2MTJ/T07znxlLvEvZVTCI0+TDuZFueFNtvjPc9e2I= X-Received: by 2002:a05:6122:240c:b0:524:2fe0:3898 with SMTP id 71dfb90a1353d-52ace631c03mr1621405e0c.5.1746015536778; Wed, 30 Apr 2025 05:18:56 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: Aditya Toshniwal Date: Wed, 30 Apr 2025 17:48:18 +0530 X-Gm-Features: ATxdqUF3Y1-iL8FBq_5TlBN_upVjoqE1HZ4QiUdFnHRLGFDnAKWQmmgxsbR1NaQ Message-ID: Subject: Re: Proposal: Adding Text-to-SQL Feature with OpenAI API Integration to pgAdmin 4 To: Yusuf Ali Nazlum Cc: pgadmin-hackers Content-Type: multipart/alternative; boundary="000000000000d7aa6d0633fdeb57" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000d7aa6d0633fdeb57 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable Hi, Sure and please don't remove pgadmin-hackers email id. On Wed, Apr 30, 2025 at 5:12=E2=80=AFPM Yusuf Ali Nazlum wrote: > Thanks for your feedback. > > I=E2=80=99m currently preparing the proposal document and will send it to= you > shortly for review. > > Best regards, > > Yusuf Nazlum > > 30 Nis 2025 =C3=87ar, saat 12:50 tarihinde Aditya Toshniwal < > aditya.toshniwal@enterprisedb.com> =C5=9Funu yazd=C4=B1: > >> 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 startu= p >>> 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 connec= t >>> 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 nee= d 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=E2=80=99d appr= eciate >>> 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 openi= ng 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 =C3=87ankaya/Ankara >>> P: (0312) 963 19 63 >>> E: info@rexven.com >>> www.rexven.com >>> >>> >>> >>> >>> [image: Afi=C5=9F] >>> >> >> >> -- >> Thanks, >> Aditya Toshniwal >> pgAdmin Hacker | Sr. Staff SDE II | *enterprisedb.com* >> >> "Don't Complain about Heat, Plant a TREE" >> > --=20 Thanks, Aditya Toshniwal pgAdmin Hacker | Sr. Staff SDE II | *enterprisedb.com* "Don't Complain about Heat, Plant a TREE" --000000000000d7aa6d0633fdeb57 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Hi,

Sure and please don't remove pgadmin-hackers email= id.

On Wed, Apr 30, 2025 at 5:12=E2=80=AFPM Yus= uf Ali Nazlum <yusuf.nazlum@r= exven.com> wrote:

Thanks for your feedback.

I=E2=80=99m currently preparing the proposal document and w= ill send it to you shortly for review.

Best regards,

Yusuf Nazlum


30 Nis 2025 =C3=87ar, saat= 12:50 tarihinde Aditya Toshniwal <aditya.toshniwal@enterprisedb.com>= =C5=9Funu yazd=C4=B1:
Hi=C2=A0Yusuf,

Sounds exciting. I would suggest c= reating a proposal document with more details which can be reviewed.
<= /div>
O= n Mon, Apr 28, 2025 at 1:38=E2=80=AFPM Yusuf Ali Nazlum <yusuf.nazlum@rexven.com&g= t; wrote:
Dear pgAdmin Hackers Community,

My name is Yu= suf Ali, and I am the CTO of Rexven, a Turkey-based startup providing e-com= merce solutions. I am a software developer with a strong background in arti= ficial 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 enhanc= ing its capabilities with a new feature.
=
I propose adding a Text-to-SQL q= uery generation feature to pgAdmin, inspired by too= ls like Cursor. This feature would allow users to connect their own OpenAI = API key to generate SQL queries from natural language input. A critical com= ponent of this feature would be a mechanism to securely send database schem= a information to the OpenAI model to ensure accurate query generation. To a= chieve this, I am considering approaches such as implementing a RAG (Retr= ieval-Augmented Generation) pattern or using fil= tering methods to optimize schema handling and improve query accuracy.

= My pla= n is to start by developing a Proof of Concept (PoC)= to validate the feature's feasibility and iteratively refine it bas= ed 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=E2=80=99d appreciate feedback= on:

    The feasibility of integrating external APIs lik= e OpenAI into pgAdmin.
  • Best practices for handling schema data securely in this context.=
  • Any existing work or plugi= ns in pgAdmin that might overlap with this feature.
I am eager to collaborate with the pgAdmin community and foll= ow the contribution guidelines to ensure a smooth process. Please let me kn= ow if there are specific steps I should take to kickstart this, such as ope= ning 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!
=
Best regards

3D""
YusufAli
=C2=A0C= o-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 Toshniwal=
pgAdmin Hacker=C2=A0| Sr= . Staff SDE II=C2= =A0| enterprisedb.com
&= quot;Don't Complain about Heat, Plant a TREE"
<= /div>


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