Oh woah this looks great.
Quite amazing they put the effort into this for Postgres instead of SQL Server. The demand must be a lot higher.
>> all without ever leaving your favorite code editor
How do I install this on Neovim then? Is there a LSP? Or is this Microsoft proprietary? I wonder how much better without Copilot integration this is then the competition.
I'm using DBeaver CE currently. Does all I need (also for SQLite).
will definitely be taking a look at this. i started my career on mostly SQL Server and using SSMS fits my brain like a glove. i've been so dissatisfied with the typical options (pgadmin, dbeaver, datagrip, etc) for managing/querying postgres since i started using it probably like 10 years ago. postgres itself is great (don't get it twisted either, SQL Server is fantastic. just costs money) but i never understood why there wasn't more uproar in the community about its DBMS tooling ecosystem
Biggest thing that JetBrains has over VSCode for me was their very clean built in database tooling
Postico has always been my defacto way to interact with Postgres. Curious if there are any Postico users who have tried this yet.
Congrats to the team on launching this! I was actually the first to demo it, as part of our sponsored session at Microsoft last week.
Here's the talk where I used it: https://www.youtube.com/watch?v=k6Vm2hakkV4
I also did a theater session at our MSFT booth, but the recording isn't up yet. You can follow the steps in this repo to check out all the features that I demo'd, however: https://github.com/Azure-Samples/postgresql-extension-playgr...
Let the team know about any issues here: https://github.com/microsoft/vscode-pgsql/issues
I wonder what is the most "valuable" IDE right now for MS. A few years ago VsCode was marketed essentially as "Visual studio for beginners", where you were supposed to move to Visual Studio after you became a real dev, but since then VSCode has been growing and growing and stands now as the most used "IDE", where Visual Studio is mostly seen as "legacy" (oversimplification, great IDE for CPP and .NET but still...).
Is there a similar feature available for SQLite? Will there need to be a totally new extension for every DB, or is there a shared portion?
Microsoft Access meets PostgreSQL, 3 decades later?
Looks nice enough. I only wish there was an easy way to spread VS Code across multiple monitors. I commonly will work in code on one monitor, and the database tool (DataGrip currently) on another.
Is there a similar extension for MySQL in VS Code?
Looks amazing- and the point they're making in the article is correct. Switching back and forth from VS to PG Admin creates friction that this seems to solve in a much nicer way
Remember the old adage, embrace, extend, extinguish.
The AI integration is interesting to me. I have been trying to get Claude to help me with postgres from within my product and have found its ability and understanding of postgres/sql to be significantly worse than with common programming languages.
Maybe it's because my tolerance for imperfection is much lower for databases than web apps, but it is so bad that I can't trust it for anything database-related beyond text transformations and generating boilerplate queries. It will incorrectly tell me things like postgres doesn't support TABLE OF <TYPE>, or make syntax errors for ON CONFLICT, and immediately agree with any "what about" or "are you sure" I throw at it.
Curious if anybody else has run into this. Obviously LLMs are not always great in specialized domains like this but the poor performance with something as popular as postgres is pretty uncharacteristic IMMO.
I wonder how this compares to pgModeler (https://pgmodeler.io/) which I've been using the most in the recent years, would love is someone who had tried both could share some observations.
Doesn't look like there's much beyond what's currently possible in DataGrip yet (which is far beyond any other SQL client I've used), but nice to see a competitor in the space - especially one that will push JetBrains on the AI assistance side of things.
I've never used any of these kind of graphical SQL editors. I'm reasonably ok with SQL but I've always just done text queries.
Does anyone here feel that the graphical editors actually save them time or make their lives easier?
There seems to be a bug — I can't re-run the query from the query history panel; it returns no results.
New query could still get results.
Overall, it should have been a separate app because you can't really see all the results in a small panel.
So it's just Azure Data Studio where it lacks SSH tunneling...
I got my hopes up for nothing
I use DataGrip, but only for very simple tasks and only against PG and occasionally SQLite and it has always felt like way overkill for me (and it's a heavy app). This will be a more convenient option!
Nice. The few db managers I’ve tried in VS Code are so awkward, creating files for queries and opening multiple panes that barely fit in the crowded IDE space
It makes me wish for something like phpmyadmin or adminer
I’m truly grateful for this. It’s really helpful because I love VSCode, and most of my projects use Postgres. The decision to prioritize Postgres support was quite unexpected.
This is not available in Cursor. Extension ID "ms-ossdata.vscode-pgsql" returns no results. I wonder if Microsoft is blocking VSCode forks from having this extension?
This might already exist, but seems like AI would be a natural fit and efficient at recommending indexes based off queries. I’ve been building a Python SQLite3 app and I gave ChatGPT the entire schema along with all queries and it did a fantastic job at recommending queries and explaining them. Compound indexes, unique indexes, compound primary keys. Taken a step further, if a process ran live inspecting queries in real time and then sent notifications of missing indexes would be super useful.
Shame it's not a generic thing that can work with MySQL
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.
the copilote being aware of postgres schema is a thing I manually have to deal with in cursor rules. I keep all the SQL DLL files that created any table in context but then also its best to have cursor rules to tell it to use one orm if possible
I wonder how well this IDE works if you use AWS or GCP instead of Azure.
Very nice and long awaited. Thanks Ms. There are basic features available now (visualisations and query). Looking ahead for more, such table/data editing etc.
Tried it, queries work but i can't even show the columns and other meta data. it says no connnection even though i have a connection to do queries.
> Password-less authentication with Entra Id
I don't understand why the first four points under this heading are basically the same.
This is so cool. A big reason I used prisma was for prisma studio. Having this kind of support in vscode is nice to see
Just tried it, wish there was better refactoring tools available!
If love for there to me a "rename variable" feature.
Does something like this exist for mysql?
I don't really understand the UI though, there's no way to provide a host
am I the only one to have that problem?
This looks great. Would all the functionality work if the databases are hosted on other cloud providers?
Nice that they’ve got it working so well with copilot, the only thing keeping me from buying a premium sub is that they don’t bundle GitHub copilot with office copilot.
It seems like all their copilots are seperate subs, which seems like a missed opportunity honestly.
Graphical schema image generation was in IntelliJ for like 15 years at least? Since the times with all the craze about UML "disrupting" software engineering.
I wonder if this will work with Redshift , which is based on Postgres?
I used Azure Data Studio with SQL Server for a while—decent, but still clunky. I believe this plugin is the evolution of that, so it’s probably solid too—but can't beat out what I'm currently using since it targets only Postgres.
It’s going to be tough to beat SQLTools for Sublime Text (https://code.mteixeira.dev/SublimeText-SQLTools/). It’s simple, fast, does the basics right, and crucially, works for many of the usual suspects.
Most IDEs try to do everything and fail, yet only target one db vendor. They’re _all_ bloated and buggy, with endless trees and menus, bells and whistles. Results grids are slow, copy/paste is janky, formatting is never quite right—or outright misleading.
SQLTools stays out of the way and just works.
...also, I don’t want AI-powered nonsense. I’ll reach for that when I need it. Get off my lawn.
Too bad I switched to PGlite for local dev (not really because I love PGlite). I unfortunately don't see any PGlite VS Code extensions.
I will be using this. 100%. very handy
This is great!
does this work for non-Azure?
and just like that, 90% of the reason i pay for a jetbrains license just...disappeared
I'm sure nobody cares, but I just independently stumbled upon this an hour ago and wondered why more people haven't used it.
"You don't have permission to access url"
Looks promising, but I'll probably stick to `psql`
It has a proprietary license[0]. That makes it a non-starter. Too bad: it looks nifty!
> The software is licensed, not sold. Microsoft reserves all other rights. Unless applicable law gives you more rights despite this limitation, you will not (and have no right to):[…] d) use the software for commercial, non-profit, or revenue-generating activities
Oops. Better not install this on your work laptop!
[0] https://marketplace.visualstudio.com/items/ms-ossdata.vscode...
https://github.com/Microsoft/vscode-pgsql
no source, not a promising privacy policy
> [...] all without ever leaving your favorite code editor.
That's cool. How do I get this into JetBrains IDEs?
Let me guess: proprietary, like Pylance, and unavailable in VSCodium?
I still think Jetbrains has the gold standard in IDE - Database interaction
Isn'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.
Has there been a final solution to the VSCode phoning-home problem?
Last time I tried to use it in my environment, it triggered too many 'external network requests' for the liking of our IT guy. We relegated it to the "Do Not Use" pile as a result.
Has this been resolved? Nobody in my team wants to use an IDE that sends data back to its masters ..
[dead]
[dead]
Ages behind Jetbrains and more of electron dumpster fire. No thanks
[flagged]
[flagged]
[flagged]
[flagged]
Glad to see them releasing it under an MIT license.
Super cool for them to finally add in VSCode. My team is trying to build even more here by building a dedicated SQL editor with a context aware AI copilot, and with sharing and collaboration so we don’t need to send queries in slack anymore :)
Check it out and get on the waitlist getgalaxy.io/explore/product-tour
happy to chat live with anyone if interested, support@getgalaxy.io
This solves a major problem that I built an npm package called "pgstrap"[1] for. It generates a "database structure" directory so that my database schema is available to LLMs (it also makes code review easier because you can see the changes to various tables). So I have a SQL file for each table in my database, neatly organized into directories for each schema. Rails has a similar idea with schema.rb
I'm not sure whether or not it's better to have your editor database-aware or to have your codebase have appropriate context committed. On one hand, less generated code/artifacts make for a cleaner codebase. On the other hand, not everyone uses VC Code or will know how to use this integration. Database browser GUIs have never really had a single winner. That said, VS Code does have enough dominance to potentially make themselves "the standard way to view a database in development"
[1] https://github.com/seveibar/pgstrap