Copilot Support & Extension Ideas

[anchildress1]

TL;DR: Microsoft’s Postgres SQL extension doesn’t just run queries — it exposes features like schema fetch, CSV bulk load, describe statements, YAML exports, and schema visualization as Copilot tools. Has anyone considered doing something similar here?

---

Hey all —

For comparison: Microsoft’s Postgres SQL extension integrates directly with GitHub Copilot. Copilot can call into the extension to do things like:

• Fetch database schema
• Bulk load CSVs
• Run describe statements
• Export schema as YAML
• Connect/disconnect servers
• List databases/servers
• Visualize schema

That means you don’t just use the extension — Copilot uses the extension for you.

Which brings me to the question:

• Has anyone considered writing Copilot tool support for this extension?
• Am I the only one that’s thought about this?
• If not, what would it look like?
• What kind of design would we need?
• How do we actually make it happen?

This extension is already widely recommended for SQL work in VS Code, but in the AI-assisted space it feels like there’s room to grow. I’ve probably burned through my hackathon quota for the next six months 😅, but I’d love to help however I can — and with any luck, my time might free up in a month or so.

Let’s start the discussion and see where it goes!