posit-dev / posit-dev/positron
Data Connections: Column and table completions
Open
@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
- Wire table, column, view completions
- Scope column completions to tables actually referenced in the current query where feasible, rather than suggesting every column in the connection
- 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
- No active connection should have no schema suggestions
- Multiple active connections: decide how completions scope (active/focused connection only vs. some kind of picker)
Contributor guide
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
Assessment
This issue has not been assessed yet.