posit-dev / posit-dev/positron

Data Connections: Column and table completions

Open
#15,072 0 comments 0 reactions 1 assignee View on GitHub

@samclark2015 is already working on this.

Since Aug 10, 2026.

area: connections investigate
Dominant language
TypeScript
Stars
4.3k
Forks
184
Avg merge
1d 11h
Merged PRs (30d)
206

Description

Context

Data Connections already has the schema for a db at the typescript layer which includes a tree with tables, columns, viewws independent of the R/Python session. Can we surface this information as part of SQL autocompletions?

Scope

  1. Wire table, column, view completions
  2. Scope column completions to tables actually referenced in the current query where feasible, rather than suggesting every column in the connection
  3. Handle large catalogs: progressive disclosure or lazy loading for connections like Snowflake/Redshift where the full tree could be large enough to matter for editor responsiveness
  4. No active connection should have no schema suggestions
  5. Multiple active connections: decide how completions scope (active/focused connection only vs. some kind of picker)

Contributor guide

Open the contributing guide

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.

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.