microsoft / microsoft/vscode-pgsql

Table context - caching, or agent needs to load on every new request?

Open
#44 0 comments 1 reaction 0 assignees View on GitHub

Nobody has claimed this yet.

enhancement
Dominant language
No language data
Stars
395
Forks
33
Avg merge
1h 46m
Merged PRs (30d)
3

Description

Hello - I'm super stoked to have this extension!

I did have a question about the expected behavior - when starting a new "ask" chat in co-pilot, it seems like the extension needs to load the database schema into context.

This can take >1 minute. Is there a way to cache this introspection, so the tables can be loaded into context more quickly?

Contributor guide

No contributing guide indexed for this repository

First steps

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. Open a pull request that references the issue number.

Research direction

No file, test, or entry point is named. Start by tracing how a new Copilot Ask chat triggers PostgreSQL schema introspection, then determine whether that result can be reused safely between requests. Done means schema context loads substantially faster without becoming stale or incorrect.

Written by the indexing model from the issue text.

Assessment

Tech stack
postgresql
Domain
databases
Issue type
Feature
Difficulty
4/5
Estimated time
3-5 days
Activity status
Stale
Clarity
Mostly clear
Newbie friendliness
35/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.