Loading video...

Video Failed to Load

Go Home

Meet the new Microsoft PostgreSQL extension for Visual Studio Code - packed with powerful tools to supercharge your PostgreSQL workflow, like: 🤖 Agent mode integration 💡 Schema visualization ⚡ Instant Docker PostgreSQL 🔎 IntelliSense-powered queries Learn more:

246,187 views • 1 year ago •via X (Twitter)

10 Comments

Nick Muller's profile picture
Nick Muller1 year ago

Curious if this can finally replace Azure Data Studio’s Postgres plugin for me 😁

Manticore Search's profile picture
Manticore Search1 year ago

🚀 Star Manticore Search on #GitHub today and join our quest for the ultimate search solution!

Ben Dower's profile picture
Ben Dower1 year ago

i usually used to tell AI to make a script that sets up the database.

NFLComedySkits's profile picture
NFLComedySkits1 year ago

VS Code has been cooking lately! My next project will be creating a database so I need to try this extension 💯

Kingsley Uyi Idehen's profile picture
Kingsley Uyi Idehen1 year ago

Why is it DBMS-specific in the age of MCP (Model Context Protocol) and the existence of MCP servers for ODBC, JDBC, and

Vinayak Soni's profile picture
Vinayak Soni1 year ago

hi can we use mssql database with this? or any other mcp you know @code

ἀꑭατολή ✙ ➔'s profile picture
ἀꑭατολή ✙ ➔1 year ago

Finally

Andy Targaryen's profile picture
Andy Targaryen1 year ago

wow

Iliya Kisliy's profile picture
Iliya Kisliy1 year ago

@theo wdyt

Vishal's profile picture
Vishal1 year ago

This Microsoft PostgreSQL extension looks really useful. It has smart tools to make working with PostgreSQL easier and faster.

Related Videos

🚀Introducing Flockx by Fetch.ai your No-Code Business & Personal Agents 👇 Starting today FlockX by enables businesses of all sizes to launch dedicated AI Agents—intelligent, autonomous representatives designed to drive measurable growth in revenue, customer retention, and operational efficiency. ✅Key Features: Zero-Code Agent Creation: Deploy your AI Agent in minutes using FlockX’s intuitive platform. No technical expertise required. Global Reach via Businesses gain instant access to a global audience, while users unlock seamless connections to enterprises worldwide—mutually empowering growth. Engage clients, resolve queries, and capture global opportunities as users interact seamlessly with your business through the platform. Proven Business Impact: Effortlessly automate critical workflows, from lead generation to loyalty management, with precision and scalability. Seamless community integration: Understand and engage your audience by connecting your AI Agent to Discord and Telegram Messenger, with tools like calendars, information dashboards, and embedded chat widgets streamlining communication. Built with the trusted uAgents framework: and hosted securely on these Agents integrate directly into your existing systems while adapting to evolving demands. 🔗Next Steps: Create your AI Agent: Claim pre-registered access: Over 1 million businesses have already been onboarded—verify if your Agent is ready for activation. The AI-driven economy demands agility. Equip your business with the tools to compete—and lead. Learn how to deploy your Agent in one minute or less.

Fetch.ai

38,274 views • 1 year ago

Big moment for Postgres! AI coding tools have been surprisingly bad at writing Postgres code. Not because the models are dumb, but because of how they learned SQL in the first place. LLMs are trained on the internet, which is full of outdated Stack Overflow answers and quick-fix tutorials. So when you ask an AI to generate a schema, it gives you something that technically runs but misses decades of Postgres evolution, like: - No GENERATED ALWAYS AS IDENTITY (added in PG10) - No expression or partial indexes - No NULLS NOT DISTINCT (PG15) - Missing CHECK constraints and proper foreign keys - Generic naming that tells you nothing But this is actually a solvable problem. You can teach AI tools to write better Postgres by giving them access to the right documentation at inference time. This exact solution is actually implemented in the newly released pg-aiguide by Tiger Data - Creators of TimescaleDB, which is an open-source MCP server that provides coding tools access to 35 years of Postgres expertise. In a gist, the MCP server enables: - Semantic search over the official PostgreSQL manual (version-aware, so it knows PG14 vs PG17 differences) - Curated skills with opinionated best practices for schema design, indexing, and constraints. I ran an experiment with Claude Code to see how well this works, and worked with the team to put this together. Prompt: "Generate a schema for an e-commerce site twice, one with the MCP server disabled, one with it enabled. Finally, run an assessment to compare the generated schemas." The run with the MCP server led to: - 420% more indexes (including partial and expression indexes) - 235% more constraints - 60% more tables (proper normalization) - 11 automation functions and triggers - Modern PG17 patterns throughout The MCP-assisted schema had proper data integrity, performance optimizations baked in, and followed naming conventions that actually make sense in production. pg-aiguide works with Claude Code, Cursor, VS Code, and any MCP-compatible tool. It's free and fully open source. I have shared the repo in the replies!

Avi Chawla

186,931 views • 6 months ago