This is amazing.
I imagine later LLM have access to my table metadata and then perhaps down the road, LLM can suggest me better queries based on execution plans that it saw.
Postgres IDE in VS Code
171–180 of 433 posts
Re: Postgres IDE in VS Code
#172Looks promising, but I'll probably stick to `psql`
I wonder about people’s development workflows. If you are using a tool like this, how much time are you spending in the command-line (where all such tools can be interfaced)? Are most tools used wrapped in some layer like this?
I spend most of my time in the command line:
- neovim for file editing,
- zsh (+zoxide) for navigation / file management,
- plain git to manage my repos,
- plain text note taking and accounting, etc.
Re: Postgres IDE in VS Code
#173Isn't PGAdmin good enough? Not hating, but I'm not a database guy either so just curious why create a VSCode extension for GUI stuff.
[deleted]
Re: Postgres IDE in VS Code
#174Earlier quoted context omitted.
I wonder about people’s development workflows. If you are using a tool like this, how much time are you spending in the command-line (where all such tools can be interfaced)? Are most tools used wrapped in some layer like this?
There’s a lot of developers that are scared of the command-line. Truth is you don’t really need these IDEs if you truly know SQL and your database, writing queries isn’t difficult. Keeping a file with common queries isn’t hard either. But most developers just keep a very shallow pool of knowledge and lean into ORMs etc.
I'm using CLIs like A LOT, but still would be happy to get _good_ autocomplete for SQL.
`psql` is pretty bad at it and in `\e` you will just end up in an editor, which will probably don't know about your schema.
I've tried many tools, but seems like I like DataGrip (or databases in PyCharm Professional) the most, so I use EAP from time to time, when I'm going to write a lot of SQL.
Re: Postgres IDE in VS Code
#175I wonder how well this IDE works if you use AWS or GCP instead of Azure.
PM on the project here - All clouds and on-prem/local/docker work great! We test those, so if you have issues, please report in the repo we'll fix them.
Re: Postgres IDE in VS Code
#176I don't really understand the UI though, there's no way to provide a host
am I the only one to have that problem?
Re: Postgres IDE in VS Code
#177Earlier quoted context omitted.
I just use a MCP server (with copilot or cline) that has a read only login to my database.
Which is strictly worse than just giving the LLM access to the source of truth for the database. You're adding a round trip to the database and the LLM and inserting a tool call in the conversation before it even starts generating any code. And the reference Postgres MCP implementation doesn't include Postgres types or materialized views, and is one of the most widely used packages: Zed.dev's MCP server for example,…
MCP also gives the LLM access to your example data, which can add clarity beyond what your schema alone provides.
Re: Postgres IDE in VS Code
#178Postico has always been my defacto way to interact with Postgres. Curious if there are any Postico users who have tried this yet.
Very Mac-oriented, and I think IntelliJ built-in DB editor has way more functions / features.
Re: Postgres IDE in VS Code
#179I don't really understand the UI though, there's no way to provide a host am I the only one to have that problem?
Figure 6 in the article shows it.