How to Query PostgreSQL from VS Code (Without Installing Anything Else)

If you work with PostgreSQL and VS Code, you've probably got pgAdmin or DBeaver open in another window. Maybe a terminal running psql. Alt-tab, run query, alt-tab back. Fifty times a day. There's a better way. Install DBCode Open the Extensions panel in VS Code. Search "DBCode". Click Install. Done. Connect to PostgreSQL Click the DBCode icon in the sidebar, then "New Connection". Pick PostgreSQL, enter your connection details. If you're on Supabase or Neon, DBCode can auto-discover your databases. One click. Browse Your Data Your databases, schemas, and tables show up in a tree view. Click any table to see its data right away. No SQL needed. Filter, sort, and group with clicks. Need to edit a row? Click it, change the value, hit apply. DBCode shows you what will change before it runs. Write SQL (or Let AI Do It) The SQL editor has syntax highlighting and autocomplete that knows your schema. It suggests table names, columns, and relationships as you type. If you have GitHub Copilot, ju