TE
科技回声
首页24小时热榜最新最佳问答展示工作
GitHubTwitter
首页

科技回声

基于 Next.js 构建的科技新闻平台,提供全球科技新闻和讨论内容。

GitHubTwitter

首页

首页最新最佳问答展示工作

资源链接

HackerNews API原版 HackerNewsNext.js

© 2025 科技回声. 版权所有。

Show HN: pgMagic – a Mac Postgres client that lets you query in natural language

49 点作者 tjhill将近 2 年前
Hi HN. This is a project I&#x27;ve been building for the last month.<p>It&#x27;s a macOS postgres client that uses your OpenAI key to generate and immediately execute queries against your database locally on your machine.<p>I imagine the user being someone familiar with SQL and able to identify errors in the generated code, but regularly needs to write queries to answer relatively simple questions.<p>This is my first software project I&#x27;m intending on selling myself and would love feedback on the product and landing page. I&#x27;d also love ideas on how to market it to users, as I&#x27;m very new to this.<p>In the near future I want to flesh out the features to include:<p>* toggle immediate execution<p>* better export&#x2F;editing<p>* local model inference<p>* windows &amp; linux support<p>* themes<p>Thanks for trying it out and let me know what you think!

9 条评论

lfittl将近 2 年前
Neat project!<p>Just in case its helpful to you, I maintain pg_query together with my colleagues at pganalyze, which packages the Postgres parser as a library: <a href="https:&#x2F;&#x2F;github.com&#x2F;pganalyze&#x2F;libpg_query">https:&#x2F;&#x2F;github.com&#x2F;pganalyze&#x2F;libpg_query</a><p>Might be useful to include in your product as a way to run a quick syntax check on the query output by the LLM, without actually connecting to the database and causing an error in the logs.
评论 #36335548 未加载
futhey将近 2 年前
This is cool. Not a feature request, but I guess my dream version of this in my head since I saw GPT-3 was this + charts, and maybe for Clickhouse.
评论 #36335561 未加载
tjhill将近 2 年前
P.S. If you would like to purchase it after the demo, please use HELLOHN for 25% off :)<p>Thanks again!
DrJid将近 2 年前
This looks really cool! Unfortunately, no matter how hard I try, I can&#x27;t seem to connect to a database. I get the &quot;error returned from database: permission denied for database &quot;postgres&quot; even though I&#x27;m specifying all the fields.
评论 #36349432 未加载
toppy将近 2 年前
Put priority on local models and aims for data analysts. Both SQL syntax and a structure of the database even for big project are simple and users will ask relatively simple questions. I bet you don&#x27;t even need &quot;large&quot; language models for this.
nozzlegear将近 2 年前
Nice work! I’m really interested in this but I made the unfortunate mistake of tying all my apps to MS SQL a long time ago. I might still pick this up for future projects.
alexalx666将近 2 年前
cool, 1 year of updates seems like a good alternative to subs
slau将近 2 年前
This is very cool. I&#x27;ll definitely try it out soon.
mehmet_mhy将近 2 年前
This is awesome!