AI: Copilot PG: VS Code: Chat DBA for PostgreSQL extension

PG Chat Participant - Visual Studio Marketplace

This is an experimental chat participant that uses Copilot to query your PostgreSQL database.

Creates queries and other fun things with your Postgres database. Use chat to create tables, views, and run queries, right in your editor. Output the results as JSON or CSV.

The entire public schema of your database will be loaded up to Copilot for each query. 

looking for albums by AC/DC:

@pg show all albums by 'AC/DC'

Copilot's response:

SELECT album.title
FROM album
JOIN artist ON album.artist_id = artist.artist_id
WHERE artist.name = 'AC/DC';

GitHub - microsoft/copilot-pg: A DBA copilot extension

.NET Rocks! Viper.NET with Rob Conery podcast

Rob Conery works at Microsoft with the VS Code team, creating content for YouTube as well as contributing to open source projects

Creating a search catalog in PostgreSQL using full text indexing - YouTube

Using PostgreSQL to Handle Calendar Data Like a Freak - YouTube